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_SV_PRGMS_INFO

Line 65: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;

61: g_person_status VARCHAR2(6) := 'NEW';
62: g_legal_status VARCHAR2(6) := 'NEW';
63: g_nonimg_form_id NUMBER(15);
64: TYPE g_address_rec_type IS TABLE OF IGS_SV_ADDRESSES%ROWTYPE INDEX BY BINARY_INTEGER;
65: TYPE g_edu_rec_type IS TABLE OF IGS_SV_PRGMS_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
66: TYPE g_dependent_rec_type IS TABLE OF IGS_SV_DEPDNT_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
67: TYPE g_convictions_rec_type IS TABLE OF IGS_SV_CONVICTIONS%ROWTYPE INDEX BY BINARY_INTEGER;
68: TYPE g_empl_rec_type IS TABLE OF IGS_SV_EMPL_INFO%ROWTYPE INDEX BY BINARY_INTEGER;
69: TYPE g_parallel_batches_tbl IS TABLE OF IGS_SV_BATCHES.BATCH_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2829: (IGS_SV_PRGMS_INFO).

2825: Date Created By : Oct 14, 2002
2826:
2827: Purpose : Validate the information that is pertaining
2828: to the Education Block information.
2829: (IGS_SV_PRGMS_INFO).
2830:
2831: Remarks : Return result:
2832: 'S' - record found and validated
2833: 'E' - validation error

Line 2844: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE

2840:
2841: ******************************************************************/
2842: FUNCTION Validate_Edu_Info (
2843: p_person_rec IN t_student_rec,
2844: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE
2845: ) RETURN VARCHAR2
2846: IS
2847:
2848: l_api_name CONSTANT VARCHAR(30) := 'Validate_Edu_Info';

Line 3120: (IGS_SV_PRGMS_INFO).

3116: Date Created By : Oct 14, 2002
3117:
3118: Purpose : Validate information pertaining to the Program
3119: information block for the student.
3120: (IGS_SV_PRGMS_INFO).
3121:
3122: Remarks : Return result:
3123: 'S' - record found and validated
3124: 'E' - validation error

Line 3134: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE

3130: ------------------------------------------------------------------------
3131:
3132: ******************************************************************/
3133: FUNCTION Get_Othr_Prgm_Info(
3134: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE
3135: ) RETURN VARCHAR2
3136: IS
3137: l_api_name CONSTANT VARCHAR(30) := 'Get_Othr_Prgm_Info';
3138:

Line 3276: (IGS_SV_PRGMS_INFO).

3272:
3273: Date Created By : Oct 14, 2002
3274:
3275: Purpose : Insert authorization codes of the student
3276: (IGS_SV_PRGMS_INFO).
3277:
3278: Remarks :
3279:
3280: Change History

Line 3286: p_auth_drp_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE

3282: ------------------------------------------------------------------------
3283:
3284: ******************************************************************/
3285: PROCEDURE Insert_Auth_Code (
3286: p_auth_drp_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE
3287: )
3288: IS
3289:
3290: l_api_name CONSTANT VARCHAR(30) := 'Insert_Auth_Code';

Line 3296: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;

3292: l_action VARCHAR2(30);
3293: l_btch_id NUMBER(14);
3294: l_tag_code VARCHAR2(30);
3295: l_edu_status VARCHAR2(10);
3296: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
3297:
3298:
3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;

Line 3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;

3295: l_edu_status VARCHAR2(10);
3296: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
3297:
3298:
3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%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;

Line 3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;

3296: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
3297:
3298:
3299: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
3300: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%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;

Line 3357: 'IGS_SV_PRGMS_INFO',

3353: p_auth_drp_data_rec.person_id,
3354: l_action,
3355: l_tag_code,
3356: 'SEND',
3357: 'IGS_SV_PRGMS_INFO',
3358: p_auth_drp_data_rec.sevis_auth_id);
3359:
3360:
3361: l_cur_rec.person_id := p_auth_drp_data_rec.person_id;

Line 3385: INSERT INTO igs_sv_prgms_info (

3381: END IF;
3382: END IF;
3383:
3384:
3385: INSERT INTO igs_sv_prgms_info (
3386: batch_id ,
3387: person_id ,
3388: prgm_action_type ,
3389: position_code ,

Line 3491: FROM igs_sv_prgms_info prg,

3487: FROM igs_pe_nonimg_stat
3488: WHERE nonimg_form_id = p_person_rec.form_id
3489: AND nonimg_stat_id NOT IN
3490: ( SELECT NVL(form_status_id,0)
3491: FROM igs_sv_prgms_info prg,
3492: igs_sv_persons pr
3493: WHERE prg.person_id = pr.person_id
3494: AND prg.batch_id = pr.batch_id
3495: AND pr.record_status <> 'E'

Line 3514: FROM igs_sv_prgms_info prg,

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,
3515: igs_sv_persons pr
3516: WHERE prg.person_id = pr.person_id
3517: AND pr.record_status <> 'E'
3518: AND prg.batch_id = pr.batch_id

Line 3529: CURSOR c_drp(cp_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE) IS

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,
3531: prgms.prgm_start_date,
3532: prgms.prgm_end_date,
3533: prgms.remarks,

Line 3535: FROM igs_sv_prgms_info prgms,

3531: prgms.prgm_start_date,
3532: prgms.prgm_end_date,
3533: prgms.remarks,
3534: prgms.auth_action_code
3535: FROM igs_sv_prgms_info prgms,
3536: igs_sv_persons pr
3537: WHERE prgms.person_id = pr.person_id
3538: AND pr.record_status <> 'E'
3539: AND prgms.person_id = p_person_rec.person_id

Line 3544: FROM igs_sv_prgms_info prs,

3540: AND prgms.prgm_action_type = 'DB'
3541: AND prgms.sevis_auth_id = cp_sevis_auth_id
3542: AND prgms.batch_id IN
3543: ( SELECT max(prs.batch_id)
3544: FROM igs_sv_prgms_info prs,
3545: igs_sv_persons pr
3546: WHERE prs.person_id = pr.person_id
3547: AND prs.batch_id = pr.batch_id
3548: AND pr.record_status <> 'E'

Line 3558: FROM igs_sv_prgms_info prgms,

3554: CURSOR c_res IS
3555: SELECT prgms.prgm_start_date,
3556: prgms.prgm_end_date,
3557: prgms.remarks
3558: FROM igs_sv_prgms_info prgms,
3559: igs_sv_persons pr
3560: WHERE prgms.person_id = pr.person_id
3561: AND prgms.batch_id = pr.batch_id
3562: AND pr.record_status <> 'E'

Line 3592: CURSOR c_auth_details(cp_person_id igs_sv_prgms_info.person_id%TYPE)

3588: IGS_PE_NONIMG_FORM_V
3589: WHERE
3590: nonimg_form_id = p_person_rec.form_id;
3591:
3592: CURSOR c_auth_details(cp_person_id igs_sv_prgms_info.person_id%TYPE)
3593: IS
3594: SELECT sevis_auth_id, sevis_authorization_code, start_dt, end_dt, comments, cancel_flag
3595: FROM igs_en_svs_auth
3596: WHERE person_id = cp_person_id;

Line 3598: CURSOR c_prgm_dates(cp_person_id igs_sv_prgms_info.person_id%TYPE)

3594: SELECT sevis_auth_id, sevis_authorization_code, start_dt, end_dt, comments, cancel_flag
3595: FROM igs_en_svs_auth
3596: WHERE person_id = cp_person_id;
3597:
3598: CURSOR c_prgm_dates(cp_person_id igs_sv_prgms_info.person_id%TYPE)
3599: IS
3600: SELECT prgm_start_date, prgm_end_date, visa_type
3601: FROM igs_pe_nonimg_form
3602: WHERE person_id = cp_person_id

Line 3621: l_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE;

3617: lv_prgm_end_dt DATE;
3618: l_cancel_flag VARCHAR2(1); -- will go as fifth OUT parameter in ENRF_GET_SEVIS_AUTH_DETAILS
3619: l_auth_rec_count NUMBER(2) := 0;
3620: l_counter NUMBER(10):= 0;
3621: l_sevis_auth_id igs_sv_prgms_info.sevis_auth_id%TYPE;
3622: c_drp_rec c_drp%ROWTYPE;
3623: BEGIN
3624:
3625: /* Debug */

Line 6210: (IGS_SV_PRGMS_INFO).

6206:
6207: Date Created By : Oct 14, 2002
6208:
6209: Purpose : Get Education information on the student
6210: (IGS_SV_PRGMS_INFO).
6211:
6212: Remarks :
6213:
6214: Change History

Line 6220: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record

6216: ------------------------------------------------------------------------
6217:
6218: ******************************************************************/
6219: FUNCTION Get_Edu_Info (
6220: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record
6221: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
6222: IS
6223:
6224: l_api_name CONSTANT VARCHAR2(25) := 'Get_Edu_Info';

Line 6241: FROM igs_sv_prgms_info cr

6237: english_reqd_met ,
6238: not_reqd_reason ,
6239: educ_lvl_remarks ,
6240: remarks
6241: FROM igs_sv_prgms_info cr
6242: WHERE cr.person_id = p_data_rec.person_id
6243: AND cr.prgm_action_type='EP'
6244: AND cr.batch_id IN
6245: ( SELECT max(prs.batch_id)

Line 6246: FROM igs_sv_prgms_info prs,

6242: WHERE cr.person_id = p_data_rec.person_id
6243: AND cr.prgm_action_type='EP'
6244: AND cr.batch_id IN
6245: ( SELECT max(prs.batch_id)
6246: FROM igs_sv_prgms_info prs,
6247: igs_sv_persons pr
6248: WHERE prs.person_id = pr.person_id
6249: AND prs.batch_id = pr.batch_id
6250: AND pr.record_status <> 'E'

Line 7195: (IGS_SV_PRGMS_INFO).

7191:
7192: Date Created By : Oct 14, 2002
7193:
7194: Purpose : Insert education information on the student
7195: (IGS_SV_PRGMS_INFO).
7196:
7197: Remarks :
7198:
7199: Change History

Line 7206: p_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE,

7202:
7203: ******************************************************************/
7204: PROCEDURE Insert_Edu_Info (
7205: p_edu_type IN VARCHAR2,
7206: p_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE,
7207: p_auth_drp_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE
7208: )
7209: IS
7210:

Line 7207: p_auth_drp_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE

7203: ******************************************************************/
7204: PROCEDURE Insert_Edu_Info (
7205: p_edu_type IN VARCHAR2,
7206: p_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE,
7207: p_auth_drp_data_rec IN IGS_SV_PRGMS_INFO%ROWTYPE
7208: )
7209: IS
7210:
7211: l_api_name CONSTANT VARCHAR(30) := 'Insert_Edu_Info';

Line 7217: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;

7213: l_action VARCHAR2(30);
7214: l_btch_id NUMBER(14);
7215: l_tag_code VARCHAR2(30);
7216: l_edu_status VARCHAR2(10);
7217: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
7218:
7219: l_education_level igs_pe_nonimg_form.education_level%TYPE;
7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;

Line 7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;

7220: l_primary_major igs_pe_nonimg_form.primary_major%TYPE;
7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%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;

Line 7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%TYPE;

7221: l_secondary_major igs_pe_nonimg_form.secondary_major%TYPE;
7222: l_minor igs_pe_nonimg_form.minor%TYPE;
7223: l_length_of_study igs_pe_nonimg_form.length_of_study%TYPE;
7224: l_prgm_start_date igs_Sv_prgms_info.prgm_start_date%TYPE;
7225: l_prgm_end_date igs_Sv_prgms_info.prgm_end_date%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;

Line 7340: 'IGS_SV_PRGMS_INFO',

7336: p_data_rec.person_id,
7337: l_action,
7338: l_tag_code,
7339: 'SEND',
7340: 'IGS_SV_PRGMS_INFO',
7341: p_data_rec.prgm_action_type);
7342:
7343: l_cur_rec.person_id := p_data_rec.person_id;
7344: l_edu_status := Get_Othr_Prgm_Info (p_data_rec => l_cur_rec);

Line 7388: 'IGS_SV_PRGMS_INFO',

7384: p_data_rec.person_id,
7385: l_action,
7386: 'SV_PRGMS',
7387: 'SEND',
7388: 'IGS_SV_PRGMS_INFO',
7389: p_data_rec.prgm_action_type);
7390: END IF;
7391: INSERT INTO igs_sv_prgms_info (
7392: batch_id ,

Line 7391: INSERT INTO igs_sv_prgms_info (

7387: 'SEND',
7388: 'IGS_SV_PRGMS_INFO',
7389: p_data_rec.prgm_action_type);
7390: END IF;
7391: INSERT INTO igs_sv_prgms_info (
7392: batch_id ,
7393: person_id ,
7394: prgm_action_type ,
7395: print_form ,

Line 9567: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record

9563:
9564: END Update_Personal_Info;
9565:
9566: FUNCTION Get_EV_Prgm_Info (
9567: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record
9568: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
9569: IS
9570:
9571: l_api_name CONSTANT VARCHAR2(25) := 'Get_EV_Prgm_Info';

Line 9581: FROM igs_sv_prgms_info

9577: effective_date,
9578: termination_reason,
9579: end_prgm_reason,
9580: remarks
9581: FROM igs_sv_prgms_info
9582: WHERE person_id = p_data_rec.person_id AND
9583: batch_id IN
9584: ( SELECT max(prg.batch_id)
9585: FROM igs_sv_prgms_info prg,

Line 9585: FROM igs_sv_prgms_info prg,

9581: FROM igs_sv_prgms_info
9582: WHERE person_id = p_data_rec.person_id AND
9583: batch_id IN
9584: ( SELECT max(prg.batch_id)
9585: FROM igs_sv_prgms_info prg,
9586: igs_sv_persons pr
9587: WHERE prg.person_id = pr.person_id
9588: AND prg.batch_id = pr.batch_id
9589: AND pr.record_status <> 'E'

Line 9668: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record

9664:
9665: END Get_EV_Prgm_Info;
9666:
9667: FUNCTION Get_nonimg_Prgm_Info (
9668: p_data_rec IN OUT NOCOPY IGS_SV_PRGMS_INFO%ROWTYPE -- Data record
9669: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
9670: IS
9671:
9672: l_api_name CONSTANT VARCHAR2(25) := 'Get_nonimg_Prgm_Info';

Line 9682: FROM igs_sv_prgms_info

9678: prgm_end_date,
9679: remarks,
9680: termination_reason,
9681: print_form
9682: FROM igs_sv_prgms_info
9683: WHERE person_id = p_data_rec.person_id AND
9684: batch_id IN
9685: ( SELECT max(prg.batch_id)
9686: FROM igs_sv_prgms_info prg,

Line 9686: FROM igs_sv_prgms_info prg,

9682: FROM igs_sv_prgms_info
9683: WHERE person_id = p_data_rec.person_id AND
9684: batch_id IN
9685: ( SELECT max(prg.batch_id)
9686: FROM igs_sv_prgms_info prg,
9687: igs_sv_persons pr
9688: WHERE prg.person_id = pr.person_id
9689: AND prg.batch_id = pr.batch_id
9690: AND pr.record_status <> 'E'

Line 9787: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;

9783: ) RETURN VARCHAR2
9784: IS
9785:
9786: l_api_name CONSTANT VARCHAR2(30) := 'Update_Program_Info';
9787: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
9788: l_status VARCHAR2(1);
9789: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;
9790: l_count NUMBER(10);
9791: l_cur_prgm_rec g_edu_rec_type;

Line 9789: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;

9785:
9786: l_api_name CONSTANT VARCHAR2(30) := 'Update_Program_Info';
9787: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
9788: l_status VARCHAR2(1);
9789: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;
9790: l_count NUMBER(10);
9791: l_cur_prgm_rec g_edu_rec_type;
9792: l_cur_authdrp_rec g_edu_rec_type;
9793: l_auth_rec_count NUMBER := 0;

Line 10075: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;

10071: ) RETURN VARCHAR2
10072: IS
10073:
10074: l_api_name CONSTANT VARCHAR2(30) := 'Update_EV_Program_Info';
10075: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10076: l_cur_authdrp_rec g_edu_rec_type;
10077: l_status VARCHAR2(1);
10078: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10079: l_count NUMBER(10);

Line 10078: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;

10074: l_api_name CONSTANT VARCHAR2(30) := 'Update_EV_Program_Info';
10075: l_cur_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10076: l_cur_authdrp_rec g_edu_rec_type;
10077: l_status VARCHAR2(1);
10078: l_prev_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10079: l_count NUMBER(10);
10080: l_cur_prgm_rec g_edu_rec_type;
10081:
10082: BEGIN

Line 11302: DELETE FROM igs_sv_prgms_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;

11298: DELETE FROM igs_sv_legal_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11299:
11300: DELETE FROM igs_sv_oth_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11301:
11302: DELETE FROM igs_sv_prgms_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11303:
11304: DELETE FROM igs_sv_persons WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
11305:
11306: DELETE FROM igs_sv_btch_summary WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ); -- prbhardw

Line 11517: l_edu_rec IGS_SV_PRGMS_INFO%ROWTYPE;

11513: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;
11514: l_issue_rec IGS_SV_PERSONS%ROWTYPE;
11515: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
11516: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
11517: l_edu_rec IGS_SV_PRGMS_INFO%ROWTYPE;
11518: l_fin_rec IGS_SV_FINANCE_INFO %ROWTYPE;
11519: l_dep_rec g_dependent_rec_type;
11520: l_f_addr_rec g_address_rec_type;
11521: l_us_addr_rec g_address_rec_type;

Line 11527: l_cur_authdrp_rec IGS_SV_PRGMS_INFO%ROWTYPE;

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:
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

Line 11539: ( SELECT NVL(prs.form_status_id,0) FROM igs_sv_prgms_info prs, igs_sv_persons pr

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
11540: WHERE prs.person_id = pr.person_id AND prs.batch_id = pr.batch_id
11541: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id)
11542: ) AND fr.sevis_school_identifier = p_org_party_id AND
11543: ( (p_dso_id IS NULL AND

Line 11570: FROM igs_sv_prgms_info prs, igs_sv_persons pr

11566: WHERE st.action_type IN ('T','C')
11567: AND st.nonimg_form_id = fr.nonimg_form_id
11568: AND st.nonimg_stat_id IN
11569: ( SELECT NVL(prs.form_status_id,0)
11570: FROM igs_sv_prgms_info prs, igs_sv_persons pr
11571: WHERE prs.person_id = pr.person_id AND prs.batch_id = pr.batch_id
11572: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id
11573: ) )
11574: AND fr.sevis_school_identifier = p_org_party_id AND