APPS.PSP_PSPLSODL_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 4: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

1: PACKAGE BODY PSP_PSPLSODL_XMLP_PKG AS
2: /* $Header: PSPLSODLB.pls 120.3.12020000.2 2013/04/05 07:23:50 lkodaman ship $ */
3: FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID_v IN NUMBER) RETURN VARCHAR2 IS
4: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
5: BEGIN
6: SELECT
7: DISTINCT
8: NAME

Line 53: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

49: RETURN 'ERROR';
50: END CF_PROJECT_NAMEFORMULA;
51:
52: FUNCTION CF_EXP_ORG_NAMEFORMULA(EXPENDITURE_ORGANIZATION_ID IN NUMBER) RETURN VARCHAR2 IS
53: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
54: BEGIN
55: IF EXPENDITURE_ORGANIZATION_ID IS NULL THEN
56: RETURN NULL;
57: END IF;

Line 289: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

285: RETURN NULL;
286: END CF_TIME_PERIOD_ENDFORMULA;
287:
288: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
289: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
290: V_INSTITUTION_ID VARCHAR2(30);
291: BEGIN
292: V_INSTITUTION_ID := VALUE('PSP_ORG_REPORT');
293: IF V_INSTITUTION_ID IS NULL THEN