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