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_CONTACT_INFO_TYPES_PKG dependencies on PER_CONTACT_INFO_TYPES_TL

Line 315: INSERT INTO per_contact_info_types_tl(

311: -- x_program_id,
312: -- x_program_update_date,
313: x_object_version_number);
314: --
315: INSERT INTO per_contact_info_types_tl(
316: information_type,
317: language,
318: source_lang,
319: description,

Line 339: FROM per_contact_info_types_tl t

335: FROM fnd_languages l
336: WHERE l.installed_flag IN ('I','B')
337: AND NOT EXISTS(
338: SELECT NULL
339: FROM per_contact_info_types_tl t
340: WHERE t.information_type = x_information_type
341: AND t.language = l.language_code);
342: --
343: OPEN c;

Line 421: FROM per_contact_info_types_tl

417: SELECT
418: description,
419: DECODE(language,USERENV('LANG'),'Y',
420: 'N') baselang
421: FROM per_contact_info_types_tl
422: WHERE information_type = x_information_type
423: AND USERENV('LANG') IN (language,source_lang)
424: FOR UPDATE OF information_type NOWAIT;
425: --

Line 618: UPDATE per_contact_info_types_tl

614: END IF;
615: -- =
616:
617: --
618: UPDATE per_contact_info_types_tl
619: SET
620: description = x_description,
621: last_update_date = x_last_update_date,
622: last_updated_by = x_last_updated_by,

Line 679: DELETE FROM per_contact_info_types_tl

675: --
676: DELETE FROM per_contact_extra_info_f
677: WHERE information_type = x_information_type;
678: --
679: DELETE FROM per_contact_info_types_tl
680: WHERE information_type = x_information_type;
681: --
682:
683: -- = Raise error when the specified information type does not exist.

Line 862: UPDATE per_contact_info_types_tl SET

858: x_description IN VARCHAR2,
859: x_owner IN VARCHAR2) IS
860: BEGIN
861: --
862: UPDATE per_contact_info_types_tl SET
863: description = x_description,
864: last_update_date = SYSDATE,
865: last_updated_by = DECODE(x_owner,'SEED',1,0),
866: last_update_login = 0,

Line 906: DELETE FROM per_contact_info_types_tl pcitt

902: -- ---------------------------------------------------------------------------
903: PROCEDURE add_language IS
904: BEGIN
905: --
906: DELETE FROM per_contact_info_types_tl pcitt
907: WHERE NOT EXISTS(
908: SELECT NULL FROM per_contact_info_types pcit
909: WHERE pcit.information_type = pcitt.information_type);
910: --

Line 911: UPDATE per_contact_info_types_tl pcitt_t SET

907: WHERE NOT EXISTS(
908: SELECT NULL FROM per_contact_info_types pcit
909: WHERE pcit.information_type = pcitt.information_type);
910: --
911: UPDATE per_contact_info_types_tl pcitt_t SET
912: description = (SELECT pcitt_b.description
913: FROM per_contact_info_types_tl pcitt_b
914: WHERE pcitt_b.information_type = pcitt_t.information_type
915: AND pcitt_b.language = pcitt_t.source_lang)

Line 913: FROM per_contact_info_types_tl pcitt_b

909: WHERE pcit.information_type = pcitt.information_type);
910: --
911: UPDATE per_contact_info_types_tl pcitt_t SET
912: description = (SELECT pcitt_b.description
913: FROM per_contact_info_types_tl pcitt_b
914: WHERE pcitt_b.information_type = pcitt_t.information_type
915: AND pcitt_b.language = pcitt_t.source_lang)
916: WHERE (pcitt_t.information_type, pcitt_t.language) IN
917: (SELECT pcitt_sub_t.information_type, pcitt_sub_t.language

Line 918: FROM per_contact_info_types_tl pcitt_sub_b, per_contact_info_types_tl pcitt_sub_t

914: WHERE pcitt_b.information_type = pcitt_t.information_type
915: AND pcitt_b.language = pcitt_t.source_lang)
916: WHERE (pcitt_t.information_type, pcitt_t.language) IN
917: (SELECT pcitt_sub_t.information_type, pcitt_sub_t.language
918: FROM per_contact_info_types_tl pcitt_sub_b, per_contact_info_types_tl pcitt_sub_t
919: WHERE pcitt_sub_b.information_type = pcitt_sub_t.information_type
920: AND pcitt_sub_b.language = pcitt_sub_t.source_lang
921: AND (pcitt_sub_b.description <> pcitt_sub_t.description
922: OR (pcitt_sub_b.description IS NULL AND pcitt_sub_t.description IS NOT NULL)

Line 925: INSERT INTO per_contact_info_types_tl(

921: AND (pcitt_sub_b.description <> pcitt_sub_t.description
922: OR (pcitt_sub_b.description IS NULL AND pcitt_sub_t.description IS NOT NULL)
923: OR (pcitt_sub_b.description IS NOT NULL AND pcitt_sub_t.description IS NULL)));
924: --
925: INSERT INTO per_contact_info_types_tl(
926: information_type,
927: language,
928: source_lang,
929: description,

Line 946: per_contact_info_types_tl pcitt,

942: pcitt.last_update_login,
943: pcitt.created_by,
944: pcitt.creation_date
945: FROM
946: per_contact_info_types_tl pcitt,
947: fnd_languages fl
948: WHERE fl.installed_flag IN ('I', 'B')
949: AND pcitt.language = USERENV('LANG')
950: AND NOT EXISTS(

Line 951: SELECT NULL FROM per_contact_info_types_tl pcitt_t

947: fnd_languages fl
948: WHERE fl.installed_flag IN ('I', 'B')
949: AND pcitt.language = USERENV('LANG')
950: AND NOT EXISTS(
951: SELECT NULL FROM per_contact_info_types_tl pcitt_t
952: WHERE pcitt_t.information_type = pcitt.information_type
953: AND pcitt_t.language = fl.language_code);
954: --
955: END add_language;

Line 1044: per_contact_info_types_tl citt,

1040: p_language IN VARCHAR2,
1041: p_description IN VARCHAR2,
1042: p_information_type IN VARCHAR2) IS
1043: SELECT 1 FROM
1044: per_contact_info_types_tl citt,
1045: per_contact_info_types cit
1046: WHERE UPPER(citt.description) = UPPER(p_description)
1047: AND citt.information_type = cit.information_type
1048: AND citt.language = p_language