APPS.PO_VAL_HEADERS2 dependencies on HR_LOCATIONS

Line 904: -- ShipToLocationId must not be null and valid in HR_LOCATIONS.

900: RAISE;
901: END vendor_info;
902:
903: -------------------------------------------------------------------------
904: -- ShipToLocationId must not be null and valid in HR_LOCATIONS.
905: -------------------------------------------------------------------------
906: PROCEDURE ship_to_location_id(
907: p_id_tbl IN po_tbl_number,
908: p_ship_to_location_id_tbl IN po_tbl_number,

Line 928: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

924: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
925: END IF;
926:
927: x_result_type := po_validations.c_result_type_success;
928: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
929: FORALL i IN 1 .. p_id_tbl.COUNT
930: INSERT INTO po_validation_results_gt
931: (result_set_id,
932: result_type,

Line 963: FROM hr_locations hrl

959: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
960: OR (p_ship_to_location_id_tbl(i) IS NOT NULL
961: AND NOT EXISTS(
962: SELECT 1
963: FROM hr_locations hrl
964: WHERE hrl.ship_to_site_flag = 'Y'
965: AND p_ship_to_location_id_tbl(i) = hrl.location_id
966: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
967:

Line 987: -- BillToLocationId must not be null and validate against HR_LOCATIONS.

983: RAISE;
984: END ship_to_location_id;
985:
986: -------------------------------------------------------------------------
987: -- BillToLocationId must not be null and validate against HR_LOCATIONS.
988: -------------------------------------------------------------------------
989: PROCEDURE bill_to_location_id(
990: p_id_tbl IN po_tbl_number,
991: p_bill_to_location_id_tbl IN po_tbl_number,

Line 1011: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS

1007: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1008: END IF;
1009:
1010: x_result_type := po_validations.c_result_type_success;
1011: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
1012: FORALL i IN 1 .. p_id_tbl.COUNT
1013: INSERT INTO po_validation_results_gt
1014: (result_set_id,
1015: result_type,

Line 1046: FROM hr_locations hrl

1042: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
1043: OR (p_bill_to_location_id_tbl(i) IS NOT NULL
1044: AND NOT EXISTS(
1045: SELECT 1
1046: FROM hr_locations hrl
1047: WHERE hrl.bill_to_site_flag = 'Y'
1048: AND p_bill_to_location_id_tbl(i) = hrl.location_id
1049: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
1050: