DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on HR_LOCATIONS_ALL

Line 231: p_ship_to_location_id IN hr_locations_all.location_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,
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,

Line 317: p_ship_to_location_id IN hr_locations_all.location_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,
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,

Line 405: p_ship_to_location_id IN hr_locations_all.location_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,
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,

Line 1384: p_ship_to_location_id IN hr_locations_all.location_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,
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,

Line 1926: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,

1922: -- 07-DEC-05 Phong La bug#4868489- modified to get ptp_id from TCM api
1923: -------------------------------------------------------------------------------
1924:
1925: FUNCTION get_ship_to_location_tax (
1926: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
1927: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
1928: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1929: p_calling_sequence IN varchar2 )
1930:

Line 1927: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,

1923: -------------------------------------------------------------------------------
1924:
1925: FUNCTION get_ship_to_location_tax (
1926: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
1927: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
1928: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1929: p_calling_sequence IN varchar2 )
1930:
1931: RETURN VARCHAR2 IS

Line 1951: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)

1947: AND nvl(tc.enabled_flag,'Y') = 'Y'
1948: AND tc.org_id in (sysinfo.org_id,-99);
1949:
1950: CURSOR get_ship_to_tax
1951: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1952: IS
1953: SELECT hr.tax_name
1954: FROM hr_locations_all hr,
1955: zx_input_classifications_v tc

Line 1954: FROM hr_locations_all hr,

1950: CURSOR get_ship_to_tax
1951: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1952: IS
1953: SELECT hr.tax_name
1954: FROM hr_locations_all hr,
1955: zx_input_classifications_v tc
1956: WHERE hr.location_id = c_ship_to_loc_id
1957: AND hr.tax_name = tc.lookup_code
1958: AND tc.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')

Line 2063: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,

2059: -- bug#4891362- overloaded version
2060: --
2061:
2062: FUNCTION get_ship_to_location_tax (
2063: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
2064: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
2065: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
2066: p_calling_sequence IN varchar2 )
2067:

Line 2064: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,

2060: --
2061:
2062: FUNCTION get_ship_to_location_tax (
2063: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
2064: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
2065: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
2066: p_calling_sequence IN varchar2 )
2067:
2068: RETURN VARCHAR2 IS