1 PACKAGE IEX_STRY_API_PUB AUTHID CURRENT_USER as
2 /* $Header: iexpsaps.pls 120.3.12010000.1 2008/07/29 10:02:54 appldev ship $ */
3
4
5 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
6 G_YES CONSTANT VARCHAR2(1) := 'Y';
7 G_NO CONSTANT VARCHAR2(1) := 'N';
8 G_NUMBER CONSTANT NUMBER := 1; -- data type is number
9 G_VARCHAR2 CONSTANT NUMBER := 2; -- data type is varchar2
10
11
12 /** reassgin strategy
13 * send signal first
14 * then call create_Strategy_pub
15 * to create the new strategy
16 * the new strategy will launch the work flow*
17 **/
18 PROCEDURE REASSIGN_STRATEGY( p_strategy_temp_id IN NUMBER,
19 p_strategy_id IN NUMBER,
20 p_status IN VARCHAR2,
21 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22 x_return_status OUT NOCOPY VARCHAR2,
23 x_msg_count OUT NOCOPY NUMBER,
24 x_msg_data OUT NOCOPY VARCHAR2);
25
26 --Start bug 6794510 gnramasa 5th Feb 08
27 /** assign strategy
28 * call create_Strategy_pub
29 * to create the new strategy
30 * the new strategy will launch the work flow*
31 **/
32 PROCEDURE ASSIGN_STRATEGY( p_strategy_temp_id IN NUMBER,
33 p_objectid IN NUMBER,
34 p_objecttype IN VARCHAR2,
35 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2);
39 --End bug 6794510 gnramasa 5th Feb 08
40
41 /** update work item and call send signal
42 * if send signal fails, roolback the work item
43 **/
44
45 PROCEDURE UPDATE_AND_SENDSIGNAL( P_strategy_work_item_Rec IN
46 iex_strategy_work_items_pvt.strategy_work_item_Rec_Type,
47 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2);
51
52
53
54 /** update work item and call send signal
55 * if send signal fails, roolback the work item
56 * this is called from the JSP page , so passing
57 * columns instead of record type
58 * temporary fix till rosetta is fixed
59 * if the status is not changed to 'CLOSED'
60 * 'CANCELLED' THEN just update the work item
61 * do not call send signal
62 *06/21/02 --jsanju
63 **/
64
65 PROCEDURE UPDATE_AND_SENDSIGNAL(p_status IN VARCHAR2
66 ,p_work_item_id IN NUMBER
67 ,p_resource_id IN NUMBER
68 ,p_execute_start IN DATE DEFAULT NULL
69 ,p_execute_end IN DATE DEFAULT NULL
70 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
71 ,x_return_status OUT NOCOPY VARCHAR2
72 ,x_msg_count OUT NOCOPY NUMBER
73 ,x_msg_data OUT NOCOPY VARCHAR2);
74
75 --06/27
76 --this procedure check the status of the workflow
77 --will be called before "changing the strategy"
78 -- " update and skip to next work item"
79 -- if the work flow is in error, then
80 --display on the screen that the work flow is in error
81 --along with the error_message attribute
82 --if the workflow is not suspended and
83 --if the activity_name is null( that means
84 --it is not a escalation or optional task)
85 -- there has been a error. display message.
86 PROCEDURE CHECK_STRATEGY_WORKFLOW ( p_strategy IN NUMBER
87 ,x_return_status OUT NOCOPY VARCHAR2
88 ,x_return_message OUT NOCOPY VARCHAR2
89 ,x_wf_status OUT NOCOPY VARCHAR2);
90 /** update work item
91 *09/09/02 --jsanju requested by ctlee .being called from
92 * jsp/html
93 **/
94
95 PROCEDURE UPDATE_WORKITEM (p_status IN VARCHAR2
96 ,p_work_item_id IN NUMBER
97 ,p_resource_id IN NUMBER
98 ,p_execute_start IN DATE DEFAULT NULL
99 ,p_execute_end IN DATE DEFAULT NULL
100 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
101 ,x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2);
104
105 --
106 --show errors package body IEX_STRY_API_PUB
107 --/
108 --
109 --SELECT line, text FROM user_errors
110 --WHERE name = 'IEX_STRY_API_PUB'
111 --AND type = 'PACKAGE'
112 --/
113
114 PROCEDURE SHOW_IN_UWQ(
115
116 P_API_VERSION IN NUMBER,
117 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT 'F',
118 P_COMMIT IN VARCHAR2 DEFAULT 'F',
119 P_VALIDATION_LEVEL IN NUMBER DEFAULT 100,
120 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
121 X_MSG_COUNT OUT NOCOPY NUMBER,
122 X_MSG_DATA OUT NOCOPY VARCHAR2,
123 P_WORK_ITEM_ID_TBL IN DBMS_SQL.NUMBER_TABLE,
124 P_UWQ_STATUS IN VARCHAR2,
125 P_NO_DAYS IN NUMBER DEFAULT NULL);
126
127 /**
128 copy strategy work item template
129 **/
130 PROCEDURE COPY_WORK_ITEM_TEMPLATE( p_work_item_temp_id IN NUMBER,
131 p_new_work_item_temp_id IN NUMBER
132 );
133
134 --Begin bug#5474793 schekuri 21-Aug-2006
135 --Added this procedure to provide a way in workitem details form to skip the pre-wait or post wait of the work item
136 PROCEDURE SKIP_WAIT(p_strategy_id in number,
137 p_workitem_id in number,
138 p_wkitem_status in varchar2,
139 x_return_status out nocopy varchar2);
140 --End bug#5474793 schekuri 21-Aug-2006
141
142 END IEX_STRY_API_PUB;
143
144