APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 28: HR_ALL_ORGANIZATION_UNITS.NAME%type

24: TRIGGER RAISED UNHANDLED EXCEPTION VALUE_E
25: by change MANAGER_NAME from varchar2(60) to
26: PER_ALL_PEOPLE_F.E.FULL_NAME%type and
27: ORGANIZATION_NAME from varchar2(60) to
28: HR_ALL_ORGANIZATION_UNITS.NAME%type
29: 2) Fixed hard coded messages
30: 24-Jun-97 70.8 teyres Changed as to is on create or replace line
31: 25-Jun-97 110.1/70.9 teyres 110.1 and 70.9 are the same
32: 03-DEC-97 110.2 mbocutt Add missing token substitution in message

Line 105: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS.NAME%type;

101: P_VERSION_ID IN NUMBER,
102: P_USER_PERSON_TYPE OUT NOCOPY VARCHAR2) IS
103: --
104: NO_OF_ORGS NUMBER(3);
105: ORGANIZATION_NAME HR_ALL_ORGANIZATION_UNITS.NAME%type;
106: MANAGER_FLAG_DESC VARCHAR2(80);
107: MANAGER_FLAG VARCHAR2(30);
108: --
109: BEGIN

Line 120: HR_ALL_ORGANIZATION_UNITS O,

116: ORGANIZATION_NAME,
117: MANAGER_FLAG_DESC,
118: MANAGER_FLAG
119: FROM PER_ALL_ASSIGNMENTS_F A,
120: HR_ALL_ORGANIZATION_UNITS O,
121: HR_ALL_ORGANIZATION_UNITS_TL OTL,
122: FND_LOOKUPS L
123: WHERE A.PERSON_ID = P_PERSON_ID
124: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')

Line 121: HR_ALL_ORGANIZATION_UNITS_TL OTL,

117: MANAGER_FLAG_DESC,
118: MANAGER_FLAG
119: FROM PER_ALL_ASSIGNMENTS_F A,
120: HR_ALL_ORGANIZATION_UNITS O,
121: HR_ALL_ORGANIZATION_UNITS_TL OTL,
122: FND_LOOKUPS L
123: WHERE A.PERSON_ID = P_PERSON_ID
124: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')
125: --Added for Bug 6010637