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