DBA Data[Home] [Help]

APPS.ARP_RATE_ADJ dependencies on DBMS_SQL

Line 327: l_cnt_line DBMS_SQL.NUMBER_TABLE;

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)

Line 328: l_line_tab DBMS_SQL.NUMBER_TABLE;

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

Line 347: l_ACCTD_AMOUNT_DUE_REMAINING DBMS_SQL.NUMBER_TABLE;

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;

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

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

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

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

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

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

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

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

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

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