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 2321: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

2317:
2318: l_jur_index NUMBER;
2319:
2320: l_jurisdictions_found VARCHAR2(1);
2321: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2322: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2323: l_tax_class zx_rates_b.tax_class%TYPE;
2324: l_temp_num NUMBER;
2325:

Line 2322: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;

2318: l_jur_index NUMBER;
2319:
2320: l_jurisdictions_found VARCHAR2(1);
2321: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
2322: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
2323: l_tax_class zx_rates_b.tax_class%TYPE;
2324: l_temp_num NUMBER;
2325:
2326: -- cursor to order the jurisdictions in the GT

Line 4692: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,

4688: p_def_reg_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
4689: p_reg_rule_flg IN zx_taxes_b.registration_type_rule_flag%TYPE,
4690: p_trx_line_index IN BINARY_INTEGER,
4691: p_direct_rate_result_id IN NUMBER,
4692: x_jurisdiction_rec OUT NOCOPY ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type,
4693: x_jurisdictions_found OUT NOCOPY VARCHAR2,
4694: x_place_of_supply_type_code OUT NOCOPY zx_taxes_b.def_place_of_supply_type_code%TYPE,
4695: x_place_of_supply_result_id OUT NOCOPY NUMBER,
4696: x_return_status OUT NOCOPY VARCHAR2) IS

Line 4931: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (

4927:
4928: IF l_location_id IS NOT NULL THEN
4929: -- get the jurisdiction
4930: --
4931: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
4932: p_location_id => l_location_id,
4933: p_location_type => l_pos_type,
4934: p_tax => p_tax,
4935: p_tax_regime_code => p_tax_regime_code,

Line 4958: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');

4954: IF (g_level_statement >= g_current_runtime_level ) THEN
4955: FND_LOG.STRING(g_level_statement,
4956: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4957: 'Incorrect return_status after calling ' ||
4958: 'ZX_TCM_GEO_JUR_PKG.get_tax_jurisdiction');
4959: FND_LOG.STRING(g_level_statement,
4960: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_place_of_supply',
4961: 'RETURN_STATUS = ' || x_return_status);
4962: FND_LOG.STRING(g_level_statement,

Line 5058: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5054: -- x_return_status retured from TCM procedure will be handled in the
5055: -- calling procedure
5056: IF (p_pos_type = 'SHIP_TO') THEN
5057:
5058: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5059: zx_valid_init_params_pkg.source_rec.ship_to_party_type,
5060: l_loc_tbl,
5061: l_loc_site,
5062: x_return_status);

Line 5068: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5064: RETURN 'SHIP_TO_'||l_loc_site;
5065:
5066: ELSIF (p_pos_type = 'SHIP_FROM') THEN
5067:
5068: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5069: zx_valid_init_params_pkg.source_rec.ship_from_party_type,
5070: l_loc_tbl,
5071: l_loc_site,
5072: x_return_status);

Line 5078: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5074: RETURN 'SHIP_FROM_'||l_loc_site;
5075:
5076: ELSIF (p_pos_type = 'BILL_TO') THEN
5077:
5078: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5079: zx_valid_init_params_pkg.source_rec.bill_to_party_type,
5080: l_loc_tbl,
5081: l_loc_site,
5082: x_return_status);

Line 5088: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5084: RETURN 'BILL_TO_'||l_loc_site;
5085:
5086: ELSIF (p_pos_type = 'BILL_FROM') THEN
5087:
5088: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5089: zx_valid_init_params_pkg.source_rec.bill_from_party_type,
5090: l_loc_tbl,
5091: l_loc_site,
5092: x_return_status);

Line 5098: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5094: RETURN 'BILL_FROM_'||l_loc_site;
5095:
5096: ELSIF (p_pos_type = 'POINT_OF_ORIGIN') THEN
5097:
5098: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5099: zx_valid_init_params_pkg.source_rec.poo_party_type,
5100: l_loc_tbl,
5101: l_loc_site,
5102: x_return_status);

Line 5108: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5104: RETURN 'POO_'||l_loc_site;
5105:
5106: ELSIF (p_pos_type = 'POINT_OF_ACCEPTANCE') THEN
5107:
5108: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5109: zx_valid_init_params_pkg.source_rec.poa_party_type,
5110: l_loc_tbl,
5111: l_loc_site,
5112: x_return_status);

Line 5118: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5114: RETURN 'POA_'||l_loc_site;
5115:
5116: ELSIF (p_pos_type = 'TRADING_HQ') THEN
5117:
5118: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5119: zx_valid_init_params_pkg.source_rec.trad_hq_party_type,
5120: l_loc_tbl,
5121: l_loc_site,
5122: x_return_status);

Line 5128: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5124: RETURN 'TRADING_HQ_'||l_loc_site;
5125:
5126: ELSIF (p_pos_type = 'OWN_HQ') THEN
5127:
5128: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5129: zx_valid_init_params_pkg.source_rec.own_hq_party_type,
5130: l_loc_tbl,
5131: l_loc_site,
5132: x_return_status);

Line 5139: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5135: RETURN 'OWN_HQ_'||l_loc_site;
5136:
5137: ELSIF (p_pos_type = 'TITLE_TRANSFER') THEN
5138:
5139: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5140: zx_valid_init_params_pkg.source_rec.ttl_trns_party_type,
5141: l_loc_tbl,
5142: l_loc_site,
5143: x_return_status);

Line 5149: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5145: RETURN 'TITLE_TRANSFER_'||l_loc_site;
5146:
5147: ELSIF (p_pos_type = 'PAYING') THEN
5148:
5149: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5150: zx_valid_init_params_pkg.source_rec.paying_party_type,
5151: l_loc_tbl,
5152: l_loc_site,
5153: x_return_status);

Line 5160: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site

5156:
5157: ELSIF (p_pos_type = 'CONTRACT') THEN
5158:
5159: /* there is no party type for point of contract. so return hardcoded value
5160: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site
5161: (zx_valid_init_params_pkg.source_rec.poc_party_type,
5162: l_loc_tbl,
5163: l_loc_site,
5164: l_init_msg_list,

Line 5174: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5170: RETURN 'POC_'||'LOCATION_ID';
5171:
5172: ELSIF (p_pos_type = 'INVENTORY') THEN
5173:
5174: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5175: zx_valid_init_params_pkg.source_rec.poi_party_type,
5176: l_loc_tbl,
5177: l_loc_site,
5178: x_return_status);

Line 5184: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(

5180: RETURN 'POI_'||l_loc_site;
5181:
5182: ELSIF (p_pos_type = 'DESTINATION') THEN
5183:
5184: ZX_TCM_GEO_JUR_PKG.get_pos_loc_or_site(
5185: zx_valid_init_params_pkg.source_rec.pod_party_type,
5186: l_loc_tbl,
5187: l_loc_site,
5188: x_return_status);

Line 8137: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;

8133: l_curr_rownum BINARY_INTEGER;
8134: l_tax_class zx_rates_b.tax_class%TYPE;
8135: l_temp_num NUMBER;
8136: l_jurisdictions_found VARCHAR2(1);
8137: l_jurisdiction_rec ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_type;
8138: l_place_of_supply_type_code zx_taxes_b.def_place_of_supply_type_code%TYPE;
8139: l_place_of_supply_result_id NUMBER;
8140: l_begin_index BINARY_INTEGER;
8141: l_end_index BINARY_INTEGER;

Line 8152: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;

8148: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8149: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8150: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8151: l_jur_index NUMBER;
8152: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8153: l_index NUMBER;
8154: l_tbl_index BINARY_INTEGER;
8155: l_rate_exists_same_prod_family BOOLEAN;
8156: l_tax_applicable BOOLEAN;