eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on PER_PERSON_TYPES

Line 11: from per_person_types;

7: p_system_person_type in varchar2) is
8:
9: cursor bus_grp is
10: select distinct business_group_id
11: from per_person_types;
12:
13: cursor person_type is
14: select person_type_id
15: from per_person_types

Line 15: from per_person_types

11: from per_person_types;
12:
13: cursor person_type is
14: select person_type_id
15: from per_person_types
16: where seeded_person_type_key= p_seeded_person_type_key
17: and last_updated_by=1;
18:
19: l_bus_grp number;

Line 28: update per_person_types

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
29: set seeded_person_type_key = p_seeded_person_type_key
30: ,last_updated_by = 1
31: ,last_update_login = 1
32: ,created_by =1

Line 39: insert into per_person_types

35: and system_person_type = p_system_person_type
36: and business_group_id = l_bus_grp;
37:
38: if sql%rowcount = 0 then
39: insert into per_person_types
40: (PERSON_TYPE_ID
41: ,BUSINESS_GROUP_ID
42: ,SEEDED_PERSON_TYPE_KEY
43: ,ACTIVE_FLAG

Line 53: (PER_PERSON_TYPES_S.nextval

49: ,LAST_UPDATE_LOGIN
50: ,LAST_UPDATE_DATE
51: ,CREATION_DATE)
52: Values
53: (PER_PERSON_TYPES_S.nextval
54: ,C1.business_group_id
55: ,p_seeded_person_type_key
56: ,'N'
57: ,'N'

Line 70: update per_person_types_tl

66: end loop;
67:
68: for c2 in person_type loop
69:
70: update per_person_types_tl
71: set last_updated_by = 1,
72: last_update_login = 1,
73: created_by = 1,
74: last_update_date = sysdate

Line 80: insert into PER_PERSON_TYPES_TL (

76:
77:
78: if sql%rowcount = 0 then
79:
80: insert into PER_PERSON_TYPES_TL (
81: PERSON_TYPE_ID
82: ,LANGUAGE
83: ,SOURCE_LANG
84: ,USER_PERSON_TYPE

Line 127: insert into PER_PERSON_TYPES (

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
130: ,ACTIVE_FLAG
131: ,DEFAULT_FLAG

Line 141: PER_PERSON_TYPES_S.nextval

137: ,LAST_UPDATE_LOGIN
138: ,CREATED_BY
139: ,CREATION_DATE
140: )select
141: PER_PERSON_TYPES_S.nextval
142: ,business_group_id
143: ,'Y'
144: ,x_default_flag
145: ,x_seeded_person_type_key

Line 156: from per_person_types

152: ,sysdate
153: from per_business_groups bg
154: where not exists(
155: select null
156: from per_person_types
157: where user_person_type = x_user_person_Type
158: and system_person_type = x_system_person_type
159: and business_group_id = bg.business_group_id);
160:

Line 161: insert into PER_PERSON_TYPES_TL (

157: where user_person_type = x_user_person_Type
158: and system_person_type = x_system_person_type
159: and business_group_id = bg.business_group_id);
160:
161: insert into PER_PERSON_TYPES_TL (
162: PERSON_TYPE_ID
163: ,LANGUAGE
164: ,SOURCE_LANG
165: ,USER_PERSON_TYPE

Line 181: from per_person_types ppt, fnd_languages l

177: ,1
178: ,1
179: ,1
180: ,sysdate
181: from per_person_types ppt, fnd_languages l
182: where L.INSTALLED_FLAG in ('I', 'B')
183: and x_seeded_person_type_key = ppt.seeded_person_type_key
184: and x_system_person_type = ppt.system_person_type
185: and x_user_person_type = ppt.user_person_type

Line 188: from per_person_types_tl

184: and x_system_person_type = ppt.system_person_type
185: and x_user_person_type = ppt.user_person_type
186: and not exists (
187: select null
188: from per_person_types_tl
189: where person_type_id = ppt.person_type_id
190: and language = l.language_code);
191:
192: insert into PER_STARTUP_PERSON_TYPES_TL (

Line 249: select person_type_id from per_person_types

245: X_LAST_UPDATE_LOGIN in NUMBER
246: ) is
247: l_count number;
248: cursor c_ppt is
249: select person_type_id from per_person_types
250: where SEEDED_PERSON_TYPE_KEY = X_SEEDED_PERSON_TYPE_KEY
251: and LAST_UPDATED_BY = 1;
252:
253: begin

Line 279: update PER_PERSON_TYPES set

275: raise no_data_found;
276: end if;
277:
278: for C_row in c_ppt loop
279: update PER_PERSON_TYPES set
280: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
281: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
282: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
283: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 287: update per_person_types_tl set

283: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
284: where person_type_id = c_row.person_type_id
285: and last_updated_by = 1;
286:
287: update per_person_types_tl set
288: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
289: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
290: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
291: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 398: select person_type_id from per_person_types

394: X_USER_PERSON_TYPE in VARCHAR2,
395: x_last_update_date in varchar2)
396: is
397: cursor c_ppt is
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';

Line 417: update PER_PERSON_TYPES_TL set

413: and X_SEEDED_PERSON_TYPE_KEY = SEEDED_PERSON_TYPE_KEY;
414:
415: for c_row in c_ppt loop
416:
417: update PER_PERSON_TYPES_TL set
418: USER_PERSON_TYPE = X_USER_PERSON_TYPE,
419: LAST_UPDATE_DATE = sysdate,
420: LAST_UPDATED_BY = 1,
421: LAST_UPDATE_LOGIN = 1,