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_008 dependencies on IGS_AD_INTERFACE_ALL

Line 50: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

46: l_label VARCHAR2(100);
47: l_debug_str VARCHAR2(2000);
48: l_enable_log VARCHAR2(1);
49: l_request_id NUMBER;
50: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
51:
52: CURSOR per_rel(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
53: SELECT mi.*,i.person_id
54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i

Line 52: CURSOR per_rel(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

48: l_enable_log VARCHAR2(1);
49: l_request_id NUMBER;
50: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
51:
52: CURSOR per_rel(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
53: SELECT mi.*,i.person_id
54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i
55: WHERE mi.interface_run_id = cp_interface_run_id
56: AND mi.interface_id = i.interface_id

Line 54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i

50: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
51:
52: CURSOR per_rel(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
53: SELECT mi.*,i.person_id
54: FROM igs_ad_relations_int_all mi, igs_ad_interface_all i
55: WHERE mi.interface_run_id = cp_interface_run_id
56: AND mi.interface_id = i.interface_id
57: AND i.interface_run_id = cp_interface_run_id
58: AND mi.status = '2';

Line 68: CURSOR c_rel_count (cp_person_id igs_ad_interface_all.person_id%TYPE,

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
68: CURSOR c_rel_count (cp_person_id igs_ad_interface_all.person_id%TYPE,
69: cp_rel_person_id igs_ad_relations_int_all.rel_person_id%TYPE,
70: cp_relationship_type igs_ad_relations_int_all.relationship_type%TYPE,
71: cp_relationship_code igs_ad_relations_int_all.relationship_code%TYPE) IS
72: SELECT count(*)

Line 701: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

697: l_label VARCHAR2(100);
698: l_debug_str VARCHAR2(2000);
699: l_enable_log VARCHAR2(1);
700: l_request_id NUMBER;
701: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
702: l_party_site_ovn hz_party_sites.object_version_number%TYPE;
703: l_location_ovn hz_locations.object_version_number%TYPE;
704: l_addr_process BOOLEAN := FALSE;
705:

Line 1605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

1601: l_label VARCHAR2(100);
1602: l_debug_str VARCHAR2(2000);
1603: l_enable_log VARCHAR2(1);
1604: l_request_id NUMBER;
1605: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
1606:
1607: --1. Pick up all the records from the table IGS_AD_REL_CON_INT.
1608: CURSOR relcon_rec_c(cp_interface_relations_id NUMBER) IS
1609: SELECT *

Line 2325: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

2321: l_label VARCHAR2(100);
2322: l_debug_str VARCHAR2(2000);
2323: l_enable_log VARCHAR2(1);
2324: l_request_id NUMBER;
2325: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
2326:
2327: --1. Pick up all the records from the table IGS_AD_RELACAD_INT WHERE STATUS = '2' AND INTERFACE_RELATIONS_ID = P_INTERFACE_RELATIONS_ID
2328: CURSOR Relacad_Rec_C(cp_interface_relations_id NUMBER) IS
2329: SELECT *

Line 3229: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

3225: l_return_status VARCHAR2(1);
3226: l_Employment_History_Id NUMBER;
3227: l_error_code VARCHAR2(30);
3228: l_count NUMBER(3);
3229: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3230: l_prog_label VARCHAR2(100);
3231: l_label VARCHAR2(100);
3232: l_debug_str VARCHAR2(2000);
3233: l_request_id NUMBER;

Line 3384: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

3380: l_count NUMBER(3);
3381: l_enable_log VARCHAR2(1);
3382: l_prog_label VARCHAR2(100);
3383: l_label VARCHAR2(100);
3384: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3385: l_debug_str VARCHAR2(2000);
3386: l_request_id NUMBER;
3387: l_birth_date DATE;
3388:

Line 3533: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

3529: l_label VARCHAR2(100);
3530: l_debug_str VARCHAR2(2000);
3531: l_enable_log VARCHAR2(1);
3532: l_request_id NUMBER;
3533: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3534:
3535: CURSOR Relns_Emp_Dtls(cp_interface_relations_id NUMBER) IS
3536: SELECT ri.*
3537: FROM igs_ad_relemp_int_all ri

Line 3935: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

3931: l_label VARCHAR2(100);
3932: l_debug_str VARCHAR2(2000);
3933: l_enable_log VARCHAR2(1);
3934: l_request_id NUMBER;
3935: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3936:
3937: CURSOR per_stat(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
3938: SELECT mi.*, i.person_id pid
3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i

Line 3937: CURSOR per_stat(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

3933: l_enable_log VARCHAR2(1);
3934: l_request_id NUMBER;
3935: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3936:
3937: CURSOR per_stat(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
3938: SELECT mi.*, i.person_id pid
3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i
3940: WHERE mi.interface_run_id = cp_interface_run_id
3941: AND mi.interface_id = i.interface_id

Line 3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i

3935: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
3936:
3937: CURSOR per_stat(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
3938: SELECT mi.*, i.person_id pid
3939: FROM igs_ad_stat_int_all mi, igs_ad_interface_all i
3940: WHERE mi.interface_run_id = cp_interface_run_id
3941: AND mi.interface_id = i.interface_id
3942: AND i.interface_run_id = cp_interface_run_id
3943: AND mi.status = '2'

Line 4443: FROM hz_parties hp, igs_ad_interface_all ii

4439: match_ind = '19'
4440: WHERE mi.interface_run_id = l_interface_run_id
4441: AND mi.status = '2'
4442: AND EXISTS ( SELECT '1'
4443: FROM hz_parties hp, igs_ad_interface_all ii
4444: WHERE ii.interface_run_id = l_interface_run_id
4445: AND ii.interface_id = mi.interface_id
4446: AND ii.person_id = hp.party_id);
4447: END IF;

Line 4480: igs_ad_interface_all ii

4476: AND mi.status = '2'
4477: AND EXISTS ( SELECT 1
4478: FROM hz_person_profiles pp,
4479: igs_pe_stat_details sd,
4480: igs_ad_interface_all ii
4481: WHERE ii.interface_run_id = l_interface_run_id AND
4482: ii.interface_id = mi.interface_id AND
4483: ii.person_id = pp.party_id AND
4484: sd.person_id(+) = pp.party_id AND

Line 4526: igs_ad_interface_all ii

4522: AND mi.match_ind IS NULL
4523: AND mi.status = '2'
4524: AND EXISTS (SELECT '1'
4525: FROM hz_parties hp,
4526: igs_ad_interface_all ii
4527: WHERE ii.interface_run_id = l_interface_run_id
4528: AND ii.interface_id = mi.interface_id
4529: AND ii.person_id = hp.party_id);
4530: END IF;

Line 5110: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

5106: l_label VARCHAR2(100);
5107: l_debug_str VARCHAR2(2000);
5108: l_enable_log VARCHAR2(1);
5109: l_request_id NUMBER;
5110: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5111: CURSOR c_biodemo(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
5112: SELECT mi.*,i.person_id
5113: FROM igs_pe_eit_int mi,
5114: igs_ad_interface_all i

Line 5111: CURSOR c_biodemo(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS

5107: l_debug_str VARCHAR2(2000);
5108: l_enable_log VARCHAR2(1);
5109: l_request_id NUMBER;
5110: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5111: CURSOR c_biodemo(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
5112: SELECT mi.*,i.person_id
5113: FROM igs_pe_eit_int mi,
5114: igs_ad_interface_all i
5115: WHERE mi.information_type IN ('PE_STAT_RES_COUNTRY','PE_STAT_RES_STATE', 'PE_STAT_RES_STATUS')

Line 5114: igs_ad_interface_all i

5110: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5111: CURSOR c_biodemo(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
5112: SELECT mi.*,i.person_id
5113: FROM igs_pe_eit_int mi,
5114: igs_ad_interface_all i
5115: WHERE mi.information_type IN ('PE_STAT_RES_COUNTRY','PE_STAT_RES_STATE', 'PE_STAT_RES_STATUS')
5116: AND mi.interface_run_id = cp_interface_run_id
5117: AND mi.interface_id = i.interface_id
5118: AND i.interface_run_id = cp_interface_run_id

Line 5461: FROM igs_pe_eit pe, igs_ad_interface_all ii

5457: match_ind = '19'
5458: WHERE mi.interface_run_id = l_interface_run_id
5459: AND mi.status = '2'
5460: AND EXISTS ( SELECT '1'
5461: FROM igs_pe_eit pe, igs_ad_interface_all ii
5462: WHERE ii.interface_run_id = l_interface_run_id
5463: AND ii.interface_id = mi.interface_id
5464: AND ii.person_id = pe.person_id
5465: AND UPPER(mi.information_type) = UPPER(pe.information_type)

Line 5498: FROM igs_pe_eit pe, igs_ad_interface_all ii

5494: WHERE mi.interface_run_id = l_interface_run_id
5495: AND mi.match_ind IS NULL
5496: AND mi.status = '2'
5497: AND EXISTS ( SELECT '1'
5498: FROM igs_pe_eit pe, igs_ad_interface_all ii
5499: WHERE ii.interface_run_id = l_interface_run_id
5500: AND ii.interface_id = mi.interface_id
5501: AND ii.person_id = pe.person_id
5502: AND UPPER(mi.information_type) = UPPER(pe.information_type)

Line 5520: FROM igs_pe_eit pe, igs_ad_interface_all ii

5516: UPDATE igs_pe_eit_int mi
5517: SET status = '3',
5518: match_ind = '20',
5519: DUP_PE_EIT_ID = (SELECT pe.pe_eit_id
5520: FROM igs_pe_eit pe, igs_ad_interface_all ii
5521: WHERE mi.interface_run_id = l_interface_run_id
5522: AND ii.interface_id = mi.interface_id
5523: AND ii.person_id = pe.person_id
5524: AND UPPER(mi.information_type) = UPPER(pe.information_type)

Line 5530: FROM igs_pe_eit pe, igs_ad_interface_all ii

5526: WHERE mi.interface_run_id = l_interface_run_id
5527: AND mi.match_ind IS NULL
5528: AND mi.status = '2'
5529: AND EXISTS (SELECT '1'
5530: FROM igs_pe_eit pe, igs_ad_interface_all ii
5531: WHERE ii.interface_run_id = l_interface_run_id
5532: AND ii.interface_id = mi.interface_id
5533: AND ii.person_id = pe.person_id
5534: AND UPPER(mi.information_type) = UPPER(pe.information_type)

Line 5809: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;

5805: l_label VARCHAR2(100);
5806: l_debug_str VARCHAR2(2000);
5807: l_enable_log VARCHAR2(1);
5808: l_request_id NUMBER;
5809: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
5810: BEGIN
5811:
5812: l_prog_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat';
5813: l_label := 'igs.plsql.igs_ad_imp_008.prc_pe_stat.';