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_EV_FORM

Line 77: form_id igs_pe_ev_form.ev_form_id%TYPE ,

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

Line 79: no_show_flag igs_pe_ev_form.no_show_flag%TYPE ,

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

Line 80: reprint_reason igs_pe_ev_form.reprint_reason%TYPE

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

Line 968: FROM igs_pe_ev_form

964: prgm_end_date ,
965: ev_form_number ,
966: init_prgm_start_date ,
967: no_show_flag
968: FROM igs_pe_ev_form
969: WHERE ev_form_id = p_person_rec.form_id ;
970:
971:
972: l_not_valid boolean := FALSE;

Line 1310: FROM igs_pe_ev_form pevf

1306: CURSOR c_ev_data IS
1307: SELECT pevf.position_code,
1308: pevf.category_code,
1309: pevf.position_remarks
1310: FROM igs_pe_ev_form pevf
1311: WHERE pevf.person_id = p_person_rec.person_id
1312: AND ev_form_id = p_person_rec.form_id;
1313:
1314: CURSOR c_country_reason(cp_person_id number) IS

Line 1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;

1328: l_citizen_cntry_code hz_citizenship.country_code%TYPE;
1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1330: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1331: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1334: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1335: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1336:

Line 1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;

1329: l_visa_type IGS_PE_VISA.visa_type%TYPE;
1330: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1331: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1334: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1335: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1336:
1337: l_not_valid BOOLEAN :=FALSE;

Line 1334: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;

1330: l_commuter VARCHAR2(1); -- ASAP need new column and table to get type
1331: l_legal_res_cntry_code VARCHAR2(30); -- ASAP need new column and table to get type
1332: l_position_code IGS_PE_EV_FORM.position_code%TYPE;
1333: l_category_code IGS_PE_EV_FORM.category_code%TYPE;
1334: l_position_remarks IGS_PE_EV_FORM.position_remarks%TYPE;
1335: l_birth_cntry_resn_code igs_pe_stat_details.birth_cntry_resn_code%TYPE;
1336:
1337: l_not_valid BOOLEAN :=FALSE;
1338: BEGIN

Line 2263: FROM igs_pe_ev_form peev

2259: peev.subject_field_code,
2260: peev.subject_field_remarks,
2261: prgm_start_date,
2262: prgm_end_date
2263: FROM igs_pe_ev_form peev
2264: WHERE peev.person_id = p_person_rec.person_id
2265: AND peev.ev_form_id = p_person_rec.form_id;
2266:
2267:

Line 2280: l_position_code igs_pe_ev_form.position_code%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;
2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

Line 2281: l_subject_field_code igs_pe_ev_form.subject_field_code%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;
2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2285:

Line 2282: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%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;
2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2285:
2286:

Line 2283: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%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;
2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2285:
2286:
2287: BEGIN

Line 2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%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;
2284: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2285:
2286:
2287: BEGIN
2288: /* Debug */

Line 2552: FROM igs_pe_ev_form peev

2548: peev.subject_field_code,
2549: peev.subject_field_remarks,
2550: prgm_start_date,
2551: prgm_end_date
2552: FROM igs_pe_ev_form peev
2553: WHERE peev.person_id = p_data_rec.person_id
2554: AND peev.ev_form_id = g_nonimg_form_id;
2555:
2556:

Line 2568: l_position_code igs_pe_ev_form.position_code%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;
2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;

Line 2569: l_subject_field_code igs_pe_ev_form.subject_field_code%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;
2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2573: l_not_valid BOOLEAN := TRUE;

Line 2570: l_subject_field_remarks igs_pe_ev_form.subject_field_remarks%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;
2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2573: l_not_valid BOOLEAN := TRUE;
2574: BEGIN

Line 2571: l_ev_prgm_start_date igs_pe_ev_form.prgm_start_date%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;
2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2573: l_not_valid BOOLEAN := TRUE;
2574: BEGIN
2575:

Line 2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%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;
2572: l_ev_prgm_end_date igs_pe_ev_form.prgm_end_date%TYPE;
2573: l_not_valid BOOLEAN := TRUE;
2574: BEGIN
2575:
2576: /* Debug */

Line 2705: FROM igs_pe_ev_form_stat

2701: to_char(prgm_end_date,'YYYY-MM-DD') prgm_end_date,
2702: remarks ,
2703: termination_reason ,
2704: end_program_reason
2705: FROM igs_pe_ev_form_stat
2706: WHERE ev_form_id = p_person_rec.form_id
2707: AND ev_form_stat_id NOT IN
2708: ( SELECT NVL(form_status_id,0)
2709: FROM igs_sv_prgms_info prg,

Line 2721: FROM igs_pe_ev_form

2717: CURSOR c_ev_category_data IS
2718: SELECT category_code,
2719: prgm_start_date,
2720: prgm_end_date
2721: FROM igs_pe_ev_form
2722: WHERE ev_form_id = p_person_rec.form_id;
2723:
2724: CURSOR c_drp IS
2725: SELECT prgms.authorization_reason,

Line 3292: FROM igs_pe_ev_form evf

3288: govt_org2_othr_name ,
3289: intl_org1_othr_name ,
3290: intl_org2_othr_name ,
3291: other_govt_name
3292: FROM igs_pe_ev_form evf
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;

Line 3310: l_program_sponsor igs_pe_ev_form.prgm_sponsor_amt%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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;

Line 3311: l_govt_org1 igs_pe_ev_form.govt_org1_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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;

Line 3312: l_govt_org2 igs_pe_ev_form.govt_org2_amt%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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;

Line 3313: l_govt_org1_code igs_pe_ev_form.govt_org1_code%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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;

Line 3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;

Line 3315: l_intl_org1 igs_pe_ev_form.intl_org1_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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;

Line 3316: l_intl_org2 igs_pe_ev_form.intl_org2_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;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;

Line 3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;

3313: l_govt_org1_code igs_pe_ev_form.govt_org1_code%TYPE;
3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;

Line 3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;

3314: l_govt_org2_code igs_pe_ev_form.govt_org2_code%TYPE;
3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);

Line 3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;

3315: l_intl_org1 igs_pe_ev_form.intl_org1_amt%TYPE;
3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;

Line 3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;

3316: l_intl_org2 igs_pe_ev_form.intl_org2_amt%TYPE;
3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;

Line 3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;

3317: l_intl_org1_code igs_pe_ev_form.intl_org1_code%TYPE;
3318: l_intl_org2_code igs_pe_ev_form.intl_org2_code%TYPE;
3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;

Line 3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;

3319: l_ev_govt igs_pe_ev_form.ev_govt_amt%TYPE;
3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;

Line 3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;

3320: l_bi_natnl_com igs_pe_ev_form.bi_natnl_com_amt%TYPE;
3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
3328:

Line 3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;

3321: l_other_org igs_pe_ev_form.other_govt_amt%TYPE;
3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
3328:
3329:

Line 3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;

3322: l_recvd_us_gvt_fund_amt VARCHAR2(30);
3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
3328:
3329:
3330: BEGIN

Line 3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;

3323: l_govt_org1_othr_name igs_pe_ev_form.govt_org1_othr_name%TYPE;
3324: l_govt_org2_othr_name igs_pe_ev_form.govt_org2_othr_name%TYPE;
3325: l_intl_org1_othr_name igs_pe_ev_form.intl_org1_othr_name%TYPE;
3326: l_intl_org2_othr_name igs_pe_ev_form.intl_org2_othr_name%TYPE;
3327: l_other_govt_name igs_pe_ev_form.other_govt_name%TYPE;
3328:
3329:
3330: BEGIN
3331:

Line 6271: l_position_code igs_pe_ev_form.position_code%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:
6275: BEGIN

Line 6272: l_subject_field_code igs_pe_ev_form.subject_field_code%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:
6275: BEGIN
6276: /* Debug */

Line 6273: l_remarks igs_pe_ev_form.subject_field_remarks%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:
6275: BEGIN
6276: /* Debug */
6277: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN

Line 7674: FROM igs_pe_ev_form

7670:
7671: -- Old dates
7672: CURSOR c_valid IS
7673: SELECT is_valid
7674: FROM igs_pe_ev_form
7675: WHERE ev_form_id = p_person_rec.form_id;
7676:
7677: -- Select current session dates.
7678:

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

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

Line 10478: FROM igs_pe_ev_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
10478: FROM igs_pe_ev_form
10479: WHERE ev_form_id = p_form_id
10480: AND p_batch_type = 'E';
10481:
10482:

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

10488: AND p_batch_type = 'I'
10489: AND action_type = 'E';
10490:
10491:
10492: CURSOR c_get_dso_id(c_person_id igs_pe_ev_form.person_id%TYPE)
10493: IS
10494: SELECT alt.api_person_id
10495: FROM hz_relationships rel, igs_pe_alt_pers_id alt
10496: WHERE rel.subject_id = c_person_id and