APPS.PER_STARTUP_PERSON_TYPES_PKG dependencies on PER_PERSON_TYPES_TL

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