DBA Data[Home] [Help]

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

Line 203: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE

199:
200: -- 14284768
201:
202: PROCEDURE insert_dispatched_tasks_nauto(
203: p_wdt_rec IN wms_dispatched_tasks%ROWTYPE
204: , p_source_task_id IN NUMBER
205: , x_return_status OUT NOCOPY VARCHAR2
206: , x_msg_count OUT NOCOPY NUMBER
207: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE