APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on HR_GENERAL

Line 24: hr_general.g_data_migrator_mode :='Y';

20: l_user_person_type varchar2(30);
21: l_system_person_type varchar2(30);
22: l_updated varchar2(1);
23: begin
24: hr_general.g_data_migrator_mode :='Y';
25:
26: for C1 in bus_grp loop
27: l_bus_grp := c1.business_group_id;
28: update per_person_types

Line 105: hr_general.g_data_migrator_mode :='N';

101: where L.INSTALLED_FLAG in ('I', 'B');
102:
103: end if;
104: end loop;
105: hr_general.g_data_migrator_mode :='N';
106: end;
107:
108: procedure INSERT_ROW (
109: X_ROWID in out nocopy VARCHAR2,

Line 125: hr_general.g_data_migrator_mode :='Y';

121: X_LAST_UPDATE_LOGIN in NUMBER
122: ) is
123:
124: begin
125: hr_general.g_data_migrator_mode :='Y';
126:
127: insert into PER_PERSON_TYPES (
128: PERSON_TYPE_ID
129: ,BUSINESS_GROUP_ID

Line 230: hr_general.g_data_migrator_mode :='N';

226: from per_startup_person_types_tl
227: where seeded_person_type_key = X_SEEDED_PERSON_TYPE_KEY
228: and language= l.language_code);
229:
230: hr_general.g_data_migrator_mode :='N';
231: end INSERT_ROW;
232:
233:
234: procedure UPDATE_ROW (

Line 254: hr_general.g_data_migrator_mode :='Y';

250: where SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY
251: and LAST_UPDATED_BY = 1;
252:
253: begin
254: hr_general.g_data_migrator_mode :='Y';
255:
256: -- The following update statement always updates the startup person types
257: -- Since these rows are seeded rows the who columns are always set accordingly
258:

Line 298: hr_general.g_data_migrator_mode :='N';

294: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
295: and last_updated_by = 1;
296:
297: end loop;
298: hr_general.g_data_migrator_mode :='N';
299: end UPDATE_ROW;
300:
301: procedure DELETE_ROW (
302: X_SEEDED_PERSON_TYPE_KEY in VARCHAR2

Line 402: hr_general.g_data_migrator_mode :='Y';

398: select person_type_id from per_person_types
399: where SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY
400: and LAST_UPDATED_BY = 1;
401: begin
402: hr_general.g_data_migrator_mode :='Y';
403: -- The following update statement always updates the startup person types
404: -- Since these rows are seeded rows the who columns are always set accordingly
405:
406: update PER_STARTUP_PERSON_TYPES_TL set

Line 428: hr_general.g_data_migrator_mode :='N';

424: and person_type_id = c_row.person_type_id
425: and last_updated_by = 1;
426:
427: end loop;
428: hr_general.g_data_migrator_mode :='N';
429: end TRANSLATE_ROW;
430:
431: function validate_upload (
432: p_Upload_mode in varchar2,

Line 468: hr_general.g_data_migrator_mode :='Y';

464:
465: procedure ADD_LANGUAGE
466: is
467: begin
468: hr_general.g_data_migrator_mode :='Y';
469: insert into PER_STARTUP_PERSON_TYPES_TL (
470: SEEDED_PERSON_TYPE_KEY,
471: USER_PERSON_TYPE,
472: LAST_UPDATE_DATE,

Line 507: hr_general.g_data_migrator_mode :='N';

503: (select NULL
504: from PER_STARTUP_PERSON_TYPES_TL T
505: where T.SEEDED_PERSON_TYPE_KEY = B.SEEDED_PERSON_TYPE_KEY
506: and T.LANGUAGE = L.LANGUAGE_CODE);
507: hr_general.g_data_migrator_mode :='N';
508: end ADD_LANGUAGE;
509:
510: /* There is no need to add new person types here. This is a one-off
511: Procedure that upgrades the data only once. New system person types