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_FINANCE_INFO

Line 4156: (IGS_SV_FINANCE_INFO).

4152: Date Created By : Oct 14, 2002
4153:
4154: Purpose : Validate information pertaining to the Finance
4155: information of the student.
4156: (IGS_SV_FINANCE_INFO).
4157:
4158: Remarks : Return result:
4159: 'S' - record found and validated
4160: 'E' - validation error

Line 4171: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record

4167:
4168: ******************************************************************/
4169: FUNCTION Validate_Finance_Info (
4170: p_person_rec IN t_student_rec,
4171: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record
4172: ) RETURN VARCHAR2
4173: IS
4174:
4175: l_api_name CONSTANT VARCHAR(30) := 'Validate_Finance_Info';

Line 6347: (IGS_SV_FINANCE_INFO)

6343:
6344: Date Created By : Oct 14, 2002
6345:
6346: Purpose : Get Finance information on the student
6347: (IGS_SV_FINANCE_INFO)
6348:
6349: Remarks :
6350:
6351: Change History

Line 6357: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record

6353: ------------------------------------------------------------------------
6354:
6355: ******************************************************************/
6356: FUNCTION Get_Finance_Info (
6357: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record
6358: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
6359: IS
6360:
6361: l_api_name CONSTANT VARCHAR2(25) := 'Get_Finance_Info';

Line 6394: FROM igs_sv_finance_info cr

6390: intl_org1_othr_name ,
6391: intl_org2_othr_name ,
6392: other_govt_name ,
6393: empl_funds
6394: FROM igs_sv_finance_info cr
6395: WHERE cr.person_id = p_data_rec.person_id
6396: AND cr.batch_id IN
6397: ( SELECT max(prs.batch_id)
6398: FROM igs_sv_finance_info prs,

Line 6398: FROM igs_sv_finance_info prs,

6394: FROM igs_sv_finance_info cr
6395: WHERE cr.person_id = p_data_rec.person_id
6396: AND cr.batch_id IN
6397: ( SELECT max(prs.batch_id)
6398: FROM igs_sv_finance_info prs,
6399: igs_sv_persons pr
6400: WHERE prs.person_id = pr.person_id
6401: AND prs.batch_id = pr.batch_id
6402: AND pr.record_status <> 'E'

Line 7492: (IGS_SV_FINANCE_INFO)

7488:
7489: Date Created By : Oct 14, 2002
7490:
7491: Purpose : Insert Finance information on the student
7492: (IGS_SV_FINANCE_INFO)
7493:
7494: Remarks :
7495:
7496: Change History

Line 7502: p_data_rec IN IGS_SV_FINANCE_INFO %ROWTYPE -- Data record

7498: ------------------------------------------------------------------------
7499:
7500: ******************************************************************/
7501: PROCEDURE Insert_Finance_Info (
7502: p_data_rec IN IGS_SV_FINANCE_INFO %ROWTYPE -- Data record
7503: )
7504: IS
7505:
7506: l_api_name CONSTANT VARCHAR(30) := 'Insert_Finance_Info';

Line 7520: 'IGS_SV_FINANCE_INFO',

7516: p_data_rec.person_id,
7517: g_person_status,
7518: 'SV_FINANCIAL',
7519: 'SEND',
7520: 'IGS_SV_FINANCE_INFO',
7521: '');
7522: INSERT INTO igs_sv_finance_info (
7523: batch_id ,
7524: person_id ,

Line 7522: INSERT INTO igs_sv_finance_info (

7518: 'SV_FINANCIAL',
7519: 'SEND',
7520: 'IGS_SV_FINANCE_INFO',
7521: '');
7522: INSERT INTO igs_sv_finance_info (
7523: batch_id ,
7524: person_id ,
7525: print_form ,
7526: acad_term_length ,

Line 10356: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;

10352: ) RETURN VARCHAR2
10353: IS
10354:
10355: l_api_name CONSTANT VARCHAR2(30) := 'Update_Finance_Info';
10356: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;
10357: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;
10358: l_status VARCHAR2(1);
10359:
10360:

Line 10357: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;

10353: IS
10354:
10355: l_api_name CONSTANT VARCHAR2(30) := 'Update_Finance_Info';
10356: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;
10357: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;
10358: l_status VARCHAR2(1);
10359:
10360:
10361: BEGIN

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

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

Line 11518: l_fin_rec IGS_SV_FINANCE_INFO %ROWTYPE;

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;
11521: l_us_addr_rec g_address_rec_type;
11522: l_site_addr_rec g_address_rec_type;