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
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:
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),
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,
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),
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),
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),
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),