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.

[Home] [Help]

APPS.ZX_PRODUCT_INTEGRATION_PKG dependencies on AR_VAT_TAX

Line 25: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;

21: pg_cm_type VARCHAR2(15);
22: pg_bad_lines NUMBER;
23:
24: -- global variables for arp_tax_calculate
25: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;
26: pg_adhoc_tax_code VARCHAR2(1);
27:
28: -- Record Type modified as a fix for Bug#7530930
29: TYPE tax_line_rec_type is RECORD (

Line 2860: FROM ar_vat_tax_all_b

2856: tax_info_rec.tax_calculation_plsql_block, --l_tax_calculation_plsql_block,
2857: tax_info_rec.userf7, --l_tax_type,
2858: tax_info_rec.usern2, --l_vat_tax_id,
2859: tax_info_rec.usern1 --l_tax_category_id
2860: FROM ar_vat_tax_all_b
2861: WHERE set_of_books_id = sysinfo.sysparam.SET_OF_BOOKS_ID
2862: AND tax_code = tax_info_rec.tax_code
2863: AND tax_info_rec.trx_date BETWEEN start_date
2864: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 3293: FROM ar_vat_tax_all_b

3289: decode(tax_type,
3290: 'LOCATION', TAX_TYPE_LOCATION,
3291: 'SALES_TAX', TAX_TYPE_SALES,
3292: TAX_TYPE_VAT ) tax_type
3293: FROM ar_vat_tax_all_b
3294: WHERE set_of_books_id = c_sob_id
3295: AND tax_code = c_tax_code
3296: AND c_trx_date between start_date and nvl(end_date, c_trx_end_date)
3297: AND nvl(enabled_flag,'Y') = 'Y'

Line 4050: l_taxable_basis ar_vat_tax.taxable_basis%type;

4046: l_tax_rounding_rule ar_system_parameters.tax_rounding_rule%type;
4047: l_tax_rule_set ar_system_parameters.global_attribute13%type;
4048: l_location_id hr_locations_all.location_id%type;
4049: l_org_class hr_locations_all.global_attribute1%type;
4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;

Line 4052: ar_vat_tax.tax_calculation_plsql_block%type;

4048: l_location_id hr_locations_all.location_id%type;
4049: l_org_class hr_locations_all.global_attribute1%type;
4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;
4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;

Line 4054: l_tax_type ar_vat_tax.tax_type%type;

4050: l_taxable_basis ar_vat_tax.taxable_basis%type;
4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;
4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;
4058: l_global_attribute6 mtl_system_items.global_attribute2%type;

Line 4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;

4051: l_tax_calculation_plsql_block
4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;
4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;
4058: l_global_attribute6 mtl_system_items.global_attribute2%type;
4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

Line 4056: l_tax_category_id ar_vat_tax.global_attribute1%type;

4052: ar_vat_tax.tax_calculation_plsql_block%type;
4053: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
4054: l_tax_type ar_vat_tax.tax_type%type;
4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;
4058: l_global_attribute6 mtl_system_items.global_attribute2%type;
4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
4060:

Line 4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;

4055: l_vat_tax_id ar_vat_tax.vat_tax_id%type;
4056: l_tax_category_id ar_vat_tax.global_attribute1%type;
4057: l_global_attribute5 mtl_system_items.global_attribute1%type;
4058: l_global_attribute6 mtl_system_items.global_attribute2%type;
4059: l_tax_classification_code ar_vat_tax_all_b.tax_code%type;
4060:
4061: -- Added by ssohal for Bug#8260273
4062: CURSOR get_org_class (c_org_id HR_ORGANIZATION_UNITS.organization_id%TYPE) IS
4063: SELECT HRL.LOCATION_ID,

Line 4375: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||

4371:
4372: tax_info_rec.tax_code := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index);
4373:
4374: IF (g_level_statement >= g_current_runtime_level) THEN
4375: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||
4376: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index));
4377: END IF;
4378:
4379: -- Fetch AR_VAT_TAX details when tax_code is not NULL

Line 4379: -- Fetch AR_VAT_TAX details when tax_code is not NULL

4375: FND_LOG.STRING(g_level_statement,'ZX.PLSQL.ZX_PRODUCT_INTEGRATION_PKG','Getting attributes from AR_VAT_TAX_ALL for tax_code: '||
4376: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index));
4377: END IF;
4378:
4379: -- Fetch AR_VAT_TAX details when tax_code is not NULL
4380: l_taxable_basis := NULL;
4381: l_tax_calculation_plsql_block := NULL;
4382: l_tax_type := NULL;
4383: l_vat_tax_id := NULL;

Line 4411: FROM ar_vat_tax_all_b

4407: l_tax_calculation_plsql_block,
4408: l_tax_type,
4409: l_vat_tax_id,
4410: l_tax_category_id
4411: FROM ar_vat_tax_all_b
4412: WHERE set_of_books_id = l_set_of_books_id
4413: AND tax_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.OUTPUT_TAX_CLASSIFICATION_CODE(p_index)
4414: AND tax_info_rec.trx_date BETWEEN start_date
4415: AND NVL(end_date, TO_DATE( '31122199', 'DDMMYYYY'))

Line 6250: FROM ar_vat_tax

6246: CURSOR sel_vat_tax_rate IS
6247: SELECT vat_tax_id, tax_rate,
6248: TAX_TYPE_VAT,
6249: nvl(validate_flag, 'N')
6250: FROM ar_vat_tax
6251: WHERE tax_code = tax_info_rec.tax_code
6252: AND set_of_books_id = sysinfo.sysparam.set_of_books_id
6253: AND trunc(tax_info_rec.trx_date) between start_date and
6254: nvl(end_date, trunc(tax_info_rec.trx_date))

Line 6263: FROM ar_vat_tax

6259: CURSOR sel_vat_tax_code_count IS
6260: SELECT 1
6261: FROM DUAL
6262: WHERE EXISTS ( SELECT tax_code
6263: FROM ar_vat_tax
6264: WHERE tax_code = tax_info_rec.tax_code
6265: AND set_of_books_id = sysinfo.sysparam.set_of_books_id
6266: AND nvl(enabled_flag, 'Y') = 'Y'
6267: AND nvl(tax_class, 'O') = 'O');