APPS.IGS_AD_IMP_008 dependencies on IGS_AD_SOURCE_CAT

Line 61: CURSOR c_category_included(p_cat_name IGS_AD_SOURCE_CAT.CATEGORY_NAME%TYPE, p_src_typ_id IGS_AD_SOURCE_CAT.SOURCE_TYPE_ID%TYPE) IS

57: AND i.interface_run_id = cp_interface_run_id
58: AND mi.status = '2';
59:
60: --cursor added to check if the src cat for relations details are included for import (tray)
61: CURSOR c_category_included(p_cat_name IGS_AD_SOURCE_CAT.CATEGORY_NAME%TYPE, p_src_typ_id IGS_AD_SOURCE_CAT.SOURCE_TYPE_ID%TYPE) IS
62: SELECT include_ind
63: FROM igs_ad_source_cat
64: WHERE CATEGORY_NAME = p_cat_name
65: AND SOURCE_TYPE_ID = p_src_typ_id;

Line 63: FROM igs_ad_source_cat

59:
60: --cursor added to check if the src cat for relations details are included for import (tray)
61: CURSOR c_category_included(p_cat_name IGS_AD_SOURCE_CAT.CATEGORY_NAME%TYPE, p_src_typ_id IGS_AD_SOURCE_CAT.SOURCE_TYPE_ID%TYPE) IS
62: SELECT include_ind
63: FROM igs_ad_source_cat
64: WHERE CATEGORY_NAME = p_cat_name
65: AND SOURCE_TYPE_ID = p_src_typ_id;
66:
67: -- Cursor to check whether the relationship exists for the person

Line 766: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;

762: l_msg_data VARCHAR2(2000);
763: l_Count NUMBER;
764: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
765: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
766: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
767: l_last_update_date DATE;
768: l_site_use_last_update_date DATE;
769: l_profile_last_update_date DATE;
770: l_row_id VARCHAR2(30);

Line 1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;

1661: l_msg_data VARCHAR2(2000);
1662: l_Count NUMBER;
1663: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
1664: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
1665: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
1666:
1667: contact_point_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type;
1668: email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type;
1669: phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type;

Line 2419: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;

2415: l_msg_data VARCHAR2(2000);
2416: l_peron_interest_id NUMBER;
2417: l_Status IGS_AD_RELATIONS_INT.STATUS%TYPE;
2418: l_Error_Code IGS_AD_RELATIONS_INT.Error_Code%TYPE;
2419: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
2420: l_check VARCHAR2(30);
2421: l_count NUMBER;
2422: l_match_ind VARCHAR2(2);
2423:

Line 5132: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;

5128: start_date = TRUNC(biodem_rec.start_date);
5129:
5130: dup_cur_rec c_dup_cur%ROWTYPE;
5131:
5132: l_rule igs_ad_source_cat.discrepancy_rule_cd%TYPE;
5133: l_count number;
5134: l_status biodem_rec.status%TYPE;
5135: l_error_code biodem_rec.error_code%TYPE;
5136: l_match_ind biodem_rec.match_ind%TYPE;