APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

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 22: HR_ALL_ORGANIZATION_UNITS

18: DISTINCT
19: NAME
20: INTO V_INSTITUTION_NAME
21: FROM
22: HR_ALL_ORGANIZATION_UNITS
23: WHERE ORGANIZATION_ID = TO_NUMBER(V_INSTITUTION_ID);
24: RETURN V_INSTITUTION_NAME;
25: RETURN NULL;
26: EXCEPTION

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 78: HR_ALL_ORGANIZATION_UNITS

74: DISTINCT
75: NAME
76: INTO V_ORGANIZATION_NAME
77: FROM
78: HR_ALL_ORGANIZATION_UNITS
79: WHERE ORGANIZATION_ID = ORGANIZATION_ID1;
80: RETURN V_ORGANIZATION_NAME;
81: RETURN NULL;
82: EXCEPTION

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

138: SELECT
139: NAME
140: INTO L_ORG_NAME
141: FROM
142: HR_ALL_ORGANIZATION_UNITS
143: WHERE ORGANIZATION_ID = ACTUAL_EXP_ORG_ID;
144: L_POETA := L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || ACTUAL_EXPENDITURE_TYPE;
145: ELSE
146: L_POETA := '';

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

Line 325: HR_ALL_ORGANIZATION_UNITS

321: SELECT
322: NAME
323: INTO L_ORG_NAME
324: FROM
325: HR_ALL_ORGANIZATION_UNITS
326: WHERE ORGANIZATION_ID = EXPENDITURE_ORGANIZATION_ID;
327: L_POETA := L_PROJECT_NAME || ' ' || L_TASK_NUMBER || ' ' || L_AWARD_NUMBER || ' ' || L_ORG_NAME || ' ' || EXPENDITURE_TYPE;
328: ELSE
329: L_POETA := '';