1 PACKAGE POR_UTIL_PKG AUTHID CURRENT_USER as
2 /* $Header: PORUTILS.pls 120.28.12020000.7 2013/05/16 07:10:10 aacai ship $ */
3
4 FUNCTION bool_to_varchar(b IN BOOLEAN) RETURN VARCHAR2;
5
6 PROCEDURE delete_requisition(p_header_id IN NUMBER);
7
8 PROCEDURE purge_requisition(p_header_id IN NUMBER);
9
10 PROCEDURE delete_working_copy_req(p_req_number IN VARCHAR2);
11
12 FUNCTION get_current_approver(p_req_header_id in number) RETURN NUMBER;
13
14 FUNCTION getSitesEnabledFlagForContract(p_header_id in number) RETURN varchar2;
15
16 FUNCTION get_cost_center(p_code_combination_id in number) RETURN VARCHAR2;
17
18 FUNCTION get_document_number(table_name_p IN VARCHAR2) RETURN NUMBER;
19
20 FUNCTION get_global_document_number(table_name_p IN VARCHAR2, org_id_p IN NUMBER)
21 RETURN NUMBER;
22
23 --Bug 12914933 Added date parameter for get_item_cost
24 FUNCTION get_item_cost(
25 x_item_id IN NUMBER,
26 x_source_organization_id IN NUMBER,
27 x_unit_of_measure IN VARCHAR2,
28 x_dest_organization_id IN NUMBER DEFAULT null,
29 x_date IN DATE DEFAULT NULL)
30 RETURN NUMBER;
31
32 FUNCTION interface_start_workflow(
33 V_charge_success IN OUT NOCOPY VARCHAR2,
34 V_budget_success IN OUT NOCOPY VARCHAR2,
35 V_accrual_success IN OUT NOCOPY VARCHAR2,
36 V_variance_success IN OUT NOCOPY VARCHAR2,
37 x_code_combination_id IN OUT NOCOPY NUMBER,
38 x_budget_account_id IN OUT NOCOPY NUMBER,
39 x_accrual_account_id IN OUT NOCOPY NUMBER,
40 x_variance_account_id IN OUT NOCOPY NUMBER,
41 x_charge_account_flex IN OUT NOCOPY VARCHAR2,
42 x_budget_account_flex IN OUT NOCOPY VARCHAR2,
43 x_accrual_account_flex IN OUT NOCOPY VARCHAR2,
44 x_variance_account_flex IN OUT NOCOPY VARCHAR2,
45 x_charge_account_desc IN OUT NOCOPY VARCHAR2,
46 x_budget_account_desc IN OUT NOCOPY VARCHAR2,
47 x_accrual_account_desc IN OUT NOCOPY VARCHAR2,
48 x_variance_account_desc IN OUT NOCOPY VARCHAR2,
49 x_coa_id NUMBER,
50 x_bom_resource_id NUMBER,
51 x_bom_cost_element_id NUMBER,
52 x_category_id NUMBER,
53 x_destination_type_code VARCHAR2,
54 x_deliver_to_location_id NUMBER,
55 x_destination_organization_id NUMBER,
56 x_destination_subinventory VARCHAR2,
57 x_expenditure_type VARCHAR2,
58 x_expenditure_organization_id NUMBER,
59 x_expenditure_item_date DATE,
60 x_item_id NUMBER,
61 x_line_type_id NUMBER,
62 x_result_billable_flag VARCHAR2,
63 x_preparer_id NUMBER,
64 x_project_id NUMBER,
65 x_document_type_code VARCHAR2,
66 x_blanket_po_header_id NUMBER,
67 x_source_type_code VARCHAR2,
68 x_source_organization_id NUMBER,
69 x_source_subinventory VARCHAR2,
70 x_task_id NUMBER,
71 x_award_set_id NUMBER,
72 x_deliver_to_person_id NUMBER,
73 x_type_lookup_code VARCHAR2,
74 x_suggested_vendor_id NUMBER,
75 x_suggested_vendor_site_id NUMBER,
76 x_wip_entity_id NUMBER,
77 x_wip_entity_type VARCHAR2,
78 x_wip_line_id NUMBER,
79 x_wip_repetitive_schedule_id NUMBER,
80 x_wip_operation_seq_num NUMBER,
81 x_wip_resource_seq_num NUMBER,
82 x_po_encumberance_flag VARCHAR2,
83 x_gl_encumbered_date DATE,
84 wf_itemkey IN OUT NOCOPY VARCHAR2,
85 V_new_combination IN OUT NOCOPY VARCHAR2,
86 header_att1 VARCHAR2,
87 header_att2 VARCHAR2,
88 header_att3 VARCHAR2,
89 header_att4 VARCHAR2,
90 header_att5 VARCHAR2,
91 header_att6 VARCHAR2,
92 header_att7 VARCHAR2,
93 header_att8 VARCHAR2,
94 header_att9 VARCHAR2,
95 header_att10 VARCHAR2,
96 header_att11 VARCHAR2,
97 header_att12 VARCHAR2,
98 header_att13 VARCHAR2,
99 header_att14 VARCHAR2,
100 header_att15 VARCHAR2,
101 line_att1 VARCHAR2,
102 line_att2 VARCHAR2,
103 line_att3 VARCHAR2,
104 line_att4 VARCHAR2,
105 line_att5 VARCHAR2,
106 line_att6 VARCHAR2,
107 line_att7 VARCHAR2,
108 line_att8 VARCHAR2,
109 line_att9 VARCHAR2,
110 line_att10 VARCHAR2,
111 line_att11 VARCHAR2,
112 line_att12 VARCHAR2,
113 line_att13 VARCHAR2,
114 line_att14 VARCHAR2,
115 line_att15 VARCHAR2,
116 distribution_att1 VARCHAR2,
117 distribution_att2 VARCHAR2,
118 distribution_att3 VARCHAR2,
119 distribution_att4 VARCHAR2,
120 distribution_att5 VARCHAR2,
121 distribution_att6 VARCHAR2,
122 distribution_att7 VARCHAR2,
123 distribution_att8 VARCHAR2,
124 distribution_att9 VARCHAR2,
125 distribution_att10 VARCHAR2,
126 distribution_att11 VARCHAR2,
127 distribution_att12 VARCHAR2,
128 distribution_att13 VARCHAR2,
129 distribution_att14 VARCHAR2,
130 distribution_att15 VARCHAR2,
131 FB_ERROR_MSG IN OUT NOCOPY VARCHAR2,
132 p_unit_price NUMBER,
133 p_blanket_po_line_num NUMBER,
134 p_misc_loa IN VARCHAR2) RETURN VARCHAR2;
135
136 FUNCTION jumpIntoFunction(p_application_id in number,
137 p_function_code in varchar2,
138 p_parameter1 in varchar2 default null,
139 p_parameter2 in varchar2 default null,
140 p_parameter3 in varchar2 default null,
141 p_parameter4 in varchar2 default null,
142 p_parameter5 in varchar2 default null,
143 p_parameter6 in varchar2 default null,
144 p_parameter7 in varchar2 default null,
145 p_parameter8 in varchar2 default null,
146 p_parameter9 in varchar2 default null,
147 p_parameter10 in varchar2 default null,
148 p_parameter11 in varchar2 default null)
149 return varchar2;
150
151 PROCEDURE restore_working_copy_req(
152 p_origHeaderId IN NUMBER,
153 p_tempHeaderId IN NUMBER,
154 p_origLineIds IN PO_TBL_NUMBER,
155 p_tempLineIds IN PO_TBL_NUMBER,
156 p_origDistIds IN PO_TBL_NUMBER,
157 p_tempDistIds IN PO_TBL_NUMBER,
158 p_origReqSupplierIds IN PO_TBL_NUMBER,
159 p_tempReqSupplierIds IN PO_TBL_NUMBER,
160 p_origPriceDiffIds IN PO_TBL_NUMBER,
161 p_tempPriceDiffIds IN PO_TBL_NUMBER);
162
163 FUNCTION submitreq(
164 req_Header_Id IN NUMBER,
165 req_num IN varchar2,
166 preparer_id IN NUMBER,
167 note_to_approver IN varchar2,
168 approver_id IN NUMBER) RETURN VARCHAR2;
169
170 PROCEDURE validate_pjm_project_info (p_deliver_to_org_id IN NUMBER,
171 p_project_id IN NUMBER,
172 p_task_id IN NUMBER,
173 p_need_by_date IN DATE,
174 p_translated_err OUT NOCOPY VARCHAR2,
175 p_result OUT NOCOPY VARCHAR2);
176
177 FUNCTION validate_ccid(
178 X_chartOfAccountsId IN NUMBER,
179 X_ccId IN NUMBER,
180 X_validationDate IN DATE,
181 X_concatSegs OUT NOCOPY VARCHAR2,
182 X_errorMsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
183
184 FUNCTION validate_open_period(
185 x_trx_date IN DATE,
186 x_sob_id IN NUMBER,
187 x_org_id IN NUMBER) RETURN NUMBER;
188
189 FUNCTION validate_segs(
190 X_chartOfAccountsId IN NUMBER,
191 X_concatSegs IN VARCHAR2,
192 X_errorMsg OUT NOCOPY VARCHAR2) RETURN NUMBER;
193
194 FUNCTION val_rcv_controls_for_date(
195 X_transaction_type IN VARCHAR2,
196 X_auto_transact_code IN VARCHAR2,
197 X_expected_receipt_date IN DATE,
198 X_transaction_date IN DATE,
199 X_routing_header_id IN NUMBER,
200 X_po_line_location_id IN NUMBER,
201 X_item_id IN NUMBER,
202 X_vendor_id IN NUMBER,
203 X_to_organization_id IN NUMBER,
204 rcv_date_exception OUT NOCOPY VARCHAR2) RETURN NUMBER;
205
206 /*---------------------------------------------------------------------*
207 * This function checks whether a given requisition header id exists *
208 * or not. If exists, return Y otherwise N. *
209 * Bug # 16705009 *
210 *---------------------------------------------------------------------*/
211 FUNCTION req_header_id_exist(p_req_header_id IN NUMBER) RETURN CHAR;
212
213 -- API to check whether the user is associated with a employee or not.
214 -- Returns true if the user is associated with a employee, else returns false
215 FUNCTION validate_user(p_user_id in number) RETURN CHAR;
216
217 FUNCTION GET_SECURITY_CLAUSE (object_schema in varchar2, object_name varchar2) return VARCHAR2;
218
219 PROCEDURE withdraw_req(p_headerId in NUMBER);
220
221 PROCEDURE deactivate_active_req(p_user_id IN NUMBER);
222
223 -- API to check transaction flow for centralized procurement
224 -- checks whether a transaction flow exists between the start OU and end OU
225 -- wrapper needed since types are defined in INV package and not in the
226 -- database
227 PROCEDURE check_transaction_flow(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2,
230 p_start_operating_unit IN NUMBER,
231 p_end_operating_unit IN NUMBER,
232 p_flow_type IN NUMBER,
233 p_organization_id IN NUMBER,
234 p_category_id IN NUMBER,
235 p_transaction_date IN DATE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY VARCHAR2,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 x_header_id OUT NOCOPY NUMBER,
240 x_new_accounting_flag OUT NOCOPY VARCHAR2,
241 x_transaction_flow_exists OUT NOCOPY VARCHAR2);
242
243 --Begin Encumbrance APIs
244 ------------------------
245
246 -- API to truncate the PO interface table PO_ENCUMBRANCE_GT
247 PROCEDURE truncate_po_encumbrance_gt;
248
249 -- API to populate the distribution data into POs interface table
250 -- PO_ENCUMBRANCE_GT
251 PROCEDURE populate_po_encumbrance_gt(
252 p_dist_data IN ICX_ENC_IN_TYPE);
253
254 -- API to check if the funds can be reserved on the requisition
255 PROCEDURE check_reserve(
256 p_api_version IN VARCHAR2,
257 p_commit IN VARCHAR2 default FND_API.G_FALSE,
258 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
259 p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
260 x_return_status OUT NOCOPY VARCHAR2,
261 p_doc_type IN VARCHAR2,
262 p_doc_subtype IN VARCHAR2,
263 p_dist_data IN ICX_ENC_IN_TYPE,
264 p_doc_level IN VARCHAR2,
265 p_doc_level_id IN NUMBER,
266 p_use_enc_gt_flag IN VARCHAR2,
267 p_override_funds IN VARCHAR2,
268 p_report_successes IN VARCHAR2,
269 x_po_return_code OUT NOCOPY VARCHAR2,
270 x_detailed_results OUT NOCOPY po_fcout_type);
271
272 -- API to check if the funds can be adjusted on the requisition
273 -- called during approver checkout
274 -- also called for just the labor and expense lines from assign contractor
275 -- during approver checkout
276 PROCEDURE check_adjust(
277 p_api_version IN VARCHAR2,
278 p_commit IN VARCHAR2 default FND_API.G_FALSE,
279 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
280 p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
281 x_return_status OUT NOCOPY VARCHAR2,
282 p_doc_type IN VARCHAR2,
283 p_doc_subtype IN VARCHAR2,
284 p_dist_data IN ICX_ENC_IN_TYPE,
285 p_doc_level IN VARCHAR2,
286 p_doc_level_id_tbl IN po_tbl_number,
287 p_override_funds IN VARCHAR2,
288 p_use_gl_date IN VARCHAR2,
289 p_override_date IN DATE,
290 p_report_successes IN VARCHAR2,
291 x_po_return_code OUT NOCOPY VARCHAR2,
292 x_detailed_results OUT NOCOPY po_fcout_type);
293
294 -- API to perform reservation of funds on a contractor line
295 -- this can have just a labor line or both a labor and expense line
296 -- called from assign contractor
297 PROCEDURE do_reserve_contractor(
298 p_api_version IN VARCHAR2,
299 p_commit IN VARCHAR2 default FND_API.G_FALSE,
300 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
301 p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
302 x_return_status OUT NOCOPY VARCHAR2,
303 p_doc_type IN VARCHAR2,
304 p_doc_subtype IN VARCHAR2,
305 p_doc_level IN VARCHAR2,
306 p_doc_level_id_tbl IN po_tbl_number,
307 p_prevent_partial_flag IN VARCHAR2,
308 p_employee_id IN NUMBER,
309 p_override_funds IN VARCHAR2,
310 p_report_successes IN VARCHAR2,
311 x_po_return_code OUT NOCOPY VARCHAR2,
312 x_detailed_results OUT NOCOPY po_fcout_type);
313
314 -- API to perform unreserve of funds on a contractor line
315 -- this can have just a labor line or both a labor and expense line
316 -- called from assign contractor
317 PROCEDURE do_unreserve_contractor(
318 p_api_version IN VARCHAR2,
319 p_commit IN VARCHAR2 default FND_API.G_FALSE,
320 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
321 p_validation_level IN number default FND_API.G_VALID_LEVEL_FULL,
322 x_return_status OUT NOCOPY VARCHAR2,
323 p_doc_type IN VARCHAR2,
324 p_doc_subtype IN VARCHAR2,
325 p_doc_level IN VARCHAR2,
326 p_doc_level_id_tbl IN po_tbl_number,
327 p_override_funds IN VARCHAR2,
328 p_employee_id IN NUMBER,
329 p_use_gl_date IN VARCHAR2,
330 p_override_date IN DATE,
331 p_report_successes IN VARCHAR2,
332 x_po_return_code OUT NOCOPY VARCHAR2,
333 x_detailed_results OUT NOCOPY po_fcout_type);
334
335 --End Encumbrance APIs
336 ------------------------
337
338 PROCEDURE cancel_workflow(p_headerId in NUMBER);
339
340 -- API Name : create_info_template
341 -- Type : Public
342 -- Pre-reqs : None
343 -- Function : Copies the information template data from the old_req_line to the record
344 -- corresponding new_req_line in the table POR_TEMPLATE_INFO while
345 -- creating a new req line. This will be called by Core Purchasing
346 -- This API is provide to Core Purchasing for bug 4716686
347 -- Parameters : p_old_reqline_id IN NUMBER : Corresponds to the existing requisition line id
348 -- p_new_reqline_id IN NUMBER : Corresponds to the new requisition line id
349 -- p_item_id IN NUMBER : Corresponds to the item id of the new requisiton line
350 -- p_category_id IN NUMBER : Corresponds to the category id of the new req. line
351 -- Version : Initial Verion : 1.0
352
353 PROCEDURE create_info_template
354 (p_api_version IN NUMBER,
355 x_return_status OUT NOCOPY VARCHAR2,
356 p_commit IN VARCHAR2 default FND_API.G_FALSE,
357 p_old_reqline_id IN NUMBER,
358 p_new_reqline_id IN NUMBER,
359 p_item_id IN NUMBER,
360 p_category_id IN NUMBER) ;
361
362 -- API Name : update_attachment_to_standard
363 -- Type : Public
364 -- Pre-reqs : None
365 -- Function : Updates the attachments associated with the requisition to standard attachment
366 -- Parameters : p_req_header_id IN NUMBER : Corresponds to the existing requisition line id
367
368 PROCEDURE update_attachment_to_standard(p_req_header_id in NUMBER);
369
370 FUNCTION is_req_encumbered(p_req_header_id in NUMBER)
371 RETURN VARCHAR2;
372
373
374 FUNCTION round_amount_precision
375 ( p_amount IN NUMBER
376 , p_currency_code IN VARCHAR2) RETURN number;
377
378 -- bug 9799749 - FP of 9449718
379 PROCEDURE reset_award( X_distribution_id IN NUMBER,
380 X_status IN OUT NOCOPY varchar2 ) ;
381
382 FUNCTION get_federal_enabled_flag RETURN VARCHAR2;
383
384 FUNCTION getCLMStatus ( user_id NUMBER, resp_id NUMBER, appl_id NUMBER ) RETURN VARCHAR2;
385
386 PROCEDURE create_req_line_from_po_line
387 (
388 p_req_line_id IN NUMBER
389 ,p_line_uda_template_id IN NUMBER
390 ,x_return_status OUT NOCOPY VARCHAR2
391 ,x_msg_count OUT NOCOPY NUMBER
392 ,x_msg_data OUT NOCOPY VARCHAR2
393 );
394
395 FUNCTION get_pr_line_status(p_req_line_id IN NUMBER)
396 RETURN VARCHAR2;
397
398 FUNCTION get_pr_line_status_search(p_req_header_id IN NUMBER, p_lines_status IN VARCHAR2)
399 RETURN NUMBER;
400
401 /* <<CLM Partial Funding Changes>> */
402 PROCEDURE get_rcv_funded_val
403 ( p_distribution_id IN NUMBER
404 ,p_can_be_received OUT NOCOPY NUMBER
405 ,p_funded OUT NOCOPY NUMBER
406 ,p_uom OUT NOCOPY VARCHAR2
407 );
408 PROCEDURE get_funded_val_dist ( p_distribution_id IN NUMBER , p_funded_value OUT NOCOPY NUMBER ) ;
409
410 /* <<CLM Partial Funding Changes>> */
411
412 PROCEDURE owner_can_approve_AME(p_document_type IN VARCHAR2
413 , p_owner_can_approve OUT NOCOPY VARCHAR2);
414
415 -- API Name :get_gbpa_data_for_bulkload
416 -- Type : Public
417 -- Pre-reqs : None
418 -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted
419 -- from iProcurement.
420 -- Parameters : p_req_header_id IN NUMBER
421 -- xUpdate_sourcing_rules_flag IN NUMBER
422 -- xAuto_sourcing_rules_flag IN NUMBER
423 -- Fixed Bug:10379671--fix the hard-coding done in START_PDOI_PROCESSING_PLSQL
424 -- of DataRootElementProcessor with the value from po_headers_all if blanket
425 -- already exists. Else, set it as 'N'.
426 --
427 -- This method is to get the value of the 2 flags used in
428 -- DataRootElementProcessor
429 PROCEDURE get_gbpa_data_for_bulkload (pHeaderId IN NUMBER,
430 xUpdate_sourcing_rules_flag OUT NOCOPY VARCHAR2,
431 xAuto_sourcing_flag OUT NOCOPY VARCHAR2);
432
433 FUNCTION is_placed_on_po(p_req_header_id IN NUMBER) RETURN VARCHAR2;
434
435 -- API Name : delete_supply
436 -- Type : Public
437 -- Pre-reqs : None
438 -- Function : Deletes MTL_SUPPLY record when a requisition line is deleted
439 -- from iProcurement.
440 -- Parameters : p_req_header_id IN NUMBER
441 -- p_req_line_id IN NUMBER
442 PROCEDURE delete_supply(p_req_header_id in NUMBER,p_req_line_id IN NUMBER);
443
444 FUNCTION validateWorkOrder(p_po_distribution_id IN number) RETURN NUMBER;
445
446 -- 13896563 changes starts
447 -- API Name : VALIDATE_JOB_RELEASED_DATE
448 -- Type : Public
449 -- Pre-reqs : None
450 -- Function : validate the POR receipt receive date with Job Release date.
451 -- Parameters : x_trx_date IN DATE
452 -- x_dist_id IN NUMBER
453 -- RETURN NUMBER
454 FUNCTION VALIDATE_JOB_RELEASED_DATE(x_trx_date IN DATE, x_dist_id IN NUMBER)
455 RETURN NUMBER;
456 -- 13896563 changes ends
457
458
459 -- 14191762 changes starts
460 -- API Name : GET_JOB_RELEASED_DATE
461 -- Type : Public
462 -- Pre-reqs : None
463 -- Function : gets the Job Release date against PO distribution.
464 -- Parameters : x_dist_id IN NUMBER
465 -- RETURN DATE
466 FUNCTION GET_JOB_RELEASED_DATE( x_dist_id IN NUMBER)
467 RETURN DATE;
468 -- 14191762 changes ends
469
470 --14062063 changes starts
471 -- API Name : val_po_dist_pjt
472 -- Type : Public
473 -- Pre-reqs : None
474 -- Function : validates the PO distribution with Project.
475 -- Parameters : x_dist_id IN NUMBER
476 -- RETURN NUMBER
477 FUNCTION val_po_dist_pjt(x_dist_id IN NUMBER) RETURN NUMBER;
478
479 -- API Name : get_po_dist_project
480 -- Type : Public
481 -- Pre-reqs : None
482 -- Function : gets the Project Name for PO distribution.
483 -- Parameters : p_po_dist_id IN NUMBER
484 -- RETURN NUMBER
485 FUNCTION get_po_dist_project(p_po_dist_id in number) RETURN VARCHAR2;
486
487 -- API Name : val_req_line_pjts
488 -- Type : Public
489 -- Pre-reqs : None
490 -- Function : validates the req line with Project.
491 -- Parameters : x_line_id IN NUMBER
492 -- RETURN NUMBER
493 FUNCTION val_req_line_pjts(x_line_id IN NUMBER)RETURN NUMBER;
494
495 -- API Name : get_req_line_invalid_pjts
496 -- Type : Public
497 -- Pre-reqs : None
498 -- Function : gets the comma separated invalid Project Name(s) for REQ Line.
499 -- Parameters : p_po_dist_id IN NUMBER
500 -- RETURN NUMBER
501 FUNCTION get_req_line_invalid_pjts(p_req_line_id IN NUMBER) RETURN VARCHAR2;
502
503 --14062063 changes ends
504
505 -- 15900708 changes starts
506 /*
507 API Name : req_imp_act_up_frm_wf
508 Type : Public
509 Pre-reqs : None
510 Function : populates the accounts in req interface table by calling
511 workflow api if charge account, charge account segments are empty.
512 and updates other accounts if already exists in req interface
513 Parameters :
514 p_request_id IN NUMBER : concurrent req no
515 p_coa_id IN NUMBER : chart of accounts id
516 p_user_id IN NUMBER : user id
517 p_login_id IN NUMBER : login id
518 p_prog_application_id IN NUMBER : program application id
519 p_program_id IN NUMBER : program id
520 */
521 PROCEDURE req_imp_act_up_frm_wf(
522 p_request_id IN NUMBER,
523 p_coa_id IN NUMBER,
524 p_user_id IN NUMBER,
525 p_login_id IN NUMBER,
526 p_prog_application_id IN NUMBER,
527 p_program_id IN NUMBER
528 );
529
530 /*
531 API Name : req_imp_mul_dst_act_up_frm_wf
532 Type : Public
533 Pre-reqs : None
534 Function : updates the accounts in req distribution interface table by calling
535 workflow api if charge account, charge account segments are empty.
536 and updates other accounts if already exists in req dist interface
537 Parameters :
538 p_request_id IN NUMBER : concurrent req no
539 p_coa_id IN NUMBER : chart of accounts id
540 p_user_id IN NUMBER : user id
541 p_login_id IN NUMBER : login id
542 p_prog_application_id IN NUMBER : program application id
543 p_program_id IN NUMBER : program id
544 */
545 PROCEDURE req_imp_mul_dst_act_up_frm_wf (
546 p_request_id IN NUMBER,
547 p_coa_id IN NUMBER,
548 p_user_id IN NUMBER,
549 p_login_id IN NUMBER,
550 p_prog_application_id IN NUMBER,
551 p_program_id IN NUMBER
552 );
553
554 -- 15900708 changes ends
555
556 FUNCTION validate_clm_req_acrn( x_document_id IN NUMBER,
557 x_errorMsg OUT NOCOPY VARCHAR2,
558 x_acrn OUT NOCOPY VARCHAR2,
559 x_charge_loa OUT NOCOPY VARCHAR2) RETURN NUMBER;
560
561 PROCEDURE Communicate(p_from_user in varchar2,
562 p_document_id in number ,
563 p_revision_number in number,
564 p_to_user_id in NUMBER,
565 p_mipr_type IN VARCHAR2,
566 p_error_code OUT NOCOPY varchar2);
567
568 PROCEDURE Start_Email_WF_Process (p_document_id IN NUMBER,
569 p_revision_num IN NUMBER,
570 p_to_user_id IN number,
571 p_from_user IN VARCHAR2,
572 p_mipr_type IN VARCHAR2,
573 p_error_code OUT NOCOPY varchar2);
574
575 procedure pdf_attach_mipr(document_id in varchar2,
576 content_type in varchar2,
577 document in out nocopy blob,
578 document_type in out nocopy varchar2);
579
580 PROCEDURE insert_action_in_mipr_history(
581 p_document_id IN NUMBER,
582 p_action_code IN VARCHAR2,
583 p_remarks IN VARCHAR2,
584 p_office_details IN VARCHAR2,
585 p_contact_id IN NUMBER);
586
587 -- PO PAR CHANGES for CLMr4 Hiding Dummy Req Begin.
588 G_REQ_TYPE VARCHAR2(10);
589 -- PO PAR CHANGES for CLMr4 Hiding Dummy Req End.
590 --bug 14308202
591 FUNCTION submitreqforcancel(
592 req_Header_Id IN NUMBER) RETURN VARCHAR2;
593
594 END POR_UTIL_PKG;