Expand|Select|Wrap|Line Numbers
- EXEC SQL
- CALL CMQRACIN(<what do i place here?> :S-FINANCE-IN-DATA.ACCT-ID);
- END-EXEC
Expand|Select|Wrap|Line Numbers
- CREATE OR REPLACE PROCEDURE Cmqracin (P_REP_CURSOR IN OUT Cr_Package.CR_CURSOR, P_ACCT_ID IN CHAR)
- IS
- BEGIN
- DECLARE
- ...
- --Write the output fields
- OPEN P_REP_CURSOR FOR
- SELECT
- CM_PAST_DUE_AMT CM_PAST_DUE_AMT,
- CM_PAST_AMT_DUE_DT CM_PAST_AMT_DUE_DT,
- CM_CURR_DUE_AMT CM_CURR_DUE_AMT,
- CM_CURR_AMT_DUE_DT CM_CURR_AMT_DUE_DT,
- CM_ACCT_BAL CM_ACCT_BAL,
- CM_LAST_PAYM_DT CM_LAST_PAYM_DT,
- CM_LAST_PAYM_RCVD CM_LAST_PAYM_RCVD,
- RCR_CHG_AMT RCR_CHG_AMT,
- CM_CASH_ONLY_IND CM_CASH_ONLY_IND,
- CM_PASSW0RD CM_PASSW0RD,
- CM_NEXT_PAYM_DT CM_NEXT_PAYM_DT,
- CM_KEY_ACCT_ROLE CM_KEY_ACCT_ROLE,
- INSTALL_DT INSTALL_DT
- FROM
- DUAL;
- END;