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.JMF_GTA_TRX_UTIL dependencies on ZX_LINES

Line 924: l_tax_type_code zx_lines.tax_type_code%TYPE;

920: ,p_customer_trx_line_id IN NUMBER
921: )
922: RETURN BOOLEAN
923: IS
924: l_tax_type_code zx_lines.tax_type_code%TYPE;
925: l_taxline_count NUMBER;
926: l_gt_currency_code fnd_currencies.currency_code%TYPE;
927: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
928:

Line 943: zx_lines

939: IS
940: SELECT
941: COUNT(*)
942: FROM
943: zx_lines
944: WHERE trx_line_id=p_customer_trx_line_id
945: AND entity_code='TRANSACTIONS'
946: AND application_id = 222
947: AND trx_level_type='LINE'

Line 1037: l_tax_type_code zx_lines.tax_type_code%TYPE;

1033: ,p_customer_trx_id IN NUMBER
1034: )
1035: RETURN BOOLEAN
1036: IS
1037: l_tax_type_code zx_lines.tax_type_code%TYPE;
1038: l_taxline_count NUMBER;
1039: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1040:
1041:

Line 1060: zx_lines

1056: (SELECT
1057: trx_line_id
1058: ,COUNT(*)
1059: FROM
1060: zx_lines
1061: WHERE application_id = 222
1062: AND trx_id=p_customer_trx_id
1063: AND trx_level_type='LINE'
1064: AND entity_code='TRANSACTIONS'

Line 1149: l_tax_type_code zx_lines.tax_type_code%TYPE;

1145: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1147: l_proc_level NUMBER := fnd_log.level_procedure;
1148:
1149: l_tax_type_code zx_lines.tax_type_code%TYPE;
1150: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1151: l_ar_taxable_amount NUMBER;
1152:
1153:

Line 1169: zx_lines

1165: IS
1166: SELECT
1167: NVL(SUM(taxable_amt_tax_curr),0)
1168: FROM
1169: zx_lines
1170: WHERE application_id = 222
1171: AND trx_id=p_customer_trx_id
1172: AND trx_level_type='LINE'
1173: AND entity_code='TRANSACTIONS'

Line 1244: l_tax_type_code zx_lines.tax_type_code%TYPE;

1240: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1241: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1242: l_proc_level NUMBER := fnd_log.level_procedure;
1243:
1244: l_tax_type_code zx_lines.tax_type_code%TYPE;
1245: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1246: l_ar_tax_amount NUMBER;
1247:
1248:

Line 1264: zx_lines

1260: IS
1261: SELECT
1262: NVL(SUM(tax_amt_tax_curr),0)
1263: FROM
1264: zx_lines
1265: WHERE application_id = 222
1266: AND trx_id=p_customer_trx_id
1267: AND trx_level_type='LINE'
1268: AND entity_code='TRANSACTIONS'

Line 1641: -- Tax currency from the table zx_lines

1637: -- CHANGE HISTORY:
1638: --
1639: -- 13-Jun-2005: Donghai Wang Creation
1640: -- 24-Nov-2005: Modify program logic to get line amount per Golden
1641: -- Tax currency from the table zx_lines
1642: --
1643: --=========================================================================
1644: FUNCTION Get_Arline_Amount
1645: (p_org_id IN NUMBER

Line 1650: l_tax_type_code zx_lines.tax_type_code%TYPE;

1646: ,p_customer_trx_line_id IN NUMBER
1647: )
1648: RETURN NUMBER
1649: IS
1650: l_tax_type_code zx_lines.tax_type_code%TYPE;
1651: l_arline_amount NUMBER;
1652: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1653: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1654:

Line 1670: zx_lines

1666: IS
1667: SELECT
1668: taxable_amt_tax_curr
1669: FROM
1670: zx_lines
1671: WHERE trx_line_id=p_customer_trx_line_id
1672: AND entity_code='TRANSACTIONS'
1673: AND application_id = 222
1674: AND trx_level_type='LINE'

Line 1762: l_tax_type_code zx_lines.tax_type_code%TYPE;

1758: ,p_customer_trx_line_id IN NUMBER
1759: )
1760: RETURN NUMBER
1761: IS
1762: l_tax_type_code zx_lines.tax_type_code%TYPE;
1763: l_arline_vatamount NUMBER;
1764: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1765: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1766:

Line 1782: zx_lines

1778: IS
1779: SELECT
1780: tax_amt_tax_curr
1781: FROM
1782: zx_lines
1783: WHERE trx_line_id=p_customer_trx_line_id
1784: AND entity_code='TRANSACTIONS'
1785: AND application_id = 222
1786: AND trx_level_type='LINE'

Line 1873: l_tax_type_code zx_lines.tax_type_code%TYPE;

1869: ,p_customer_trx_line_id IN NUMBER
1870: )
1871: RETURN NUMBER
1872: IS
1873: l_tax_type_code zx_lines.tax_type_code%TYPE;
1874: l_tax_rate NUMBER;
1875: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1876: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1877:

Line 1893: zx_lines

1889: IS
1890: SELECT
1891: tax_rate
1892: FROM
1893: zx_lines
1894: WHERE trx_line_id=p_customer_trx_line_id
1895: AND entity_code='TRANSACTIONS'
1896: AND application_id = 222
1897: AND trx_level_type='LINE'

Line 2273: -- x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE

2269:
2270: -- p_trx_line_id IN NUMBER
2271: -- p_tax_type_code IN VARCHAR2
2272: -- x_status OUT NOCOPY NUMBER
2273: -- x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE
2274: --
2275: -- DESIGN REFERENCES:
2276: --
2277: --

Line 2288: , x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE

2284: (p_trx_line_id IN NUMBER
2285: , p_tax_type_code IN VARCHAR2
2286: , p_currency_code IN VARCHAR2
2287: , x_status OUT NOCOPY NUMBER
2288: , x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE
2289: )
2290: IS
2291: l_tax_line_count NUMBER;
2292: l_procedure_name VARCHAR2(50) := 'verify_tax_line';

Line 2293: l_tax_line_id zx_lines.tax_line_id%TYPE;

2289: )
2290: IS
2291: l_tax_line_count NUMBER;
2292: l_procedure_name VARCHAR2(50) := 'verify_tax_line';
2293: l_tax_line_id zx_lines.tax_line_id%TYPE;
2294: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
2295:
2296: BEGIN
2297:

Line 2327: zx_lines tax

2323: COUNT(*)
2324: INTO
2325: l_tax_line_count
2326: FROM
2327: zx_lines tax
2328: WHERE tax.trx_line_id = p_trx_line_id
2329: AND tax.entity_code = 'TRANSACTIONS'
2330: AND application_id = 222
2331: AND tax.trx_level_type = 'LINE'

Line 2353: zx_lines tax

2349: tax.tax_line_id
2350: INTO
2351: l_tax_line_id
2352: FROM
2353: zx_lines tax
2354: WHERE tax.trx_line_id = p_trx_line_id
2355: AND tax.application_id = 222
2356: AND tax.trx_level_type = 'LINE'
2357: AND tax.entity_code = 'TRANSACTIONS'

Line 2456: l_tax_registration_number zx_lines.tax_registration_number%TYPE;

2452: l_procedure_name VARCHAR2(30) := 'get_info_from_ebtax';
2453: l_lines_status NUMBER;
2454: l_status NUMBER;
2455: l_error_buffer VARCHAR2(180);
2456: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
2457: l_tax_registration_count NUMBER;
2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;

Line 2458: l_tax_line_id zx_lines.tax_line_id%TYPE;

2454: l_status NUMBER;
2455: l_error_buffer VARCHAR2(180);
2456: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
2457: l_tax_registration_count NUMBER;
2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;

Line 2459: l_tax_rate zx_lines.tax_rate%TYPE;

2455: l_error_buffer VARCHAR2(180);
2456: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
2457: l_tax_registration_count NUMBER;
2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;

Line 2460: l_unit_price zx_lines.unit_price%TYPE;

2456: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
2457: l_tax_registration_count NUMBER;
2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;

Line 2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;

2457: l_tax_registration_count NUMBER;
2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;

Line 2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;

2458: l_tax_line_id zx_lines.tax_line_id%TYPE;
2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;
2466: l_fp_reg_number_count NUMBER;

Line 2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;

2459: l_tax_rate zx_lines.tax_rate%TYPE;
2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;
2466: l_fp_reg_number_count NUMBER;
2467: l_amount zx_lines.taxable_amt%TYPE;

Line 2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;

2460: l_unit_price zx_lines.unit_price%TYPE;
2461: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
2462: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;
2466: l_fp_reg_number_count NUMBER;
2467: l_amount zx_lines.taxable_amt%TYPE;
2468: l_currency_code VARCHAR2(30);

Line 2467: l_amount zx_lines.taxable_amt%TYPE;

2463: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
2464: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
2465: l_tp_registration_number zx_registrations.registration_number%TYPE;
2466: l_fp_reg_number_count NUMBER;
2467: l_amount zx_lines.taxable_amt%TYPE;
2468: l_currency_code VARCHAR2(30);
2469: l_error_string VARCHAR2(500);
2470: --added by subba for R12.1
2471: l_invoice_type jmf_gta_tax_limits_all.invoice_type%type;

Line 2548: -- if the line count = 1 , get data from zx_lines and transfer it to GTA

2544:
2545: -- if the line count is 0, return -1 and the line can't be transfer and don't
2546: -- throw any exception
2547: -- if the line count > 1 , return 1 and throw exception
2548: -- if the line count = 1 , get data from zx_lines and transfer it to GTA
2549: -- 29-JUN-2006 Upated by Shujuan, insert Tax_currency_conversion_rate
2550: -- into l_tax_curr_conversion_rate in order to calculate the unit price of
2551: -- tax concurrency for bug 5168900
2552: IF l_lines_status = 0

Line 2575: zx_lines tax

2571: , l_trx_line_quantity
2572: , l_amount
2573: , l_tax_curr_conversion_rate
2574: FROM
2575: zx_lines tax
2576: WHERE tax.trx_line_id = p_trx_line_id
2577: AND tax.entity_code = 'TRANSACTIONS'
2578: AND application_id = 222
2579: AND tax.trx_level_type = 'LINE'

Line 2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;

2793: IS
2794: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;

Line 2798: l_tax zx_lines.tax%TYPE;

2794: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;

Line 2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;

2795: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;

Line 2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;

2796: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
2797: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
2798: l_tax zx_lines.tax%TYPE;
2799: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2800: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
2801: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
2802: l_tax_registration_number zx_registrations.registration_number%TYPE;
2803: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
2804: l_reg_tax zx_registrations.tax%TYPE;

Line 2918: zx_lines tax

2914: , l_tax
2915: , l_tax_jurisdiction_code
2916: , l_tax_determine_date
2917: FROM
2918: zx_lines tax
2919: WHERE
2920: tax.tax_line_id = p_tax_line_id;
2921:
2922: EXCEPTION

Line 3030: ,'tax or tax_jur is null in zx_lines ');

3026: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3027: THEN
3028: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3029: , G_MODULE_PREFIX || l_procedure_name
3030: ,'tax or tax_jur is null in zx_lines ');
3031: END IF;
3032:
3033: END IF;/*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3034:

Line 3177: l_tax_type_code zx_lines.tax_type_code%TYPE;

3173: ,p_customer_trx_line_id IN NUMBER
3174: )
3175: RETURN VARCHAR2
3176: IS
3177: l_tax_type_code zx_lines.tax_type_code%TYPE;
3178: l_tax_rate NUMBER;
3179: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3180: l_tax_line_id zx_lines.tax_line_id%TYPE;
3181: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;

Line 3180: l_tax_line_id zx_lines.tax_line_id%TYPE;

3176: IS
3177: l_tax_type_code zx_lines.tax_type_code%TYPE;
3178: l_tax_rate NUMBER;
3179: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3180: l_tax_line_id zx_lines.tax_line_id%TYPE;
3181: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3182: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3183:
3184:

Line 3200: zx_lines

3196: IS
3197: SELECT
3198: tax_line_id
3199: FROM
3200: zx_lines
3201: WHERE trx_line_id=p_customer_trx_line_id
3202: AND entity_code='TRANSACTIONS'
3203: AND application_id = 222
3204: AND trx_id = p_customer_trx_id