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_BIO_INFO

Line 1219: (IGS_SV_BIO_INFO)

1215: Date Created By : Oct 14, 2002
1216:
1217: Purpose : Validation procedure on data that is to be
1218: resident in the BIO Info block.
1219: (IGS_SV_BIO_INFO)
1220:
1221: Remarks : Return result:
1222: 'S' - record found and validated
1223: 'E' - validation error

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

1261: END Validate_Name;
1262:
1263: Function Validate_Bio_Info(
1264: p_person_rec IN t_student_rec,
1265: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record
1266: ) RETURN VARCHAR2
1267: IS
1268:
1269: l_api_name CONSTANT VARCHAR(30) := 'Validate_Bio_Info';

Line 3630: l_dep_data_rec IGS_SV_BIO_INFO%ROWTYPE ;

3626:
3627: l_api_name CONSTANT VARCHAR(30) := 'Validate_Dependent_Info';
3628:
3629: l_dep_person_rec t_student_rec;
3630: l_dep_data_rec IGS_SV_BIO_INFO%ROWTYPE ;
3631: l_counter NUMBER(10) := 0;
3632: l_rel_count NUMBER(10) := 0;
3633: l_dep_sevis_id VARCHAR2(30); --PRBHARDW
3634: -- Dependent codes

Line 4867: (IGS_SV_BIO_INFO).

4863:
4864: Date Created By : Oct 14, 2002
4865:
4866: Purpose : Get BIO Information for the student.
4867: (IGS_SV_BIO_INFO).
4868:
4869: Remarks :
4870:
4871: Change History

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

4873: ------------------------------------------------------------------------
4874:
4875: ******************************************************************/
4876: FUNCTION Get_Bio_Info (
4877: p_data_rec IN OUT NOCOPY IGS_SV_BIO_INFO%ROWTYPE -- Data record
4878: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
4879: IS
4880:
4881: l_api_name CONSTANT VARCHAR2(25) := 'Get_Bio_Info';

Line 4898: FROM igs_sv_bio_info cr

4894: commuter ,
4895: remarks ,
4896: birth_cntry_resn_code ,
4897: birth_city
4898: FROM igs_sv_bio_info cr
4899: WHERE cr.person_id = p_data_rec.person_id
4900: AND cr.batch_id IN
4901: ( SELECT max(prs.batch_id)
4902: FROM igs_sv_bio_info prs,

Line 4902: FROM igs_sv_bio_info prs,

4898: FROM igs_sv_bio_info cr
4899: WHERE cr.person_id = p_data_rec.person_id
4900: AND cr.batch_id IN
4901: ( SELECT max(prs.batch_id)
4902: FROM igs_sv_bio_info prs,
4903: igs_sv_persons pr
4904: WHERE prs.person_id = pr.person_id
4905: AND prs.batch_id = pr.batch_id
4906: AND pr.record_status <> 'E'

Line 5888: (IGS_SV_BIO_INFO).

5884:
5885: Date Created By : Oct 14, 2002
5886:
5887: Purpose : Insert Bio information block.
5888: (IGS_SV_BIO_INFO).
5889:
5890: Remarks :
5891:
5892: Change History

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

5894: ------------------------------------------------------------------------
5895:
5896: ******************************************************************/
5897: PROCEDURE Insert_Bio_Info(
5898: p_data_rec IN IGS_SV_BIO_INFO%ROWTYPE -- Data record
5899: )
5900: IS
5901: l_api_name CONSTANT VARCHAR(30) := 'Insert_Bio_Info';
5902:

Line 5915: 'IGS_SV_BIO_INFO',

5911: p_data_rec.person_id,
5912: g_person_status,
5913: 'SV_BIO',
5914: 'SEND',
5915: 'IGS_SV_BIO_INFO',
5916: '');
5917: INSERT INTO IGS_SV_BIO_INFO (
5918: batch_id ,
5919: person_id ,

Line 5917: INSERT INTO IGS_SV_BIO_INFO (

5913: 'SV_BIO',
5914: 'SEND',
5915: 'IGS_SV_BIO_INFO',
5916: '');
5917: INSERT INTO IGS_SV_BIO_INFO (
5918: batch_id ,
5919: person_id ,
5920: print_form ,
5921: birth_date ,

Line 8037: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

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

Line 8045: l_prev_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

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

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

10137: DELETE FROM igs_sv_addresses WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10138:
10139: DELETE FROM igs_sv_addresses WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL );
10140:
10141: DELETE FROM igs_sv_bio_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10142:
10143: DELETE FROM igs_sv_convictions WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10144:
10145: 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 10376: l_bio_rec IGS_SV_BIO_INFO%ROWTYPE;

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