DBA Data[Home] [Help]

APPS.ARP_RATE_ADJ dependencies on DBMS_SQL

Line 331: l_cnt_line DBMS_SQL.NUMBER_TABLE;

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)

Line 332: l_line_tab DBMS_SQL.NUMBER_TABLE;

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

Line 351: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

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;

Line 352: l_AMOUNT_DUE_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;

Line 353: l_CHRG_ACCTD_AMOUNT_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;

Line 354: l_CHRG_AMOUNT_REMAINING 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;

Line 355: l_FRT_ADJ_ACCTD_REMAINING 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;

Line 356: l_FRT_ADJ_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;
360: l_FRT_UNED_AMOUNT DBMS_SQL.NUMBER_TABLE;

Line 357: l_FRT_ED_ACCTD_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;

Line 358: l_FRT_ED_AMOUNT 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;

Line 359: l_FRT_UNED_ACCTD_AMOUNT 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;
363: BEGIN

Line 360: l_FRT_UNED_AMOUNT 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
364: --

Line 361: l_customer_trx_line_id 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: --
365: IF PG_DEBUG in ('Y', 'C') THEN