APPS.IGS_AD_IMP_028 dependencies on IGS_AD_INTERFACE_ALL

Line 49: p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,

45: l_request_id NUMBER := fnd_global.conc_request_id;
46: /***************************Status,Discrepancy Rule, Match Indicators, Error Codes*******************/
47:
48: PROCEDURE prc_pe_qual_details (
49: p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,
50: p_rule VARCHAR2,
51: p_enable_log VARCHAR2) AS
52:
53: /*************************************

Line 69: l_person_id igs_ad_interface_all.person_id%TYPE;

65: l_status VARCHAR2(1);
66: l_error_code VARCHAR2(30);
67: l_error_text VARCHAR2(2000);
68: l_interface_qual_id igs_uc_qual_ints.interface_qual_id%TYPE;
69: l_person_id igs_ad_interface_all.person_id%TYPE;
70: l_person_id_errored igs_ad_interface_all.person_id%TYPE;
71:
72: l_prog_label VARCHAR2(100);
73: l_label VARCHAR2(100);

Line 70: l_person_id_errored igs_ad_interface_all.person_id%TYPE;

66: l_error_code VARCHAR2(30);
67: l_error_text VARCHAR2(2000);
68: l_interface_qual_id igs_uc_qual_ints.interface_qual_id%TYPE;
69: l_person_id igs_ad_interface_all.person_id%TYPE;
70: l_person_id_errored igs_ad_interface_all.person_id%TYPE;
71:
72: l_prog_label VARCHAR2(100);
73: l_label VARCHAR2(100);
74: l_debug_str VARCHAR2(2000);