DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on WMS_OP_PLAN_INSTANCES

Line 6: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


2: /*$Header: WMSOPPVS.pls 120.0.12000000.1 2007/01/16 06:54:59 appldev ship $*/
3:
4: /**
5: *

Procedure:Insert_Plan_instance
6: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


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

Line 7: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype

3:
4: /**
5: *

Procedure:Insert_Plan_instance
6: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


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: */

Line 13: p_insert_rec IN wms_op_plan_instances%ROWTYPE

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: );

Line 21: * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.


17: );
18:
19: /**
20: *

Procedure:Update_Plan_instance
21: * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.


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

Line 22: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype

18:
19: /**
20: *

Procedure:Update_Plan_instance
21: * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.


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: */

Line 28: p_update_rec IN wms_op_plan_instances%ROWTYPE

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: );

Line 36: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


32: );
33:
34: /**
35: *

Procedure:Delete_Plan_instance
36: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


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

Line 51: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


47: );
48:
49: /**
50: *

Procedure:Archive_Plan_instance
51: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


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

Line 68: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


64: , x_msg_data OUT NOCOPY fnd_new_messages.MESSAGE_TEXT%TYPE);
65:
66: /**
67: *

Procedure:Complete_Plan_instance
68: * This procedure inserts data into the table WMS_OP_PLAN_INSTANCES.


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

Line 98: * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.


94: );
95:
96: /**
97: *

Procedure:Update_Operation_instance
98: * This procedure updates data into the table WMS_OP_PLAN_INSTANCES.


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

Line 113: * This procedure deletes the data in the table WMS_OP_PLAN_INSTANCES.


109: );
110:
111: /**
112: *

Procedure:Delete_Operation_instance
113: * This procedure deletes the data in the table WMS_OP_PLAN_INSTANCES.


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