[Home] [Help]
PACKAGE: APPS.ASO_PA_APR_WF_PVT
Source
1 PACKAGE ASO_PA_APR_WF_PVT AUTHID CURRENT_USER AS
2 /* $Header: asovwpas.pls 120.0.12020000.6 2013/05/02 10:56:11 rassharm noship $ */
3
4
5 TYPE aso_attribute_label_tbl_type IS TABLE OF VARCHAR2 (80);
6
7 PROCEDURE start_aso_approvals (
8 P_Object_approval_id IN NUMBER,
9 P_itemtype_name IN VARCHAR2,
10 P_sender_name IN VARCHAR2
11 );
12
13
14
15 PROCEDURE update_approval_status (
16 p_update_header_or_detail_flag IN VARCHAR2,
17 p_object_approval_id IN NUMBER,
18 p_approval_det_id IN NUMBER,
19 p_status IN VARCHAR2,
20 note IN VARCHAR2
21 );
22
23 procedure Get_Next_Approvers(itemtype in varchar2,
24 itemkey in varchar2,
25 actid in number,
26 funcmode in varchar2,
27 resultout out NOCOPY varchar2);
28
29 procedure Launch_Parallel_Approval(itemtype in varchar2,
30 itemkey in varchar2,
31 actid in number,
32 funcmode in varchar2,
33 resultout out NOCOPY varchar2);
34
35 PROCEDURE set_attributes (
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 set_notification_attributes (
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 is_fyi_approver(
52 itemtype IN VARCHAR2,
53 itemkey IN VARCHAR2,
54 actid IN NUMBER,
55 funcmode IN VARCHAR2,
56 resultout OUT NOCOPY VARCHAR2);
57
58 PROCEDURE update_Action_history_approve (
59 itemtype IN VARCHAR2,
60 itemkey IN VARCHAR2,
61 actid IN NUMBER,
62 funcmode IN VARCHAR2,
63 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64 );
65
66 PROCEDURE update_Action_history_reject(
67 itemtype IN VARCHAR2,
68 itemkey IN VARCHAR2,
69 actid IN NUMBER,
70 funcmode IN VARCHAR2,
71 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72 );
73
74 PROCEDURE update_Action_history_timedout (
75 itemtype IN VARCHAR2,
76 itemkey IN VARCHAR2,
77 actid IN NUMBER,
78 funcmode IN VARCHAR2,
79 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80 );
81
82 PROCEDURE process_response_ame(itemtype in varchar2,
83 itemkey in varchar2,
84 p_response in varchar2);
85
86
87 PROCEDURE process_response_approve(
88 itemtype IN VARCHAR2,
89 itemkey IN VARCHAR2,
90 actid IN NUMBER,
91 funcmode IN VARCHAR2,
92 resultout OUT NOCOPY VARCHAR2);
93
94 PROCEDURE process_response_reject(
95 itemtype IN VARCHAR2,
96 itemkey IN VARCHAR2,
97 actid IN NUMBER,
98 funcmode IN VARCHAR2,
99 resultout OUT NOCOPY VARCHAR2);
100
101 PROCEDURE process_response_timedout(
102 itemtype IN VARCHAR2,
103 itemkey IN VARCHAR2,
104 actid IN NUMBER,
105 funcmode IN VARCHAR2,
106 resultout OUT NOCOPY VARCHAR2);
107
108 PROCEDURE update_Action_history_pending(
109 itemtype IN VARCHAR2,
110 itemkey IN VARCHAR2,
111 actid IN NUMBER,
112 funcmode IN VARCHAR2,
113 resultout OUT NOCOPY VARCHAR2);
114
115 PROCEDURE update_Action_history_fyi(
116 itemtype IN VARCHAR2,
117 itemkey IN VARCHAR2,
118 actid IN NUMBER,
119 funcmode IN VARCHAR2,
120 resultout OUT NOCOPY VARCHAR2);
121
122 PROCEDURE update_entity(
123 p_object_approval_id IN NUMBER,
124 p_status IN VARCHAR2);
125
126 PROCEDURE update_entity_reject (
127 itemtype IN VARCHAR2,
128 itemkey IN VARCHAR2,
129 actid IN NUMBER,
130 funcmode IN VARCHAR2,
131 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
132 );
133
134
135 PROCEDURE is_ame_exception(
136 itemtype IN VARCHAR2,
137 itemkey IN VARCHAR2,
138 actid IN NUMBER,
139 funcmode IN VARCHAR2,
140 resultout OUT NOCOPY VARCHAR2);
141
142 procedure insertapprovershistory
143 (l_approval_det_id number,
144 l_approval_id number,
145 l_approver_person_id IN number,
146 l_approver_user_id in number,
147 l_order_number number,
148 l_NAME VARCHAR2,
149 l_ITEM_CLASS VARCHAR2,
150 l_ITEM_ID VARCHAR2,
151 l_ACTION_TYPE_ID NUMBER,
152 l_GROUP_OR_CHAIN_ID NUMBER,
153 L_OCCURRENCE NUMBER,
154 L_AUTHORITY VARCHAR2,
155 l_APPROVER_CATEGORY VARCHAR2);
156
157 PROCEDURE cancelapproval (
158 approval_id IN NUMBER,
159 p_itemtype IN VARCHAR2,
160 p_user_id IN NUMBER
161 );
162
163 PROCEDURE PROCESS_BEAT_BY_FIRST( itemtype in varchar2,
164 itemkey in varchar2,
165 actid in number,
166 funcmode in varchar2,
167 resultout out NOCOPY varchar2);
168
169 PROCEDURE UPDATE_ENTITY_approved (
170 itemtype IN VARCHAR2,
171 itemkey IN VARCHAR2,
172 actid IN NUMBER,
173 funcmode IN VARCHAR2,
174 resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
175
176
177 PROCEDURE insertruledetails(approvalid IN number,
178 p_rule_list_ids IN ame_util.idList);
179
180 -- bug 16712534
181 procedure cancel_notify_approver
182 (
183 p_approval_id IN NUMBER,
184 p_item_type IN VARCHAR2,
185 p_message_name IN VARCHAR2,
186 p_from_user_name IN VARCHAR2,
187 p_from_displayname IN VARCHAR2,
188 p_cancellor_username IN VARCHAR2,
189 p_cancellor_displayname IN VARCHAR2,
190 p_role IN VARCHAR2
191 );
192
193 END ASO_PA_APR_WF_PVT;