[Home] [Help]
PACKAGE: APPS.ASO_APR_WF_PVT
Source
1 PACKAGE aso_apr_wf_pvt AS
2 /* $Header: asovwaps.pls 120.2 2006/06/22 18:06:27 skulkarn ship $ */
3 TYPE aso_attribute_label_tbl_type IS TABLE OF VARCHAR2 (80);
4
5 PROCEDURE start_aso_approvals (
6 P_Object_approval_id IN NUMBER,
7 P_itemtype_name IN VARCHAR2,
8 P_sender_name IN VARCHAR2
9 );
10
11 PROCEDURE submit_approval (
12 itemtype IN VARCHAR2,
13 itemkey IN VARCHAR2,
14 actid IN NUMBER,
15 funcmode IN VARCHAR2,
16 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
17 );
18
19 PROCEDURE check_rejected (
20 itemtype IN VARCHAR2,
21 itemkey IN VARCHAR2,
22 actid IN NUMBER,
23 funcmode IN VARCHAR2,
24 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
25 );
26
27 PROCEDURE submit_next_batch (
28 itemtype IN VARCHAR2,
29 itemkey IN VARCHAR2,
30 actid IN NUMBER,
31 funcmode IN VARCHAR2,
32 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
33 );
34
35 PROCEDURE approved (
36 itemtype IN VARCHAR2,
37 itemkey IN VARCHAR2,
38 actid IN NUMBER,
39 funcmode IN VARCHAR2,
40 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
41 );
42
43 PROCEDURE rejected (
44 itemtype IN VARCHAR2,
45 itemkey IN VARCHAR2,
46 actid IN NUMBER,
47 funcmode IN VARCHAR2,
48 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
49 );
50
51 PROCEDURE timedout (
52 itemtype IN VARCHAR2,
53 itemkey IN VARCHAR2,
54 actid IN NUMBER,
55 funcmode IN VARCHAR2,
56 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
57 );
58
59 PROCEDURE cancelapproval (
60 approval_id IN NUMBER,
61 p_itemtype IN VARCHAR2,
62 p_user_id IN NUMBER
63 );
64
65 PROCEDURE send_notification (
66 itemtype IN VARCHAR2,
67 itemkey IN VARCHAR2,
68 actid IN NUMBER,
69 funcmode IN VARCHAR2,
70 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
71 );
72
73 PROCEDURE send_cancel_notification (
74 itemtype IN VARCHAR2,
75 itemkey IN VARCHAR2,
76 actid IN NUMBER,
77 funcmode IN VARCHAR2,
78 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
79 );
80
81 PROCEDURE update_approver_list (
82 p_object_approval_id IN NUMBER
83 );
84
85 PROCEDURE last_approver_timeout_check (
86 p_object_approval_id IN NUMBER
87 );
88
89 PROCEDURE approver_details_doc (
90 document_id IN VARCHAR2,
91 display_type IN VARCHAR2,
92 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
93 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94 );
95
96 PROCEDURE quote_summary_doc (
97 document_id IN VARCHAR2,
98 display_type IN VARCHAR2,
99 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
101 );
102
103 PROCEDURE requester_comments_doc (
104 document_id IN VARCHAR2,
105 display_type IN VARCHAR2,
106 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
107 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
108 );
109
110 PROCEDURE rule_details_doc (
111 document_id IN VARCHAR2,
112 display_type IN VARCHAR2,
113 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115 );
116
117 PROCEDURE quote_detail_url (
118 document_id IN VARCHAR2,
119 display_type IN VARCHAR2,
120 document IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
121 document_type IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
122 );
123
124 PROCEDURE get_attribute_label (
125 p_approval_id IN NUMBER,
126 p_attribute_tbl OUT NOCOPY /* file.sql.39 change */ aso_attribute_label_tbl_type
127 );
128
129 FUNCTION GetRunFuncURL
130 (
131 p_function_name IN VARCHAR2
132 , p_resp_appl_id IN NUMBER DEFAULT NULL
133 , p_resp_id IN NUMBER DEFAULT NULL
134 , p_security_group_id IN NUMBER DEFAULT NULL
135 , p_parameters IN VARCHAR2 DEFAULT NULL
136 ) RETURN VARCHAR2;
137
138 PROCEDURE set_attributes (
139 itemtype IN VARCHAR2,
140 itemkey IN VARCHAR2,
141 actid IN NUMBER,
142 funcmode IN VARCHAR2,
143 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
144 );
145
146 PROCEDURE update_entity (
147 itemtype IN VARCHAR2,
148 itemkey IN VARCHAR2,
149 actid IN NUMBER,
150 funcmode IN VARCHAR2,
151 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
152 );
153
154 PROCEDURE update_approval_status (
155 p_update_header_or_detail_flag IN VARCHAR2,
156 p_object_approval_id IN NUMBER,
157 p_approval_det_id IN NUMBER,
158 p_status IN VARCHAR2,
159 note IN VARCHAR2
160 );
161
162 END aso_apr_wf_pvt;