APPS.PSP_PSPDAREG_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 15: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

11: GL_FLEX_VALUES VARCHAR2(2000);
12: L_PROJECT_NAME VARCHAR2(30);
13: L_AWARD_NUMBER VARCHAR2(15);
14: L_TASK_NUMBER VARCHAR2(300); -- Bug : 16391366 (27/03/2013)
15: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
16: L_POETA_NEW VARCHAR2(2000);
17: BEGIN
18: IF GLCCID_NEW IS NOT NULL THEN
19: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)

Line 76: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

72: GL_FLEX_VALUES VARCHAR2(2000);
73: L_PROJECT_NAME VARCHAR2(30);
74: L_AWARD_NUMBER VARCHAR2(15);
75: L_TASK_NUMBER VARCHAR2(300); -- Bug : 16391366 (27/03/2013)
76: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
77: L_POETA_OLD VARCHAR2(2000);
78: BEGIN
79: IF GLCCID_OLD IS NOT NULL THEN
80: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)

Line 174: V_ORGNAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

170: RETURN (NULL);
171: END CF_SUBMITTED_BYFORMULA;
172:
173: FUNCTION CF_ASSIGN_ORG_IDFORMULA RETURN CHAR IS
174: V_ORGNAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
175: BEGIN
176: IF P_ASSIGNMENT_ORGANIZATION_ID IS NULL THEN
177: RETURN ('All');
178: ELSE

Line 218: V_ORGNAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;

214: RETURN (TRUE);
215: END AFTERPFORM;
216:
217: FUNCTION CF_PRIMARY_ORG_NAMEFORMULA RETURN CHAR IS
218: V_ORGNAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
219: BEGIN
220: IF P_PRIMARY_ORGANIZATION_ID IS NULL THEN
221: RETURN ('All');
222: ELSE