[Home] [Help]
PACKAGE: APPS.IGS_AS_SS_DOC_REQUEST
Source
1 PACKAGE Igs_As_Ss_Doc_Request AS
2 /* $Header: IGSAS45S.pls 120.2 2005/10/19 23:56:43 appldev ship $ */
3
4 FUNCTION check_waivers
5 (p_person_id NUMBER) RETURN VARCHAR2;
6
7 PROCEDURE Get_Summary_Display_Message
8 (P_Person_Id NUMBER,
9 P_Hold_Message OUT NOCOPY VARCHAR2,
10 P_Hint_Message OUT NOCOPY VARCHAR2,
11 P_Request_allowed OUT NOCOPY VARCHAR2,
12 P_Transcript_allowed OUT NOCOPY VARCHAR2,
13 P_Encert_Allowed OUT NOCOPY VARCHAR2,
14 p_LifetimeFee_allowed OUT NOCOPY VARCHAR2);
15
16 FUNCTION Get_Item_Details_For_Order
17 (P_ORDER_NUMBER NUMBER) RETURN VARCHAR2 ;
18
19 FUNCTION Get_Order_Details_Include_Addr
20 (P_ITEM_NUMBER NUMBER) RETURN VARCHAR2 ;
21
22 --PRAGMA RESTRICT_REFERENCES(Get_Item_Details_For_Order, WNDS, WNPS); msrinivi
23
24 FUNCTION Get_Transcript_Fee (
25 p_person_id IN NUMBER,
26 p_document_type IN VARCHAR2,
27 p_number_of_copies IN NUMBER,
28 p_include_delivery_fee IN VARCHAR2 DEFAULT 'Y',
29 p_delivery_method_type IN VARCHAR2 DEFAULT NULL,
30 p_item_number IN NUMBER DEFAULT NULL
31 )
32 RETURN NUMBER ;
33 PRAGMA RESTRICT_REFERENCES(Get_Transcript_Fee, WNDS, WNPS);
34
35
36
37 FUNCTION enrp_get_career_dates(p_person_id IN NUMBER,
38 p_course_type IN VARCHAR2)
39 RETURN VARCHAR2;
40 --PRAGMA RESTRICT_REFERENCES( enrp_get_career_dates, WNDS, WNPS);
41
42 PROCEDURE CREATE_INVOICE (p_order_number IN NUMBER,
43 p_payment_type IN VARCHAR2 DEFAULT 'MAKE_PAYMENT',
44 p_invoice_id OUT NOCOPY NUMBER,
45 p_return_status OUT NOCOPY VARCHAR2,
46 p_msg_count OUT NOCOPY NUMBER,
47 p_msg_data OUT NOCOPY VARCHAR2,
48 p_waiver_amount OUT NOCOPY NUMBER);
49
50 FUNCTION show_bill_me_later (
51 p_person_id IN NUMBER
52 ) RETURN VARCHAR2;
53
54
55
56 PROCEDURE UPDATE_ORDER_FEE
57 (P_ORDER_NUMBER NUMBER,
58 P_ITEM_NUMBER NUMBER,
59 P_OLD_SUB_DOC_TYPE VARCHAR2,
60 P_OLD_DELIV_TYPE VARCHAR2,
61 P_OLD_NUM_COPIES VARCHAR2,
62 P_NEW_SUB_DOC_TYPE VARCHAR2,
63 P_NEW_DELIV_TYPE VARCHAR2,
64 P_NEW_NUM_COPIES VARCHAR2,
65 P_RETURN_STATUS OUT NOCOPY VARCHAR2,
66 P_MSG_DATA OUT NOCOPY VARCHAR2,
67 P_MSG_COUNT OUT NOCOPY NUMBER
68 );
69
70
71 FUNCTION Inst_Is_EDI_Partner(p_Inst_Code VARCHAR2) RETURN VARCHAR2;
72
73
74 FUNCTION Is_All_Progs_allowed RETURN VARCHAR2;
75
76
77 PROCEDURE create_as_application (
78 p_credit_id IN igs_fi_applications.credit_id%TYPE,
79 p_invoice_id IN igs_fi_applications.invoice_id%TYPE,
80 p_amount_apply IN igs_fi_applications.amount_applied%TYPE,
81 p_appl_type IN igs_fi_applications.application_type%TYPE,
82 p_appl_hierarchy_id IN igs_fi_applications.appl_hierarchy_Id%TYPE,
83 p_validation IN VARCHAR2,
84 p_application_id OUT NOCOPY igs_fi_applications.application_id%TYPE,
85 p_err_msg OUT NOCOPY fnd_new_messages.message_name%TYPE,
86 p_status OUT NOCOPY VARCHAR2
87 );
88
89
90 FUNCTION get_prg_st_end_dts(p_person_id NUMBER, p_course_cd VARCHAR2) RETURN VARCHAR2;
91
92 PROCEDURE delete_order_and_items(
93 p_order_number IN igs_as_order_hdr.order_number%TYPE,
94 p_msg_count OUT NOCOPY NUMBER,
95 p_msg_data OUT NOCOPY VARCHAR2,
96 p_return_status OUT NOCOPY VARCHAR2
97 );
98
99
100 PROCEDURE Get_Doc_And_Delivery_Fee ( p_person_id IN NUMBER,
101 p_document_type IN VARCHAR2,
102 p_document_sub_type IN VARCHAR2,
103 p_number_of_copies IN NUMBER,
104 p_delivery_method_type IN VARCHAR2 DEFAULT NULL,
105 p_document_fee OUT NOCOPY NUMBER,
106 p_delivery_fee OUT NOCOPY NUMBER,
107 p_program_on_file IN Varchar2 DEFAULT NULL,
108 p_plan_id IN OUT NOCOPY Number ,
109 p_item_number IN NUMBER DEFAULT NULL
110 );
111
112
113 PROCEDURE Pay_Lifetime_Fees (p_person_id IN NUMBER,
114 p_order_number IN NUMBER,
115 p_return_status OUT NOCOPY VARCHAR2,
116 p_msg_data OUT NOCOPY VARCHAR2,
117 p_msg_count OUT NOCOPY NUMBER
118 );
119
120 PROCEDURE recalc_after_lft_paid (p_person_id IN NUMBER,
121 p_order_number IN NUMBER,
122 p_return_status OUT NOCOPY VARCHAR2,
123 p_msg_data OUT NOCOPY VARCHAR2,
124 p_msg_count OUT NOCOPY NUMBER
125 );
126
127 PROCEDURE get_as_current_term (
128 p_cal_type OUT NOCOPY VARCHAR2,
129 p_sequence_number OUT NOCOPY NUMBER,
130 p_description OUT NOCOPY VARCHAR2
131 );
132
133 PROCEDURE get_as_next_term ( p_cal_type OUT NOCOPY VARCHAR2,
134 p_sequence_number OUT NOCOPY NUMBER,
135 p_description OUT NOCOPY VARCHAR2
136 );
137 PROCEDURE get_as_previous_term ( p_cal_type OUT NOCOPY VARCHAR2,
138 p_sequence_number OUT NOCOPY NUMBER,
139 p_description OUT NOCOPY VARCHAR2
140 );
141 /*
142 PROCEDURE CALC_DOC_FEE (
143 p_person_id IN NUMBER DEFAULT NULL,
144 p_document_type IN VARCHAR2 DEFAULT NULL,
145 p_number_of_copies IN NUMBER DEFAULT NULL,
146 p_include_delivery_fee IN VARCHAR2 DEFAULT NULL,
147 p_delivery_method_type IN VARCHAR2 DEFAULT NULL,
148 p_program_on_file IN Varchar2 DEFAULT NULL,
149 p_plan_id IN OUT NOCOPY Number ,
150 p_doc_fee OUT NOCOPY Varchar2
151 );
152 */
153
154 PROCEDURE Re_calc_doc_fees(
155 p_person_Id IN Number DEFAULT NULL,
156 p_Plan_id IN Number DEFAULT NULL,
157 p_subs_unsubs IN Varchar2 Default 'U' ,-- Possible values 'U' and 'S'
158 p_admin_person_id IN Number DEFAULT NULL, -- The person Id of the admin
159 p_orders_recalc OUT NOCOPY Varchar2 -- To return comma seperated List of Order numbers that got recalculated.
160 );
161
162 PROCEDURE create_trns_plan_invoice_id (
163 p_person_id IN NUMBER,
164 p_fee_amount IN NUMBER,
165 p_invoice_id OUT NOCOPY NUMBER,
166 p_return_status OUT NOCOPY VARCHAR2,
167 p_msg_count OUT NOCOPY NUMBER,
168 p_msg_data OUT NOCOPY VARCHAR2,
169 p_waiver_amount OUT NOCOPY NUMBER
170 );
171 PROCEDURE delete_bulk_item
172 (
173 p_item_number IN NUMBER,
174 p_msg_count OUT NOCOPY NUMBER,
175 p_msg_data OUT NOCOPY VARCHAR2,
176 p_return_status OUT NOCOPY VARCHAR2
177 );
178
179 PROCEDURE place_bulk_order
180 (
181 p_person_ids IN VARCHAR2,
182 p_program_cds IN VARCHAR2,
183 p_prog_vers IN VARCHAR2,
184 p_printer_name IN VARCHAR2,
185 p_schedule_date IN DATE,
186 p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
187 p_trans_type IN igs_as_doc_details.document_type%TYPE,
188 p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
189 p_incl_ind IN VARCHAR2,
190 p_num_copies IN NUMBER,
191 p_admin_person_id IN hz_parties.party_id%TYPE,
192 p_order_desc IN igs_as_order_hdr.order_description%TYPE,
193 p_purpose IN igs_as_doc_details.DOC_PURPOSE_CODE%TYPE,
194 p_effbuff OUT NOCOPY VARCHAR2,
195 p_Status OUT NOCOPY VARCHAR2
196 );
197
198 PROCEDURE submit_print_request
199 (
200 p_errbuf OUT NOCOPY VARCHAR2,
201 p_retcode OUT NOCOPY VARCHAR2,
202 p_order_number IN igs_as_order_hdr.order_number%TYPE,
203 p_item_numbers IN igs_as_doc_details.item_number%TYPE,
204 p_printer_name IN VARCHAR2,
205 p_schedule_date IN DATE
206 );
207
208 PROCEDURE produce_docs_ss
209 (
210 p_item_numbers IN VARCHAR2,
211 p_printer_name IN VARCHAR2,
212 p_schedule_date IN DATE,
213 p_ret_status OUT NOCOPY VARCHAR2,
214 p_effbuff OUT NOCOPY VARCHAR2,
215 p_req_ids OUT NOCOPY VARCHAR2
216 );
217
218 PROCEDURE bulk_order_job
219 (
220 errbuf OUT NOCOPY VARCHAR2,
221 retcode OUT NOCOPY NUMBER,
222 p_person_ids IN VARCHAR2,
223 p_program_cds IN VARCHAR2,
224 p_prog_vers IN VARCHAR2,
225 p_printer_name IN VARCHAR2,
226 p_schedule_date IN DATE,
227 p_action_type IN VARCHAR2, -- Whether create doc only or create doc and produce docs also
228 p_trans_type IN igs_as_doc_details.document_type%TYPE,
229 p_deliv_meth IN igs_as_doc_details.delivery_method_type%TYPE,
230 p_incl_ind IN VARCHAR2,
231 p_num_copies IN NUMBER,
232 p_admin_person_id IN hz_parties.party_id%TYPE,
233 p_order_desc IN igs_as_order_hdr.order_description%TYPE,
234 p_purpose IN igs_as_doc_details.DOC_PURPOSE_CODE%TYPE
235 );
236
237 FUNCTION get_latest_yop
238 (
239 p_person_id hz_parties.party_id%TYPE,
240 p_course_cd igs_ps_ver.course_cd%TYPE
241 ) RETURN VARCHAR2;
242
243
244 FUNCTION is_order_del_alwd( P_ORDER_NUMBER NUMBER)
245 RETURN VARCHAR2;
246
247
248 END Igs_As_Ss_Doc_Request;