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 IGS_PE_NONIMG_FORM

Line 76: person_id igs_pe_nonimg_form.person_id%TYPE,

72: g_running_batches g_running_batches_tbl;
73:
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

Line 958: FROM igs_pe_nonimg_form

954: transfer_from_school,
955: prgm_start_date,
956: last_session_flag,
957: adjudicated_flag
958: FROM igs_pe_nonimg_form
959: WHERE nonimg_form_id = p_person_rec.form_id ;
960:
961: CURSOR c_ev_data IS
962: SELECT create_reason ,

Line 973: l_prog_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

969: WHERE ev_form_id = p_person_rec.form_id ;
970:
971:
972: l_not_valid boolean := FALSE;
973: l_prog_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
974:
975: BEGIN
976:
977: /* Debug */

Line 1298: FROM igs_pe_nonimg_form

1294: AND SYSDATE BETWEEN peva.visa_issue_date AND peva.visa_expiry_date;
1295:
1296: CURSOR c_com_data IS
1297: SELECT decode(commuter_ind,'Y','1','0') commuter
1298: FROM igs_pe_nonimg_form
1299: WHERE nonimg_form_id = p_person_rec.form_id;
1300:
1301: CURSOR c_perm_res_data IS
1302: SELECT perm_res_cntry

Line 2253: FROM igs_pe_nonimg_form penf

2249: decode(penf.english_reqd,'Y','1','0') english_reqd,
2250: decode(penf.english_reqd_met,'Y','1','0') english_reqd_met,
2251: penf.not_reqd_reason,
2252: penf.educ_lvl_remarks
2253: FROM igs_pe_nonimg_form penf
2254: WHERE penf.person_id = p_person_rec.person_id
2255: AND penf.nonimg_form_id = p_person_rec.form_id;
2256:
2257: CURSOR c_ev_data IS

Line 2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;

2265: AND peev.ev_form_id = p_person_rec.form_id;
2266:
2267:
2268: l_not_valid BOOLEAN := FALSE;
2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

2266:
2267:
2268: l_not_valid BOOLEAN := FALSE;
2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

Line 2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

2267:
2268: l_not_valid BOOLEAN := FALSE;
2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

Line 2272: l_minor igs_pe_nonimg_form.minor%TYPE;

2268: l_not_valid BOOLEAN := FALSE;
2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

2269: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

2270: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

Line 2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

2271: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

Line 2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

2272: l_minor igs_pe_nonimg_form.minor%TYPE;
2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2280: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

2273: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2280: l_position_code igs_pe_ev_form.position_code%TYPE;
2281: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

2274: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2280: l_position_code igs_pe_ev_form.position_code%TYPE;
2281: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2282: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

2275: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2276: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2277: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2278: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2279: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2280: l_position_code igs_pe_ev_form.position_code%TYPE;
2281: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2282: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2283: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

Line 2542: FROM igs_pe_nonimg_form penf

2538: decode(penf.english_reqd,'Y','1','0') english_reqd,
2539: decode(penf.english_reqd_met,'Y','1','0') english_reqd_met,
2540: penf.not_reqd_reason,
2541: penf.educ_lvl_remarks
2542: FROM igs_pe_nonimg_form penf
2543: WHERE penf.person_id = p_data_rec.person_id
2544: AND penf.nonimg_form_id = g_nonimg_form_id;
2545:
2546: CURSOR c_ev_data IS

Line 2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;

2553: WHERE peev.person_id = p_data_rec.person_id
2554: AND peev.ev_form_id = g_nonimg_form_id;
2555:
2556:
2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

2554: AND peev.ev_form_id = g_nonimg_form_id;
2555:
2556:
2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

Line 2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

2555:
2556:
2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

Line 2560: l_minor igs_pe_nonimg_form.minor%TYPE;

2556:
2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

2557: l_education_level igs_pe_nonimg_form.education_level%TYPE;
2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;

2558: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

Line 2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;

2559: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

Line 2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

2560: l_minor igs_pe_nonimg_form.minor%TYPE;
2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2568: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

2561: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2568: l_position_code igs_pe_ev_form.position_code%TYPE;
2569: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

2562: l_prgm_start_date igs_pe_nonimg_form.prgm_start_date%TYPE;
2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2568: l_position_code igs_pe_ev_form.position_code%TYPE;
2569: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2570: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

2563: l_prgm_end_date igs_pe_nonimg_form.prgm_end_date%TYPE;
2564: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
2565: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
2566: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
2567: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
2568: l_position_code igs_pe_ev_form.position_code%TYPE;
2569: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
2570: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
2571: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%TYPE;

Line 2762: FROM IGS_PE_NONIMG_FORM

2758:
2759:
2760: CURSOR c_visa_type IS
2761: SELECT visa_type
2762: FROM IGS_PE_NONIMG_FORM
2763: WHERE nonimg_form_id = p_person_rec.form_id;
2764:
2765: CURSOR c_termination_reason(p_visa varchar2, p_term_reason igs_pe_nonimg_stat.termination_reason%TYPE) IS
2766: SELECT COUNT(1)

Line 2781: IGS_PE_NONIMG_FORM_V

2777: CURSOR c_prev_end_date IS
2778: SELECT
2779: PRGM_END_DATE
2780: FROM
2781: IGS_PE_NONIMG_FORM_V
2782: WHERE
2783: nonimg_form_id = p_person_rec.form_id;
2784:
2785: l_not_valid BOOLEAN := FALSE;

Line 3267: FROM igs_pe_nonimg_form penf

3263: other_funds_amt,
3264: other_funds_desc,
3265: empl_funds_amt,
3266: remarks
3267: FROM igs_pe_nonimg_form penf
3268: WHERE penf.person_id = p_person_rec.person_id
3269: AND penf.nonimg_form_id = p_person_rec.form_id;
3270:
3271: CURSOR c_ev_data IS

Line 3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;

3293: WHERE evf.person_id = p_person_rec.person_id
3294: AND evf.ev_form_id = p_person_rec.form_id;
3295:
3296: l_not_valid BOOLEAN := FALSE;
3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;

Line 3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;

3294: AND evf.ev_form_id = p_person_rec.form_id;
3295:
3296: l_not_valid BOOLEAN := FALSE;
3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;

Line 3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;

3295:
3296: l_not_valid BOOLEAN := FALSE;
3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;

Line 3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;

3296: l_not_valid BOOLEAN := FALSE;
3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;

Line 3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;

3297: l_acad_term_length igs_pe_nonimg_form.acad_term_length%TYPE;
3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;

Line 3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;

3298: l_tuition igs_pe_nonimg_form.tuition_amt%TYPE;
3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;

Line 3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;

3299: l_living_exp igs_pe_nonimg_form.living_exp_amt%TYPE;
3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;

Line 3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;

3300: l_dependent_exp igs_pe_nonimg_form.depdnt_exp_amt%TYPE;
3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;

Line 3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;

3301: l_other_exp igs_pe_nonimg_form.other_exp_amt%TYPE;
3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;

Line 3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;

3302: l_other_exp_desc igs_pe_nonimg_form.other_exp_desc%TYPE;
3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;
3310: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;

Line 3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;

3303: l_personal_funds igs_pe_nonimg_form.personal_funds_amt%TYPE;
3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;
3310: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
3311: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;

Line 3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;

3304: l_school_funds igs_pe_nonimg_form.school_funds_amt%TYPE;
3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;
3310: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
3311: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
3312: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;

Line 3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;

3305: l_school_funds_desc igs_pe_nonimg_form.school_funds_desc%TYPE;
3306: l_other_funds igs_pe_nonimg_form.other_funds_amt%TYPE;
3307: l_other_funds_desc igs_pe_nonimg_form.other_funds_desc%TYPE;
3308: l_empl_funds igs_pe_nonimg_form.empl_funds_amt%TYPE;
3309: l_remarks igs_pe_nonimg_form.remarks%TYPE;
3310: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%TYPE;
3311: l_govt_org1 igs_pe_ev_form.govt_org1_amt%TYPE;
3312: l_govt_org2 igs_pe_ev_form.govt_org2_amt%TYPE;
3313: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;

Line 4450: FROM igs_pe_nonimg_form

4446: l_months NUMBER(2);
4447: CURSOR c_get_visa_type
4448: IS
4449: SELECT visa_type
4450: FROM igs_pe_nonimg_form
4451: WHERE person_id = p_person_rec.person_id
4452: AND nonimg_form_id = p_person_rec.form_id;
4453:
4454: BEGIN

Line 4579: igs_pe_nonimg_form frm

4575: empl_party_id,
4576: action_code,
4577: NVL(em.print_flag, 'N') print_flag
4578: FROM igs_pe_nonimg_empl em,
4579: igs_pe_nonimg_form frm
4580: WHERE frm.person_id = cp_person_id
4581: AND frm.nonimg_form_id = em.nonimg_form_id
4582: ORDER BY nonimg_empl_id;
4583:

Line 6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;

6256: l_tag_code VARCHAR2(30);
6257: l_edu_status VARCHAR2(10);
6258: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
6259:
6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;
6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

Line 6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;

6257: l_edu_status VARCHAR2(10);
6258: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
6259:
6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;
6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;

Line 6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

6258: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
6259:
6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;
6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;

Line 6263: l_minor igs_pe_nonimg_form.minor%TYPE;

6259:
6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;
6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

Line 6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;

6260: l_education_level igs_pe_nonimg_form.education_level%TYPE;
6261: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
6262: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

Line 6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;

6263: l_minor igs_pe_nonimg_form.minor%TYPE;
6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
6269: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
6270: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
6271: l_position_code igs_pe_ev_form.position_code%TYPE;

Line 6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;

6264: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
6269: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
6270: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
6271: l_position_code igs_pe_ev_form.position_code%TYPE;
6272: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;

Line 6269: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;

6265: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
6269: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
6270: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
6271: l_position_code igs_pe_ev_form.position_code%TYPE;
6272: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
6273: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;

Line 6270: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;

6266: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;
6267: l_english_reqd igs_pe_nonimg_form.english_reqd%TYPE;
6268: l_english_reqd_met igs_pe_nonimg_form.english_reqd_met%TYPE;
6269: l_not_reqd_reason igs_pe_nonimg_form.not_reqd_reason%TYPE;
6270: l_educ_lvl_remarks igs_pe_nonimg_form.educ_lvl_remarks%TYPE;
6271: l_position_code igs_pe_ev_form.position_code%TYPE;
6272: l_subject_field_code igs_pe_ev_form.subject_field_code%TYPE;
6273: l_remarks igs_pe_ev_form.subject_field_remarks%TYPE;
6274:

Line 7200: FROM igs_pe_nonimg_form

7196: CURSOR c_ses_dates IS
7197: SELECT to_char(curr_session_end_date,'YYYY-MM-DD') ,
7198: to_char(next_session_start_date ,'YYYY-MM-DD'),
7199: last_session_flag
7200: FROM igs_pe_nonimg_form
7201: WHERE nonimg_form_id = p_person_rec.form_id;
7202:
7203: l_start_date igs_sv_persons.curr_session_end_date%TYPE;
7204: l_end_date igs_sv_persons.next_session_start_date%TYPE;

Line 7207: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;

7203: l_start_date igs_sv_persons.curr_session_end_date%TYPE;
7204: l_end_date igs_sv_persons.next_session_start_date%TYPE;
7205: l_old_start_date igs_sv_persons.curr_session_end_date%TYPE;
7206: l_old_end_date igs_sv_persons.next_session_start_date%TYPE;
7207: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
7208: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
7209: l_f_addr_rec g_address_rec_type;
7210: l_count NUMBER(10);
7211: l_changes_found VARCHAR2(1) := 'N'; --No changes by default

Line 7208: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;

7204: l_end_date igs_sv_persons.next_session_start_date%TYPE;
7205: l_old_start_date igs_sv_persons.curr_session_end_date%TYPE;
7206: l_old_end_date igs_sv_persons.next_session_start_date%TYPE;
7207: l_old_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
7208: l_last_session_flag igs_pe_nonimg_form.last_session_flag%TYPE;
7209: l_f_addr_rec g_address_rec_type;
7210: l_count NUMBER(10);
7211: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
7212:

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 10473: FROM igs_pe_nonimg_form

10469: AND batch_type = p_batch_type;
10470:
10471: CURSOR c_print_form (p_form_id NUMBER) IS
10472: SELECT decode(print_form,'Y','1','0') print_form
10473: FROM igs_pe_nonimg_form
10474: WHERE nonimg_form_id = p_form_id
10475: AND p_batch_type = 'I'
10476: UNION
10477: SELECT decode(print_form,'Y','1','0') print_form