1 PACKAGE pa_control_items_workflow AUTHID CURRENT_USER as
2 /* $Header: PACIWFPS.pls 120.2.12010000.2 2009/08/11 07:16:20 anuragar ship $ */
3 /*============================================================================+
4 | Copyright (c) 1993 Oracle Corporation Belmont, California, USA |
5 | All rights reserved. |
6 | Oracle Manufacturing |
7 +=============================================================================+
8
9 FILE NAME : PACIWFPS.pls
10 DESCRIPTION :
11 This file creates package procedures that are called to
12 execute each activity in the Progress Status Workflow.
13
14
15
16 HISTORY : 07/22/02 SYAO Initial Creation
17 20/01/04 sanantha Bug 3297238. FP M changes.
18 23/06/04 rasinha Bug# 3691192 FP M Changes
19 Added three procedures namely CLOSE_CI_ACTION,KEEP_OPEN and CANCEL_NOTIF_AND_ABORT_WF.
20 CLOSE_CI_ACTION and KEEP_OPEN are called from the PAWFCIAC workflow funtions.
21 CLOSE_CI_ACTION closes an Action without signing it off,
22 KEEP_OPEN keeps the action open and registers any comment given by the user and
23 CANCEL_NOTIF_AND_ABORT_WF cancels any open notification for an action and also aborts the workflow.
24 Also added some item attributes in the workflow PAWFCIAC.
25 10-Aug-05 rasinha Bug# 4527911:
26 1)Added the procedure close_notification to close an open action
27 notification.
28 2)Modifed the procedure CANCEL_NOTIF_AND_ABORT_WF .Added parameter
29 p_ci_action_id and removed the following parameters p_item_type,
30 p_item_key and p_nid.
31 =============================================================================*/
32
33 Procedure start_workflow(
34 p_item_type IN VARCHAR2
35 , p_process_name IN VARCHAR2
36
37 , p_ci_id IN NUMBER
38
39 , x_item_key OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
40 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
41 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
42 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43 );
44
45 Procedure cancel_workflow (
46 p_Item_type IN VARCHAR2
47 , p_Item_key IN VARCHAR2
48 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
49 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
50 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
51 );
52
53 PROCEDURE change_status_rejected
54 (itemtype IN VARCHAR2
55 ,itemkey IN VARCHAR2
56 ,actid IN NUMBER
57 ,funcmode IN VARCHAR2
58 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
59
60 PROCEDURE change_status_working
61 (itemtype IN VARCHAR2
62 ,itemkey IN VARCHAR2
63 ,actid IN NUMBER
64 ,funcmode IN VARCHAR2
65 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
66
67 PROCEDURE change_status_approved
68 (itemtype IN VARCHAR2
69 ,itemkey IN VARCHAR2
70 ,actid IN NUMBER
71 ,funcmode IN VARCHAR2
72 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
73
74 PROCEDURE is_approver_same_as_submitter(
75 itemtype IN VARCHAR2
76 ,itemkey IN VARCHAR2
77 ,actid IN NUMBER
78 ,funcmode IN VARCHAR2
79 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
80
81
82
83 PROCEDURE check_status_change
84 (itemtype IN VARCHAR2
85 ,itemkey IN VARCHAR2
86 ,actid IN NUMBER
87 ,funcmode IN VARCHAR2
88 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
89
90 PROCEDURE approval_request_post_notfy
91 (itemtype IN VARCHAR2
92 ,itemkey IN VARCHAR2
93 ,actid IN NUMBER
94 ,funcmode IN VARCHAR2
95 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
96
97
98 PROCEDURE forward_notification(
99 itemtype IN VARCHAR2
100 ,itemkey IN VARCHAR2
101 ,actid IN NUMBER
102 ,funcmode IN VARCHAR2
103 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
104
105
106 PROCEDURE show_clob_content
107 (document_id IN VARCHAR2,
108 display_type IN VARCHAR2,
109 document IN OUT NOCOPY clob, --File.Sql.39 bug 4440895
110 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
111
112 --Bug 3297238. FP M changes.
113 PROCEDURE START_NOTIFICATION_WF
114 ( p_item_type In VARCHAR2
115 ,p_process_name In VARCHAR2
116 ,p_ci_id In pa_control_items.ci_id%TYPE
117 ,p_action_id In pa_ci_actions.ci_action_id%TYPE := NULL
118 ,x_item_key Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
119 ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120 ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
121 ,x_msg_data Out NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
122
123 --Bug 3297238. FP M changes.
124 PROCEDURE set_workflow_attributes(
125 p_item_type In VARCHAR2
126 ,p_process_name In VARCHAR2
127 ,p_ci_id In pa_control_items.ci_id%TYPE
128 ,p_action_id In pa_ci_actions.ci_action_id%TYPE := NULL
129 ,p_item_key In NUMBER
130 ,x_return_status Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
131 ,x_msg_count Out NOCOPY NUMBER --File.Sql.39 bug 4440895
132 ,x_msg_data Out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
133 );
134
135 -- Bug# 3691192 FP M Changes
136 PROCEDURE CLOSE_CI_ACTION(
137 itemtype IN VARCHAR2
138 ,itemkey IN VARCHAR2
139 ,actid IN NUMBER
140 ,funcmode IN VARCHAR2
141 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
142
143 --Bug# 3691192 FP M Changes
144 PROCEDURE KEEP_OPEN (
145 itemtype IN VARCHAR2
146 ,itemkey IN VARCHAR2
147 ,actid IN NUMBER
148 ,funcmode IN VARCHAR2
149 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
150
151 -- Bug# 3691192 FP M Changes
152 PROCEDURE cancel_notif_and_abort_wf(
153 p_ci_action_id IN NUMBER,
154 x_msg_count OUT NOCOPY NUMBER ,
155 x_msg_data OUT NOCOPY VARCHAR2 ,
156 x_return_status OUT NOCOPY VARCHAR2 );
157
158 PROCEDURE close_notification(
159 p_item_type in VARCHAR2,
160 p_item_key in VARCHAR2,
161 p_nid in NUMBER,
162 p_action in VARCHAR2,
163 p_sign_off_flag in VARCHAR2,
164 p_response in VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER ,
166 x_msg_data OUT NOCOPY VARCHAR2 ,
167 x_return_status OUT NOCOPY VARCHAR2 );
168 PROCEDURE show_task_details
169 (document_id IN VARCHAR2,
170 display_type IN VARCHAR2,
171 document IN OUT NOCOPY VARCHAR2, -- 4537865
172 document_type IN OUT NOCOPY VARCHAR2);
173
174 END pa_control_items_workflow;
175