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

Line 79: person_number hz_parties.party_number%TYPE,

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

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

362: p_batch_type IN VARCHAR2
363: ) RETURN VARCHAR2
364: IS
365:
366: CURSOR c_alt_id (cp_local_inst hz_parties.party_number%TYPE)
367: IS
368: SELECT org_alternate_id
369: FROM igs_or_org_alt_ids
370: WHERE org_structure_id = cp_local_inst

Line 390: l_local_inst hz_parties.party_number%TYPE;

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

Line 1506: igs_pe_hz_parties prt

1502: hzc.country_code,
1503: prt.birth_city
1504: FROM hz_person_profiles hzpp,
1505: hz_citizenship hzc,
1506: igs_pe_hz_parties prt
1507: WHERE hzpp.party_id = p_person_rec.person_id
1508: AND prt.party_id = hzpp.party_id
1509: AND hzc.party_id (+) = hzpp.party_id
1510: AND sysdate between hzpp.effective_start_date AND NVL(hzpp.effective_end_date,sysdate+1);

Line 1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;

1543: l_middle_name hz_person_profiles.person_middle_name%TYPE;
1544: l_first_name hz_person_profiles.person_first_name%TYPE;
1545: l_suffix hz_person_profiles.person_name_suffix%TYPE;
1546: l_birth_date hz_person_profiles.date_of_birth%TYPE;
1547: l_birth_city igs_pe_hz_parties.birth_city%TYPE;
1548: l_gender hz_person_profiles.gender%TYPE;
1549: l_birth_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1550: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1551: l_visa_type IGS_PE_VISA.visa_type%TYPE;

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

5515:
5516:
5517: -- Select only! unreported records since no data change is possbile.
5518:
5519: CURSOR c_data(cp_person_id hz_parties.party_id%TYPE) IS
5520: SELECT nonimg_empl_id,
5521: frm.nonimg_form_id,
5522: decode ( empl_type,'01','O','02','C','F') empl_rec_type,
5523: empl_type,

Line 5543: FROM hz_parties

5539:
5540:
5541: CURSOR c_empl_name (l_party_id NUMBER) IS
5542: SELECT party_name
5543: FROM hz_parties
5544: WHERE party_id = l_party_id;
5545:
5546: CURSOR c_empl_addr (l_party_id NUMBER) IS
5547: SELECT SUBSTR(address1||address2||address3||address4,1,60) addr_line1,

Line 11525: l_submiter_number hz_parties.party_number%TYPE;

11521: l_us_addr_rec g_address_rec_type;
11522: l_site_addr_rec g_address_rec_type;
11523: l_exist NUMBER(25);
11524: l_submiter_id NUMBER(25);
11525: l_submiter_number hz_parties.party_number%TYPE;
11526: no_show_status VARCHAR2(1);
11527: l_cur_authdrp_rec IGS_SV_PRGMS_INFO%ROWTYPE;
11528: l_btch_id igs_sv_batches.batch_id%TYPE;
11529:

Line 11532: FROM igs_pe_ev_form fr, hz_parties pr

11528: l_btch_id igs_sv_batches.batch_id%TYPE;
11529:
11530: CURSOR C_EV_CUR IS
11531: SELECT fr.person_id, min(ev_form_id) form_id, pr.party_number person_number, fr.no_show_flag, fr.reprint_reason reprint_reason
11532: FROM igs_pe_ev_form fr, hz_parties pr
11533: WHERE pr.party_id = fr.person_id AND fr.form_effective_date <= trunc(sysdate)
11534: AND fr.ev_form_id NOT IN
11535: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st
11536: WHERE st.action_type IN ('TR','ED')

Line 11561: FROM igs_pe_nonimg_form fr, hz_parties pr

11557: GROUP BY pr.party_number,fr.person_id, fr.no_show_flag, fr.reprint_reason;
11558:
11559: CURSOR C_NI_CUR IS
11560: SELECT fr.person_id, min(nonimg_form_id) form_id, pr.party_number person_number, null no_show_flag, fr.reprint_reason reprint_reason
11561: FROM igs_pe_nonimg_form fr, hz_parties pr
11562: WHERE pr.party_id = fr.person_id
11563: AND fr.form_effective_date <= trunc(sysdate)
11564: AND fr.nonimg_form_id NOT IN
11565: ( SELECT st.nonimg_form_id FROM IGS_PE_NONIMG_STAT st

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

11594: SELECT person_party_id
11595: FROM fnd_user
11596: WHERE user_id = g_update_by;
11597:
11598: CURSOR submiter_number_cur(cp_party_id hz_parties.party_id%TYPE) IS
11599: SELECT party_number
11600: FROM hz_parties
11601: WHERE party_id = cp_party_id;
11602:

Line 11600: FROM hz_parties

11596: WHERE user_id = g_update_by;
11597:
11598: CURSOR submiter_number_cur(cp_party_id hz_parties.party_id%TYPE) IS
11599: SELECT party_number
11600: FROM hz_parties
11601: WHERE party_id = cp_party_id;
11602:
11603: CURSOR c_prev_info( p_id NUMBER, f_id NUMBER) IS
11604: SELECT 1

Line 13518: l_person_num hz_parties.party_number%TYPE;

13514: IS
13515:
13516: l_api_name CONSTANT VARCHAR(30) := 'xml_log_file';
13517: l_per_count NUMBER(5) := 0;
13518: l_person_num hz_parties.party_number%TYPE;
13519: l_info_meaning igs_lookup_values.meaning%TYPE;
13520:
13521: CURSOR c_updated_pers(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13522: IS

Line 13543: CURSOR c_get_prsn_num(cp_party_id hz_parties.party_id%TYPE)

13539: WHERE summ.person_id = pers.person_id AND
13540: summ.batch_id=pers.batch_id AND
13541: summ.adm_action_code ='HOLD' AND
13542: summ.batch_id = pers.batch_id);
13543: CURSOR c_get_prsn_num(cp_party_id hz_parties.party_id%TYPE)
13544: IS
13545: SELECT party_number
13546: FROM hz_parties
13547: WHERE party_id = cp_party_id;

Line 13546: FROM hz_parties

13542: summ.batch_id = pers.batch_id);
13543: CURSOR c_get_prsn_num(cp_party_id hz_parties.party_id%TYPE)
13544: IS
13545: SELECT party_number
13546: FROM hz_parties
13547: WHERE party_id = cp_party_id;
13548:
13549: CURSOR c_get_info(cp_tag_code igs_sv_btch_summary.tag_code%TYPE)
13550: IS

Line 13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers

13641:
13642: CURSOR c_get_new_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13643: IS
13644: SELECT hz.party_number prsn_num, lkp.meaning info
13645: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13646: WHERE svbs.batch_id = cp_batch_id
13647: AND svbs.person_id = hz.party_id
13648: AND svbs.tag_code = lkp.lookup_code
13649: AND lkp.lookup_type ='IGS_SV_COMP_TREE'

Line 13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers

13654:
13655: CURSOR c_get_updated_persons(cp_batch_id igs_sv_btch_summary.batch_id%TYPE)
13656: IS
13657: SELECT hz.party_number prsn_num, lkp.meaning info
13658: FROM igs_sv_btch_summary svbs, hz_parties hz, igs_lookup_values lkp, igs_sv_persons pers
13659: WHERE svbs.batch_id = cp_batch_id
13660: AND svbs.person_id = hz.party_id
13661: AND svbs.tag_code = lkp.lookup_code
13662: AND lkp.lookup_type ='IGS_SV_COMP_TREE'

Line 13850: CURSOR c_get_person_num(cp_person_id hz_parties.party_id%TYPE) IS

13846: FROM igs_pe_hz_rel
13847: WHERE relationship_id = cp_rel_id
13848: AND directional_flag = cp_dir_flag; -- fix for bug 5258405
13849:
13850: CURSOR c_get_person_num(cp_person_id hz_parties.party_id%TYPE) IS
13851: SELECT party_number person_num, person_first_name first_name, person_last_name last_name
13852: FROM hz_parties
13853: WHERE party_id = cp_person_id;
13854:

Line 13852: FROM hz_parties

13848: AND directional_flag = cp_dir_flag; -- fix for bug 5258405
13849:
13850: CURSOR c_get_person_num(cp_person_id hz_parties.party_id%TYPE) IS
13851: SELECT party_number person_num, person_first_name first_name, person_last_name last_name
13852: FROM hz_parties
13853: WHERE party_id = cp_person_id;
13854:
13855: lv_return_status VARCHAR2(1) ;
13856: lv_msg_count NUMBER;

Line 13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;

13855: lv_return_status VARCHAR2(1) ;
13856: lv_msg_count NUMBER;
13857: lv_msg_data VARCHAR2(2000);
13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;
13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;
13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:

Line 13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;

13856: lv_msg_count NUMBER;
13857: lv_msg_data VARCHAR2(2000);
13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;
13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;
13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:
13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;

Line 13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;

13857: lv_msg_data VARCHAR2(2000);
13858: lv_party_relationship_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE ;
13859: lv_party_id HZ_PARTIES.PARTY_ID%TYPE ;
13860: lv_party_number HZ_PARTIES.PARTY_NUMBER%TYPE ;
13861: lv_last_update_date HZ_PARTIES.LAST_UPDATE_DATE%TYPE ;
13862: lv_object_version_number HZ_RELATIONSHIPS.OBJECT_VERSION_NUMBER%TYPE;
13863:
13864: l_subject HZ_RELATIONSHIPS.SUBJECT_ID%TYPE;
13865: l_rel_id HZ_RELATIONSHIPS.RELATIONSHIP_ID%TYPE;

Line 13872: l_person_id HZ_PARTIES.PARTY_ID%TYPE ;

13868: l_file_name igs_pe_persid_group_all.file_name%TYPE;
13869: l_str VARCHAR2(32767);
13870: lv_status VARCHAR2(1);
13871: --l_cursor_id NUMBER (15);
13872: l_person_id HZ_PARTIES.PARTY_ID%TYPE ;
13873: TYPE person_rec IS REF CURSOR;
13874: c_person_rec person_rec;
13875: -- l_num_of_rows NUMBER (15);
13876:

Line 13887: person_num hz_parties.party_number%TYPE,

13883: l_obj_id HZ_RELATIONSHIPS.OBJECT_ID%TYPE;
13884:
13885: TYPE c_person_det IS RECORD
13886: (
13887: person_num hz_parties.party_number%TYPE,
13888: person_name VARCHAR2(500),
13889: dso_person_num hz_parties.party_number%TYPE
13890: );
13891:

Line 13889: dso_person_num hz_parties.party_number%TYPE

13885: TYPE c_person_det IS RECORD
13886: (
13887: person_num hz_parties.party_number%TYPE,
13888: person_name VARCHAR2(500),
13889: dso_person_num hz_parties.party_number%TYPE
13890: );
13891:
13892: TYPE g_existing_rel_tbl IS TABLE OF c_person_det INDEX BY BINARY_INTEGER;
13893:

Line 13895: l_person_num hz_parties.party_number%TYPE;

13891:
13892: TYPE g_existing_rel_tbl IS TABLE OF c_person_det INDEX BY BINARY_INTEGER;
13893:
13894: g_existing_rel g_existing_rel_tbl;
13895: l_person_num hz_parties.party_number%TYPE;
13896: l_first_name hz_parties.person_first_name%TYPE;
13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;

Line 13896: l_first_name hz_parties.person_first_name%TYPE;

13892: TYPE g_existing_rel_tbl IS TABLE OF c_person_det INDEX BY BINARY_INTEGER;
13893:
13894: g_existing_rel g_existing_rel_tbl;
13895: l_person_num hz_parties.party_number%TYPE;
13896: l_first_name hz_parties.person_first_name%TYPE;
13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;
13900: l_new_first_name hz_parties.person_first_name%TYPE;

Line 13897: l_last_name hz_parties.person_last_name%TYPE;

13893:
13894: g_existing_rel g_existing_rel_tbl;
13895: l_person_num hz_parties.party_number%TYPE;
13896: l_first_name hz_parties.person_first_name%TYPE;
13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;
13900: l_new_first_name hz_parties.person_first_name%TYPE;
13901: l_new_last_name hz_parties.person_last_name%TYPE;

Line 13899: l_new_person_num hz_parties.party_number%TYPE;

13895: l_person_num hz_parties.party_number%TYPE;
13896: l_first_name hz_parties.person_first_name%TYPE;
13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;
13900: l_new_first_name hz_parties.person_first_name%TYPE;
13901: l_new_last_name hz_parties.person_last_name%TYPE;
13902:
13903: l_counter NUMBER := 0;

Line 13900: l_new_first_name hz_parties.person_first_name%TYPE;

13896: l_first_name hz_parties.person_first_name%TYPE;
13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;
13900: l_new_first_name hz_parties.person_first_name%TYPE;
13901: l_new_last_name hz_parties.person_last_name%TYPE;
13902:
13903: l_counter NUMBER := 0;
13904: l_count NUMBER := 0;

Line 13901: l_new_last_name hz_parties.person_last_name%TYPE;

13897: l_last_name hz_parties.person_last_name%TYPE;
13898:
13899: l_new_person_num hz_parties.party_number%TYPE;
13900: l_new_first_name hz_parties.person_first_name%TYPE;
13901: l_new_last_name hz_parties.person_last_name%TYPE;
13902:
13903: l_counter NUMBER := 0;
13904: l_count NUMBER := 0;
13905: l_temp_count NUMBER := 0;