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.AR_GTA_TRX_UTIL dependencies on AR_GTA_SYSTEM_PARAMETERS_ALL

Line 1142: ar_gta_system_parameters_all

1138: SELECT
1139: vat_tax_type_code
1140: ,gt_currency_code
1141: FROM
1142: ar_gta_system_parameters_all
1143: WHERE org_id=p_org_id;
1144:
1145: CURSOR c_taxline_count(pc_trx_id NUMBER)
1146: IS

Line 1256: ar_gta_system_parameters_all

1252: SELECT
1253: vat_tax_type_code
1254: ,gt_currency_code
1255: FROM
1256: ar_gta_system_parameters_all
1257: WHERE org_id=p_org_id;
1258:
1259: CURSOR c_tax_line_count
1260: IS

Line 1368: ar_gta_system_parameters_all

1364: SELECT
1365: vat_tax_type_code
1366: ,gt_currency_code
1367: FROM
1368: ar_gta_system_parameters_all
1369: WHERE org_id=p_org_id;
1370:
1371: CURSOR c_ar_taxable_amount
1372: IS

Line 1463: ar_gta_system_parameters_all

1459: SELECT
1460: vat_tax_type_code
1461: ,gt_currency_code
1462: FROM
1463: ar_gta_system_parameters_all
1464: WHERE org_id=p_org_id;
1465:
1466: CURSOR c_ar_tax_amount
1467: IS

Line 1868: ar_gta_system_parameters_all

1864: SELECT
1865: vat_tax_type_code
1866: ,gt_currency_code
1867: FROM
1868: ar_gta_system_parameters_all
1869: WHERE org_id=p_org_id;
1870:
1871: --CURSOR c_ar_line_taxable_amount --Donghai Wang bug5212702 May-17,2006
1872: CURSOR c_ar_line_taxable_amount(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 1980: ar_gta_system_parameters_all

1976: SELECT
1977: vat_tax_type_code
1978: ,gt_currency_code
1979: FROM
1980: ar_gta_system_parameters_all
1981: WHERE org_id=p_org_id;
1982:
1983: --CURSOR c_ar_line_vatamount--Donghai Wang bug5212702 May-17,2006
1984: CURSOR c_ar_line_vatamount(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 2091: ar_gta_system_parameters_all

2087: SELECT
2088: vat_tax_type_code
2089: ,gt_currency_code
2090: FROM
2091: ar_gta_system_parameters_all
2092: WHERE org_id=p_org_id;
2093:
2094: --CURSOR c_ar_line_tax_rate --Donghai Wang bug5212702 May-17,2006
2095: CURSOR c_ar_line_tax_rate(pc_trx_id NUMBER) --Donghai Wang bug5212702 May-17,2006

Line 2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

2204: ----Yao Zhang add end for bug#8404856
2205:
2206: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2207: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2208: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2209: l_error_string VARCHAR2(500);
2210:
2211: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2212: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

Line 2243: ar_gta_system_parameters_all

2239: gt_currency_code
2240: INTO
2241: l_currency_code
2242: FROM
2243: ar_gta_system_parameters_all
2244: WHERE org_id=p_org_id;
2245:
2246: EXCEPTION
2247: WHEN no_data_found THEN

Line 2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;

2558: l_valid_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2559: --Yao Zhang add end for bug#8404856
2560: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2561: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2562: l_currency_code ar_gta_system_parameters_all.gt_currency_code%TYPE;
2563: l_error_string VARCHAR2(500);
2564:
2565: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
2566: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

Line 2598: ar_gta_system_parameters_all

2594: gt_currency_code
2595: INTO
2596: l_currency_code
2597: FROM
2598: ar_gta_system_parameters_all
2599: WHERE org_id=p_org_id;
2600:
2601: EXCEPTION
2602: WHEN no_data_found THEN

Line 3226: ar_gta_system_parameters_all

3222: gt_currency_code
3223: INTO
3224: l_currency_code
3225: FROM
3226: ar_gta_system_parameters_all
3227: WHERE org_id=p_org_id;
3228:
3229: EXCEPTION
3230: WHEN no_data_found THEN

Line 3959: ar_gta_system_parameters_all

3955: SELECT
3956: vat_tax_type_code
3957: ,gt_currency_code
3958: FROM
3959: ar_gta_system_parameters_all
3960: WHERE org_id=p_org_id;
3961:
3962: --CURSOR c_tax_line_id --Donghai Wang bug5212702 May-17,2006
3963: CURSOR c_tax_line_id(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 4289: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;

4285: IS
4286: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
4287: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4288: l_proc_level NUMBER := fnd_log.level_procedure;
4289: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
4290: l_format_mask VARCHAR2(50);
4291: l_formatted_amount VARCHAR2(50);
4292:
4293: CURSOR c_base_currency IS

Line 4297: ar_gta_system_parameters_all

4293: CURSOR c_base_currency IS
4294: SELECT
4295: gt_currency_code
4296: FROM
4297: ar_gta_system_parameters_all
4298: WHERE
4299: org_id=p_org_id;
4300:
4301: BEGIN