DBA Data[Home] [Help]

APPS.ZX_TDS_APPLICABILITY_DETM_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 399: ZX_TCM_GEO_JUR_PKG.get_master_geography (

395: --
396: l_location_type := substr(l_det_factor_code_tab(l_det_factor_tab_rownum),1,
397: length(l_det_factor_code_tab(l_det_factor_tab_rownum))-12);
398:
399: ZX_TCM_GEO_JUR_PKG.get_master_geography (
400: p_location_id => l_location_id,
401: p_location_type => l_location_type,
402: p_geography_type => 'COUNTRY',
403: x_geography_id => l_geography_id,

Line 2379: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

2375:
2376: l_jur_index NUMBER;
2377:
2378: l_jurisdictions_found VARCHAR2(1);
2379: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2380: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2381: l_tax_class zx_rates_b.tax_class%TYPE;
2382: l_temp_num NUMBER;
2383:

Line 2380: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;

2376: l_jur_index NUMBER;
2377:
2378: l_jurisdictions_found VARCHAR2(1);
2379: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2380: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2381: l_tax_class zx_rates_b.tax_class%TYPE;
2382: l_temp_num NUMBER;
2383:
2384: -- Added for bug 10184087 --

Line 5190: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,

5186: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5187: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
5188: p_trx_line_index IN BINARY_INTEGER,
5189: p_direct_rate_result_id IN NUMBER,
5190: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
5191: x_jurisdictions_found OUT NOCOPY VARCHAR2,
5192: x_place_of_supply_type_code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,
5193: x_place_of_supply_result_id OUT NOCOPY NUMBER,
5194: x_return_status OUT NOCOPY VARCHAR2) IS

Line 5429: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

5425:
5426: IF l_location_id IS NOT NULL THEN
5427: -- get the jurisdiction
5428: --
5429: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
5430: p_location_id => l_location_id,
5431: p_location_type => l_pos_type,
5432: p_tax => p_tax,
5433: p_tax_regime_code => p_tax_regime_code,

Line 5456: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');

5452: IF (g_level_statement >= g_current_runtime_level ) THEN
5453: FND_LOG.STRING(g_level_statement,
5454: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
5455: 'Incorrect return_status after calling ' ||
5456: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
5457: FND_LOG.STRING(g_level_statement,
5458: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
5459: 'RETURN_STATUS = ' || x_return_status);
5460: FND_LOG.STRING(g_level_statement,

Line 5556: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5552: -- x_return_status retured from TCM procedure will be handled in the
5553: -- calling procedure
5554: IF (p_pos_type = 'SHIP_TO') THEN
5555:
5556: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5557: zx_valid_init_params_pkg.source_rec.ship_to_party_type,
5558: l_loc_tbl,
5559: l_loc_site,
5560: x_return_status);

Line 5566: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5562: RETURN 'SHIP_TO_'||l_loc_site;
5563:
5564: ELSIF (p_pos_type = 'SHIP_FROM') THEN
5565:
5566: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5567: zx_valid_init_params_pkg.source_rec.ship_from_party_type,
5568: l_loc_tbl,
5569: l_loc_site,
5570: x_return_status);

Line 5576: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5572: RETURN 'SHIP_FROM_'||l_loc_site;
5573:
5574: ELSIF (p_pos_type = 'BILL_TO') THEN
5575:
5576: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5577: zx_valid_init_params_pkg.source_rec.bill_to_party_type,
5578: l_loc_tbl,
5579: l_loc_site,
5580: x_return_status);

Line 5586: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5582: RETURN 'BILL_TO_'||l_loc_site;
5583:
5584: ELSIF (p_pos_type = 'BILL_FROM') THEN
5585:
5586: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5587: zx_valid_init_params_pkg.source_rec.bill_from_party_type,
5588: l_loc_tbl,
5589: l_loc_site,
5590: x_return_status);

Line 5596: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5592: RETURN 'BILL_FROM_'||l_loc_site;
5593:
5594: ELSIF (p_pos_type = 'POINT_OF_ORIGIN') THEN
5595:
5596: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5597: zx_valid_init_params_pkg.source_rec.poo_party_type,
5598: l_loc_tbl,
5599: l_loc_site,
5600: x_return_status);

Line 5606: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5602: RETURN 'POO_'||l_loc_site;
5603:
5604: ELSIF (p_pos_type = 'POINT_OF_ACCEPTANCE') THEN
5605:
5606: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5607: zx_valid_init_params_pkg.source_rec.poa_party_type,
5608: l_loc_tbl,
5609: l_loc_site,
5610: x_return_status);

Line 5616: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5612: RETURN 'POA_'||l_loc_site;
5613:
5614: ELSIF (p_pos_type = 'TRADING_HQ') THEN
5615:
5616: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5617: zx_valid_init_params_pkg.source_rec.trad_hq_party_type,
5618: l_loc_tbl,
5619: l_loc_site,
5620: x_return_status);

Line 5626: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5622: RETURN 'TRADING_HQ_'||l_loc_site;
5623:
5624: ELSIF (p_pos_type = 'OWN_HQ') THEN
5625:
5626: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5627: zx_valid_init_params_pkg.source_rec.own_hq_party_type,
5628: l_loc_tbl,
5629: l_loc_site,
5630: x_return_status);

Line 5637: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5633: RETURN 'OWN_HQ_'||l_loc_site;
5634:
5635: ELSIF (p_pos_type = 'TITLE_TRANSFER') THEN
5636:
5637: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5638: zx_valid_init_params_pkg.source_rec.ttl_trns_party_type,
5639: l_loc_tbl,
5640: l_loc_site,
5641: x_return_status);

Line 5647: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5643: RETURN 'TITLE_TRANSFER_'||l_loc_site;
5644:
5645: ELSIF (p_pos_type = 'PAYING') THEN
5646:
5647: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5648: zx_valid_init_params_pkg.source_rec.paying_party_type,
5649: l_loc_tbl,
5650: l_loc_site,
5651: x_return_status);

Line 5658: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site

5654:
5655: ELSIF (p_pos_type = 'CONTRACT') THEN
5656:
5657: /* there is no party type for point of contract. so return hardcoded value
5658: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site
5659: (zx_valid_init_params_pkg.source_rec.poc_party_type,
5660: l_loc_tbl,
5661: l_loc_site,
5662: l_init_msg_list,

Line 5672: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5668: RETURN 'POC_'||'LOCATION_ID';
5669:
5670: ELSIF (p_pos_type = 'INVENTORY') THEN
5671:
5672: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5673: zx_valid_init_params_pkg.source_rec.poi_party_type,
5674: l_loc_tbl,
5675: l_loc_site,
5676: x_return_status);

Line 5682: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5678: RETURN 'POI_'||l_loc_site;
5679:
5680: ELSIF (p_pos_type = 'DESTINATION') THEN
5681:
5682: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5683: zx_valid_init_params_pkg.source_rec.pod_party_type,
5684: l_loc_tbl,
5685: l_loc_site,
5686: x_return_status);

Line 8799: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

8795: l_curr_rownum BINARY_INTEGER;
8796: l_tax_class zx_rates_b.tax_class%TYPE;
8797: l_temp_num NUMBER;
8798: l_jurisdictions_found VARCHAR2(1);
8799: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8800: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
8801: l_place_of_supply_result_id NUMBER;
8802: l_begin_index BINARY_INTEGER;
8803: l_end_index BINARY_INTEGER;

Line 8814: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;

8810: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8811: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8812: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8813: l_jur_index NUMBER;
8814: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8815: l_index NUMBER;
8816: l_tbl_index BINARY_INTEGER;
8817: l_rate_exists_same_prod_family BOOLEAN;
8818: l_tax_applicable BOOLEAN;