APPS.AP_IMPORT_VALIDATION_PKG dependencies on HR_LOCATIONS

Line 111: l_country_code HR_LOCATIONS_ALL.COUNTRY%TYPE;

107: l_total_amt_tolerance NUMBER;
108:
109: l_party_site_id NUMBER(15);
110: /* 9738820 additional parameters */
111: l_country_code HR_LOCATIONS_ALL.COUNTRY%TYPE;
112: l_return_status VARCHAR2(1);
113: l_msg_count NUMBER;
114: l_msg_data VARCHAR2(1000);
115: /* End Bug 9738820 parameters */

Line 7263: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is

7259: -- FOR UPDATE OF invoice_line_id; -- Bug 1714845
7260:
7261:
7262: -- bug# 13398814 starts
7263: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
7264: Select ship_to_location_id
7265: From hr_locations
7266: Where location_code = p_ship_to_loc_code
7267: and nvl(ship_to_site_flag, 'N') = 'Y';

Line 7265: From hr_locations

7261:
7262: -- bug# 13398814 starts
7263: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
7264: Select ship_to_location_id
7265: From hr_locations
7266: Where location_code = p_ship_to_loc_code
7267: and nvl(ship_to_site_flag, 'N') = 'Y';
7268:
7269:

Line 10858: hr_locations hl

10854:
10855: SELECT 'Y', line_location_id
10856: INTO l_po_shipment_is_valid_flag, l_po_line_location_id
10857: FROM po_line_locations pll,
10858: hr_locations hl
10859: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10860: AND hl.location_id = pll.ship_to_location_id
10861: AND pll.po_header_id = l_po_header_id
10862: AND pll.po_line_id = l_po_line_id;

Line 10985: FROM po_line_locations pll, hr_locations hl

10981: SELECT 'Y', line_location_id,
10982: po_line_id
10983: INTO l_po_shipment_is_valid_flag, l_po_line_location_id,
10984: l_po_line_id
10985: FROM po_line_locations pll, hr_locations hl
10986: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10987: AND hl.location_id = pll.ship_to_location_id
10988: AND pll.po_header_id = l_po_header_id
10989: AND pll.po_release_id = l_po_release_id;

Line 11079: hr_locations hl

11075:
11076: SELECT 'Y'
11077: INTO l_po_shipment_is_consis_flag
11078: FROM po_line_locations pll,
11079: hr_locations hl
11080: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11081: AND hl.location_id = pll.ship_to_location_id
11082: AND line_location_id = l_po_line_location_id;
11083:

Line 11127: hr_locations hl

11123: --
11124: SELECT 'Y'
11125: INTO l_po_shipment_is_consis_flag
11126: FROM po_line_locations pll,
11127: hr_locations hl
11128: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11129: AND hl.location_id = pll.ship_to_location_id
11130: AND po_line_id = l_po_line_id
11131: AND shipment_num = p_invoice_lines_rec.po_shipment_num

Line 11264: hr_locations hl

11260: --
11261: SELECT 'Y'
11262: INTO l_po_shipment_is_consis_flag
11263: FROM po_line_locations pll,
11264: hr_locations hl
11265: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11266: AND hl.location_id = pll.ship_to_location_id
11267: AND po_release_id = l_po_release_id
11268: AND shipment_num = p_invoice_lines_rec.po_shipment_num

Line 23704: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is

23700: p_default_last_update_login IN NUMBER,
23701: p_current_invoice_status IN OUT NOCOPY VARCHAR2,
23702: p_calling_sequence IN VARCHAR2) return boolean IS
23703:
23704: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
23705: Select ship_to_location_id
23706: From hr_locations
23707: Where location_code = p_ship_to_loc_code
23708: and nvl(ship_to_site_flag, 'N') = 'Y';

Line 23706: From hr_locations

23702: p_calling_sequence IN VARCHAR2) return boolean IS
23703:
23704: Cursor c_ship_to_location (p_ship_to_loc_code HR_LOCATIONS.LOCATION_CODE%TYPE) Is
23705: Select ship_to_location_id
23706: From hr_locations
23707: Where location_code = p_ship_to_loc_code
23708: and nvl(ship_to_site_flag, 'N') = 'Y';
23709:
23710: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;