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.

[Home] [Help]

APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on IGS_SV_OTH_INFO

Line 1836: Other information. (IGS_SV_OTH_INFO)

1832:
1833: Date Created By : Oct 14, 2002
1834:
1835: Purpose : Validation on the data block pertaining to
1836: Other information. (IGS_SV_OTH_INFO)
1837:
1838: Remarks : Return result:
1839: 'S' - record found and validated
1840: 'E' - validation error

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

1851:
1852: ******************************************************************/
1853: FUNCTION Validate_Other_Info (
1854: p_person_rec IN t_student_rec,
1855: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record
1856: ) RETURN VARCHAR2
1857: IS
1858:
1859: l_api_name CONSTANT VARCHAR(30) := 'Validate_Other_Info';

Line 5957: (IGS_SV_OTH_INFO)

5953:
5954: Date Created By : Oct 14, 2002
5955:
5956: Purpose : Get other information on the student
5957: (IGS_SV_OTH_INFO)
5958:
5959: Remarks :
5960:
5961: Change History

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

5963: ------------------------------------------------------------------------
5964:
5965: ******************************************************************/
5966: FUNCTION Get_Other_Info (
5967: p_data_rec IN OUT NOCOPY IGS_SV_OTH_INFO%ROWTYPE -- Data record
5968: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5969: IS
5970:
5971: l_api_name CONSTANT VARCHAR2(25) := 'Get_Other_Info';

Line 5978: FROM igs_sv_oth_info cr

5974: SELECT drivers_license ,
5975: drivers_license_state ,
5976: ssn ,
5977: tax_id
5978: FROM igs_sv_oth_info cr
5979: WHERE cr.person_id = p_data_rec.person_id
5980: AND cr.batch_id IN
5981: ( SELECT max(prs.batch_id)
5982: FROM igs_sv_oth_info prs,

Line 5982: FROM igs_sv_oth_info prs,

5978: FROM igs_sv_oth_info cr
5979: WHERE cr.person_id = p_data_rec.person_id
5980: AND cr.batch_id IN
5981: ( SELECT max(prs.batch_id)
5982: FROM igs_sv_oth_info prs,
5983: igs_sv_persons pr
5984: WHERE prs.person_id = pr.person_id
5985: AND prs.batch_id = pr.batch_id
5986: AND pr.record_status <> 'E'

Line 6954: (IGS_SV_OTH_INFO)

6950:
6951: Date Created By : Oct 14, 2002
6952:
6953: Purpose : Insert Other information block
6954: (IGS_SV_OTH_INFO)
6955:
6956: remarks :
6957:
6958: Change History

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

6960: ------------------------------------------------------------------------
6961:
6962: ******************************************************************/
6963: PROCEDURE Insert_Other_Info (
6964: p_data_rec IN IGS_SV_OTH_INFO%ROWTYPE -- Data record
6965: )
6966: IS
6967:
6968: l_api_name CONSTANT VARCHAR(30) := 'Insert_Other_Info';

Line 6982: 'IGS_SV_OTH_INFO',

6978: p_data_rec.person_id,
6979: g_person_status,
6980: 'SV_OTHER',
6981: 'SEND',
6982: 'IGS_SV_OTH_INFO',
6983: '');
6984:
6985: INSERT INTO IGS_SV_OTH_INFO (
6986: batch_id ,

Line 6985: INSERT INTO IGS_SV_OTH_INFO (

6981: 'SEND',
6982: 'IGS_SV_OTH_INFO',
6983: '');
6984:
6985: INSERT INTO IGS_SV_OTH_INFO (
6986: batch_id ,
6987: person_id ,
6988: print_form ,
6989: drivers_license ,

Line 9150: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

9146: IS
9147:
9148: l_api_name CONSTANT VARCHAR2(30) := 'Update_Personal_Info';
9149: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
9150: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
9151: l_f_addr_rec g_address_rec_type;
9152: l_us_addr_rec g_address_rec_type;
9153: l_count NUMBER(10);
9154: l_changes_found VARCHAR2(1) := 'N'; --No changes by default

Line 9158: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

9154: l_changes_found VARCHAR2(1) := 'N'; --No changes by default
9155: l_status VARCHAR2(1);
9156:
9157: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;
9158: l_prev_oth_rec IGS_SV_OTH_INFO%ROWTYPE;
9159: l_prev_f_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
9160: l_prev_us_addr_rec IGS_SV_ADDRESSES%ROWTYPE;
9161:
9162:

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

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

Line 11516: l_oth_rec IGS_SV_OTH_INFO%ROWTYPE;

11512: l_batch_id igs_sv_batches.batch_id%TYPE;
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;