APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on WMS_DISPATCHED_TASKS
Line 129: * This procedure updates the task records in WMS_DISPATCHED_TASKS
125:
126:
127: /**
128: *
Procedure:Update_Dispatched_tasks 129: * This procedure updates the task records in WMS_DISPATCHED_TASKS
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
Line 136: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
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: );
Line 144: * This procedure inserts the task records into WMS_DISPATCHED_TASKS
140: );
141:
142: /**
143: *
Procedure:Insert_Dispatched_tasks 144: * This procedure inserts the task records into WMS_DISPATCHED_TASKS
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
Line 153: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
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
Line 162: * This procedure deletes the task records into WMS_DISPATCHED_TASKS
158: );
159:
160: /**
161: *
Procedure:Delete_Dispatched_taska 162: * This procedure deletes the task records into WMS_DISPATCHED_TASKS
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
Line 181: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY
177: );
178:
179: /**
180: *
Procedure:Archive_Dispatched_tasks 181: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY
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
Line 182: * @param p_task_id - Task Id of WMS_DISPATCHED_TASKS
178:
179: /**
180: *
Procedure:Archive_Dispatched_tasks
181: * This procedure archives the task records into WMS_DISPATCHED_TASKS_HISTORY
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