PACKAGE: APPS.IGS_AD_SS_APPL_FEE_PKG

Source

1 PACKAGE igs_ad_ss_appl_fee_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSADB7S.pls 115.8 2003/06/17 09:05:24 pathipat noship $ */
3 
4 PROCEDURE check_offer_update(
5          p_person_id IN NUMBER,
6 	 p_admission_application_number IN NUMBER,
7 	 p_nominated_course_cd IN VARCHAR2,
8 	 p_sequence_number IN NUMBER,
9 	 x_return_status OUT NOCOPY VARCHAR2,
10 	 x_msg_count OUT NOCOPY NUMBER,
11 	 x_msg_data OUT NOCOPY VARCHAR2);
12 
13 PROCEDURE check_offer_resp_update(
14          p_person_id IN NUMBER,
15 	 p_admission_application_number IN NUMBER,
16 	 p_nominated_course_cd IN VARCHAR2,
17 	 p_sequence_number IN NUMBER,
18 	 x_return_status OUT NOCOPY VARCHAR2,
19 	 x_msg_count OUT NOCOPY NUMBER,
20 	 x_msg_data OUT NOCOPY VARCHAR2);
21 
22 PROCEDURE check_update_aeps_acs(
23          p_person_id  IN NUMBER,
24          p_admission_application_number  IN NUMBER,
25          p_nominated_course_cd    IN VARCHAR2,
26          p_sequence_number        IN NUMBER,
27          x_return_status          OUT NOCOPY VARCHAR2,
28          x_msg_count              OUT NOCOPY NUMBER,
29          x_msg_data               OUT NOCOPY VARCHAR2);
30 
31 PROCEDURE get_appl_type_fee_details(
32          p_person_id             IN NUMBER,
33          p_admission_appl_number IN NUMBER,
34          appl_fee_amt            OUT NOCOPY NUMBER,
35          revenue_acct_code       OUT NOCOPY VARCHAR2,
36          cash_acct_code          OUT NOCOPY VARCHAR2,
37          revenue_acct_ccid       OUT NOCOPY NUMBER,
38          cash_acct_ccid          OUT NOCOPY NUMBER,
39          x_return_status         OUT NOCOPY VARCHAR2,
40          x_msg_count             OUT NOCOPY NUMBER,
41          x_msg_data              OUT NOCOPY VARCHAR2);
42 
43 PROCEDURE upd_fee_details(
44          p_person_id                        IN NUMBER,
45          p_admission_appl_number            IN NUMBER,
46          p_app_fee_amt                      IN NUMBER,
47          p_authorization_number             IN VARCHAR2,
48          p_sys_fee_status                   IN VARCHAR2,
49          p_sys_fee_type                     IN VARCHAR2,
50          p_sys_fee_method                   IN VARCHAR2,
51          x_return_status                    OUT NOCOPY VARCHAR2,
52          x_msg_count                        OUT NOCOPY NUMBER,
53          x_msg_data                         OUT NOCOPY VARCHAR2,
54          p_credit_card_code                 IN VARCHAR2,
55          p_credit_card_holder_name          IN VARCHAR2,
56          p_credit_card_number               IN VARCHAR2,
57          p_credit_card_expiration_date      IN DATE,
58          p_gl_date                          IN DATE,
59          p_rev_gl_ccid                      IN NUMBER,
60          p_cash_gl_ccid                     IN NUMBER,
61          p_rev_account_cd                   IN VARCHAR2,
62          p_cash_account_cd                  IN VARCHAR2,
63          p_credit_card_tangible_cd          IN VARCHAR2
64          );
65 
66 END igs_ad_ss_appl_fee_pkg;