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_FINANCE_INFO

Line 3232: (IGS_SV_FINANCE_INFO).

3228: Date Created By : Oct 14, 2002
3229:
3230: Purpose : Validate information pertaining to the Finance
3231: information of the student.
3232: (IGS_SV_FINANCE_INFO).
3233:
3234: Remarks : Return result:
3235: 'S' - record found and validated
3236: 'E' - validation error

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

3243:
3244: ******************************************************************/
3245: FUNCTION Validate_Finance_Info (
3246: p_person_rec IN t_student_rec,
3247: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record
3248: ) RETURN VARCHAR2
3249: IS
3250:
3251: l_api_name CONSTANT VARCHAR(30) := 'Validate_Finance_Info';

Line 5389: (IGS_SV_FINANCE_INFO)

5385:
5386: Date Created By : Oct 14, 2002
5387:
5388: Purpose : Get Finance information on the student
5389: (IGS_SV_FINANCE_INFO)
5390:
5391: Remarks :
5392:
5393: Change History

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

5395: ------------------------------------------------------------------------
5396:
5397: ******************************************************************/
5398: FUNCTION Get_Finance_Info (
5399: p_data_rec IN OUT NOCOPY IGS_SV_FINANCE_INFO%ROWTYPE -- Data record
5400: ) RETURN VARCHAR2 -- 'S' Record found, 'N' - not found. 'U' - Unexpected error
5401: IS
5402:
5403: l_api_name CONSTANT VARCHAR2(25) := 'Get_Finance_Info';

Line 5436: FROM igs_sv_finance_info cr

5432: intl_org1_othr_name ,
5433: intl_org2_othr_name ,
5434: other_govt_name ,
5435: empl_funds
5436: FROM igs_sv_finance_info cr
5437: WHERE cr.person_id = p_data_rec.person_id
5438: AND cr.batch_id IN
5439: ( SELECT max(prs.batch_id)
5440: FROM igs_sv_finance_info prs,

Line 5440: FROM igs_sv_finance_info prs,

5436: FROM igs_sv_finance_info cr
5437: WHERE cr.person_id = p_data_rec.person_id
5438: AND cr.batch_id IN
5439: ( SELECT max(prs.batch_id)
5440: FROM igs_sv_finance_info prs,
5441: igs_sv_persons pr
5442: WHERE prs.person_id = pr.person_id
5443: AND prs.batch_id = pr.batch_id
5444: AND pr.record_status <> 'E'

Line 6550: (IGS_SV_FINANCE_INFO)

6546:
6547: Date Created By : Oct 14, 2002
6548:
6549: Purpose : Insert Finance information on the student
6550: (IGS_SV_FINANCE_INFO)
6551:
6552: Remarks :
6553:
6554: Change History

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

6556: ------------------------------------------------------------------------
6557:
6558: ******************************************************************/
6559: PROCEDURE Insert_Finance_Info (
6560: p_data_rec IN IGS_SV_FINANCE_INFO %ROWTYPE -- Data record
6561: )
6562: IS
6563:
6564: l_api_name CONSTANT VARCHAR(30) := 'Insert_Finance_Info';

Line 6578: 'IGS_SV_FINANCE_INFO',

6574: p_data_rec.person_id,
6575: g_person_status,
6576: 'SV_FINANCIAL',
6577: 'SEND',
6578: 'IGS_SV_FINANCE_INFO',
6579: '');
6580: INSERT INTO igs_sv_finance_info (
6581: batch_id ,
6582: person_id ,

Line 6580: INSERT INTO igs_sv_finance_info (

6576: 'SV_FINANCIAL',
6577: 'SEND',
6578: 'IGS_SV_FINANCE_INFO',
6579: '');
6580: INSERT INTO igs_sv_finance_info (
6581: batch_id ,
6582: person_id ,
6583: print_form ,
6584: acad_term_length ,

Line 9231: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;

9227: ) RETURN VARCHAR2
9228: IS
9229:
9230: l_api_name CONSTANT VARCHAR2(30) := 'Update_Finance_Info';
9231: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;
9232: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;
9233: l_status VARCHAR2(1);
9234:
9235:

Line 9232: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;

9228: IS
9229:
9230: l_api_name CONSTANT VARCHAR2(30) := 'Update_Finance_Info';
9231: l_cur_rec IGS_SV_FINANCE_INFO%ROWTYPE;
9232: l_prev_rec IGS_SV_FINANCE_INFO%ROWTYPE;
9233: l_status VARCHAR2(1);
9234:
9235:
9236: BEGIN

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

10149: DELETE FROM igs_sv_empl_info WHERE batch_id = p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10150:
10151: DELETE FROM igs_sv_empl_info WHERE batch_id > p_batch_id AND ( person_id = p_person_id OR p_person_id IS NULL ) ;
10152:
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 ) ;

Line 10379: l_fin_rec IGS_SV_FINANCE_INFO %ROWTYPE;

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;
10382: l_us_addr_rec g_address_rec_type;
10383: l_site_addr_rec g_address_rec_type;