APPS.PO_VAL_HEADERS2 dependencies on HR_LOCATIONS

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

910: RAISE;
911: END vendor_info;
912:
913: -------------------------------------------------------------------------
914: -- ShipToLocationId must not be null and valid in HR_LOCATIONS.
915: -------------------------------------------------------------------------
916: PROCEDURE ship_to_location_id(
917: p_id_tbl IN po_tbl_number,
918: p_ship_to_location_id_tbl IN po_tbl_number,

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

934: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
935: END IF;
936:
937: x_result_type := po_validations.c_result_type_success;
938: -- validate ship_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
939: FORALL i IN 1 .. p_id_tbl.COUNT
940: INSERT INTO po_validation_results_gt
941: (result_set_id,
942: result_type,

Line 973: FROM hr_locations hrl

969: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
970: OR (p_ship_to_location_id_tbl(i) IS NOT NULL
971: AND NOT EXISTS(
972: SELECT 1
973: FROM hr_locations hrl
974: WHERE hrl.ship_to_site_flag = 'Y'
975: AND p_ship_to_location_id_tbl(i) = hrl.location_id
976: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
977:

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

993: RAISE;
994: END ship_to_location_id;
995:
996: -------------------------------------------------------------------------
997: -- BillToLocationId must not be null and validate against HR_LOCATIONS.
998: -------------------------------------------------------------------------
999: PROCEDURE bill_to_location_id(
1000: p_id_tbl IN po_tbl_number,
1001: p_bill_to_location_id_tbl IN po_tbl_number,

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

1017: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
1018: END IF;
1019:
1020: x_result_type := po_validations.c_result_type_success;
1021: -- validate bill_to_location_id is not null (for PO and BPA) and valid in HR_LOCATIONS
1022: FORALL i IN 1 .. p_id_tbl.COUNT
1023: INSERT INTO po_validation_results_gt
1024: (result_set_id,
1025: result_type,

Line 1056: FROM hr_locations hrl

1052: AND p_type_lookup_code_tbl(i) <> 'QUOTATION')
1053: OR (p_bill_to_location_id_tbl(i) IS NOT NULL
1054: AND NOT EXISTS(
1055: SELECT 1
1056: FROM hr_locations hrl
1057: WHERE hrl.bill_to_site_flag = 'Y'
1058: AND p_bill_to_location_id_tbl(i) = hrl.location_id
1059: AND SYSDATE < NVL(hrl.inactive_date, SYSDATE + 1)));
1060: