APPS.PER_PERSON_TYPES_PKG dependencies on PER_PERSON_TYPES_TL

Line 18: from per_person_types_tl pttl,

14: -- to avoid FTS
15: -- Bug #3646157
16: --
17: cursor csr_user_name is select null
18: from per_person_types_tl pttl,
19: per_person_types pt
20: where pt.business_group_id = p_business_group_id
21: and upper(pttl.user_person_type) = upper(p_user_person_type)
22: and (pt.rowid <> p_rowid

Line 154: p_entity_name => 'PER_PERSON_TYPES_TL',

150: --
151:
152: BEGIN
153: PER_RIC_PKG.chk_integrity (
154: p_entity_name => 'PER_PERSON_TYPES_TL',
155: p_ref_entity => 'PER_PERSON_TYPES',
156: p_ref_column_name => 'PERSON_TYPE_ID',
157: p_ref_col_value_number => X_PERSON_TYPE_ID,
158: p_ref_col_value_varchar => NULL,

Line 167: insert into PER_PERSON_TYPES_TL (

163: --
164: -- Code Ends Here.
165: --
166:
167: insert into PER_PERSON_TYPES_TL (
168: PERSON_TYPE_ID,
169: USER_PERSON_TYPE,
170: -- LAST_UPDATE_DATE,
171: -- LAST_UPDATED_BY,

Line 191: from PER_PERSON_TYPES_TL T

187: from FND_LANGUAGES L
188: where L.INSTALLED_FLAG in ('I', 'B')
189: and not exists
190: (select NULL
191: from PER_PERSON_TYPES_TL T
192: where T.PERSON_TYPE_ID = X_Person_Type_Id
193: and T.LANGUAGE = L.LANGUAGE_CODE);
194: --
195: OPEN C;

Line 222: per_person_types_tl ppt_tl

218: ppt.default_flag,
219: ppt.system_person_type,
220: ppt_tl.user_person_type
221: FROM per_person_types ppt,
222: per_person_types_tl ppt_tl
223: WHERE ppt.rowid = X_Rowid
224: AND ppt.person_type_id = ppt_tl.person_type_id
225: AND ppt_tl.language = userenv('LANG')
226: FOR UPDATE of ppt.person_type_id NOWAIT;

Line 232: from PER_PERSON_TYPES_TL

228: --MLS
229: cursor c1 is select
230: USER_PERSON_TYPE,
231: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
232: from PER_PERSON_TYPES_TL
233: where PERSON_TYPE_ID = X_Person_Type_Id
234: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
235: for update of PERSON_TYPE_ID nowait;
236: --

Line 327: update PER_PERSON_TYPES_TL set

323: hr_utility.raise_error;
324: end if;
325:
326: -- MLS
327: update PER_PERSON_TYPES_TL set
328: USER_PERSON_TYPE = X_User_Person_Type,
329: -- LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
330: -- LAST_UPDATED_BY = X_LAST_UPDATED_BY,
331: -- LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 359: delete from PER_PERSON_TYPES_TL

355: Check_System_Delete(X_Person_type_Id);
356: --
357:
358: -- MLS
359: delete from PER_PERSON_TYPES_TL
360: where PERSON_TYPE_ID = X_Person_Type_Id;
361:
362: if (sql%notfound) then
363: raise no_data_found;

Line 375: p_ref_entity => 'PER_PERSON_TYPES_TL',

371:
372: BEGIN
373: PER_RIC_PKG.chk_integrity (
374: p_entity_name => 'PER_PERSON_TYPES',
375: p_ref_entity => 'PER_PERSON_TYPES_TL',
376: p_ref_column_name => 'PERSON_TYPE_ID',
377: p_ref_col_value_number => X_PERSON_TYPE_ID,
378: p_ref_col_value_varchar => NULL,
379: p_ref_col_value_date => NULL,

Line 644: UPDATE per_person_types_tl

640: open csr_person_type(x_person_type,x_business_group_name);
641: fetch csr_person_type into l_person_type;
642: close csr_person_type;
643: -- Update table
644: UPDATE per_person_types_tl
645: SET user_person_type = X_USER_PERSON_TYPE
646: ,last_update_date = SYSDATE
647: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
648: ,last_update_login = 1

Line 657: -- process PER_PERSON_TYPES_TL table

653: --
654: procedure ADD_LANGUAGE
655: is
656: begin
657: -- process PER_PERSON_TYPES_TL table
658: delete from PER_PERSON_TYPES_TL T
659: where not exists
660: (select NULL
661: from PER_PERSON_TYPES B

Line 658: delete from PER_PERSON_TYPES_TL T

654: procedure ADD_LANGUAGE
655: is
656: begin
657: -- process PER_PERSON_TYPES_TL table
658: delete from PER_PERSON_TYPES_TL T
659: where not exists
660: (select NULL
661: from PER_PERSON_TYPES B
662: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID

Line 665: update PER_PERSON_TYPES_TL T set (

661: from PER_PERSON_TYPES B
662: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID
663: );
664:
665: update PER_PERSON_TYPES_TL T set (
666: USER_PERSON_TYPE
667: ) = (select
668: B.USER_PERSON_TYPE
669: from PER_PERSON_TYPES_TL B

Line 669: from PER_PERSON_TYPES_TL B

665: update PER_PERSON_TYPES_TL T set (
666: USER_PERSON_TYPE
667: ) = (select
668: B.USER_PERSON_TYPE
669: from PER_PERSON_TYPES_TL B
670: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID
671: and B.LANGUAGE = T.SOURCE_LANG)
672: where (
673: T.PERSON_TYPE_ID,

Line 678: from PER_PERSON_TYPES_TL SUBB, PER_PERSON_TYPES_TL SUBT

674: T.LANGUAGE
675: ) in (select
676: SUBT.PERSON_TYPE_ID,
677: SUBT.LANGUAGE
678: from PER_PERSON_TYPES_TL SUBB, PER_PERSON_TYPES_TL SUBT
679: where SUBB.PERSON_TYPE_ID = SUBT.PERSON_TYPE_ID
680: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
681: and (SUBB.USER_PERSON_TYPE <> SUBT.USER_PERSON_TYPE
682: ));

Line 684: insert into PER_PERSON_TYPES_TL (

680: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
681: and (SUBB.USER_PERSON_TYPE <> SUBT.USER_PERSON_TYPE
682: ));
683:
684: insert into PER_PERSON_TYPES_TL (
685: PERSON_TYPE_ID,
686: USER_PERSON_TYPE,
687: LAST_UPDATE_DATE,
688: LAST_UPDATED_BY,

Line 704: from PER_PERSON_TYPES_TL B, FND_LANGUAGES L

700: B.CREATED_BY,
701: B.CREATION_DATE,
702: L.LANGUAGE_CODE,
703: B.SOURCE_LANG
704: from PER_PERSON_TYPES_TL B, FND_LANGUAGES L
705: where L.INSTALLED_FLAG in ('I', 'B')
706: and B.LANGUAGE = userenv('LANG')
707: and not exists
708: (select NULL

Line 709: from PER_PERSON_TYPES_TL T

705: where L.INSTALLED_FLAG in ('I', 'B')
706: and B.LANGUAGE = userenv('LANG')
707: and not exists
708: (select NULL
709: from PER_PERSON_TYPES_TL T
710: where T.PERSON_TYPE_ID = B.PERSON_TYPE_ID
711: and T.LANGUAGE = L.LANGUAGE_CODE);
712:
713: -- process PER_STARTUP_PERSON_TYPES_TL table

Line 752: FROM per_person_types_tl pptt,

748: p_person_type_id IN NUMBER,
749: p_bus_grp_id IN NUMBER)
750: IS
751: SELECT 1
752: FROM per_person_types_tl pptt,
753: per_person_types ppt
754: WHERE upper(pptt.user_person_type)=upper(p_user_person_type)
755: AND pptt.person_type_id = ppt.person_type_id
756: AND pptt.language = p_language