224: --ORDER BY transaction_id
225: ;
226:
227:
228: l_ae_par_rec CSTPALTY.CST_AE_PAR_REC_TYPE;
229: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
230: --l_ae_par_rec CST_AE_PAR_REC_TYPE;
231: --l_err_rec CST_AE_ERR_REC_TYPE;
232: l_sql_to_run VARCHAR2(500);
225: ;
226:
227:
228: l_ae_par_rec CSTPALTY.CST_AE_PAR_REC_TYPE;
229: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
230: --l_ae_par_rec CST_AE_PAR_REC_TYPE;
231: --l_err_rec CST_AE_ERR_REC_TYPE;
232: l_sql_to_run VARCHAR2(500);
233: l_package_name VARCHAR2(100);
385:
386: END create_acct_entry;
387:
388: PROCEDURE insert_ae_lines (
389: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
390: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
391: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
392: )
393: IS
386: END create_acct_entry;
387:
388: PROCEDURE insert_ae_lines (
389: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
390: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
391: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
392: )
393: IS
394: l_ae_header_id NUMBER;
387:
388: PROCEDURE insert_ae_lines (
389: i_ae_txn_rec IN CSTPALTY.cst_ae_txn_rec_type,
390: i_ae_line_rec_tbl IN CSTPALTY.cst_ae_line_tbl_type,
391: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
392: )
393: IS
394: l_ae_header_id NUMBER;
395: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
391: o_err_rec OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
392: )
393: IS
394: l_ae_header_id NUMBER;
395: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
396: --l_err_rec CST_AE_ERR_REC_TYPE;
397: l_stmt_num NUMBER;
398: l_request_id NUMBER;
399: l_user_id NUMBER;