37: INDEX BY BINARY_INTEGER;
38:
39: /* R12 Changes Start */
40: TYPE OUNameRec IS RECORD (
41: Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE,
42: OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE);
43:
44: TYPE OUNameTab IS TABLE OF OUNameRec
45: INDEX BY BINARY_INTEGER;
38:
39: /* R12 Changes Start */
40: TYPE OUNameRec IS RECORD (
41: Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE,
42: OU_Name HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE);
43:
44: TYPE OUNameTab IS TABLE OF OUNameRec
45: INDEX BY BINARY_INTEGER;
46: /* R12 Changes End */
95: Org ID passedas a input parameter.
96: Arguments : P_Org_ID - Organization Identifier
97: Return : Operating Unit Name
98: ***************************************************************************/
99: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
100: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
101: /* R12 Changes End */
102:
103: END PA_UTILS3;
96: Arguments : P_Org_ID - Organization Identifier
97: Return : Operating Unit Name
98: ***************************************************************************/
99: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
100: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
101: /* R12 Changes End */
102:
103: END PA_UTILS3;