DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on GL_CODE_COMBINATIONS

Line 234: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

230: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
231: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
232: p_vendor_id IN po_vendors.vendor_id%TYPE,
233: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
234: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
235: p_concatenated_segments IN varchar2,
236: p_templ_tax_classification_cd IN varchar2,
237: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
238: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

Line 320: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

316: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
317: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
318: p_vendor_id IN po_vendors.vendor_id%TYPE,
319: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
320: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
321: p_concatenated_segments IN varchar2,
322: p_templ_tax_classification_cd IN varchar2,
323: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
324: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

Line 408: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

404: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
405: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
406: p_vendor_id IN po_vendors.vendor_id%TYPE,
407: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
408: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
409: p_concatenated_segments IN varchar2,
410: p_templ_tax_classification_cd IN varchar2,
411: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
412: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

Line 1393: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

1389: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
1390: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
1391: p_vendor_id IN po_vendors.vendor_id%TYPE,
1392: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
1393: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
1394: p_concatenated_segments IN varchar2,
1395: p_templ_tax_classification_cd IN varchar2,
1396: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
1397: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

Line 2130: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

2126: p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
2127: p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
2128: p_vendor_id IN po_vendors.vendor_id%TYPE,
2129: p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
2130: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
2131: p_concatenated_segments IN varchar2,
2132: p_templ_tax_classification_cd IN varchar2,
2133: p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
2134: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,

Line 2856: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,

2852:
2853:
2854:
2855: PROCEDURE get_account_tax (
2856: p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
2857: p_concatenated_segments IN varchar2,
2858: p_tax_classification_code IN OUT NOCOPY varchar2,
2859: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
2860: p_tax_classification_found IN OUT NOCOPY boolean,

Line 2866: l_account_seg_value gl_code_combinations.segment1%TYPE;

2862:
2863: l_curr_calling_sequence VARCHAR2(2000);
2864: l_bind_org_id financials_system_parameters.org_id%TYPE;
2865: l_app_column_name fnd_id_flex_segments.application_column_name%TYPE;
2866: l_account_seg_value gl_code_combinations.segment1%TYPE;
2867: -- l_tax_type_code gl_tax_option_accounts.tax_type_code%TYPE;
2868: l_tax_type_code zx_acct_tx_cls_defs.tax_class%TYPE;
2869: l_delimiter varchar2(5) := NULL;
2870: l_result number;

Line 2909: -- Get the column name that holds the account segment in GL_CODE_COMBINATIONS

2905: debug_loc := 'Get_Account_Tax';
2906: l_curr_calling_sequence := 'ZX_AP_TAX_CLASSIFICATN_DEF_PKG.'||debug_loc||'<-'||p_calling_sequence;
2907:
2908: IF (p_code_combination_id is not NULL and p_code_combination_id <> -1) THEN
2909: -- Get the column name that holds the account segment in GL_CODE_COMBINATIONS
2910: IF (g_level_statement >= g_current_runtime_level ) THEN
2911: FND_LOG.STRING(g_level_statement,
2912: 'ZX.PLSQL.ZX_AP_TAX_CLASSIFICATN_DEF_PKG.Get_Account_Tax',
2913: 'Getting tax code using code combination ID');

Line 2926: ' FROM gl_code_combinations cc' ||

2922: 'GL_ACCOUNT',
2923: l_app_column_name);
2924: --Bug Fix 1064036
2925: statement := 'SELECT ' || l_app_column_name ||
2926: ' FROM gl_code_combinations cc' ||
2927: ' WHERE cc.code_combination_id = ' || p_code_combination_id;
2928:
2929: execute immediate statement into l_account_seg_value ;
2930: IF (g_level_statement >= g_current_runtime_level ) THEN