[Home] [Help]
232: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
233: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
234: p_item_org_id IN mtl_system_items.organization_id%TYPE,
235: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
236: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
237: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
238: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
239: FUNC_SHORT_NAME IN VARCHAR2,
240: p_calling_sequence IN VARCHAR2,
318: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
319: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
320: p_item_org_id IN mtl_system_items.organization_id%TYPE,
321: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
322: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
323: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
324: FUNC_SHORT_NAME IN VARCHAR2,
325: p_calling_sequence IN VARCHAR2,
326: p_event_class_code IN VARCHAR2,
406: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
407: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
408: p_item_org_id IN mtl_system_items.organization_id%TYPE,
409: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
410: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
411: p_tax_user_override_flag IN VARCHAR2,
412: p_user_tax_name IN VARCHAR2,
413: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
414: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
1385: p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
1386: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1387: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1388: p_tax_classification_code IN OUT NOCOPY VARCHAR2,
1389: p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
1390: p_tax_user_override_flag IN VARCHAR2,
1391: p_user_tax_name IN VARCHAR2,
1392: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1393: APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
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,
2269: p_calling_sequence IN varchar2) IS
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;
2279: l_flexsegtab fnd_flex_ext.SegmentArray;
2280: l_account_seg_num number;
2392: -- This would ensure that the tax code is defaulted even in a single org instance.
2393: statement := 'SELECT toa.allow_tax_code_override_flag, ' ||
2394: 'toa.tax_classification_code, ' ||
2395: 'toa.tax_class ' ||
2396: 'FROM zx_acct_tx_cls_defs_all toa, ' ||
2397: 'zx_input_classifications_v tc ' ||
2398: 'WHERE toa.account_segment_value = :l_account_seg_value ' ||
2399: 'AND (toa.org_id = :l_bind_org_id or toa.org_id = -1)' ||
2400: 'AND toa.tax_class = ''I'' ' ||
2405: 'UNION ' ||
2406: 'SELECT toa.allow_tax_code_override_flag, ' ||
2407: 'toa.tax_classification_code, ' ||
2408: 'toa.tax_class ' ||
2409: 'FROM zx_acct_tx_cls_defs_all toa ' ||
2410: 'WHERE toa.account_segment_value = :l_account_seg_value ' ||
2411: 'AND ( toa.org_id = :l_bind_org_id or toa.org_id = -1 )' ||
2412: 'AND toa.tax_class = ''N'' ';
2413: IF (g_level_statement >= g_current_runtime_level ) THEN