DBA Data[Home] [Help]

APPS.ARP_PROCESS_DET_PKG dependencies on DBMS_SQL

Line 1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1336: WHERE b.gt_id = p_app_rec.gt_id
1337: AND b.app_level = p_app_rec.app_level
1338: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1339:
1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1337: AND b.app_level = p_app_rec.app_level
1338: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1339:
1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1338: AND b.REF_CUSTOMER_TRX_LINE_ID = c.customer_trx_line_id;
1339:
1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1339:
1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1340: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1341: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

Line 1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1342: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;

Line 1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1343: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;

Line 1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1344: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1352: l_last_fetch BOOLEAN := FALSE;

Line 1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

1345: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1352: l_last_fetch BOOLEAN := FALSE;
1353: BEGIN

Line 1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;

1346: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1352: l_last_fetch BOOLEAN := FALSE;
1353: BEGIN
1354: arp_standard.debug('res_ctl_rem_amt_for_app +');

Line 1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;

1347: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1348: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1349: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;
1350: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;
1351: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;
1352: l_last_fetch BOOLEAN := FALSE;
1353: BEGIN
1354: arp_standard.debug('res_ctl_rem_amt_for_app +');
1355: disp_app_rec(p_app_rec);