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 ZX_LINES

Line 181: l_document_subtype zx_lines_det_factors.DOCUMENT_SUB_TYPE%TYPE;

177: l_error_string VARCHAR2(1000);
178:
179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
180: l_class_code hz_code_assignments.CLASS_CODE%TYPE;
181: l_document_subtype zx_lines_det_factors.DOCUMENT_SUB_TYPE%TYPE;
182:
183: BEGIN
184:
185: /*

Line 270: FROM zx_lines_det_factors z

266: IF l_class_code = 'AR_GTA_GENERAL_TAXPAYER' THEN
267: --check if document type specifis the invoice as common invoice.
268: SELECT z.DOCUMENT_SUB_TYPE
269: INTO l_document_subtype
270: FROM zx_lines_det_factors z
271: WHERE z.TRX_ID = p_customer_trx_id
272: AND z.TRX_LINE_ID = p_trx_line_id;
273: IF l_document_subtype = 'AR_GTA_COM_VAT_INV' THEN
274: l_invoice_type := '2'; -- 'COMMON';

Line 1131: l_tax_type_code zx_lines.tax_type_code%TYPE;

1127: ,p_customer_trx_line_id IN NUMBER
1128: )
1129: RETURN BOOLEAN
1130: IS
1131: l_tax_type_code zx_lines.tax_type_code%TYPE;
1132: l_taxline_count NUMBER;
1133: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1134: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
1135:

Line 1150: zx_lines

1146: IS
1147: SELECT
1148: COUNT(*)
1149: FROM
1150: zx_lines
1151: WHERE trx_line_id=p_customer_trx_line_id
1152: AND entity_code='TRANSACTIONS'
1153: AND application_id = 222
1154: AND trx_level_type='LINE'

Line 1244: l_tax_type_code zx_lines.tax_type_code%TYPE;

1240: ,p_customer_trx_id IN NUMBER
1241: )
1242: RETURN BOOLEAN
1243: IS
1244: l_tax_type_code zx_lines.tax_type_code%TYPE;
1245: l_taxline_count NUMBER;
1246: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1247:
1248:

Line 1267: zx_lines

1263: (SELECT
1264: trx_line_id
1265: ,COUNT(*)
1266: FROM
1267: zx_lines
1268: WHERE application_id = 222
1269: AND trx_id=p_customer_trx_id
1270: AND trx_level_type='LINE'
1271: AND entity_code='TRANSACTIONS'

Line 1356: l_tax_type_code zx_lines.tax_type_code%TYPE;

1352: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1353: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1354: l_proc_level NUMBER := fnd_log.level_procedure;
1355:
1356: l_tax_type_code zx_lines.tax_type_code%TYPE;
1357: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1358: l_ar_taxable_amount NUMBER;
1359:
1360:

Line 1376: zx_lines

1372: IS
1373: SELECT
1374: NVL(SUM(taxable_amt_tax_curr),0)
1375: FROM
1376: zx_lines
1377: WHERE application_id = 222
1378: AND trx_id=p_customer_trx_id
1379: AND trx_level_type='LINE'
1380: AND entity_code='TRANSACTIONS'

Line 1451: l_tax_type_code zx_lines.tax_type_code%TYPE;

1447: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1448: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1449: l_proc_level NUMBER := fnd_log.level_procedure;
1450:
1451: l_tax_type_code zx_lines.tax_type_code%TYPE;
1452: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1453: l_ar_tax_amount NUMBER;
1454:
1455:

Line 1471: zx_lines

1467: IS
1468: SELECT
1469: NVL(SUM(tax_amt_tax_curr),0)
1470: FROM
1471: zx_lines
1472: WHERE application_id = 222
1473: AND trx_id=p_customer_trx_id
1474: AND trx_level_type='LINE'
1475: AND entity_code='TRANSACTIONS'

Line 1848: -- Tax currency from the table zx_lines

1844: -- CHANGE HISTORY:
1845: --
1846: -- 13-Jun-2005: Donghai Wang Creation
1847: -- 24-Nov-2005: Modify program logic to get line amount per Golden
1848: -- Tax currency from the table zx_lines
1849: --
1850: --=========================================================================
1851: FUNCTION Get_Arline_Amount
1852: (p_org_id IN NUMBER

Line 1857: l_tax_type_code zx_lines.tax_type_code%TYPE;

1853: ,p_customer_trx_line_id IN NUMBER
1854: )
1855: RETURN NUMBER
1856: IS
1857: l_tax_type_code zx_lines.tax_type_code%TYPE;
1858: l_arline_amount NUMBER;
1859: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1860: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1861:

Line 1877: zx_lines

1873: IS
1874: SELECT
1875: taxable_amt_tax_curr
1876: FROM
1877: zx_lines
1878: WHERE trx_line_id=p_customer_trx_line_id
1879: AND entity_code='TRANSACTIONS'
1880: AND application_id = 222
1881: AND trx_level_type='LINE'

Line 1969: l_tax_type_code zx_lines.tax_type_code%TYPE;

1965: ,p_customer_trx_line_id IN NUMBER
1966: )
1967: RETURN NUMBER
1968: IS
1969: l_tax_type_code zx_lines.tax_type_code%TYPE;
1970: l_arline_vatamount NUMBER;
1971: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1972: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
1973:

Line 1989: zx_lines

1985: IS
1986: SELECT
1987: tax_amt_tax_curr
1988: FROM
1989: zx_lines
1990: WHERE trx_line_id=p_customer_trx_line_id
1991: AND entity_code='TRANSACTIONS'
1992: AND application_id = 222
1993: AND trx_level_type='LINE'

Line 2080: l_tax_type_code zx_lines.tax_type_code%TYPE;

2076: ,p_customer_trx_line_id IN NUMBER
2077: )
2078: RETURN NUMBER
2079: IS
2080: l_tax_type_code zx_lines.tax_type_code%TYPE;
2081: l_tax_rate NUMBER;
2082: l_gt_currency_code fnd_currencies.currency_code%TYPE;
2083: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
2084:

Line 2100: zx_lines

2096: IS
2097: SELECT
2098: tax_rate
2099: FROM
2100: zx_lines
2101: WHERE trx_line_id=p_customer_trx_line_id
2102: AND entity_code='TRANSACTIONS'
2103: AND application_id = 222
2104: AND trx_level_type='LINE'

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

2983:
2984: -- p_trx_line_id IN NUMBER
2985: -- p_tax_type_code IN VARCHAR2
2986: -- x_status OUT NOCOPY NUMBER
2987: -- x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE
2988: --
2989: -- DESIGN REFERENCES:
2990: --
2991: --

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

2998: (p_trx_line_id IN NUMBER
2999: , p_tax_type_code IN VARCHAR2
3000: , p_currency_code IN VARCHAR2
3001: , x_status OUT NOCOPY NUMBER
3002: , x_tax_line_id OUT NOCOPY zx_lines.tax_line_id%TYPE
3003: )
3004: IS
3005: l_tax_line_count NUMBER;
3006: l_procedure_name VARCHAR2(50) := 'verify_tax_line';

Line 3007: l_tax_line_id zx_lines.tax_line_id%TYPE;

3003: )
3004: IS
3005: l_tax_line_count NUMBER;
3006: l_procedure_name VARCHAR2(50) := 'verify_tax_line';
3007: l_tax_line_id zx_lines.tax_line_id%TYPE;
3008: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
3009:
3010: BEGIN
3011:

Line 3041: zx_lines tax

3037: COUNT(*)
3038: INTO
3039: l_tax_line_count
3040: FROM
3041: zx_lines tax
3042: WHERE tax.trx_line_id = p_trx_line_id
3043: AND tax.entity_code = 'TRANSACTIONS'
3044: AND application_id = 222
3045: AND tax.trx_level_type = 'LINE'

Line 3067: zx_lines tax

3063: tax.tax_line_id
3064: INTO
3065: l_tax_line_id
3066: FROM
3067: zx_lines tax
3068: WHERE tax.trx_line_id = p_trx_line_id
3069: AND tax.application_id = 222
3070: AND tax.trx_level_type = 'LINE'
3071: AND tax.entity_code = 'TRANSACTIONS'

Line 3174: l_tax_registration_number zx_lines.tax_registration_number%TYPE;

3170: l_procedure_name VARCHAR2(30) := 'get_info_from_ebtax';
3171: l_lines_status NUMBER;
3172: l_status NUMBER;
3173: l_error_buffer VARCHAR2(180);
3174: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
3175: l_tax_registration_count NUMBER;
3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;

Line 3176: l_tax_line_id zx_lines.tax_line_id%TYPE;

3172: l_status NUMBER;
3173: l_error_buffer VARCHAR2(180);
3174: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
3175: l_tax_registration_count NUMBER;
3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;

Line 3177: l_tax_rate zx_lines.tax_rate%TYPE;

3173: l_error_buffer VARCHAR2(180);
3174: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
3175: l_tax_registration_count NUMBER;
3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;

Line 3178: l_unit_price zx_lines.unit_price%TYPE;

3174: l_tax_registration_number zx_lines.tax_registration_number%TYPE;
3175: l_tax_registration_count NUMBER;
3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;

Line 3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;

3175: l_tax_registration_count NUMBER;
3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;

Line 3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;

3176: l_tax_line_id zx_lines.tax_line_id%TYPE;
3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;
3184: l_fp_reg_number_count NUMBER;

Line 3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;

3177: l_tax_rate zx_lines.tax_rate%TYPE;
3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;
3184: l_fp_reg_number_count NUMBER;
3185: l_amount zx_lines.taxable_amt%TYPE;

Line 3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;

3178: l_unit_price zx_lines.unit_price%TYPE;
3179: l_trx_line_quantity zx_lines.trx_line_quantity%TYPE;
3180: l_tax_amount zx_lines.tax_amt_funcl_curr%TYPE;
3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;
3184: l_fp_reg_number_count NUMBER;
3185: l_amount zx_lines.taxable_amt%TYPE;
3186: l_currency_code VARCHAR2(30);

Line 3185: l_amount zx_lines.taxable_amt%TYPE;

3181: l_taxable_amount zx_lines.taxable_amt_funcl_curr%TYPE;
3182: l_tax_curr_conversion_rate zx_lines.tax_currency_conversion_rate%TYPE;
3183: l_tp_registration_number zx_registrations.registration_number%TYPE;
3184: l_fp_reg_number_count NUMBER;
3185: l_amount zx_lines.taxable_amt%TYPE;
3186: l_currency_code VARCHAR2(30);
3187: l_error_string VARCHAR2(500);
3188: --added by subba for R12.1
3189: l_invoice_type ar_gta_tax_limits_all.invoice_type%type;

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

3262:
3263: -- if the line count is 0, return -1 and the line can't be transfer and don't
3264: -- throw any exception
3265: -- if the line count > 1 , return 1 and throw exception
3266: -- if the line count = 1 , get data from zx_lines and transfer it to GTA
3267: -- 29-JUN-2006 Upated by Shujuan, insert Tax_currency_conversion_rate
3268: -- into l_tax_curr_conversion_rate in order to calculate the unit price of
3269: -- tax concurrency for bug 5168900
3270: IF l_lines_status = 0

Line 3295: zx_lines tax

3291: , l_trx_line_quantity
3292: , l_amount
3293: , l_tax_curr_conversion_rate
3294: FROM
3295: zx_lines tax
3296: WHERE tax.trx_line_id = p_trx_line_id
3297: AND tax.entity_code = 'TRANSACTIONS'
3298: AND application_id = 222
3299: AND tax.trx_level_type = 'LINE'

Line 3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;

3516: IS
3517: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;

Line 3521: l_tax zx_lines.tax%TYPE;

3517: l_procedure_name VARCHAR2(80) := 'get_tp_tax_registration_number';
3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;

Line 3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;

3518: l_bill_to_site_use_id ra_customer_trx_all.bill_to_site_use_id%TYPE;
3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;

Line 3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;

3519: l_ra_cust_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
3520: l_tax_regime_code zx_lines.tax_regime_code%TYPE;
3521: l_tax zx_lines.tax%TYPE;
3522: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
3523: l_tax_determine_date zx_lines.tax_determine_date%TYPE;
3524: l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%TYPE;
3525: l_tax_registration_number zx_registrations.registration_number%TYPE;
3526: l_reg_tax_regime_code zx_registrations.tax_regime_code%TYPE;
3527: l_reg_tax zx_registrations.tax%TYPE;

Line 3642: zx_lines tax

3638: , l_tax
3639: , l_tax_jurisdiction_code
3640: , l_tax_determine_date
3641: FROM
3642: zx_lines tax
3643: WHERE
3644: tax.tax_line_id = p_tax_line_id;
3645:
3646: EXCEPTION

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

3750: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3751: THEN
3752: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3753: , G_MODULE_PREFIX || l_procedure_name
3754: ,'tax or tax_jur is null in zx_lines ');
3755: END IF;
3756:
3757: END IF;/*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3758:

Line 3945: l_tax_type_code zx_lines.tax_type_code%TYPE;

3941: ,p_customer_trx_line_id IN NUMBER
3942: )
3943: RETURN VARCHAR2
3944: IS
3945: l_tax_type_code zx_lines.tax_type_code%TYPE;
3946: l_tax_rate NUMBER;
3947: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3948: l_tax_line_id zx_lines.tax_line_id%TYPE;
3949: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;

Line 3948: l_tax_line_id zx_lines.tax_line_id%TYPE;

3944: IS
3945: l_tax_type_code zx_lines.tax_type_code%TYPE;
3946: l_tax_rate NUMBER;
3947: l_gt_currency_code fnd_currencies.currency_code%TYPE;
3948: l_tax_line_id zx_lines.tax_line_id%TYPE;
3949: l_tp_tax_registration_number zx_registrations.registration_number%TYPE;
3950: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--Donghai Wang bug5212702 May-17,2006
3951:
3952:

Line 3968: zx_lines

3964: IS
3965: SELECT
3966: tax_line_id
3967: FROM
3968: zx_lines
3969: WHERE trx_line_id=p_customer_trx_line_id
3970: AND entity_code='TRANSACTIONS'
3971: AND application_id = 222
3972: AND trx_id = p_customer_trx_id