APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 10: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

6: RETURN (TRUE);
7: END BEFOREPFORM;
8:
9: FUNCTION CF_INSTITUTION_NAMEFORMULA RETURN VARCHAR2 IS
10: V_INSTITUTION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
11: V_INSTITUTION_ID VARCHAR2(30);
12: BEGIN
13: V_INSTITUTION_ID := FND_Profile.VALUE('PSP_ORG_REPORT');
14: IF V_INSTITUTION_ID IS NULL THEN

Line 71: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

67: ,CF_CURRENCY_FORMAT));
68: END CF_DISTRIBUTION_AMOUNT_DSPFORM;
69:
70: FUNCTION CF_ORGANIZATION_NAMEFORMULA(ORGANIZATION_ID1 IN NUMBER) RETURN VARCHAR2 IS
71: V_ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
72: BEGIN
73: SELECT
74: DISTINCT
75: NAME

Line 103: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

99: GL_FLEX_VALUES VARCHAR2(2000);
100: L_PROJECT_NAME VARCHAR2(30);
101: L_AWARD_NUMBER VARCHAR2(15);
102: L_TASK_NUMBER VARCHAR2(300); -- Bug 16391366 (27/03/2013)
103: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
104: L_POETA VARCHAR2(2000);
105: BEGIN
106: IF ACTUAL_GL_CCID IS NOT NULL THEN
107: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)

Line 286: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

282: GL_FLEX_VALUES VARCHAR2(2000);
283: L_PROJECT_NAME VARCHAR2(30);
284: L_AWARD_NUMBER VARCHAR2(15);
285: L_TASK_NUMBER VARCHAR2(300); -- Bug 16391366 (27/03/2013)
286: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
287: L_POETA VARCHAR2(2000);
288: BEGIN
289: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
290: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)