1 PACKAGE IGS_AD_GEN_015 AUTHID CURRENT_USER AS
2 /* $Header: IGSADC4S.pls 115.2 2003/10/01 08:18:17 nsinha noship $ */
3 /******************************************************************
4 Created By: Navin Sinha
5 Date Created By: 07-Oct-2002
6 Purpose: New Package to Insert record in the table IGS_AD_APP_REQ
7 (Application Fee ) whenever an Enrollment Deposit is
8 Recorded in the Student Finance .
9 Known limitations,enhancements,remarks:
10 Change History
11 Who When What
12 Navin Sinha 10/1/2003 BUG NO : 3160036 : OSSTST15: enrollment deposit fee error in sf gl interface process
13 Added New procedure to updare record in the table IGS_AD_APP_REQ.
14 ******************************************************************/
15 g_chk_ad_app_req VARCHAR2(1); -- This variable is called from the igs_ad_app_req_pkg (bug#2901627 -- rghosh)
16
17 PROCEDURE Create_Enrollment_Deposit(
18 p_person_id IN NUMBER,
19 p_admission_appl_number IN NUMBER,
20 p_enrollment_deposit_amount IN NUMBER,
21 p_payment_date IN DATE,
22 p_fee_payment_method IN VARCHAR2,
23 p_reference_number IN VARCHAR2 );
24
25 PROCEDURE update_igs_ad_app_req (
26 p_rowid IN VARCHAR2,
27 p_app_req_id IN NUMBER,
28 p_person_id IN NUMBER,
29 p_admission_appl_number IN NUMBER,
30 p_applicant_fee_type IN NUMBER,
31 p_applicant_fee_status IN NUMBER,
32 p_fee_date IN DATE,
33 p_fee_payment_method IN NUMBER,
34 p_fee_amount IN NUMBER,
35 p_reference_num IN VARCHAR2 DEFAULT NULL,
36 p_credit_card_code IN VARCHAR2 DEFAULT NULL,
37 p_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
38 p_credit_card_number IN VARCHAR2 DEFAULT NULL,
39 p_credit_card_expiration_date IN DATE DEFAULT NULL,
40 p_rev_gl_ccid IN NUMBER DEFAULT NULL,
41 p_cash_gl_ccid IN NUMBER DEFAULT NULL,
42 p_rev_account_cd IN VARCHAR2 DEFAULT NULL,
43 p_cash_account_cd IN VARCHAR2 DEFAULT NULL,
44 p_posting_control_id IN NUMBER DEFAULT NULL,
45 p_gl_date IN DATE DEFAULT NULL,
46 p_gl_posted_date IN DATE DEFAULT NULL,
47 p_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
48 p_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
49 p_credit_card_status_code IN VARCHAR2 DEFAULT NULL,
50 p_mode IN VARCHAR2
51 );
52
53
54 END IGS_AD_GEN_015;