2210:
2211: CURSOR C_GET_ORG(p_ORG_ID NUMBER)
2212: IS
2213: SELECT NAME
2214: FROM HR_ALL_ORGANIZATION_UNITS_TL
2215: WHERE ORGANIZATION_ID =p_org_id
2216: AND LANGUAGE = USERENV('LANG');
2217:
2218: TYPE TBL_ITEM_ATTR IS TABLE OF C_GET_ITEM%ROWTYPE;
2337:
2338: CURSOR C_GET_ORG(p_ORG_ID NUMBER)
2339: IS
2340: SELECT NAME
2341: FROM HR_ALL_ORGANIZATION_UNITS_TL
2342: WHERE ORGANIZATION_ID =p_org_id
2343: AND LANGUAGE = USERENV('LANG');
2344:
2345:
2469:
2470: CURSOR C_GET_ORG(p_ORG_ID NUMBER)
2471: IS
2472: SELECT NAME
2473: FROM HR_ALL_ORGANIZATION_UNITS_TL
2474: WHERE ORGANIZATION_ID =p_org_id
2475: AND LANGUAGE = USERENV('LANG');
2476:
2477: CURSOR c_get_item_name(p_item_id NUMBER, p_org_id NUMBER)
2650:
2651: CURSOR C_GET_ORG(p_ORG_ID NUMBER)
2652: IS
2653: SELECT NAME
2654: FROM HR_ALL_ORGANIZATION_UNITS_TL
2655: WHERE ORGANIZATION_ID =p_org_id
2656: AND LANGUAGE = USERENV('LANG');
2657:
2658: CURSOR c_get_item_name(p_item_id NUMBER, p_org_id NUMBER)