APPS.JMF_GTA_TRX_UTIL dependencies on JMF_GTA_SYSTEM_PARAMETERS_ALL

Line 935: jmf_gta_system_parameters_all

931: SELECT
932: vat_tax_type_code
933: ,gt_currency_code
934: FROM
935: jmf_gta_system_parameters_all
936: WHERE org_id=p_org_id;
937:
938: CURSOR c_taxline_count(pc_trx_id NUMBER)
939: IS

Line 1049: jmf_gta_system_parameters_all

1045: SELECT
1046: vat_tax_type_code
1047: ,gt_currency_code
1048: FROM
1049: jmf_gta_system_parameters_all
1050: WHERE org_id=p_org_id;
1051:
1052: CURSOR c_tax_line_count
1053: IS

Line 1161: jmf_gta_system_parameters_all

1157: SELECT
1158: vat_tax_type_code
1159: ,gt_currency_code
1160: FROM
1161: jmf_gta_system_parameters_all
1162: WHERE org_id=p_org_id;
1163:
1164: CURSOR c_ar_taxable_amount
1165: IS

Line 1256: jmf_gta_system_parameters_all

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

Line 1661: jmf_gta_system_parameters_all

1657: SELECT
1658: vat_tax_type_code
1659: ,gt_currency_code
1660: FROM
1661: jmf_gta_system_parameters_all
1662: WHERE org_id=p_org_id;
1663:
1664: --CURSOR c_ar_line_taxable_amount --Donghai Wang bug5212702 May-17,2006
1665: CURSOR c_ar_line_taxable_amount(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 1773: jmf_gta_system_parameters_all

1769: SELECT
1770: vat_tax_type_code
1771: ,gt_currency_code
1772: FROM
1773: jmf_gta_system_parameters_all
1774: WHERE org_id=p_org_id;
1775:
1776: --CURSOR c_ar_line_vatamount--Donghai Wang bug5212702 May-17,2006
1777: CURSOR c_ar_line_vatamount(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 1884: jmf_gta_system_parameters_all

1880: SELECT
1881: vat_tax_type_code
1882: ,gt_currency_code
1883: FROM
1884: jmf_gta_system_parameters_all
1885: WHERE org_id=p_org_id;
1886:
1887: --CURSOR c_ar_line_tax_rate --Donghai Wang bug5212702 May-17,2006
1888: CURSOR c_ar_line_tax_rate(pc_trx_id NUMBER) --Donghai Wang bug5212702 May-17,2006

Line 1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;

1991: l_bill_to_customer_id ra_customer_trx_all.bill_to_customer_id%TYPE;
1992:
1993: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
1994: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
1995: l_currency_code jmf_gta_system_parameters_all.gt_currency_code%TYPE;
1996: l_error_string VARCHAR2(500);
1997:
1998: l_paying_customer_id ra_customer_trx_all.paying_customer_id%TYPE;
1999: l_paying_site_use_id ra_customer_trx_all.paying_site_use_id%TYPE;

Line 2030: jmf_gta_system_parameters_all

2026: gt_currency_code
2027: INTO
2028: l_currency_code
2029: FROM
2030: jmf_gta_system_parameters_all
2031: WHERE org_id=p_org_id;
2032:
2033: EXCEPTION
2034: WHEN no_data_found THEN

Line 2508: jmf_gta_system_parameters_all

2504: gt_currency_code
2505: INTO
2506: l_currency_code
2507: FROM
2508: jmf_gta_system_parameters_all
2509: WHERE org_id=p_org_id;
2510:
2511: EXCEPTION
2512: WHEN no_data_found THEN

Line 3191: jmf_gta_system_parameters_all

3187: SELECT
3188: vat_tax_type_code
3189: ,gt_currency_code
3190: FROM
3191: jmf_gta_system_parameters_all
3192: WHERE org_id=p_org_id;
3193:
3194: --CURSOR c_tax_line_id --Donghai Wang bug5212702 May-17,2006
3195: CURSOR c_tax_line_id(pc_trx_id NUMBER)--Donghai Wang bug5212702 May-17,2006

Line 3521: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;

3517: IS
3518: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
3519: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3520: l_proc_level NUMBER := fnd_log.level_procedure;
3521: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3522: l_format_mask VARCHAR2(50);
3523: l_formatted_amount VARCHAR2(50);
3524:
3525: CURSOR c_base_currency IS

Line 3529: jmf_gta_system_parameters_all

3525: CURSOR c_base_currency IS
3526: SELECT
3527: gt_currency_code
3528: FROM
3529: jmf_gta_system_parameters_all
3530: WHERE
3531: org_id=p_org_id;
3532:
3533: BEGIN