1 PACKAGE AP_WFAPPROVAL_PKG AUTHID CURRENT_USER AS
2 /* $Header: apiawges.pls 120.0.12000000.3 2007/07/20 07:07:12 schamaku ship $ */
3 -- Public Procedure Specification
4
5 FUNCTION ap_accounting_flex(p_ccid IN NUMBER,
6 p_seg_name IN VARCHAR2,
7 p_set_of_books_id IN NUMBER ) RETURN VARCHAR2;
8
9 FUNCTION ap_dist_accounting_flex(p_seg_name IN VARCHAR2,
10 p_dist_id IN NUMBER) RETURN VARCHAR2;
11
12 PROCEDURE iaw_po_check(itemtype IN VARCHAR2,
13 itemkey IN VARCHAR2,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 resultout OUT NOCOPY VARCHAR2);
17
18 PROCEDURE get_approver(itemtype IN VARCHAR2,
19 itemkey IN VARCHAR2,
20 actid IN NUMBER,
21 funcmode IN VARCHAR2,
22 resultout OUT NOCOPY VARCHAR2 );
23
24 PROCEDURE update_history(itemtype IN VARCHAR2,
25 itemkey IN VARCHAR2,
26 actid IN NUMBER,
27 funcmode IN VARCHAR2,
28 resultout OUT NOCOPY VARCHAR2 );
29
30 PROCEDURE insert_history(itemtype IN VARCHAR2,
31 itemkey IN VARCHAR2 );
32
33 PROCEDURE insert_history(p_invoice_id IN NUMBER,
34 p_iteration IN NUMBER,
35 p_org_id IN NUMBER,
36 p_status IN VARCHAR2);
37
38 PROCEDURE escalate_request(itemtype IN VARCHAR2,
39 itemkey IN VARCHAR2,
40 actid IN NUMBER,
41 funcmode IN VARCHAR2,
42 resultout OUT NOCOPY VARCHAR2 );
43
44 PROCEDURE set_attribute_values(itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2 );
46
47 PROCEDURE notification_handler(itemtype IN VARCHAR2,
48 itemkey IN VARCHAR2,
49 actid IN NUMBER,
50 funcmode IN VARCHAR2,
51 resultout OUT NOCOPY VARCHAR2 );
52
53 PROCEDURE iaw_raise_event(eventname IN VARCHAR2,
54 itemkey IN VARCHAR2,
55 p_org_id IN NUMBER );
56
57 FUNCTION get_attribute_value( p_invoice_id IN NUMBER,
58 p_dist_id IN NUMBER DEFAULT NULL,
59 p_attribute_name IN VARCHAR2,
60 p_context IN VARCHAR2 DEFAULT NULL)
61 RETURN VARCHAR2;
62 --Bug 5968183
63 --Added procedure to change Invoice Approval status when a workflow is cancelled for the same.
64 PROCEDURE Update_Invoice_Status(
65 p_invoice_id IN ap_invoices_all.invoice_id%TYPE);
66 --End of 5968183
67 END AP_WFAPPROVAL_PKG;
68
69