[Home] [Help]
224: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
225: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
226: p_vendor_id IN po_vendors.vendor_id%TYPE,
227: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
228: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
229: p_concatenated_segments IN varchar2,
230: p_templ_tax_classification_cd IN varchar2,
231: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
310: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
311: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
312: p_vendor_id IN po_vendors.vendor_id%TYPE,
313: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
314: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
315: p_concatenated_segments IN varchar2,
316: p_templ_tax_classification_cd IN varchar2,
317: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
398: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
399: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
400: p_vendor_id IN po_vendors.vendor_id%TYPE,
401: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
402: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
403: p_concatenated_segments IN varchar2,
404: p_templ_tax_classification_cd IN varchar2,
405: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1377: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1378: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1379: p_vendor_id IN po_vendors.vendor_id%TYPE,
1380: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1381: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1382: p_concatenated_segments IN varchar2,
1383: p_templ_tax_classification_cd IN varchar2,
1384: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
2260:
2261:
2262:
2263: PROCEDURE get_account_tax (
2264: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
2265: p_concatenated_segments IN varchar2,
2266: p_tax_classification_code IN OUT NOCOPY varchar2,
2267: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
2268: p_tax_classification_found IN OUT NOCOPY boolean,
2270:
2271: l_curr_calling_sequence VARCHAR2(2000);
2272: l_bind_org_id financials_system_parameters.org_id%TYPE;
2273: l_app_column_name fnd_id_flex_segments.application_column_name%TYPE;
2274: l_account_seg_value gl_code_combinations.segment1%TYPE;
2275: -- l_tax_type_code gl_tax_option_accounts.tax_type_code%TYPE;
2276: l_tax_type_code zx_acct_tx_cls_defs.tax_class%TYPE;
2277: l_delimiter varchar2(5) := NULL;
2278: l_result number;
2313: debug_loc := 'Get_Account_Tax';
2314: l_curr_calling_sequence := 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG.'||debug_loc||'<-'||p_calling_sequence;
2315:
2316: IF (p_code_combination_id is not NULL and p_code_combination_id <> -1) THEN
2317: -- Get the column name that holds the account segment in GL_CODE_COMBINATIONS
2318: IF (g_level_statement >= g_current_runtime_level ) THEN
2319: FND_LOG.STRING(g_level_statement,
2320: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2321: 'Getting tax code using code combination ID');
2330: 'GL_ACCOUNT',
2331: l_app_column_name);
2332: --Bug Fix 1064036
2333: statement := 'SELECT ' || l_app_column_name ||
2334: ' FROM gl_code_combinations cc' ||
2335: ' WHERE cc.code_combination_id = ' || p_code_combination_id;
2336:
2337: execute immediate statement into l_account_seg_value ;
2338: IF (g_level_statement >= g_current_runtime_level ) THEN