323: FROM ra_customer_trx_lines_gt
324: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
325: GROUP BY CUSTOMER_TRX_LINE_ID;
326:
327: l_cnt_line DBMS_SQL.NUMBER_TABLE;
328: l_line_tab DBMS_SQL.NUMBER_TABLE;
329: l_reset_rem VARCHAR2(1) := 'N';
330:
331: CURSOR c_trx_rem_gt(p_customer_trx_id IN NUMBER)
324: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
325: GROUP BY CUSTOMER_TRX_LINE_ID;
326:
327: l_cnt_line DBMS_SQL.NUMBER_TABLE;
328: l_line_tab DBMS_SQL.NUMBER_TABLE;
329: l_reset_rem VARCHAR2(1) := 'N';
330:
331: CURSOR c_trx_rem_gt(p_customer_trx_id IN NUMBER)
332: IS
343: customer_trx_line_id
344: FROM ra_customer_trx_lines
345: WHERE customer_trx_id = p_customer_trx_id;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
344: FROM ra_customer_trx_lines
345: WHERE customer_trx_id = p_customer_trx_id;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
345: WHERE customer_trx_id = p_customer_trx_id;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
346:
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
348: l_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
349: l_CHRG_ACCTD_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
357: l_customer_trx_line_id DBMS_SQL.NUMBER_TABLE;
350: l_CHRG_AMOUNT_REMAINING DBMS_SQL.NUMBER_TABLE;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
357: l_customer_trx_line_id DBMS_SQL.NUMBER_TABLE;
358: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;
351: l_FRT_ADJ_ACCTD_REMAINING DBMS_SQL.NUMBER_TABLE;
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
357: l_customer_trx_line_id DBMS_SQL.NUMBER_TABLE;
358: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;
359: BEGIN
352: l_FRT_ADJ_REMAINING DBMS_SQL.NUMBER_TABLE;
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
357: l_customer_trx_line_id DBMS_SQL.NUMBER_TABLE;
358: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;
359: BEGIN
360: --
353: l_FRT_ED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
354: l_FRT_ED_AMOUNT DBMS_SQL.NUMBER_TABLE;
355: l_FRT_UNED_ACCTD_AMOUNT DBMS_SQL.NUMBER_TABLE;
356: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;
357: l_customer_trx_line_id DBMS_SQL.NUMBER_TABLE;
358: g_ae_sys_rec arp_acct_main.ae_sys_rec_type;
359: BEGIN
360: --
361: IF PG_DEBUG in ('Y', 'C') THEN