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_LEGAL_INFO

Line 671: (IGS_SV_LEGAL_INFO)

667: Date Created By : Oct 14, 2002
668:
669: Purpose : Validate information pertaining to the
670: Legal information block of student.
671: (IGS_SV_LEGAL_INFO)
672:
673: Remarks : Return result:
674: 'S' - record found and validated
675: 'E' - validation error

Line 4952: (IGS_SV_LEGAL_INFO)

4948: Date Created By : Oct 14, 2002
4949:
4950: Purpose : Validate information pertaining to the
4951: Legal information block of student.
4952: (IGS_SV_LEGAL_INFO)
4953:
4954: Remarks : Return result:
4955: 'S' - record found and validated
4956: 'E' - validation error

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

4963:
4964: ******************************************************************/
4965: FUNCTION Validate_Legal_Info (
4966: p_person_rec IN t_student_rec,
4967: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
4968: ) RETURN VARCHAR2
4969: IS
4970:
4971: l_api_name CONSTANT VARCHAR(30) := 'Validate_Legal_Info';

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

5111: END Validate_Legal_Info;
5112:
5113: FUNCTION Validate_ev_Legal_Info (
5114: p_person_rec IN t_student_rec,
5115: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
5116: ) RETURN VARCHAR2
5117: IS
5118:
5119: l_api_name CONSTANT VARCHAR(30) := 'Validate_ev_Legal_Info';

Line 6651: (IGS_SV_LEGAL_INFO).

6647:
6648: Date Created By : Oct 14, 2002
6649:
6650: Purpose : Get the legal information for the student.
6651: (IGS_SV_LEGAL_INFO).
6652:
6653: Remarks :
6654:
6655: Change History

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

6657: ------------------------------------------------------------------------
6658:
6659: ******************************************************************/
6660: FUNCTION Get_Legal_Info (
6661: p_data_rec IN OUT NOCOPY IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
6662: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
6663: IS
6664: l_api_name CONSTANT VARCHAR2(25) := 'Get_Legal_Info';
6665:

Line 6679: FROM igs_sv_legal_info cr

6675: port_of_entry ,
6676: date_of_entry ,
6677: remarks ,
6678: visa_issue_date
6679: FROM igs_sv_legal_info cr
6680: WHERE cr.person_id = p_data_rec.person_id
6681: AND cr.batch_id IN
6682: ( SELECT max(prs.batch_id)
6683: FROM igs_sv_legal_info prs,

Line 6683: FROM igs_sv_legal_info prs,

6679: FROM igs_sv_legal_info cr
6680: WHERE cr.person_id = p_data_rec.person_id
6681: AND cr.batch_id IN
6682: ( SELECT max(prs.batch_id)
6683: FROM igs_sv_legal_info prs,
6684: igs_sv_persons pr
6685: WHERE prs.person_id = pr.person_id
6686: AND prs.batch_id = pr.batch_id
6687: AND pr.record_status <> 'E'

Line 7992: (IGS_SV_LEGAL_INFO).

7988:
7989: Date Created By : Oct 14, 2002
7990:
7991: Purpose : Insert Legal information on the student.
7992: (IGS_SV_LEGAL_INFO).
7993:
7994: Remarks :
7995:
7996: Change History

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

7998: ------------------------------------------------------------------------
7999:
8000: ******************************************************************/
8001: PROCEDURE Insert_Legal_Info (
8002: p_data_rec IN IGS_SV_LEGAL_INFO%ROWTYPE -- Data record
8003: )
8004: IS
8005: l_api_name CONSTANT VARCHAR(30) := 'Insert_Legal_Info';
8006:

Line 8019: 'IGS_SV_LEGAL_INFO',

8015: p_data_rec.person_id,
8016: g_legal_status, --g_person_status, commented for bug 5253779
8017: 'SV_LEGAL',
8018: 'SEND',
8019: 'IGS_SV_LEGAL_INFO',
8020: '');
8021: INSERT INTO igs_sv_legal_info (
8022: batch_id ,
8023: person_id ,

Line 8021: INSERT INTO igs_sv_legal_info (

8017: 'SV_LEGAL',
8018: 'SEND',
8019: 'IGS_SV_LEGAL_INFO',
8020: '');
8021: INSERT INTO igs_sv_legal_info (
8022: batch_id ,
8023: person_id ,
8024: print_form ,
8025: psprt_number ,

Line 8244: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;

8240: IS
8241:
8242: l_api_name CONSTANT VARCHAR2(30) := 'Update_Registration_Info';
8243:
8244: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8245: l_status VARCHAR2(1);
8246:
8247: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8248:

Line 8247: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;

8243:
8244: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8245: l_status VARCHAR2(1);
8246:
8247: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8248:
8249:
8250: -- Old dates
8251: CURSOR c_old_ses_dates IS

Line 8545: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;

8541: IS
8542:
8543: l_api_name CONSTANT VARCHAR2(30) := 'Update_ev_Legal_Info';
8544:
8545: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8546: l_status VARCHAR2(1);
8547:
8548: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8549:

Line 8548: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;

8544:
8545: l_cur_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8546: l_status VARCHAR2(1);
8547:
8548: l_prev_rec IGS_SV_LEGAL_INFO%ROWTYPE;
8549:
8550: l_count NUMBER(10);
8551: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
8552:

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

11294: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11295:
11296: DELETE FROM igs_sv_finance_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11297:
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 ) ;