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_LEGAL_INFO

Line 627: (IGS_SV_LEGAL_INFO)

623: Date Created By : Oct 14, 2002
624:
625: Purpose : Validate information pertaining to the
626: Legal information block of student.
627: (IGS_SV_LEGAL_INFO)
628:
629: Remarks : Return result:
630: 'S' - record found and validated
631: 'E' - validation error

Line 4000: (IGS_SV_LEGAL_INFO)

3996: Date Created By : Oct 14, 2002
3997:
3998: Purpose : Validate information pertaining to the
3999: Legal information block of student.
4000: (IGS_SV_LEGAL_INFO)
4001:
4002: Remarks : Return result:
4003: 'S' - record found and validated
4004: 'E' - validation error

Line 4015: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record

4011:
4012: ******************************************************************/
4013: FUNCTION Validate_Legal_Info (
4014: p_person_rec IN t_student_rec,
4015: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
4016: ) RETURN VARCHAR2
4017: IS
4018:
4019: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';

Line 4159: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record

4155: END Validate_Legal_Info;
4156:
4157: FUNCTION Validate_ev_Legal_Info (
4158: p_person_rec IN t_student_rec,
4159: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
4160: ) RETURN VARCHAR2
4161: IS
4162:
4163: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';

Line 5693: (IGS_SV_LEGAL_INFO).

5689:
5690: Date Created By : Oct 14, 2002
5691:
5692: Purpose : Get the legal information for the student.
5693: (IGS_SV_LEGAL_INFO).
5694:
5695: Remarks :
5696:
5697: Change History

Line 5703: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record

5699: ------------------------------------------------------------------------
5700:
5701: ******************************************************************/
5702: FUNCTION Get_Legal_Info (
5703: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
5704: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5705: IS
5706: l_api_name CONSTANT VARCHAR2(25) := 'Get_Legal_Info';
5707:

Line 5721: FROM igs_sv_legal_info cr

5717: port_of_entry ,
5718: date_of_entry ,
5719: remarks ,
5720: visa_issue_date
5721: FROM igs_sv_legal_info cr
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,

Line 5725: FROM igs_sv_legal_info prs,

5721: FROM igs_sv_legal_info cr
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'

Line 6916: (IGS_SV_LEGAL_INFO).

6912:
6913: Date Created By : Oct 14, 2002
6914:
6915: Purpose : Insert Legal information on the student.
6916: (IGS_SV_LEGAL_INFO).
6917:
6918: Remarks :
6919:
6920: Change History

Line 6926: p_data_rec IN IGS_SV_LEGAL_INFO%ROWTYPE -- Data record

6922: ------------------------------------------------------------------------
6923:
6924: ******************************************************************/
6925: PROCEDURE Insert_Legal_Info (
6926: p_data_rec IN IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
6927: )
6928: IS
6929: l_api_name CONSTANT VARCHAR(30) := 'Insert_Legal_Info';
6930:

Line 6943: 'IGS_SV_LEGAL_INFO',

6939: p_data_rec.person_id,
6940: g_person_status,
6941: 'SV_LEGAL',
6942: 'SEND',
6943: 'IGS_SV_LEGAL_INFO',
6944: '');
6945: INSERT INTO igs_sv_legal_info (
6946: batch_id ,
6947: person_id ,

Line 6945: INSERT INTO igs_sv_legal_info (

6941: 'SV_LEGAL',
6942: 'SEND',
6943: 'IGS_SV_LEGAL_INFO',
6944: '');
6945: INSERT INTO igs_sv_legal_info (
6946: batch_id ,
6947: person_id ,
6948: print_form ,
6949: psprt_number ,

Line 7168: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;

7164: IS
7165:
7166: l_api_name CONSTANT VARCHAR2(30) := 'Update_Registration_Info';
7167:
7168: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7169: l_status VARCHAR2(1);
7170:
7171: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7172:

Line 7171: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;

7167:
7168: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7169: l_status VARCHAR2(1);
7170:
7171: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7172:
7173:
7174: -- Old dates
7175: CURSOR c_old_ses_dates IS

Line 7469: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;

7465: IS
7466:
7467: l_api_name CONSTANT VARCHAR2(30) := 'Update_ev_Legal_Info';
7468:
7469: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7470: l_status VARCHAR2(1);
7471:
7472: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7473:

Line 7472: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;

7468:
7469: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7470: l_status VARCHAR2(1);
7471:
7472: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
7473:
7474: l_count NUMBER(10);
7475: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
7476:

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

10151: DELETE FROM igs_sv_empl_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10152:
10153: DELETE FROM igs_sv_finance_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10154:
10155: DELETE FROM igs_sv_legal_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10156:
10157: DELETE FROM igs_sv_oth_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10158:
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 ) ;