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 */
101: Org ID passedas a input parameter.
102: Arguments : P_Org_ID - Organization Identifier
103: Return : Operating Unit Name
104: ***************************************************************************/
105: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
106: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
107: /* R12 Changes End */
108:
109: END PA_UTILS3;
102: Arguments : P_Org_ID - Organization Identifier
103: Return : Operating Unit Name
104: ***************************************************************************/
105: FUNCTION GetCachedOUName (P_Org_ID HR_ALL_ORGANIZATION_UNITS_TL.ORGANIZATION_ID%TYPE)
106: RETURN HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
107: /* R12 Changes End */
108:
109: END PA_UTILS3;