1 PACKAGE igs_ad_app_req_pkg AS
2 /* $Header: IGSAIA2S.pls 120.0 2005/06/01 21:01:20 appldev noship $ */
3
4 g_pkg_cst_completed_chk VARCHAR2(1); --added this variable that will be populated with a value of 'N' . This variable will be called from the procedure
5 -- igs_ad_gen_002.check_adm_appl_inst_stat -- rghosh (bug#2901627)
6
7 PROCEDURE insert_row (
8 X_ROWID in out NOCOPY VARCHAR2,
9 x_APP_REQ_ID IN OUT NOCOPY NUMBER,
10 x_PERSON_ID IN NUMBER,
11 x_ADMISSION_APPL_NUMBER IN NUMBER,
12 x_APPLICANT_FEE_TYPE IN NUMBER,
13 x_APPLICANT_FEE_STATUS IN NUMBER,
14 x_FEE_DATE IN DATE,
15 x_FEE_PAYMENT_METHOD IN NUMBER,
16 x_FEE_AMOUNT IN NUMBER,
17 x_REFERENCE_NUM IN VARCHAR2 DEFAULT NULL,
18 X_MODE IN VARCHAR2 DEFAULT 'R' ,
19 x_credit_card_code IN VARCHAR2 DEFAULT NULL,
20 x_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
21 x_credit_card_number IN VARCHAR2 DEFAULT NULL,
22 x_credit_card_expiration_date IN DATE DEFAULT NULL,
23 x_rev_gl_ccid IN NUMBER DEFAULT NULL,
24 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
25 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
26 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
27 x_gl_date IN DATE DEFAULT NULL,
28 x_gl_posted_date IN DATE DEFAULT NULL,
29 x_posting_control_id IN NUMBER DEFAULT NULL,
30 x_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
31 x_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
32 x_credit_card_status_code IN VARCHAR2 DEFAULT NULL
33 );
34
35 PROCEDURE lock_row (
36 X_ROWID in VARCHAR2,
37 x_APP_REQ_ID IN NUMBER,
38 x_PERSON_ID IN NUMBER,
39 x_ADMISSION_APPL_NUMBER IN NUMBER,
40 x_APPLICANT_FEE_TYPE IN NUMBER,
41 x_APPLICANT_FEE_STATUS IN NUMBER,
42 x_FEE_DATE IN DATE,
43 x_FEE_PAYMENT_METHOD IN NUMBER,
44 x_FEE_AMOUNT IN NUMBER,
45 x_REFERENCE_NUM IN VARCHAR2 DEFAULT NULL,
46 x_credit_card_code IN VARCHAR2 DEFAULT NULL,
47 x_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
48 x_credit_card_number IN VARCHAR2 DEFAULT NULL,
49 x_credit_card_expiration_date IN DATE DEFAULT NULL,
50 x_rev_gl_ccid IN NUMBER DEFAULT NULL,
51 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
52 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
53 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
54 x_gl_date IN DATE DEFAULT NULL,
55 x_gl_posted_date IN DATE DEFAULT NULL,
56 x_posting_control_id IN NUMBER DEFAULT NULL,
57 x_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
58 x_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
59 x_credit_card_status_code IN VARCHAR2 DEFAULT NULL
60 );
61
62
63
64 PROCEDURE update_row (
65 X_ROWID in VARCHAR2,
66 x_APP_REQ_ID IN NUMBER,
67 x_PERSON_ID IN NUMBER,
68 x_ADMISSION_APPL_NUMBER IN NUMBER,
69 x_APPLICANT_FEE_TYPE IN NUMBER,
70 x_APPLICANT_FEE_STATUS IN NUMBER,
71 x_FEE_DATE IN DATE,
72 x_FEE_PAYMENT_METHOD IN NUMBER,
73 x_FEE_AMOUNT IN NUMBER,
74 x_REFERENCE_NUM IN VARCHAR2 DEFAULT NULL,
75 X_MODE IN VARCHAR2 DEFAULT 'R' ,
76 x_credit_card_code IN VARCHAR2 DEFAULT NULL,
77 x_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
78 x_credit_card_number IN VARCHAR2 DEFAULT NULL,
79 x_credit_card_expiration_date IN DATE DEFAULT NULL,
80 x_rev_gl_ccid IN NUMBER DEFAULT NULL,
81 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
82 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
83 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
84 x_gl_date IN DATE DEFAULT NULL,
85 x_gl_posted_date IN DATE DEFAULT NULL,
86 x_posting_control_id IN NUMBER DEFAULT NULL,
87 x_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
88 x_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
89 x_credit_card_status_code IN VARCHAR2 DEFAULT NULL
90 );
91
92 PROCEDURE add_row (
93 X_ROWID in out NOCOPY VARCHAR2,
94 x_APP_REQ_ID IN OUT NOCOPY NUMBER,
95 x_PERSON_ID IN NUMBER,
96 x_ADMISSION_APPL_NUMBER IN NUMBER,
97 x_APPLICANT_FEE_TYPE IN NUMBER,
98 x_APPLICANT_FEE_STATUS IN NUMBER,
99 x_FEE_DATE IN DATE,
100 x_FEE_PAYMENT_METHOD IN NUMBER,
101 x_FEE_AMOUNT IN NUMBER,
102 x_REFERENCE_NUM IN VARCHAR2 DEFAULT NULL,
103 X_MODE IN VARCHAR2 DEFAULT 'R' ,
104 x_credit_card_code IN VARCHAR2 DEFAULT NULL,
105 x_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
106 x_credit_card_number IN VARCHAR2 DEFAULT NULL,
107 x_credit_card_expiration_date IN DATE DEFAULT NULL,
108 x_rev_gl_ccid IN NUMBER DEFAULT NULL,
109 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
110 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
111 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
112 x_gl_date IN DATE DEFAULT NULL,
113 x_gl_posted_date IN DATE DEFAULT NULL,
114 x_posting_control_id IN NUMBER DEFAULT NULL,
115 x_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
116 x_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
117 x_credit_card_status_code IN VARCHAR2 DEFAULT NULL
118 ) ;
119
120 PROCEDURE delete_row (
121 X_ROWID IN VARCHAR2,
122 x_mode IN VARCHAR2 DEFAULT 'R'
123 ) ;
124 FUNCTION get_pk_for_validation (
125 x_app_req_id IN NUMBER
126 ) RETURN BOOLEAN ;
127
128 PROCEDURE Get_FK_Igs_Ad_Code_Classes (
129 x_code_id IN NUMBER
130 );
131
132 PROCEDURE Get_FK_Igs_Ad_Appl (
133 x_person_id IN NUMBER,
134 x_admission_appl_number IN NUMBER
135 );
136
137
138 PROCEDURE Check_Constraints (
139 Column_Name IN VARCHAR2 DEFAULT NULL,
140 Column_Value IN VARCHAR2 DEFAULT NULL ) ;
141
142
143 PROCEDURE Before_DML (
144 p_action IN VARCHAR2,
145 x_rowid IN VARCHAR2 DEFAULT NULL,
146 x_app_req_id IN NUMBER DEFAULT NULL,
147 x_person_id IN NUMBER DEFAULT NULL,
148 x_admission_appl_number IN NUMBER DEFAULT NULL,
149 x_applicant_fee_type IN NUMBER DEFAULT NULL,
150 x_applicant_fee_status IN NUMBER DEFAULT NULL,
151 x_fee_date IN DATE DEFAULT NULL,
152 x_fee_payment_method IN NUMBER DEFAULT NULL,
153 x_fee_amount IN NUMBER DEFAULT NULL,
154 x_reference_num IN VARCHAR2 DEFAULT NULL,
155 x_creation_date IN DATE DEFAULT NULL,
156 x_created_by IN NUMBER DEFAULT NULL,
157 x_last_update_date IN DATE DEFAULT NULL,
158 x_last_updated_by IN NUMBER DEFAULT NULL,
159 x_last_update_login IN NUMBER DEFAULT NULL,
160 x_credit_card_code IN VARCHAR2 DEFAULT NULL,
161 x_credit_card_holder_name IN VARCHAR2 DEFAULT NULL,
162 x_credit_card_number IN VARCHAR2 DEFAULT NULL,
163 x_credit_card_expiration_date IN DATE DEFAULT NULL,
164 x_rev_gl_ccid IN NUMBER DEFAULT NULL,
165 x_cash_gl_ccid IN NUMBER DEFAULT NULL,
166 x_rev_account_cd IN VARCHAR2 DEFAULT NULL,
167 x_cash_account_cd IN VARCHAR2 DEFAULT NULL,
168 x_gl_date IN DATE DEFAULT NULL,
169 x_gl_posted_date IN DATE DEFAULT NULL,
170 x_posting_control_id IN NUMBER DEFAULT NULL,
171 x_credit_card_tangible_cd IN VARCHAR2 DEFAULT NULL,
172 x_credit_card_payee_cd IN VARCHAR2 DEFAULT NULL,
173 x_credit_card_status_code IN VARCHAR2 DEFAULT NULL
174 );
175
176 END igs_ad_app_req_pkg;