1 PACKAGE wms_op_runtime_pvt_apis AS
2 /*$Header: WMSOPPVS.pls 120.0.12000000.1 2007/01/16 06:54:59 appldev ship $*/
3
4 /**
5 * <p>Procedure:<b>Insert_Plan_instance</b>
6 * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.</p>
7 * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
8 * @param x_return_status - Return Status
9 * @param x_msg_count - Returns the Message Count
10 * @param x_msg_data - Returns Error Message
11 */
12 PROCEDURE insert_plan_instance(
13 p_insert_rec IN wms_op_plan_instances%ROWTYPE
14 , x_return_status OUT NOCOPY VARCHAR2
15 , x_msg_count OUT NOCOPY NUMBER
16 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
17 );
18
19 /**
20 * <p>Procedure:<b>Update_Plan_instance</b>
21 * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.</p>
22 * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
23 * @param x_return_status - Return Status
24 * @param x_msg_count - Returns Message Count
25 * @param x_msg_data - Returns Error Message
26 */
27 PROCEDURE update_plan_instance(
28 p_update_rec IN wms_op_plan_instances%ROWTYPE
29 , x_return_status OUT NOCOPY VARCHAR2
30 , x_msg_count OUT NOCOPY NUMBER
31 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
32 );
33
34 /**
35 * <p>Procedure:<b>Delete_Plan_instance</b>
36 * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.</p>
37 * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be deleted
38 * @param x_return_status - Return Status
39 * @param x_msg_count - Returns Message Count
40 * @param x_msg_data - Returns Error Message
41 */
42 PROCEDURE delete_plan_instance(
43 p_op_plan_instance_id IN NUMBER
44 , x_return_status OUT NOCOPY VARCHAR2
45 , x_msg_count OUT NOCOPY NUMBER
46 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
47 );
48
49 /**
50 * <p>Procedure:<b>Archive_Plan_instance</b>
51 * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.</p>
52 * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be archived.
53 * @param p_inventory_item_id Inventory Item Id of the Plan
54 * @param p_transaction_quantity Transaction Quantitity of the Plan
55 * @param p_transaction_uom Transaction UOM of the Plan
56 * @param x_return_status - Return Status
57 * @param x_msg_count - Returns Message Count
58 * @param x_msg_data - Returns Error Message
59 */
60 PROCEDURE archive_plan_instance(
61 p_op_plan_instance_id IN NUMBER
62 , x_return_status OUT NOCOPY VARCHAR2
63 , x_msg_count OUT NOCOPY NUMBER
64 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE);
65
66 /**
67 * <p>Procedure:<b>Complete_Plan_instance</b>
68 * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.</p>
69 * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be completed.
70 * @param x_return_status - Return Status
71 * @param x_msg_count - Returns Message Count
72 * @param x_msg_data - Returns Error Message
73 */
74 PROCEDURE complete_plan_instance(
75 p_op_plan_instance_id IN NUMBER
76 , x_return_status OUT NOCOPY VARCHAR2
77 , x_msg_count OUT NOCOPY NUMBER
78 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
79 );
80
81 /**
82 * <p>Procedure:<b>Insert_operation_instance</b>
83 * This procedure inserts data into the table WMS_OP_OPERATION_INSTANCES.</p>
84 * @param p_insert_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype
85 * @param x_return_status - Return Status
86 * @param x_msg_count - Returns Message Count
87 * @param x_msg_data - Returns Error Message
88 */
89 PROCEDURE insert_operation_instance(
90 p_insert_rec IN wms_op_operation_instances%ROWTYPE
91 , x_return_status OUT NOCOPY VARCHAR2
92 , x_msg_count OUT NOCOPY NUMBER
93 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
94 );
95
96 /**
97 * <p>Procedure:<b>Update_Operation_instance</b>
98 * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.</p>
99 * @param p_update_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype
100 * @param x_return_status - Return Status
101 * @param x_msg_count - Returns Message Count
102 * @param x_msg_data - Returns Error Message
103 */
104 PROCEDURE update_operation_instance(
105 p_update_rec IN wms_op_operation_instances%ROWTYPE
106 , x_return_status OUT NOCOPY VARCHAR2
107 , x_msg_count OUT NOCOPY NUMBER
108 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
109 );
110
111 /**
112 * <p>Procedure:<b>Delete_Operation_instance</b>
113 * This procedure deletes the data in the table WMS_OP_PLAN_INSTANCES.</p>
114 * @param p_op_plan_instance_id - Plan Instance Id of all the Operations that has to be deleted
115 * @param x_return_status - Return Status
116 * @param x_msg_count - Returns Message Count
117 * @param x_msg_data - Returns Error Message
118 */
119 PROCEDURE delete_operation_instance(
120 p_operation_instance_id NUMBER
121 , x_return_status OUT NOCOPY VARCHAR2
122 , x_msg_count OUT NOCOPY NUMBER
123 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
124 );
125
126
127 /**
128 * <p>Procedure:<b>Update_Dispatched_tasks</b>
129 * This procedure updates the task records in WMS_DISPATCHED_TASKS</p>
130 * @param p_wdt_rec - WDT record that has to be updated.
131 * @param x_return_status - Return Status
132 * @param x_msg_count - Returns Message Count
133 * @param x_msg_data - Returns Error Message
134 */
135 PROCEDURE update_dipatched_tasks(
136 p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
137 , x_return_status OUT NOCOPY VARCHAR2
138 , x_msg_count OUT NOCOPY NUMBER
139 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
140 );
141
142 /**
143 * <p>Procedure:<b>Insert_Dispatched_tasks</b>
144 * This procedure inserts the task records into WMS_DISPATCHED_TASKS</p>
145 * AND THERE IS AN AUTONOMOUS COMMIT IN THIS INSERT!!!
146 * @param p_wdt_rec - WDT record that has to be inserted.
147 * @param p_source_task_id - Transaction Temp Id of the WDT record.
148 * @param x_return_status - Return Status
149 * @param x_msg_count - Returns Message Count
150 * @param x_msg_data - Returns Error Message
151 */
152 PROCEDURE insert_dispatched_tasks(
153 p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
154 , p_source_task_id IN NUMBER
155 , x_return_status OUT NOCOPY VARCHAR2
156 , x_msg_count OUT NOCOPY NUMBER
157 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
158 );
159
160 /**
161 * <p>Procedure:<b>Delete_Dispatched_taska</b>
162 * This procedure deletes the task records into WMS_DISPATCHED_TASKS</p>
163 * AND THERE IS AN AUTOMONOUS COMMIT IN THIS DELETE!
164 * SO IT SHOULD ONLY BE USED TO DELETE WDT CREATED BY insert_dispatched_tasks.
165 * @param p_source_task_id - Transaction Temp Id of the WDT record.
166 * @param x_return_status - Return Status
167 * @param x_msg_count - Returns Message Count
168 * @param x_msg_data - Returns Error Message
169 */
170 PROCEDURE delete_dispatched_task
171 (
172 p_source_task_id IN NUMBER
173 , p_wms_task_type IN NUMBER
174 , x_return_status OUT NOCOPY VARCHAR2
175 , x_msg_count OUT NOCOPY NUMBER
176 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
177 );
178
179 /**
180 * <p>Procedure:<b>Archive_Dispatched_tasks</b>
181 * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY</p>
182 * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
183 * @param p_source_task_id - Document Id for the Parent document record
184 * @param p_activity_type_id - Activity Type Id
185 * @param p_op_plan_instance_id - Operation Plan Id for the Parent Record
186 * @param p_op_plan_status - Plan Status for the parent record to be archived
187 */
188
189 PROCEDURE archive_dispatched_tasks(
190 x_return_status OUT NOCOPY VARCHAR2
191 , x_msg_count OUT NOCOPY NUMBER
192 , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE
193 , p_task_id IN NUMBER
194 , p_source_task_id IN NUMBER
195 , p_activity_type_id IN NUMBER
196 , p_op_plan_instance_id IN NUMBER
197 , p_op_plan_status IN NUMBER
198 );
199
200
201
202
203 END wms_op_runtime_pvt_apis;