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.IGS_OR_INST_IMP_003_PKG dependencies on FND_LOOKUP_VALUES

Line 383: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,

379: AND owner_table_name = cp_owner_table_name;
380:
381: --cursor for field level validation of data , for TITLE field (tray)
382: CURSOR c_val_contact_title(p_title igs_or_inst_con_int.title%TYPE,
383: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
384: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
385: SELECT 'X'
386: FROM fnd_lookup_values
387: WHERE lookup_type = cp_lookup_type

Line 384: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS

380:
381: --cursor for field level validation of data , for TITLE field (tray)
382: CURSOR c_val_contact_title(p_title igs_or_inst_con_int.title%TYPE,
383: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
384: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
385: SELECT 'X'
386: FROM fnd_lookup_values
387: WHERE lookup_type = cp_lookup_type
388: AND lookup_code = p_title

Line 386: FROM fnd_lookup_values

382: CURSOR c_val_contact_title(p_title igs_or_inst_con_int.title%TYPE,
383: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
384: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
385: SELECT 'X'
386: FROM fnd_lookup_values
387: WHERE lookup_type = cp_lookup_type
388: AND lookup_code = p_title
389: AND enabled_flag = cp_enabled_flag
390: AND view_application_id = 222

Line 570: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,

566: int_phones_rec cur_get_int_phones%ROWTYPE;
567:
568: --cursor for validating data before importing phones (tray)
569: CURSOR c_val_phone(p_type igs_or_inst_cphn_int.type%TYPE,
570: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
571: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
572: SELECT 'X'
573: FROM fnd_lookup_values
574: WHERE lookup_type = cp_lookup_type

Line 571: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS

567:
568: --cursor for validating data before importing phones (tray)
569: CURSOR c_val_phone(p_type igs_or_inst_cphn_int.type%TYPE,
570: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
571: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
572: SELECT 'X'
573: FROM fnd_lookup_values
574: WHERE lookup_type = cp_lookup_type
575: AND lookup_code = p_type

Line 573: FROM fnd_lookup_values

569: CURSOR c_val_phone(p_type igs_or_inst_cphn_int.type%TYPE,
570: cp_lookup_type fnd_lookup_values.lookup_type%TYPE,
571: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
572: SELECT 'X'
573: FROM fnd_lookup_values
574: WHERE lookup_type = cp_lookup_type
575: AND lookup_code = p_type
576: AND enabled_flag = cp_enabled_flag
577: AND view_application_id = 222

Line 1656: cp_lookup_typ fnd_lookup_values.lookup_type%TYPE,

1652: AS
1653:
1654: --cursor added to validate if the site use code in interface table is present in fnd_lookups
1655: CURSOR c_val_addr_usage(p_site_use_code igs_or_adrusge_int.site_use_code%TYPE,
1656: cp_lookup_typ fnd_lookup_values.lookup_type%TYPE,
1657: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
1658: SELECT 'X'
1659: FROM fnd_lookup_values
1660: WHERE lookup_type= cp_lookup_typ

Line 1657: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS

1653:
1654: --cursor added to validate if the site use code in interface table is present in fnd_lookups
1655: CURSOR c_val_addr_usage(p_site_use_code igs_or_adrusge_int.site_use_code%TYPE,
1656: cp_lookup_typ fnd_lookup_values.lookup_type%TYPE,
1657: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
1658: SELECT 'X'
1659: FROM fnd_lookup_values
1660: WHERE lookup_type= cp_lookup_typ
1661: AND lookup_code = p_site_use_code

Line 1659: FROM fnd_lookup_values

1655: CURSOR c_val_addr_usage(p_site_use_code igs_or_adrusge_int.site_use_code%TYPE,
1656: cp_lookup_typ fnd_lookup_values.lookup_type%TYPE,
1657: cp_enabled_flag fnd_lookup_values.enabled_flag%TYPE) IS
1658: SELECT 'X'
1659: FROM fnd_lookup_values
1660: WHERE lookup_type= cp_lookup_typ
1661: AND lookup_code = p_site_use_code
1662: AND enabled_flag = cp_enabled_flag
1663: AND view_application_id = 222