eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_ALLOCATION_PKG dependencies on DBMS_SQL

Line 1271: l_ccid_tab DBMS_SQL.NUMBER_TABLE;

1267: WHERE ctl.ae_tax_link_id = b.customer_trx_line_id
1268: AND ctl.ae_account_class = 'TAX'
1269: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;
1270:
1271: l_ccid_tab DBMS_SQL.NUMBER_TABLE;
1272: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;
1273:
1274:
1275: BEGIN

Line 1272: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;

1268: AND ctl.ae_account_class = 'TAX'
1269: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;
1270:
1271: l_ccid_tab DBMS_SQL.NUMBER_TABLE;
1272: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;
1273:
1274:
1275: BEGIN
1276:

Line 2846: inv_line_tbl DBMS_SQL.NUMBER_TABLE;

2842: and ae_account_class = 'TAX'
2843: group by ae_link_to_cust_trx_line_id
2844: order by ae_link_to_cust_trx_line_id;
2845:
2846: inv_line_tbl DBMS_SQL.NUMBER_TABLE;
2847:
2848: l_last_fetch BOOLEAN := FALSE;
2849: l_mirror_link_ctr VARCHAR2(1) := 'N';
2850: l_set_ed_adj_link VARCHAR2(1) := 'N';

Line 4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,

4095: l_tax_acctd_applied NUMBER := 0;
4096: l_rowid VARCHAR2(50);
4097:
4098: TYPE g_ae_alloc_type IS RECORD (
4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,
4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,

Line 4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,

4096: l_rowid VARCHAR2(50);
4097:
4098: TYPE g_ae_alloc_type IS RECORD (
4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,
4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 4101: ae_amount DBMS_SQL.NUMBER_TABLE,

4097:
4098: TYPE g_ae_alloc_type IS RECORD (
4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,
4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,

Line 4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,

4098: TYPE g_ae_alloc_type IS RECORD (
4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,
4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,

Line 4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,

4099: l_rowid DBMS_SQL.VARCHAR2_TABLE,
4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,

Line 4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,

4100: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,

4101: ae_amount DBMS_SQL.NUMBER_TABLE,
4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,

Line 4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,

4102: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,

4103: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,

Line 4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,

4104: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,

Line 4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,

4105: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE

Line 4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,

4106: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
4114: );

Line 4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,

4107: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
4114: );
4115:

Line 4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,

4108: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
4114: );
4115:
4116: g_ae_alloc_rev_tax_tbl g_ae_alloc_type;

Line 4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE

4109: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
4110: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
4111: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
4112: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
4113: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
4114: );
4115:
4116: g_ae_alloc_rev_tax_tbl g_ae_alloc_type;
4117: