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_SV_NI_BATCH_PROCESS_PKG dependencies on HZ_PARTIES

Line 78: person_number hz_parties.party_number%TYPE,

74: TYPE c_stdnt_list IS RECORD
75: (
76: person_id igs_pe_nonimg_form.person_id%TYPE,
77: form_id igs_pe_ev_form.ev_form_id%TYPE ,
78: person_number hz_parties.party_number%TYPE,
79: no_show_flag igs_pe_ev_form.no_show_flag%TYPE ,
80: reprint_reason igs_pe_ev_form.reprint_reason%TYPE
81: );
82:

Line 362: CURSOR c_alt_id (cp_local_inst hz_parties.party_number%TYPE)

358: p_batch_type IN VARCHAR2
359: ) RETURN VARCHAR2
360: IS
361:
362: CURSOR c_alt_id (cp_local_inst hz_parties.party_number%TYPE)
363: IS
364: SELECT org_alternate_id
365: FROM igs_or_org_alt_ids
366: WHERE org_structure_id = cp_local_inst

Line 386: l_local_inst hz_parties.party_number%TYPE;

382: AND p_batch_type ='E')
383: );
384:
385: l_alt_id VARCHAR2(255);
386: l_local_inst hz_parties.party_number%TYPE;
387:
388: BEGIN
389: /* Debug
390: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 1284: igs_pe_hz_parties prt

1280: hzc.country_code,
1281: prt.birth_city
1282: FROM hz_person_profiles hzpp,
1283: hz_citizenship hzc,
1284: igs_pe_hz_parties prt
1285: WHERE hzpp.party_id = p_person_rec.person_id
1286: AND prt.party_id = hzpp.party_id
1287: AND hzc.party_id (+) = hzpp.party_id
1288: AND sysdate between hzpp.effective_start_date AND NVL(hzpp.effective_end_date,sysdate+1);

Line 1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;

1321: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1322: l_first_name hz_person_profiles.person_first_name%TYPE;
1323: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1324: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1325: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1326: l_gender hz_person_profiles.gender%TYPE;
1327: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1328: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;

Line 4563: CURSOR c_data(cp_person_id hz_parties.party_id%TYPE) IS

4559:
4560:
4561: -- Select only! unreported records since no data change is possbile.
4562:
4563: CURSOR c_data(cp_person_id hz_parties.party_id%TYPE) IS
4564: SELECT nonimg_empl_id,
4565: frm.nonimg_form_id,
4566: decode ( empl_type,'01','O','02','C','F') empl_rec_type,
4567: empl_type,

Line 4587: FROM hz_parties

4583:
4584:
4585: CURSOR c_empl_name (l_party_id NUMBER) IS
4586: SELECT party_name
4587: FROM hz_parties
4588: WHERE party_id = l_party_id;
4589:
4590: CURSOR c_empl_addr (l_party_id NUMBER) IS
4591: SELECT SUBSTR(address1||address2||address3||address4,1,60) addr_line1,

Line 10386: l_submiter_number hz_parties.party_number%TYPE;

10382: l_us_addr_rec g_address_rec_type;
10383: l_site_addr_rec g_address_rec_type;
10384: l_exist NUMBER(25);
10385: l_submiter_id NUMBER(25);
10386: l_submiter_number hz_parties.party_number%TYPE;
10387: no_show_status VARCHAR2(1);
10388: l_cur_authdrp_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10389: l_btch_id igs_sv_batches.batch_id%TYPE;
10390:

Line 10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt

10389: l_btch_id igs_sv_batches.batch_id%TYPE;
10390:
10391: CURSOR C_EV_CUR IS
10392: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
10393: FROM igs_pe_ev_form fr, hz_parties pr, igs_pe_alt_pers_id alt
10394: WHERE pr.party_id = fr.person_id AND fr.form_effective_date <= trunc(sysdate)
10395: AND fr.ev_form_id NOT IN
10396: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st
10397: WHERE st.action_type IN ('TR','ED')

Line 10417: FROM igs_pe_nonimg_form fr, hz_parties pr

10413: GROUP BY pr.party_number,fr.person_id, fr.no_show_flag, fr.reprint_reason;
10414:
10415: CURSOR C_NI_CUR IS
10416: SELECT fr.person_id, min(nonimg_form_id) form_id, pr.party_number person_number, null no_show_flag, fr.reprint_reason reprint_reason
10417: FROM igs_pe_nonimg_form fr, hz_parties pr
10418: WHERE pr.party_id = fr.person_id
10419: AND fr.form_effective_date <= trunc(sysdate)
10420: AND fr.nonimg_form_id NOT IN
10421: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st

Line 10450: CURSOR submiter_number_cur(cp_party_id hz_parties.party_id%TYPE) IS

10446: SELECT person_party_id
10447: FROM fnd_user
10448: WHERE user_id = g_update_by;
10449:
10450: CURSOR submiter_number_cur(cp_party_id hz_parties.party_id%TYPE) IS
10451: SELECT party_number
10452: FROM hz_parties
10453: WHERE party_id = cp_party_id;
10454:

Line 10452: FROM hz_parties

10448: WHERE user_id = g_update_by;
10449:
10450: CURSOR submiter_number_cur(cp_party_id hz_parties.party_id%TYPE) IS
10451: SELECT party_number
10452: FROM hz_parties
10453: WHERE party_id = cp_party_id;
10454:
10455: CURSOR c_prev_info( p_id NUMBER, f_id NUMBER) IS
10456: SELECT 1

Line 12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12332:
12333: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12334: IS
12335: SELECT hz.party_number prsn_num, lkp.meaning info
12336: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12337: WHERE svbs.batch_id = cp_batch_id
12338: AND svbs.action_code = 'NEW'
12339: AND svbs.person_id = hz.party_id
12340: AND svbs.TAG_CODE = lkp.lookup_code

Line 12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp

12342:
12343: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
12344: IS
12345: SELECT hz.party_number prsn_num, lkp.meaning info
12346: FROM igs_sv_btch_summary svbs, hz_parties hz, IGS_LOOKUP_VALUES lkp
12347: WHERE svbs.batch_id = cp_batch_id
12348: AND svbs.action_code <> 'NEW'
12349: AND svbs.person_id = hz.party_id
12350: AND svbs.TAG_CODE = lkp.lookup_code