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.
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