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 1202: l_ccid_tab DBMS_SQL.NUMBER_TABLE;

1198: WHERE ctl.ae_tax_link_id = b.customer_trx_line_id
1199: AND ctl.ae_account_class = 'TAX'
1200: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;
1201:
1202: l_ccid_tab DBMS_SQL.NUMBER_TABLE;
1203: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;
1204:
1205:
1206: BEGIN

Line 1203: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;

1199: AND ctl.ae_account_class = 'TAX'
1200: GROUP BY ctl.ae_cust_trx_line_gl_dist_id;
1201:
1202: l_ccid_tab DBMS_SQL.NUMBER_TABLE;
1203: l_ctlgd_tab DBMS_SQL.NUMBER_TABLE;
1204:
1205:
1206: BEGIN
1207:

Line 2560: inv_line_tbl DBMS_SQL.NUMBER_TABLE;

2556: and ae_account_class = 'TAX'
2557: group by ae_link_to_cust_trx_line_id
2558: order by ae_link_to_cust_trx_line_id;
2559:
2560: inv_line_tbl DBMS_SQL.NUMBER_TABLE;
2561:
2562: l_last_fetch BOOLEAN := FALSE;
2563: l_mirror_link_ctr VARCHAR2(1) := 'N';
2564: l_set_ed_adj_link VARCHAR2(1) := 'N';

Line 3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,

3809: l_tax_acctd_applied NUMBER := 0;
3810: l_rowid VARCHAR2(50);
3811:
3812: TYPE g_ae_alloc_type IS RECORD (
3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,
3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,

Line 3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,

3810: l_rowid VARCHAR2(50);
3811:
3812: TYPE g_ae_alloc_type IS RECORD (
3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,
3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 3815: ae_amount DBMS_SQL.NUMBER_TABLE,

3811:
3812: TYPE g_ae_alloc_type IS RECORD (
3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,
3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,

Line 3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,

3812: TYPE g_ae_alloc_type IS RECORD (
3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,
3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,

Line 3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,

3813: l_rowid DBMS_SQL.VARCHAR2_TABLE,
3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,

Line 3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,

3814: ae_account_class DBMS_SQL.VARCHAR2_TABLE,
3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,

3815: ae_amount DBMS_SQL.NUMBER_TABLE,
3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,

Line 3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,

3816: ae_acctd_amount DBMS_SQL.NUMBER_TABLE,
3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,

Line 3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,

3817: ae_pro_amt DBMS_SQL.NUMBER_TABLE,
3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,

Line 3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,

3818: ae_pro_acctd_amt DBMS_SQL.NUMBER_TABLE,
3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,

Line 3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,

3819: ae_taxable_amount DBMS_SQL.NUMBER_TABLE,
3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE

Line 3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,

3820: ae_taxable_acctd_amount DBMS_SQL.NUMBER_TABLE,
3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
3828: );

Line 3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,

3821: ae_pro_frt_chrg_amt DBMS_SQL.NUMBER_TABLE,
3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
3828: );
3829:

Line 3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,

3822: ae_pro_frt_chrg_acctd_amt DBMS_SQL.NUMBER_TABLE,
3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
3828: );
3829:
3830: g_ae_alloc_rev_tax_tbl g_ae_alloc_type;

Line 3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE

3823: ae_pro_taxable_amt DBMS_SQL.NUMBER_TABLE,
3824: ae_pro_taxable_acctd_amt DBMS_SQL.NUMBER_TABLE,
3825: ae_collected_tax_ccid DBMS_SQL.NUMBER_TABLE,
3826: ae_pro_def_tax_amt DBMS_SQL.NUMBER_TABLE,
3827: ae_pro_def_tax_acctd_amt DBMS_SQL.NUMBER_TABLE
3828: );
3829:
3830: g_ae_alloc_rev_tax_tbl g_ae_alloc_type;
3831: