APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on HR_OPERATING_UNITS

Line 34: -- This procedure also validates the org_id against the HR_OPERATING_UNITS

30: --Function:
31: -- Validates org_id. It can not be NULL or -2.
32: -- (For Operating Unit (org_id), iProc defined a values of -2 for 'All Orgs'.
33: -- This value will now fail validation in migration program.)
34: -- This procedure also validates the org_id against the HR_OPERATING_UNITS
35: -- table. The org_id must exist in this table and must not be end-dated.
36: --
37: --Parameters:
38: --IN:

Line 110: -- Also validates the org_id against HR_OPERATING_UNITS.

106:
107: -- ECO bug 5584556: Add new messages
108: l_progress := '060';
109: -- SQL What: Bulk validate org_id -- it should not be NULL or -2.
110: -- Also validates the org_id against HR_OPERATING_UNITS.
111: -- Gets the errored rows into GT table.
112: -- SQL Why : It will be used to mark the record in interface tables as rejected.
113: -- SQL Join: interface_header_id
114: FORALL i IN 1 .. l_interface_header_ids.COUNT

Line 168: -- Validate the org_id against HR_OPERATING_UNITS.

164: -- ECO bug 5584556: End
165:
166: l_progress := '090';
167: -- SQL What: Bulk validate org_id.
168: -- Validate the org_id against HR_OPERATING_UNITS.
169: -- Gets the errored rows into GT table.
170: -- SQL Why : It will be used to mark the record in interface tables as rejected.
171: -- SQL Join: interface_header_id
172: FORALL i IN 1 .. l_interface_header_ids.COUNT

Line 188: FROM HR_OPERATING_UNITS HROU

184: -- ECO bug 5584556: End
185: AND (
186: NOT EXISTS
187: (SELECT 'Valid Operating Unit ID'
188: FROM HR_OPERATING_UNITS HROU
189: WHERE HROU.organization_id = l_org_ids(i)
190: -- Bug 5060582: Dont need the date checks
191: --AND sysdate BETWEEN
192: -- nvl(HROU.date_from, sysdate-1)