APPS.PSP_PSPDAREG_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

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(25);
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 54: HR_ALL_ORGANIZATION_UNITS

50: SELECT
51: NAME
52: INTO L_ORG_NAME
53: FROM
54: HR_ALL_ORGANIZATION_UNITS
55: WHERE ORGANIZATION_ID = EXP_ORG_ID_NEW;
56: L_POETA_NEW := L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || EXPENDITURE_TYPE_NEW;
57: ELSE
58: L_POETA_NEW := '';

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(25);
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 115: HR_ALL_ORGANIZATION_UNITS

111: SELECT
112: NAME
113: INTO L_ORG_NAME
114: FROM
115: HR_ALL_ORGANIZATION_UNITS
116: WHERE ORGANIZATION_ID = EXP_ORG_ID_OLD;
117: L_POETA_OLD := L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || EXPENDITURE_TYPE_OLD;
118: ELSE
119: L_POETA_OLD := '';

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

Line 228: HR_ALL_ORGANIZATION_UNITS

224: DISTINCT
225: NAME
226: INTO V_ORGNAME
227: FROM
228: HR_ALL_ORGANIZATION_UNITS
229: WHERE ORGANIZATION_ID = P_PRIMARY_ORGANIZATION_ID;
230: RETURN (V_ORGNAME);
231: END IF;
232: END CF_PRIMARY_ORG_NAMEFORMULA;