DBA Data[Home] [Help]

APPS.ARP_PROCESS_DET_PKG dependencies on DBMS_SQL

Line 1342: l_rev_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1343: l_rev_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1344: l_frt_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1345: l_frt_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1346: l_chrg_adj_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1347: l_chrg_adj_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1348: l_tax_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1349: l_tax_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1350: l_frt_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1351: l_frt_acctd_amt_rem_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1352: l_ctl_id_tab DBMS_SQL.NUMBER_TABLE;

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

Line 1353: l_line_type_tab DBMS_SQL.VARCHAR2_TABLE;

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