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 IGS_PE_EV_FORM

Line 78: form_id igs_pe_ev_form.ev_form_id%TYPE ,

74:
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: );

Line 80: no_show_flag igs_pe_ev_form.no_show_flag%TYPE ,

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:
84: TYPE t_student_rec IS RECORD

Line 81: reprint_reason igs_pe_ev_form.reprint_reason%TYPE

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:
84: TYPE t_student_rec IS RECORD
85: ( person_id igs_sv_persons.person_id%TYPE,

Line 1190: FROM igs_pe_ev_form

1186: prgm_end_date ,
1187: ev_form_number ,
1188: init_prgm_start_date ,
1189: no_show_flag
1190: FROM igs_pe_ev_form
1191: WHERE ev_form_id = p_person_rec.form_id ;
1192:
1193:
1194: l_not_valid boolean := FALSE;

Line 1532: FROM igs_pe_ev_form pevf

1528: CURSOR c_ev_data IS
1529: SELECT pevf.position_code,
1530: pevf.category_code,
1531: pevf.position_remarks
1532: FROM igs_pe_ev_form pevf
1533: WHERE pevf.person_id = p_person_rec.person_id
1534: AND ev_form_id = p_person_rec.form_id;
1535:
1536: CURSOR c_country_reason(cp_person_id number) IS

Line 1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;

1550: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1551: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1552: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1553: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1555: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1556: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1557: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1558:

Line 1555: l_category_code IGS_PE_EV_FORM.category_code%TYPE;

1551: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1552: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1553: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1555: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1556: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1557: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1558:
1559: l_not_valid BOOLEAN :=FALSE;

Line 1556: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;

1552: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1553: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1554: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1555: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1556: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1557: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1558:
1559: l_not_valid BOOLEAN :=FALSE;
1560: BEGIN

Line 2872: FROM igs_pe_ev_form peev

2868: peev.subject_field_code,
2869: peev.subject_field_remarks,
2870: prgm_start_date,
2871: prgm_end_date
2872: FROM igs_pe_ev_form peev
2873: WHERE peev.person_id = p_person_rec.person_id
2874: AND peev.ev_form_id = p_person_rec.form_id;
2875:
2876:

Line 2889: l_position_code igs_pe_ev_form.position_code%TYPE;

2885: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

Line 2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

2886: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2894:

Line 2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

2887: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2894:
2895:

Line 2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

2888: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2894:
2895:
2896: BEGIN

Line 2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

2889: l_position_code igs_pe_ev_form.position_code%TYPE;
2890: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2891: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2892: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
2893: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2894:
2895:
2896: BEGIN
2897: /* Debug */

Line 3161: FROM igs_pe_ev_form peev

3157: peev.subject_field_code,
3158: peev.subject_field_remarks,
3159: prgm_start_date,
3160: prgm_end_date
3161: FROM igs_pe_ev_form peev
3162: WHERE peev.person_id = p_data_rec.person_id
3163: AND peev.ev_form_id = g_nonimg_form_id;
3164:
3165:

Line 3177: l_position_code igs_pe_ev_form.position_code%TYPE;

3173: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

Line 3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

3174: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
3182: l_not_valid BOOLEAN := TRUE;

Line 3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

3175: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
3182: l_not_valid BOOLEAN := TRUE;
3183: BEGIN

Line 3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

3176: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
3182: l_not_valid BOOLEAN := TRUE;
3183: BEGIN
3184:

Line 3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

3177: l_position_code igs_pe_ev_form.position_code%TYPE;
3178: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3179: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3180: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;
3181: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
3182: l_not_valid BOOLEAN := TRUE;
3183: BEGIN
3184:
3185: /* Debug */

Line 3305: l_position_code igs_pe_ev_form.position_code%TYPE;

3301:
3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

Line 3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

3302: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

Line 3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

3303: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
3304: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
3305: l_position_code igs_pe_ev_form.position_code%TYPE;
3306: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
3307: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
3308: l_education_level igs_pe_nonimg_form.education_level%TYPE;
3309: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
3310: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
3311: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

Line 3510: FROM igs_pe_ev_form_stat

3506: to_char(prgm_end_date,'YYYY-MM-DD') prgm_end_date,
3507: remarks ,
3508: termination_reason ,
3509: end_program_reason
3510: FROM igs_pe_ev_form_stat
3511: WHERE ev_form_id = p_person_rec.form_id
3512: AND ev_form_stat_id NOT IN
3513: ( SELECT NVL(form_status_id,0)
3514: FROM igs_sv_prgms_info prg,

Line 3526: FROM igs_pe_ev_form

3522: CURSOR c_ev_category_data IS
3523: SELECT category_code,
3524: prgm_start_date,
3525: prgm_end_date
3526: FROM igs_pe_ev_form
3527: WHERE ev_form_id = p_person_rec.form_id;
3528:
3529: CURSOR c_drp(cp_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE) IS
3530: SELECT prgms.authorization_reason,

Line 4216: FROM igs_pe_ev_form evf

4212: govt_org2_othr_name ,
4213: intl_org1_othr_name ,
4214: intl_org2_othr_name ,
4215: other_govt_name
4216: FROM igs_pe_ev_form evf
4217: WHERE evf.person_id = p_person_rec.person_id
4218: AND evf.ev_form_id = p_person_rec.form_id;
4219:
4220: l_not_valid BOOLEAN := FALSE;

Line 4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;

4230: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;

Line 4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;

4231: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;

Line 4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;

4232: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;

Line 4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;

4233: l_remarks igs_pe_nonimg_form.remarks%TYPE;
4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;

Line 4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;

4234: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;

Line 4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;

4235: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;

Line 4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;

4236: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;

Line 4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;

4237: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;

Line 4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;

4238: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);

Line 4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;

4239: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;

Line 4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;

4240: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;

Line 4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;

4241: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
4242: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;

Line 4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;

4243: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;

Line 4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;

4244: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
4252:

Line 4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;

4245: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
4252:
4253:

Line 4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;

4246: l_recvd_us_gvt_fund_amt VARCHAR2(30);
4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
4252:
4253:
4254: BEGIN

Line 4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;

4247: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
4248: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
4249: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
4250: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
4251: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
4252:
4253:
4254: BEGIN
4255:

Line 7230: l_position_code igs_pe_ev_form.position_code%TYPE;

7226: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
7233:
7234: BEGIN

Line 7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

7227: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
7233:
7234: BEGIN
7235: /* Debug */

Line 7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

7228: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
7229: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
7230: l_position_code igs_pe_ev_form.position_code%TYPE;
7231: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
7232: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
7233:
7234: BEGIN
7235: /* Debug */
7236: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 8750: FROM igs_pe_ev_form

8746:
8747: -- Old dates
8748: CURSOR c_valid IS
8749: SELECT is_valid
8750: FROM igs_pe_ev_form
8751: WHERE ev_form_id = p_person_rec.form_id;
8752:
8753: -- Select current session dates.
8754:

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 11535: (SELECT st.ev_form_id FROM igs_pe_ev_form_stat st

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')
11537: AND st.ev_form_id = fr.ev_form_id
11538: AND st.ev_form_stat_id IN
11539: ( SELECT NVL(prs.form_status_id,0) FROM igs_sv_prgms_info prs, igs_sv_persons pr

Line 11626: FROM igs_pe_ev_form

11622: WHERE nonimg_form_id = p_form_id
11623: AND p_batch_type = 'I'
11624: UNION
11625: SELECT decode(print_form,'Y','1','0') print_form
11626: FROM igs_pe_ev_form
11627: WHERE ev_form_id = p_form_id
11628: AND p_batch_type = 'E';
11629:
11630:

Line 11640: CURSOR c_get_dso_id(c_person_id igs_pe_ev_form.person_id%TYPE)

11636: AND p_batch_type = 'I'
11637: AND action_type = 'E';
11638:
11639:
11640: CURSOR c_get_dso_id(c_person_id igs_pe_ev_form.person_id%TYPE)
11641: IS
11642: SELECT alt.api_person_id, alt.pe_person_id
11643: FROM hz_relationships rel, igs_pe_alt_pers_id alt
11644: WHERE rel.subject_id = c_person_id and