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_SV_PERSONS

Line 84: ( person_id igs_sv_persons.person_id%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,
85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,

Line 85: batch_id igs_sv_persons.batch_id%TYPE,

81: );
82:
83: TYPE t_student_rec IS RECORD
84: ( person_id igs_sv_persons.person_id%TYPE,
85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,

Line 86: record_number igs_sv_persons.record_number%TYPE,

82:
83: TYPE t_student_rec IS RECORD
84: ( person_id igs_sv_persons.person_id%TYPE,
85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,

Line 87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged

83: TYPE t_student_rec IS RECORD
84: ( person_id igs_sv_persons.person_id%TYPE,
85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,

Line 88: person_number igs_sv_persons.person_number%TYPE,

84: ( person_id igs_sv_persons.person_id%TYPE,
85: batch_id igs_sv_persons.batch_id%TYPE,
86: record_number igs_sv_persons.record_number%TYPE,
87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,
92: print_form igs_sv_persons.print_form%TYPE,

Line 91: form_id igs_sv_persons.form_id%TYPE,

87: record_status igs_sv_persons.record_status%TYPE, --(N)ew (C)hanged
88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,
92: print_form igs_sv_persons.print_form%TYPE,
93: dep_flag VARCHAR2(1),
94: person_status VARCHAR2(1),
95: changes_found VARCHAR2(1),

Line 92: print_form igs_sv_persons.print_form%TYPE,

88: person_number igs_sv_persons.person_number%TYPE,
89: sevis_user_id igs_sv_batches.sevis_user_id%TYPE,
90: batch_type igs_sv_batches.batch_type%TYPE,
91: form_id igs_sv_persons.form_id%TYPE,
92: print_form igs_sv_persons.print_form%TYPE,
93: dep_flag VARCHAR2(1),
94: person_status VARCHAR2(1),
95: changes_found VARCHAR2(1),
96: issue_status VARCHAR2(1),

Line 110: no_show_flag igs_sv_persons.no_show_flag%TYPE,

106: site_addr_status VARCHAR2(1),
107: legal_status VARCHAR2(1),
108: dep_count NUMBER(3),
109: edu_count NUMBER(3),
110: no_show_flag igs_sv_persons.no_show_flag%TYPE,
111: reprint_reason igs_sv_persons.reprint_rsn_code%TYPE -- prbhardw
112: );
113:
114:

Line 111: reprint_reason igs_sv_persons.reprint_rsn_code%TYPE -- prbhardw

107: legal_status VARCHAR2(1),
108: dep_count NUMBER(3),
109: edu_count NUMBER(3),
110: no_show_flag igs_sv_persons.no_show_flag%TYPE,
111: reprint_reason igs_sv_persons.reprint_rsn_code%TYPE -- prbhardw
112: );
113:
114:
115:

Line 928: (IGS_SV_PERSONS)

924: Date Created By : Oct 14, 2002
925:
926: Purpose : Validate the information for the block that
927: is to be used for the Person Info Block
928: (IGS_SV_PERSONS)
929:
930: Remarks : Return result:
931: 'S' - record found and validated
932: 'E' - validation error

Line 943: p_data_rec IN OUT NOCOPY IGS_SV_PERSONS%ROWTYPE -- Data record

939:
940: ******************************************************************/
941: FUNCTION Validate_Issue_Info (
942: p_person_rec IN t_student_rec,
943: p_data_rec IN OUT NOCOPY IGS_SV_PERSONS%ROWTYPE -- Data record
944: ) RETURN VARCHAR2
945: IS
946:
947: l_api_name CONSTANT VARCHAR(30) := 'Validate_Issue_Info';

Line 2687: igs_sv_persons pr

2683: WHERE nonimg_form_id = p_person_rec.form_id
2684: AND nonimg_stat_id NOT IN
2685: ( SELECT NVL(form_status_id,0)
2686: FROM igs_sv_prgms_info prg,
2687: igs_sv_persons pr
2688: WHERE prg.person_id = pr.person_id
2689: AND prg.batch_id = pr.batch_id
2690: AND pr.record_status <> 'E'
2691: AND prg.person_id = p_person_rec.person_id

Line 2710: igs_sv_persons pr

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,
2710: igs_sv_persons pr
2711: WHERE prg.person_id = pr.person_id
2712: AND pr.record_status <> 'E'
2713: AND prg.batch_id = pr.batch_id
2714: AND prg.person_id = p_person_rec.person_id)

Line 2731: igs_sv_persons pr

2727: prgms.prgm_end_date,
2728: prgms.remarks,
2729: prgms.auth_action_code
2730: FROM igs_sv_prgms_info prgms,
2731: igs_sv_persons pr
2732: WHERE prgms.person_id = pr.person_id
2733: AND pr.record_status <> 'E'
2734: AND prgms.person_id = p_person_rec.person_id
2735: AND prgms.prgm_action_type = 'DB'

Line 2739: igs_sv_persons pr

2735: AND prgms.prgm_action_type = 'DB'
2736: AND prgms.batch_id IN
2737: ( SELECT max(prs.batch_id)
2738: FROM igs_sv_prgms_info prs,
2739: igs_sv_persons pr
2740: WHERE prs.person_id = pr.person_id
2741: AND prs.batch_id = pr.batch_id
2742: AND pr.record_status <> 'E'
2743: AND prs.person_id = p_person_rec.person_id

Line 2752: igs_sv_persons pr

2748: SELECT prgms.prgm_start_date,
2749: prgms.prgm_end_date,
2750: prgms.remarks
2751: FROM igs_sv_prgms_info prgms,
2752: igs_sv_persons pr
2753: WHERE prgms.person_id = pr.person_id
2754: AND prgms.batch_id = pr.batch_id
2755: AND pr.record_status <> 'E'
2756: AND prgms.person_id = p_person_rec.person_id

Line 3888: igs_sv_persons pr

3884: AND convict_ind ='Y'
3885: AND felony_details_id NOT IN
3886: ( SELECT conviction_id
3887: FROM igs_sv_convictions prg,
3888: igs_sv_persons pr
3889: WHERE prg.person_id = pr.person_id
3890: AND prg.batch_id = pr.batch_id
3891: AND pr.record_status <> 'E'
3892: AND prg.person_id = p_person_rec.person_id )

Line 4330: igs_sv_persons pr

4326: nonimg_empl_id = p_data_rec.nonimg_empl_id and
4327: batch_id IN
4328: ( SELECT max(emp.batch_id)
4329: FROM igs_sv_empl_info emp,
4330: igs_sv_persons pr
4331: WHERE emp.person_id = pr.person_id
4332: AND emp.batch_id = pr.batch_id
4333: AND pr.record_status <> 'E'
4334: AND emp.person_id = p_data_rec.person_id

Line 4729: (IGS_SV_PERSONS).

4725:
4726: Date Created By : Oct 14, 2002
4727:
4728: Purpose : Get the person information on the student.
4729: (IGS_SV_PERSONS).
4730:
4731: Remarks :
4732:
4733: Change History

Line 4739: p_data_rec IN OUT NOCOPY IGS_SV_PERSONS%ROWTYPE -- Data record

4735: ------------------------------------------------------------------------
4736:
4737: ******************************************************************/
4738: FUNCTION Get_Issue_Info (
4739: p_data_rec IN OUT NOCOPY IGS_SV_PERSONS%ROWTYPE -- Data record
4740: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
4741: IS
4742:
4743: l_api_name CONSTANT VARCHAR2(25) := 'Get_Issue_Info';

Line 4763: FROM igs_sv_persons cr

4759: cr.ev_create_reason ,
4760: cr.ev_form_number ,
4761: cr.no_show_flag ,
4762: cr.last_session_flag
4763: FROM igs_sv_persons cr
4764: WHERE cr.person_id = p_data_rec.person_id
4765: AND cr.batch_id IN
4766: ( SELECT max(mx.batch_id)
4767: FROM igs_sv_persons mx

Line 4767: FROM igs_sv_persons mx

4763: FROM igs_sv_persons cr
4764: WHERE cr.person_id = p_data_rec.person_id
4765: AND cr.batch_id IN
4766: ( SELECT max(mx.batch_id)
4767: FROM igs_sv_persons mx
4768: WHERE mx.person_id = p_data_rec.person_id
4769: AND mx.record_status <> 'E'
4770: );
4771:

Line 4903: igs_sv_persons pr

4899: WHERE cr.person_id = p_data_rec.person_id
4900: AND cr.batch_id IN
4901: ( SELECT max(prs.batch_id)
4902: FROM igs_sv_bio_info prs,
4903: igs_sv_persons pr
4904: WHERE prs.person_id = pr.person_id
4905: AND prs.batch_id = pr.batch_id
4906: AND pr.record_status <> 'E'
4907: AND prs.person_id = p_data_rec.person_id

Line 5027: igs_sv_persons pr

5023: WHERE cr.person_id = p_data_rec.person_id
5024: AND cr.batch_id IN
5025: ( SELECT max(prs.batch_id)
5026: FROM igs_sv_oth_info prs,
5027: igs_sv_persons pr
5028: WHERE prs.person_id = pr.person_id
5029: AND prs.batch_id = pr.batch_id
5030: AND pr.record_status <> 'E'
5031: AND prs.person_id = p_data_rec.person_id

Line 5153: igs_sv_persons pr

5149: AND cr.party_site_id = p_data_rec.party_site_id
5150: AND cr.batch_id IN
5151: ( SELECT max(prs.batch_id)
5152: FROM igs_sv_addresses prs,
5153: igs_sv_persons pr
5154: WHERE prs.person_id = pr.person_id
5155: AND prs.batch_id = pr.batch_id
5156: AND pr.record_status <> 'E'
5157: AND prs.person_id = p_data_rec.person_id

Line 5289: igs_sv_persons pr

5285: --AND cr.prgm_action_type='EP'
5286: AND cr.batch_id IN
5287: ( SELECT max(prs.batch_id)
5288: FROM igs_sv_prgms_info prs,
5289: igs_sv_persons pr
5290: WHERE prs.person_id = pr.person_id
5291: AND prs.batch_id = pr.batch_id
5292: AND pr.record_status <> 'E'
5293: AND prs.person_id = p_data_rec.person_id

Line 5441: igs_sv_persons pr

5437: WHERE cr.person_id = p_data_rec.person_id
5438: AND cr.batch_id IN
5439: ( SELECT max(prs.batch_id)
5440: FROM igs_sv_finance_info prs,
5441: igs_sv_persons pr
5442: WHERE prs.person_id = pr.person_id
5443: AND prs.batch_id = pr.batch_id
5444: AND pr.record_status <> 'E'
5445: AND prs.person_id = p_data_rec.person_id

Line 5594: igs_sv_persons pr

5590: AND cr.depdnt_id = p_data_rec.depdnt_id
5591: AND cr.batch_id IN
5592: ( SELECT max(prs.batch_id)
5593: FROM igs_sv_depdnt_info prs,
5594: igs_sv_persons pr
5595: WHERE prs.person_id = pr.person_id
5596: AND prs.batch_id = pr.batch_id
5597: AND pr.record_status <> 'E'
5598: AND prs.person_id = p_data_rec.person_id

Line 5726: igs_sv_persons pr

5722: WHERE cr.person_id = p_data_rec.person_id
5723: AND cr.batch_id IN
5724: ( SELECT max(prs.batch_id)
5725: FROM igs_sv_legal_info prs,
5726: igs_sv_persons pr
5727: WHERE prs.person_id = pr.person_id
5728: AND prs.batch_id = pr.batch_id
5729: AND pr.record_status <> 'E'
5730: AND prs.person_id = p_data_rec.person_id

Line 5821: (IGS_SV_PERSONS).

5817:
5818: Date Created By : Oct 14, 2002
5819:
5820: Purpose : Updating of person issue information block
5821: (IGS_SV_PERSONS).
5822:
5823: Remarks :
5824:
5825: Change History

Line 5831: p_data_rec IN IGS_SV_PERSONS%ROWTYPE -- Data record

5827: ------------------------------------------------------------------------
5828:
5829: ******************************************************************/
5830: PROCEDURE Update_Issue_Info (
5831: p_data_rec IN IGS_SV_PERSONS%ROWTYPE -- Data record
5832: )
5833: IS
5834:
5835: l_api_name CONSTANT VARCHAR(30) := 'Update_Issue_Info';

Line 5845: UPDATE IGS_SV_PERSONS

5841: l_debug_str := 'Entering Update_Issue_Info. p_data_rec.person_id is '||p_data_rec.person_id|| ' and p_data_rec.batch_id is '||p_data_rec.batch_id;
5842: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
5843: END IF;
5844:
5845: UPDATE IGS_SV_PERSONS
5846: SET issuing_reason = p_data_rec.issuing_reason,
5847: curr_session_end_date = p_data_rec.curr_session_end_date ,
5848: next_session_start_date= p_data_rec.next_session_start_date ,
5849: other_reason = p_data_rec.other_reason ,

Line 7179: FROM igs_sv_persons pr

7175: CURSOR c_old_ses_dates IS
7176: SELECT pr.curr_session_end_date,
7177: pr.next_session_start_date,
7178: pr.last_session_flag
7179: FROM igs_sv_persons pr
7180: WHERE pr.person_id = p_person_rec.person_id
7181: AND pr.batch_id IN
7182: ( SELECT max(btch.batch_id)
7183: FROM igs_sv_persons prs,

Line 7183: FROM igs_sv_persons prs,

7179: FROM igs_sv_persons pr
7180: WHERE pr.person_id = p_person_rec.person_id
7181: AND pr.batch_id IN
7182: ( SELECT max(btch.batch_id)
7183: FROM igs_sv_persons prs,
7184: igs_sv_batches btch,
7185: igs_sv_persons pr
7186: WHERE prs.person_id = pr.person_id
7187: AND prs.batch_id = pr.batch_id

Line 7185: igs_sv_persons pr

7181: AND pr.batch_id IN
7182: ( SELECT max(btch.batch_id)
7183: FROM igs_sv_persons prs,
7184: igs_sv_batches btch,
7185: igs_sv_persons pr
7186: WHERE prs.person_id = pr.person_id
7187: AND prs.batch_id = pr.batch_id
7188: AND pr.record_status <> 'E'
7189: AND prs.batch_id = btch.batch_id

Line 7203: l_start_date igs_sv_persons.curr_session_end_date%TYPE;

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

Line 7204: l_end_date igs_sv_persons.next_session_start_date%TYPE;

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

Line 7205: l_old_start_date igs_sv_persons.curr_session_end_date%TYPE;

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

Line 7206: l_old_end_date igs_sv_persons.next_session_start_date%TYPE;

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

Line 7365: UPDATE igs_sv_persons

7361:
7362: END IF;*/
7363: -- Update session dates for the main record required.
7364:
7365: UPDATE igs_sv_persons
7366: SET curr_session_end_date = l_start_date,
7367: next_session_start_date = l_end_date,
7368: last_session_flag = l_last_session_flag ---prbhardw
7369: WHERE person_id = p_person_rec.person_id and

Line 8474: igs_sv_persons pr

8470: WHERE person_id = p_data_rec.person_id AND
8471: batch_id IN
8472: ( SELECT max(prg.batch_id)
8473: FROM igs_sv_prgms_info prg,
8474: igs_sv_persons pr
8475: WHERE prg.person_id = pr.person_id
8476: AND prg.batch_id = pr.batch_id
8477: AND pr.record_status <> 'E'
8478: AND prg.person_id = p_data_rec.person_id

Line 8575: igs_sv_persons pr

8571: WHERE person_id = p_data_rec.person_id AND
8572: batch_id IN
8573: ( SELECT max(prg.batch_id)
8574: FROM igs_sv_prgms_info prg,
8575: igs_sv_persons pr
8576: WHERE prg.person_id = pr.person_id
8577: AND prg.batch_id = pr.batch_id
8578: AND pr.record_status <> 'E'
8579: AND prg.person_id = p_data_rec.person_id

Line 9461: igs_sv_persons pr

9457:
9458: CURSOR c_spouse_of_rel IS
9459: SELECT COUNT(1)
9460: FROM igs_sv_depdnt_info cr,
9461: igs_sv_persons pr
9462: WHERE cr.person_id = p_person_rec.person_id
9463: AND pr.record_status <> 'E'
9464: AND cr.person_id = pr.person_id
9465: AND cr.relationship = 'SPOUSE_OF';

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

10159: DELETE FROM igs_sv_prgms_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10160:
10161: DELETE FROM igs_sv_prgms_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10162:
10163: DELETE FROM igs_sv_persons WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10164:
10165: DELETE FROM igs_sv_persons WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10166:
10167: 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 10165: DELETE FROM igs_sv_persons WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );

10161: DELETE FROM igs_sv_prgms_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10162:
10163: DELETE FROM igs_sv_persons WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10164:
10165: DELETE FROM igs_sv_persons WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10166:
10167: 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
10168:
10169: 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 10262: FUNCTION Get_pre_noshow_status(p_person_id igs_sv_persons.person_id%TYPE, p_batch_id igs_sv_persons.person_id%TYPE)

10258:
10259: END EV_Batch_Process;
10260:
10261:
10262: FUNCTION Get_pre_noshow_status(p_person_id igs_sv_persons.person_id%TYPE, p_batch_id igs_sv_persons.person_id%TYPE)
10263: RETURN VARCHAR2
10264: IS
10265: l_no_show_status VARCHAR2(1);
10266: CURSOR no_show_change(c_person_id igs_sv_persons.person_id%TYPE, c_batch_id igs_sv_persons.person_id%TYPE)

Line 10266: CURSOR no_show_change(c_person_id igs_sv_persons.person_id%TYPE, c_batch_id igs_sv_persons.person_id%TYPE)

10262: FUNCTION Get_pre_noshow_status(p_person_id igs_sv_persons.person_id%TYPE, p_batch_id igs_sv_persons.person_id%TYPE)
10263: RETURN VARCHAR2
10264: IS
10265: l_no_show_status VARCHAR2(1);
10266: CURSOR no_show_change(c_person_id igs_sv_persons.person_id%TYPE, c_batch_id igs_sv_persons.person_id%TYPE)
10267: IS
10268: SELECT old_per.no_show_flag
10269: FROM igs_sv_persons new_per, igs_sv_persons old_per
10270: WHERE new_per.person_id = c_person_id AND

Line 10269: FROM igs_sv_persons new_per, igs_sv_persons old_per

10265: l_no_show_status VARCHAR2(1);
10266: CURSOR no_show_change(c_person_id igs_sv_persons.person_id%TYPE, c_batch_id igs_sv_persons.person_id%TYPE)
10267: IS
10268: SELECT old_per.no_show_flag
10269: FROM igs_sv_persons new_per, igs_sv_persons old_per
10270: WHERE new_per.person_id = c_person_id AND
10271: new_per.batch_id = c_batch_id AND
10272: old_per.batch_id = (SELECT max(batch_id) FROM igs_sv_persons WHERE batch_id < c_batch_id) AND
10273: old_per.person_id = new_per.person_id;

Line 10272: old_per.batch_id = (SELECT max(batch_id) FROM igs_sv_persons WHERE batch_id < c_batch_id) AND

10268: SELECT old_per.no_show_flag
10269: FROM igs_sv_persons new_per, igs_sv_persons old_per
10270: WHERE new_per.person_id = c_person_id AND
10271: new_per.batch_id = c_batch_id AND
10272: old_per.batch_id = (SELECT max(batch_id) FROM igs_sv_persons WHERE batch_id < c_batch_id) AND
10273: old_per.person_id = new_per.person_id;
10274: BEGIN
10275:
10276: OPEN no_show_change(p_person_id,p_batch_id);

Line 10374: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;

10370:
10371:
10372:
10373: l_batch_id igs_sv_batches.batch_id%TYPE;
10374: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;
10375: l_issue_rec IGS_SV_PERSONS%ROWTYPE;
10376: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
10377: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
10378: l_edu_rec IGS_SV_PRGMS_INFO%ROWTYPE;

Line 10375: l_issue_rec IGS_SV_PERSONS%ROWTYPE;

10371:
10372:
10373: l_batch_id igs_sv_batches.batch_id%TYPE;
10374: l_person_sevis_id IGS_SV_PERSONS.SEVIS_USER_ID%TYPE;
10375: l_issue_rec IGS_SV_PERSONS%ROWTYPE;
10376: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
10377: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
10378: l_edu_rec IGS_SV_PRGMS_INFO%ROWTYPE;
10379: l_fin_rec IGS_SV_FINANCE_INFO %ROWTYPE;

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

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
10401: WHERE prs.person_id = pr.person_id AND prs.batch_id = pr.batch_id
10402: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id)
10403: ) AND fr.sevis_school_identifier = p_org_party_id AND
10404: (

Line 10426: FROM igs_sv_prgms_info prs, igs_sv_persons pr

10422: WHERE st.action_type IN ('T','C')
10423: AND st.nonimg_form_id = fr.nonimg_form_id
10424: AND st.nonimg_stat_id IN
10425: ( SELECT NVL(prs.form_status_id,0)
10426: FROM igs_sv_prgms_info prs, igs_sv_persons pr
10427: WHERE prs.person_id = pr.person_id AND prs.batch_id = pr.batch_id
10428: AND pr.record_status <> 'E' AND prs.person_id = fr.person_id
10429: ) )
10430: AND fr.sevis_school_identifier = p_org_party_id AND

Line 10457: FROM igs_sv_persons a,

10453: WHERE party_id = cp_party_id;
10454:
10455: CURSOR c_prev_info( p_id NUMBER, f_id NUMBER) IS
10456: SELECT 1
10457: FROM igs_sv_persons a,
10458: igs_sv_batches b
10459: WHERE person_id = p_id
10460: AND a.batch_id = b.batch_id
10461: AND b.batch_type = p_batch_type

Line 10509: l_record_number igs_sv_persons.record_number%TYPE;

10505:
10506:
10507:
10508: l_batch_status VARCHAR(1) := 'N'; -- batch status (S)uccess, (E)rror,'N'o new students
10509: l_record_number igs_sv_persons.record_number%TYPE;
10510: l_student_rec t_student_rec;
10511: l_status VARCHAR2(1);
10512: l_count NUMBER(10);
10513: l_soa_count NUMBER(5); -- prbhardw CP enhancement

Line 10763: l_debug_str := 'Inserting in igs_sv_persons batch id: '||l_batch_id;

10759: END IF;
10760: /* Debug */
10761: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
10762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10763: l_debug_str := 'Inserting in igs_sv_persons batch id: '||l_batch_id;
10764: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10765: END IF;
10766: INSERT INTO igs_sv_persons (
10767: batch_id ,

Line 10766: INSERT INTO igs_sv_persons (

10762: l_label := 'igs.plsql.igs_sv_ni_batch_process_pkg.Create_Batch';
10763: l_debug_str := 'Inserting in igs_sv_persons batch id: '||l_batch_id;
10764: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
10765: END IF;
10766: INSERT INTO igs_sv_persons (
10767: batch_id ,
10768: person_id ,
10769: record_number,
10770: form_id ,

Line 11133: 'IGS_SV_PERSONS',

11129: l_student_rec.person_id,
11130: 'NOSHOW',
11131: 'SV_STATUS',
11132: 'SEND',
11133: 'IGS_SV_PERSONS',
11134: '');
11135: END IF;
11136: ELSE
11137:

Line 11830: UPDATE igs_sv_persons

11826: END IF;
11827:
11828: IF lower(p_Status) <> 'true' THEN
11829:
11830: UPDATE igs_sv_persons
11831: SET record_status = 'E',
11832: sevis_error_code = p_SEVIS_ErrorCode,
11833: sevis_error_element = p_SEVIS_ErrorElement
11834: WHERE batch_id = p_BatchID

Line 12067: update igs_sv_persons set SEVIS_USER_ID = p_sevisID ,

12063: p_SEVIS_ErrorCode => p_SEVIS_ErrorCode,
12064: p_SEVIS_ErrorElement => p_SEVIS_ErrorElement
12065: );
12066:
12067: update igs_sv_persons set SEVIS_USER_ID = p_sevisID ,
12068: SEVIS_ERROR_CODE = p_SEVIS_ErrorCode, SEVIS_ERROR_ELEMENT = p_SEVIS_ErrorElement
12069: where person_id = p_PersonID;
12070:
12071: EXCEPTION