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_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 126: insert into PER_PERSON_TYPES_TL (

122: X_User_Person_Type
123:
124: );
125: -- MLS
126: insert into PER_PERSON_TYPES_TL (
127: PERSON_TYPE_ID,
128: USER_PERSON_TYPE,
129: -- LAST_UPDATE_DATE,
130: -- LAST_UPDATED_BY,

Line 150: from PER_PERSON_TYPES_TL T

146: from FND_LANGUAGES L
147: where L.INSTALLED_FLAG in ('I', 'B')
148: and not exists
149: (select NULL
150: from PER_PERSON_TYPES_TL T
151: where T.PERSON_TYPE_ID = X_Person_Type_Id
152: and T.LANGUAGE = L.LANGUAGE_CODE);
153: --
154: OPEN C;

Line 181: per_person_types_tl ppt_tl

177: ppt.default_flag,
178: ppt.system_person_type,
179: ppt_tl.user_person_type
180: FROM per_person_types ppt,
181: per_person_types_tl ppt_tl
182: WHERE ppt.rowid = X_Rowid
183: AND ppt.person_type_id = ppt_tl.person_type_id
184: AND ppt_tl.language = userenv('LANG')
185: FOR UPDATE of ppt.person_type_id NOWAIT;

Line 191: from PER_PERSON_TYPES_TL

187: --MLS
188: cursor c1 is select
189: USER_PERSON_TYPE,
190: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
191: from PER_PERSON_TYPES_TL
192: where PERSON_TYPE_ID = X_Person_Type_Id
193: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
194: for update of PERSON_TYPE_ID nowait;
195: --

Line 286: update PER_PERSON_TYPES_TL set

282: hr_utility.raise_error;
283: end if;
284:
285: -- MLS
286: update PER_PERSON_TYPES_TL set
287: USER_PERSON_TYPE = X_User_Person_Type,
288: -- LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
289: -- LAST_UPDATED_BY = X_LAST_UPDATED_BY,
290: -- LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 318: delete from PER_PERSON_TYPES_TL

314: Check_System_Delete(X_Person_type_Id);
315: --
316:
317: -- MLS
318: delete from PER_PERSON_TYPES_TL
319: where PERSON_TYPE_ID = X_Person_Type_Id;
320:
321: if (sql%notfound) then
322: raise no_data_found;

Line 582: UPDATE per_person_types_tl

578: open csr_person_type(x_person_type,x_business_group_name);
579: fetch csr_person_type into l_person_type;
580: close csr_person_type;
581: -- Update table
582: UPDATE per_person_types_tl
583: SET user_person_type = X_USER_PERSON_TYPE
584: ,last_update_date = SYSDATE
585: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
586: ,last_update_login = 1

Line 595: -- process PER_PERSON_TYPES_TL table

591: --
592: procedure ADD_LANGUAGE
593: is
594: begin
595: -- process PER_PERSON_TYPES_TL table
596: delete from PER_PERSON_TYPES_TL T
597: where not exists
598: (select NULL
599: from PER_PERSON_TYPES B

Line 596: delete from PER_PERSON_TYPES_TL T

592: procedure ADD_LANGUAGE
593: is
594: begin
595: -- process PER_PERSON_TYPES_TL table
596: delete from PER_PERSON_TYPES_TL T
597: where not exists
598: (select NULL
599: from PER_PERSON_TYPES B
600: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID

Line 603: update PER_PERSON_TYPES_TL T set (

599: from PER_PERSON_TYPES B
600: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID
601: );
602:
603: update PER_PERSON_TYPES_TL T set (
604: USER_PERSON_TYPE
605: ) = (select
606: B.USER_PERSON_TYPE
607: from PER_PERSON_TYPES_TL B

Line 607: from PER_PERSON_TYPES_TL B

603: update PER_PERSON_TYPES_TL T set (
604: USER_PERSON_TYPE
605: ) = (select
606: B.USER_PERSON_TYPE
607: from PER_PERSON_TYPES_TL B
608: where B.PERSON_TYPE_ID = T.PERSON_TYPE_ID
609: and B.LANGUAGE = T.SOURCE_LANG)
610: where (
611: T.PERSON_TYPE_ID,

Line 616: from PER_PERSON_TYPES_TL SUBB, PER_PERSON_TYPES_TL SUBT

612: T.LANGUAGE
613: ) in (select
614: SUBT.PERSON_TYPE_ID,
615: SUBT.LANGUAGE
616: from PER_PERSON_TYPES_TL SUBB, PER_PERSON_TYPES_TL SUBT
617: where SUBB.PERSON_TYPE_ID = SUBT.PERSON_TYPE_ID
618: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
619: and (SUBB.USER_PERSON_TYPE <> SUBT.USER_PERSON_TYPE
620: ));

Line 622: insert into PER_PERSON_TYPES_TL (

618: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
619: and (SUBB.USER_PERSON_TYPE <> SUBT.USER_PERSON_TYPE
620: ));
621:
622: insert into PER_PERSON_TYPES_TL (
623: PERSON_TYPE_ID,
624: USER_PERSON_TYPE,
625: LAST_UPDATE_DATE,
626: LAST_UPDATED_BY,

Line 642: from PER_PERSON_TYPES_TL B, FND_LANGUAGES L

638: B.CREATED_BY,
639: B.CREATION_DATE,
640: L.LANGUAGE_CODE,
641: B.SOURCE_LANG
642: from PER_PERSON_TYPES_TL B, FND_LANGUAGES L
643: where L.INSTALLED_FLAG in ('I', 'B')
644: and B.LANGUAGE = userenv('LANG')
645: and not exists
646: (select NULL

Line 647: from PER_PERSON_TYPES_TL T

643: where L.INSTALLED_FLAG in ('I', 'B')
644: and B.LANGUAGE = userenv('LANG')
645: and not exists
646: (select NULL
647: from PER_PERSON_TYPES_TL T
648: where T.PERSON_TYPE_ID = B.PERSON_TYPE_ID
649: and T.LANGUAGE = L.LANGUAGE_CODE);
650:
651: -- process PER_STARTUP_PERSON_TYPES_TL table

Line 690: FROM per_person_types_tl pptt,

686: p_person_type_id IN NUMBER,
687: p_bus_grp_id IN NUMBER)
688: IS
689: SELECT 1
690: FROM per_person_types_tl pptt,
691: per_person_types ppt
692: WHERE upper(pptt.user_person_type)=upper(p_user_person_type)
693: AND pptt.person_type_id = ppt.person_type_id
694: AND pptt.language = p_language