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_AD_IMP_006 dependencies on IGS_AD_INTERFACE

Line 39: CURSOR alias_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

35: PROCEDURE Prc_Pe_Alias
36: ( P_SOURCE_TYPE_ID IN NUMBER,
37: P_BATCH_ID IN NUMBER )
38: AS
39: CURSOR alias_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
40: SELECT hii.*, i.person_id
41: FROM igs_ad_alias_int_all hii, igs_ad_interface_all i
42: WHERE hii.interface_run_id = cp_interface_run_id
43: AND i.interface_id = hii.interface_id

Line 41: FROM igs_ad_alias_int_all hii, igs_ad_interface_all i

37: P_BATCH_ID IN NUMBER )
38: AS
39: CURSOR alias_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
40: SELECT hii.*, i.person_id
41: FROM igs_ad_alias_int_all hii, igs_ad_interface_all i
42: WHERE hii.interface_run_id = cp_interface_run_id
43: AND i.interface_id = hii.interface_id
44: AND i.interface_run_id = cp_interface_run_id
45: AND hii.status = '2';

Line 62: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

58: l_label VARCHAR2(4000);
59: l_debug_str VARCHAR2(4000);
60: l_enable_log VARCHAR2(1);
61: l_request_id NUMBER(10);
62: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
63:
64: --------Start of local Validate_pe_alias ------
65: PROCEDURE Validate_pe_alias(PERSON_ALIAS_REC alias_cur%ROWTYPE,
66: l_error_code OUT NOCOPY VARCHAR2) AS

Line 73: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;

69: SELECT birth_date
70: FROM igs_pe_person_base_v
71: WHERE person_id= cp_person_id;
72:
73: l_birth_date IGS_AD_INTERFACE.BIRTH_DT%TYPE;
74:
75: BEGIN
76:
77: --ALIAS_TYPE

Line 252: CURSOR emp_dtls(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

248: PROCEDURE Prc_Pe_Empnt_Dtls (
249: P_SOURCE_TYPE_ID IN NUMBER,
250: P_BATCH_ID IN VARCHAR2 )
251: AS
252: CURSOR emp_dtls(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
253: SELECT hii.*, i.person_id
254: FROM igs_ad_emp_int_all hii, igs_ad_interface_all i
255: WHERE hii.interface_run_id = cp_interface_run_id
256: AND i.interface_id = hii.interface_id

Line 254: FROM igs_ad_emp_int_all hii, igs_ad_interface_all i

250: P_BATCH_ID IN VARCHAR2 )
251: AS
252: CURSOR emp_dtls(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
253: SELECT hii.*, i.person_id
254: FROM igs_ad_emp_int_all hii, igs_ad_interface_all i
255: WHERE hii.interface_run_id = cp_interface_run_id
256: AND i.interface_id = hii.interface_id
257: AND i.interface_run_id = cp_interface_run_id
258: AND hii.status = '2';

Line 278: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

274: l_label VARCHAR2(4000);
275: l_debug_str VARCHAR2(4000);
276: l_enable_log VARCHAR2(1);
277: l_request_id NUMBER(10);
278: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
279: l_object_version_number NUMBER;
280: ------ Local Procedure validate_emp_dtls---
281: PROCEDURE validate_emp_dtls (PERSON_EMP_REC IN emp_dtls%ROWTYPE,
282: P_EMPLOYER_PARTY_ID IN OUT NOCOPY NUMBER,

Line 608: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

604: match_ind = '19'
605: WHERE mi.interface_run_id = l_interface_run_id
606: AND mi.status = '2'
607: AND EXISTS ( SELECT '1'
608: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
609: WHERE ii.interface_run_id = l_interface_run_id
610: AND ii.interface_id = mi.interface_id
611: AND pe.employed_by_party_id = hz.party_id(+)
612: AND ii.person_id = pe.party_id

Line 647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz

643: WHERE mi.interface_run_id = l_interface_run_id
644: AND mi.match_ind IS NULL
645: AND mi.status = '2'
646: AND EXISTS ( SELECT '1'
647: FROM hz_employment_history pe, igs_ad_interface_all ii, igs_ad_hz_emp_dtl ahed, hz_parties hz
648: WHERE ii.interface_run_id = l_interface_run_id
649: AND ii.interface_id = mi.interface_id
650: AND ii.person_id = pe.party_id
651: AND pe.employment_history_id = ahed.employment_history_id (+)

Line 676: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

672: UPDATE igs_ad_emp_int_all mi
673: SET status = '3',
674: match_ind = '20',
675: dup_employment_number = (SELECT employment_history_id
676: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
677: WHERE ii.interface_run_id = l_interface_run_id
678: AND ii.interface_id = mi.interface_id
679: AND ii.person_id = pe.party_id
680: AND pe.employed_by_party_id = hz.party_id (+)

Line 689: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz

685: WHERE mi.interface_run_id = l_interface_run_id
686: AND mi.match_ind IS NULL
687: AND mi.status = '2'
688: AND EXISTS (SELECT '1'
689: FROM hz_employment_history pe, igs_ad_interface_all ii, hz_parties hz
690: WHERE ii.interface_run_id = l_interface_run_id
691: AND ii.interface_id = mi.interface_id
692: AND ii.person_id = pe.party_id
693: AND pe.employed_by_party_id = hz.party_id (+)

Line 948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

944: ) AS
945:
946: l_dup_person_interest_id IGS_AD_EXCURR_INT.DUP_PERSON_INTEREST_ID%TYPE;
947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id
951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i
952: WHERE hii.interface_run_id = cp_interface_run_id

Line 949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

945:
946: l_dup_person_interest_id IGS_AD_EXCURR_INT.DUP_PERSON_INTEREST_ID%TYPE;
947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id
951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i
952: WHERE hii.interface_run_id = cp_interface_run_id
953: AND i.interface_id = hii.interface_id

Line 951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i

947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id
951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i
952: WHERE hii.interface_run_id = cp_interface_run_id
953: AND i.interface_id = hii.interface_id
954: AND i.interface_run_id = cp_interface_run_id
955: AND hii.status = '2';