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_OTH_INFO

Line 1611: Other information. (IGS_SV_OTH_INFO)

1607:
1608: Date Created By : Oct 14, 2002
1609:
1610: Purpose : Validation on the data block pertaining to
1611: Other information. (IGS_SV_OTH_INFO)
1612:
1613: Remarks : Return result:
1614: 'S' - record found and validated
1615: 'E' - validation error

Line 1630: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record

1626:
1627: ******************************************************************/
1628: FUNCTION Validate_Other_Info (
1629: p_person_rec IN t_student_rec,
1630: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record
1631: ) RETURN VARCHAR2
1632: IS
1633:
1634: l_api_name CONSTANT VARCHAR(30) := 'Validate_Other_Info';

Line 5001: (IGS_SV_OTH_INFO)

4997:
4998: Date Created By : Oct 14, 2002
4999:
5000: Purpose : Get other information on the student
5001: (IGS_SV_OTH_INFO)
5002:
5003: Remarks :
5004:
5005: Change History

Line 5011: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record

5007: ------------------------------------------------------------------------
5008:
5009: ******************************************************************/
5010: FUNCTION Get_Other_Info (
5011: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record
5012: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5013: IS
5014:
5015: l_api_name CONSTANT VARCHAR2(25) := 'Get_Other_Info';

Line 5022: FROM igs_sv_oth_info cr

5018: SELECT drivers_license ,
5019: drivers_license_state ,
5020: ssn ,
5021: tax_id
5022: FROM igs_sv_oth_info cr
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,

Line 5026: FROM igs_sv_oth_info prs,

5022: FROM igs_sv_oth_info cr
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'

Line 5995: (IGS_SV_OTH_INFO)

5991:
5992: Date Created By : Oct 14, 2002
5993:
5994: Purpose : Insert Other information block
5995: (IGS_SV_OTH_INFO)
5996:
5997: remarks :
5998:
5999: Change History

Line 6005: p_data_rec IN IGS_SV_OTH_INFO%ROWTYPE -- Data record

6001: ------------------------------------------------------------------------
6002:
6003: ******************************************************************/
6004: PROCEDURE Insert_Other_Info (
6005: p_data_rec IN IGS_SV_OTH_INFO%ROWTYPE -- Data record
6006: )
6007: IS
6008:
6009: l_api_name CONSTANT VARCHAR(30) := 'Insert_Other_Info';

Line 6023: 'IGS_SV_OTH_INFO',

6019: p_data_rec.person_id,
6020: g_person_status,
6021: 'SV_OTHER',
6022: 'SEND',
6023: 'IGS_SV_OTH_INFO',
6024: '');
6025:
6026: INSERT INTO IGS_SV_OTH_INFO (
6027: batch_id ,

Line 6026: INSERT INTO IGS_SV_OTH_INFO (

6022: 'SEND',
6023: 'IGS_SV_OTH_INFO',
6024: '');
6025:
6026: INSERT INTO IGS_SV_OTH_INFO (
6027: batch_id ,
6028: person_id ,
6029: print_form ,
6030: drivers_license ,

Line 8038: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

8034: IS
8035:
8036: l_api_name CONSTANT VARCHAR2(30) := 'Update_Personal_Info';
8037: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
8038: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
8039: l_f_addr_rec g_address_rec_type;
8040: l_us_addr_rec g_address_rec_type;
8041: l_count NUMBER(10);
8042: l_changes_found VARCHAR2(1) := 'N'; --No changes by default

Line 8046: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

8042: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
8043: l_status VARCHAR2(1);
8044:
8045: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
8046: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
8047: l_prev_f_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8048: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
8049:
8050:

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

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

Line 10377: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

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;
10380: l_dep_rec g_dependent_rec_type;
10381: l_f_addr_rec g_address_rec_type;