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_BIO_INFO

Line 1441: (IGS_SV_BIO_INFO)

1437: Date Created By : Oct 14, 2002
1438:
1439: Purpose : Validation procedure on data that is to be
1440: resident in the BIO Info block.
1441: (IGS_SV_BIO_INFO)
1442:
1443: Remarks : Return result:
1444: 'S' - record found and validated
1445: 'E' - validation error

Line 1487: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record

1483: END Validate_Name;
1484:
1485: Function Validate_Bio_Info(
1486: p_person_rec IN t_student_rec,
1487: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record
1488: ) RETURN VARCHAR2
1489: IS
1490:
1491: l_api_name CONSTANT VARCHAR(30) := 'Validate_Bio_Info';

Line 4553: l_dep_data_rec IGS_SV_BIO_INFO%ROWTYPE ;

4549:
4550: l_api_name CONSTANT VARCHAR(30) := 'Validate_Dependent_Info';
4551:
4552: l_dep_person_rec t_student_rec;
4553: l_dep_data_rec IGS_SV_BIO_INFO%ROWTYPE ;
4554: l_counter NUMBER(10) := 0;
4555: l_rel_count NUMBER(10) := 0;
4556: l_dep_sevis_id VARCHAR2(30); --PRBHARDW
4557: -- Dependent codes

Line 5823: (IGS_SV_BIO_INFO).

5819:
5820: Date Created By : Oct 14, 2002
5821:
5822: Purpose : Get BIO Information for the student.
5823: (IGS_SV_BIO_INFO).
5824:
5825: Remarks :
5826:
5827: Change History

Line 5833: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record

5829: ------------------------------------------------------------------------
5830:
5831: ******************************************************************/
5832: FUNCTION Get_Bio_Info (
5833: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record
5834: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5835: IS
5836:
5837: l_api_name CONSTANT VARCHAR2(25) := 'Get_Bio_Info';

Line 5854: FROM igs_sv_bio_info cr

5850: commuter ,
5851: remarks ,
5852: birth_cntry_resn_code ,
5853: birth_city
5854: FROM igs_sv_bio_info cr
5855: WHERE cr.person_id = p_data_rec.person_id
5856: AND cr.batch_id IN
5857: ( SELECT max(prs.batch_id)
5858: FROM igs_sv_bio_info prs,

Line 5858: FROM igs_sv_bio_info prs,

5854: FROM igs_sv_bio_info cr
5855: WHERE cr.person_id = p_data_rec.person_id
5856: AND cr.batch_id IN
5857: ( SELECT max(prs.batch_id)
5858: FROM igs_sv_bio_info prs,
5859: igs_sv_persons pr
5860: WHERE prs.person_id = pr.person_id
5861: AND prs.batch_id = pr.batch_id
5862: AND pr.record_status <> 'E'

Line 6847: (IGS_SV_BIO_INFO).

6843:
6844: Date Created By : Oct 14, 2002
6845:
6846: Purpose : Insert Bio information block.
6847: (IGS_SV_BIO_INFO).
6848:
6849: Remarks :
6850:
6851: Change History

Line 6857: p_data_rec IN IGS_SV_BIO_INFO%ROWTYPE -- Data record

6853: ------------------------------------------------------------------------
6854:
6855: ******************************************************************/
6856: PROCEDURE Insert_Bio_Info(
6857: p_data_rec IN IGS_SV_BIO_INFO%ROWTYPE -- Data record
6858: )
6859: IS
6860: l_api_name CONSTANT VARCHAR(30) := 'Insert_Bio_Info';
6861:

Line 6874: 'IGS_SV_BIO_INFO',

6870: p_data_rec.person_id,
6871: g_person_status,
6872: 'SV_BIO',
6873: 'SEND',
6874: 'IGS_SV_BIO_INFO',
6875: '');
6876: INSERT INTO IGS_SV_BIO_INFO (
6877: batch_id ,
6878: person_id ,

Line 6876: INSERT INTO IGS_SV_BIO_INFO (

6872: 'SV_BIO',
6873: 'SEND',
6874: 'IGS_SV_BIO_INFO',
6875: '');
6876: INSERT INTO IGS_SV_BIO_INFO (
6877: batch_id ,
6878: person_id ,
6879: print_form ,
6880: birth_date ,

Line 9149: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

9145: ) RETURN VARCHAR2
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);

Line 9157: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

9153: l_count NUMBER(10);
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:

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

11284: -- Delete from all related tables
11285:
11286: DELETE FROM igs_sv_addresses WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
11287:
11288: DELETE FROM igs_sv_bio_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11289:
11290: DELETE FROM igs_sv_convictions WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
11291:
11292: DELETE FROM igs_sv_depdnt_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;

Line 11515: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

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