DBA Data[Home] [Help]

APPS.PER_EIT_UTILITY_SS dependencies on PER_PEOPLE_INFO_TYPES

Line 105: from per_people_info_types

101: IS
102:
103: cursor c_person_types is
104: select information_type
105: from per_people_info_types
106: where information_type not like 'GHR%';
107:
108: cursor c_job_types is
109: select information_type

Line 139: P_INFO_TYPE_TABLE_NAME => 'PER_PEOPLE_INFO_TYPES',

135: FOR person_type IN c_person_types LOOP
136:
137: if eit_not_exist(P_APPLICATION_SHORT_NAME => 'PER',
138: P_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
139: P_INFO_TYPE_TABLE_NAME => 'PER_PEOPLE_INFO_TYPES',
140: P_INFORMATION_TYPE => person_type.information_type,
141: P_ROWID => l_row_id)
142: THEN
143:

Line 144: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW

140: P_INFORMATION_TYPE => person_type.information_type,
141: P_ROWID => l_row_id)
142: THEN
143:
144: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
145: (x_rowid => l_row_id,
146: x_application_short_name => 'PER',
147: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
148: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),

Line 149: X_INFO_TYPE_TABLE_NAME => 'PER_PEOPLE_INFO_TYPES',

145: (x_rowid => l_row_id,
146: x_application_short_name => 'PER',
147: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
148: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),
149: X_INFO_TYPE_TABLE_NAME => 'PER_PEOPLE_INFO_TYPES',
150: X_INFORMATION_TYPE => person_type.information_type,
151: X_OBJECT_VERSION_NUMBER => 1,
152: X_CREATION_DATE => sysdate,
153: X_CREATED_BY => -1,

Line 173: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW

169: P_INFORMATION_TYPE => job_type.information_type,
170: P_ROWID => l_row_id)
171: THEN
172:
173: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
174: (x_rowid => l_row_id,
175: x_application_short_name => 'PER',
176: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
177: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),

Line 204: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW

200: P_INFORMATION_TYPE => assignment_type.information_type,
201: P_ROWID => l_row_id)
202: THEN
203:
204: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
205: (x_rowid => l_row_id,
206: x_application_short_name => 'PER',
207: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
208: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),

Line 235: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW

231: P_INFORMATION_TYPE => position_type.information_type,
232: P_ROWID => l_row_id)
233: THEN
234:
235: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
236: (x_rowid => l_row_id,
237: x_application_short_name => 'PER',
238: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
239: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),

Line 266: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW

262: P_INFORMATION_TYPE => location_type.information_type,
263: P_ROWID => l_row_id)
264: THEN
265:
266: PER_PEOPLE_INFO_TYPES_SEC_PKG.INSERT_ROW
267: (x_rowid => l_row_id,
268: x_application_short_name => 'PER',
269: --X_RESPONSIBILITY_NAME => P_RESPONSIBILITY_NAME,
270: X_RESPONSIBILITY_KEY => GET_RESP_KEY('PER', P_RESPONSIBILITY_NAME),