[Home] [Help]
PACKAGE: APPS.PV_WORKFLOW_PUB
Source
1 PACKAGE PV_WORKFLOW_PUB AUTHID CURRENT_USER as
2 /* $Header: pvxwffns.pls 120.1 2006/05/31 04:13:56 dhii noship $ */
3 -- Start of Comments
4
5 -- Package name : PV_WORKFLOW_PUB
6 -- Purpose :
7 -- History :
8 --
9 -- NOTE :
10 -- End of Comments
11 --
12
13 -- WF itemtypes
14
15 g_wf_itemtype_pvasgnmt CONSTANT VARCHAR2(30) := 'PVASGNMT';
16
17
18 -- WF process
19
20 g_wf_pcs_initiate_assignment CONSTANT varchar2(30) := 'PV_INITIATE_ASSGNMNT_PCS';
21 g_wf_pcs_abandon_fyi CONSTANT varchar2(30) := 'PV_PRTNR_ABNDN_FYI_PCS';
22 g_wf_pcs_withdraw_fyi CONSTANT varchar2(30) := 'PV_CM_ACTIVE_WITHDRAW_FYI_PCS';
23
24 -- WF functions
25
26 g_wf_fn_cm_response_block CONSTANT varchar2(30) := 'PV_CM_RESPONSE_BLOCK_FN';
27 g_wf_fn_pt_response_block CONSTANT varchar2(30) := 'PV_PT_RESPONSE_BLOCK_FN';
28
29 -- WF attributes
30
31 g_wf_attr_bypass_cm_approval CONSTANT varchar2(30) := 'PV_BYPASS_CM_APPROVAL_ATTR';
32 g_wf_attr_email_enabled CONSTANT varchar2(30) := 'PV_EMAIL_ENABLED_ATTR';
33 g_wf_attr_assignment_type CONSTANT varchar2(30) := 'PV_ASSIGNMENT_TYPE_ATTR';
34 g_wf_attr_assign_type_mean CONSTANT varchar2(30) := 'PV_ASSIGN_TYPE_MEAN_ATTR';
35 g_wf_attr_customer_id CONSTANT varchar2(30) := 'PV_CUSTOMER_ID_ATTR';
36 g_wf_attr_customer_name CONSTANT varchar2(30) := 'PV_CUSTOMER_NAME_ATTR';
37 g_wf_attr_address_id CONSTANT varchar2(30) := 'PV_CUST_ADDR_ID_ATTR';
38 g_wf_attr_matched_timeout CONSTANT varchar2(30) := 'PV_MATCHED_TIMEOUT_ATTR';
39 g_wf_attr_matched_timeout_dt CONSTANT varchar2(30) := 'PV_MATCHED_TIMEOUT_DATE_ATTR';
40 g_wf_attr_offered_timeout CONSTANT varchar2(30) := 'PV_OFFERED_TIMEOUT_ATTR';
41 g_wf_attr_offered_timeout_dt CONSTANT varchar2(30) := 'PV_OFFERED_TIMEOUT_DATE_ATTR';
42 g_wf_attr_current_serial_rank CONSTANT varchar2(30) := 'PV_SERIAL_RANK_ATTR';
43 g_wf_attr_next_serial_rank CONSTANT varchar2(30) := 'PV_NEXT_SERIAL_RANK_ATTR';
44 g_wf_attr_partner_org CONSTANT varchar2(30) := 'PV_PARTNER_ORG_ATTR';
45 g_wf_attr_partner_id CONSTANT varchar2(30) := 'PV_PARTNER_ID_ATTR';
46 g_wf_attr_opportunity_id CONSTANT varchar2(30) := 'PV_OPP_ID_ATTR';
47 g_wf_attr_entity_name CONSTANT varchar2(30) := 'PV_OPP_NAME_ATTR';
48 g_wf_attr_entity_amount CONSTANT varchar2(30) := 'PV_OPP_AMOUNT_ATTR';
49 g_wf_attr_opp_number CONSTANT varchar2(30) := 'PV_OPP_NUMBER_ATTR';
50 g_wf_attr_cm_respond_url CONSTANT varchar2(30) := 'PV_CM_RESPOND_URL_ATTR';
51 g_wf_attr_offer_outcome CONSTANT varchar2(30) := 'PV_OFFER_OUTCOME_ATTR';
52 g_wf_attr_pt_outcome CONSTANT varchar2(30) := 'PV_PT_OUTCOME_ATTR';
53 g_wf_attr_routing_outcome CONSTANT varchar2(30) := 'PV_ROUTING_OUTCOME_ATTR';
54 g_wf_attr_organization_type CONSTANT varchar2(30) := 'PV_ORG_TYPE_ATTR';
55 g_wf_attr_ext_org_party_id CONSTANT varchar2(30) := 'PV_EXT_ORG_PARTY_ID_ATTR';
56 g_wf_attr_vendor_org_name CONSTANT varchar2(30) := 'PV_VENDOR_NAME_ATTR';
57 g_wf_attr_responding_cm CONSTANT varchar2(30) := 'PV_RESPONDING_CM_ATTR';
58 g_wf_attr_action_reason CONSTANT varchar2(30) := 'PV_ACTION_REASON_ATTR';
59 g_wf_attr_wf_activity_id CONSTANT varchar2(30) := 'PV_WF_ACTIVITY_ID_ATTR';
60 g_wf_attr_process_rule_id CONSTANT varchar2(30) := 'PV_PROCESS_RULE_ATTR';
61
62 -- used only by the PV_WORKFLOW_PUB.SET_NOTIFIED_PARTY_NOTIFY_ID api
63 g_wf_attr_pvt_notify_type CONSTANT varchar2(30) := 'PV_NOTIFY_TYPE_ATTR_PVT';
64
65 -- used only by the PV_WORKFLOW_PUB.SET_TIMEOUT api
66 g_wf_attr_pvt_timeout_type CONSTANT varchar2(30) := 'PV_TIMEOUT_TYPE_ATTR_PVT';
67
68
69 -- start WF lookup codes -------------------------------------------------------------------
70
71 -- timeout code
72
73 g_wf_timeout CONSTANT varchar2(30) := '#TIMEOUT';
74 g_wf_complete CONSTANT varchar2(30) := 'COMPLETE';
75
76 -- CM response lookup
77
78 g_wf_lkup_cm_approved CONSTANT varchar2(30) := 'CM_APPROVED';
79 g_wf_lkup_cm_rejected CONSTANT varchar2(30) := 'CM_REJECTED';
80 g_wf_lkup_cm_timeout CONSTANT varchar2(30) := 'CM_TIMEOUT';
81
82 -- matched outcome lookup
83
84 g_wf_lkup_match_approved CONSTANT varchar2(30) := 'MATCH_APPROVED';
85 g_wf_lkup_match_rejected CONSTANT varchar2(30) := 'MATCH_REJECTED';
86 g_wf_lkup_match_timedout CONSTANT varchar2(30) := 'MATCH_TIMEDOUT';
87 g_wf_lkup_match_withdrawn CONSTANT varchar2(30) := 'MATCH_WITHDRAWN';
88
89 -- offered outcome lookup
90
91 g_wf_lkup_offer_approved CONSTANT varchar2(30) := 'PT_APPROVED';
92 g_wf_lkup_offer_rejected CONSTANT varchar2(30) := 'PT_REJECTED';
93 g_wf_lkup_offer_timedout CONSTANT varchar2(30) := 'PT_TIMEOUT';
94 g_wf_lkup_offer_withdrawn CONSTANT varchar2(30) := 'OFFER_WITHDRAWN';
95 g_wf_lkup_offer_lost_chance CONSTANT varchar2(30) := 'LOST_CHANCE';
96 g_wf_lkup_offer_cm_app_for_pt CONSTANT varchar2(30) := 'CM_APP_FOR_PT';
97
98 -- assignment type lookup
99
100 g_wf_lkup_single CONSTANT varchar2(30) := 'SINGLE';
101 g_wf_lkup_serial CONSTANT varchar2(30) := 'SERIAL';
102 g_wf_lkup_broadcast CONSTANT varchar2(30) := 'BROADCAST';
103 g_wf_lkup_joint CONSTANT varchar2(30) := 'JOINT';
104
105 -- standard boolean type lookup
106
107 g_wf_lkup_true CONSTANT varchar2(1) := 'T';
108 g_wf_lkup_false CONSTANT varchar2(1) := 'F';
109
110 -- standard yes/no type lookup
111
112 g_wf_lkup_yes CONSTANT varchar2(1) := 'Y';
113 g_wf_lkup_no CONSTANT varchar2(1) := 'N';
114
115
116 -- end WF lookup codes -------------------------------------------------------------------
117
118 procedure BYPASS_CM_APPROVAL_CHK (
119 itemtype in varchar2,
120 itemkey in varchar2,
121 actid in number,
122 funcmode in varchar2,
123 resultout in OUT NOCOPY varchar2);
124
125 procedure SET_TIMEOUT (
126 itemtype in varchar2,
127 itemkey in varchar2,
128 actid in number,
129 funcmode in varchar2,
130 resultout in OUT NOCOPY varchar2);
131
132 procedure WAIT_ON_MATCH (
133 itemtype in varchar2,
134 itemkey in varchar2,
135 actid in number,
136 funcmode in varchar2,
137 resultout in OUT NOCOPY varchar2);
138
139 procedure GET_ASSIGNMENT_TYPE (
140 itemtype in varchar2,
141 itemkey in varchar2,
142 actid in number,
143 funcmode in varchar2,
144 resultout in OUT NOCOPY varchar2);
145
146 procedure SERIAL_NEXT_PARTNER (
147 itemtype in varchar2,
148 itemkey in varchar2,
149 actid in number,
150 funcmode in varchar2,
151 resultout in OUT NOCOPY varchar2);
152
153 procedure WAIT_ON_OFFER (
154 itemtype in varchar2,
155 itemkey in varchar2,
156 actid in number,
157 funcmode in varchar2,
158 resultout in OUT NOCOPY varchar2);
159
160 procedure PROCESS_MATCH_OUTCOME (
161 itemtype in varchar2,
162 itemkey in varchar2,
163 actid in number,
164 funcmode in varchar2,
165 resultout in OUT NOCOPY varchar2);
166
167 procedure PROCESS_OFFER_OUTCOME (
168 itemtype in varchar2,
169 itemkey in varchar2,
170 actid in number,
171 funcmode in varchar2,
172 resultout in OUT NOCOPY varchar2);
173
174 procedure BYPASS_PT_APPROVAL_CHK (
175 itemtype in varchar2,
176 itemkey in varchar2,
177 actid in number,
178 funcmode in varchar2,
179 resultout in OUT NOCOPY varchar2);
180
181 procedure NEED_PT_OK_CHK (
182 itemtype in varchar2,
183 itemkey in varchar2,
184 actid in number,
185 funcmode in varchar2,
186 resultout in OUT NOCOPY varchar2);
187
188 procedure WRAPUP_PROCESSING (
189 itemtype in varchar2,
190 itemkey in varchar2,
191 actid in number,
192 funcmode in varchar2,
193 resultout in OUT NOCOPY varchar2);
194
195 procedure ABANDON_FYI (
196 itemtype in varchar2,
197 itemkey in varchar2,
198 actid in number,
199 funcmode in varchar2,
200 resultout in OUT NOCOPY varchar2);
201
202 procedure WITHDRAW_FYI (
203 itemtype in varchar2,
204 itemkey in varchar2,
205 actid in number,
206 funcmode in varchar2,
207 resultout in OUT NOCOPY varchar2);
208
209
210 procedure GET_PRODUCTS (document_id in varchar2,
211 display_type in varchar2,
212 document in out nocopy varchar2,
213 document_type in out nocopy varchar2);
214
215 procedure GET_OPPTY_CONTACTS (document_id in varchar2,
216 display_type in varchar2,
217 document in out nocopy varchar2,
218 document_type in out nocopy varchar2);
219
220 procedure GET_PUBLISH_NOTES (document_id in varchar2,
221 display_type in varchar2,
222 document in out nocopy varchar2,
223 document_type in out nocopy varchar2);
224 procedure get_assign_type_mean (
225 document_id in varchar2,
226 display_type in varchar2,
227 document in out nocopy varchar2,
228 document_type in out nocopy varchar2);
229
230 procedure get_vendor_org_name (
231 document_id in varchar2,
232 display_type in varchar2,
233 document in out nocopy varchar2,
234 document_type in out nocopy varchar2);
235
236 procedure get_accept_user_name (
237 document_id in varchar2,
238 display_type in varchar2,
239 document in out nocopy varchar2,
240 document_type in out nocopy varchar2);
241
242 procedure get_accept_user_org (
243 document_id in varchar2,
244 display_type in varchar2,
245 document in out nocopy varchar2,
246 document_type in out nocopy varchar2);
247
248 End PV_WORKFLOW_PUB;