DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on HR_LOCATIONS_ALL

Line 237: p_ship_to_location_id IN hr_locations_all.location_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,
239: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
240: p_item_org_id IN mtl_system_items.organization_id%TYPE,
241: p_tax_classification_code IN OUT NOCOPY VARCHAR2,

Line 323: p_ship_to_location_id IN hr_locations_all.location_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,
325: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
326: p_item_org_id IN mtl_system_items.organization_id%TYPE,
327: p_tax_classification_code IN OUT NOCOPY VARCHAR2,

Line 411: p_ship_to_location_id IN hr_locations_all.location_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,
413: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
414: p_item_org_id IN mtl_system_items.organization_id%TYPE,
415: p_tax_classification_code IN OUT NOCOPY VARCHAR2,

Line 1396: p_ship_to_location_id IN hr_locations_all.location_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,
1398: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
1399: p_item_org_id IN mtl_system_items.organization_id%TYPE,
1400: p_tax_classification_code IN OUT NOCOPY VARCHAR2,

Line 1938: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,

1934: -- 07-DEC-05 Phong La bug#4868489- modified to get ptp_id from TCM api
1935: -------------------------------------------------------------------------------
1936:
1937: FUNCTION get_ship_to_location_tax (
1938: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
1939: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
1940: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1941: p_calling_sequence IN varchar2 )
1942:

Line 1939: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,

1935: -------------------------------------------------------------------------------
1936:
1937: FUNCTION get_ship_to_location_tax (
1938: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
1939: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
1940: p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
1941: p_calling_sequence IN varchar2 )
1942:
1943: RETURN VARCHAR2 IS

Line 1963: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)

1959: AND nvl(tc.enabled_flag,'Y') = 'Y'
1960: AND tc.org_id in (sysinfo.org_id,-99);
1961:
1962: CURSOR get_ship_to_tax
1963: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1964: IS
1965: SELECT hr.tax_name
1966: FROM hr_locations_all hr,
1967: zx_input_classifications_v tc

Line 1966: FROM hr_locations_all hr,

1962: CURSOR get_ship_to_tax
1963: (c_ship_to_loc_id HR_LOCATIONS_ALL.location_id%TYPE)
1964: IS
1965: SELECT hr.tax_name
1966: FROM hr_locations_all hr,
1967: zx_input_classifications_v tc
1968: WHERE hr.location_id = c_ship_to_loc_id
1969: AND hr.tax_name = tc.lookup_code
1970: AND tc.lookup_type IN ('ZX_INPUT_CLASSIFICATIONS', 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')

Line 2075: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,

2071: -- bug#4891362- overloaded version
2072: --
2073:
2074: FUNCTION get_ship_to_location_tax (
2075: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
2076: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
2077: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
2078: p_calling_sequence IN varchar2 )
2079:

Line 2076: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,

2072: --
2073:
2074: FUNCTION get_ship_to_location_tax (
2075: p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
2076: p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
2077: --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
2078: p_calling_sequence IN varchar2 )
2079:
2080: RETURN VARCHAR2 IS

Line 2133: p_ship_to_location_id IN hr_locations_all.location_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,
2135: p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
2136: p_item_org_id IN mtl_system_items.organization_id%TYPE,
2137: p_tax_classification_code IN OUT NOCOPY VARCHAR2,