eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on WMS_OP_PLAN_INSTANCES

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

31:
32:
33: /**
34: *

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

36: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
37: * @param x_return_status - Return Status
38: * @param x_msg_count - Returns the Message Count
39: * @param x_msg_data - Returns Error Message

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

32:
33: /**
34: *

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

36: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
37: * @param x_return_status - Return Status
38: * @param x_msg_count - Returns the Message Count
39: * @param x_msg_data - Returns Error Message
40: */

Line 42: (p_insert_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,

38: * @param x_msg_count - Returns the Message Count
39: * @param x_msg_data - Returns Error Message
40: */
41: PROCEDURE insert_plan_instance
42: (p_insert_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
46:

Line 60: print_debug('Inserting Records into WMS_OP_PLAN_INSTANCES',l_module_name,9);

56: END IF;
57:
58:
59: IF (l_debug=1) THEN
60: print_debug('Inserting Records into WMS_OP_PLAN_INSTANCES',l_module_name,9);
61: END IF;
62:
63: INSERT INTO WMS_OP_PLAN_INSTANCES
64: (OP_PLAN_INSTANCE_ID,

Line 63: INSERT INTO WMS_OP_PLAN_INSTANCES

59: IF (l_debug=1) THEN
60: print_debug('Inserting Records into WMS_OP_PLAN_INSTANCES',l_module_name,9);
61: END IF;
62:
63: INSERT INTO WMS_OP_PLAN_INSTANCES
64: (OP_PLAN_INSTANCE_ID,
65: OPERATION_PLAN_ID,
66: ACTIVITY_TYPE_ID,
67: PLAN_TYPE_ID,

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

152:
153:
154: /**
155: *

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

157: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
158: * @param x_return_status - Return Status
159: * @param x_msg_count - Returns Message Count
160: * @param x_msg_data - Returns Error Message

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

153:
154: /**
155: *

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

157: * @param p_insert_rec - Record Variable of type WMS_OP_PLAN_INSTANCES%rowtype
158: * @param x_return_status - Return Status
159: * @param x_msg_count - Returns Message Count
160: * @param x_msg_data - Returns Error Message
161: */

Line 163: (p_update_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,

159: * @param x_msg_count - Returns Message Count
160: * @param x_msg_data - Returns Error Message
161: */
162: PROCEDURE update_plan_instance
163: (p_update_rec IN WMS_OP_PLAN_INSTANCES%ROWTYPE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
167:

Line 187: print_debug('Updating WMS_OP_PLAN_INSTANCES',l_module_name,3);

183: RAISE fnd_api.g_exc_error;
184: END IF;
185:
186: IF (l_debug=1) THEN
187: print_debug('Updating WMS_OP_PLAN_INSTANCES',l_module_name,3);
188: END IF;
189:
190: /*Updating WOPI*/
191: UPDATE WMS_OP_PLAN_INSTANCES

Line 191: UPDATE WMS_OP_PLAN_INSTANCES

187: print_debug('Updating WMS_OP_PLAN_INSTANCES',l_module_name,3);
188: END IF;
189:
190: /*Updating WOPI*/
191: UPDATE WMS_OP_PLAN_INSTANCES
192: SET
193: OP_PLAN_INSTANCE_ID = decode(p_update_rec.OP_PLAN_INSTANCE_ID,G_MISS_NUM,NULL,NULL,OP_PLAN_INSTANCE_ID,p_update_rec.OP_PLAN_INSTANCE_ID),
194: OPERATION_PLAN_ID = decode(p_update_rec.OPERATION_PLAN_ID,G_MISS_NUM,NULL,NULL,OPERATION_PLAN_ID,p_update_rec.OPERATION_PLAN_ID),
195: ACTIVITY_TYPE_ID = decode(p_update_rec.ACTIVITY_TYPE_ID,G_MISS_NUM,NULL,NULL,ACTIVITY_TYPE_ID,p_update_rec.ACTIVITY_TYPE_ID),

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

257: END;
258:
259: /**
260: *

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

262: * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be deleted
263: * @param x_return_status - Return Status
264: * @param x_msg_count - Returns Message Count
265: * @param x_msg_data - Returns Error Message

Line 295: DELETE FROM WMS_OP_PLAN_INSTANCES

291: IF (l_debug=1) THEN
292: print_debug('Deleting Plan Instances','Delete_Plan_instance',9);
293: END IF;
294:
295: DELETE FROM WMS_OP_PLAN_INSTANCES
296: WHERE OP_PLAN_INSTANCE_ID = P_op_plan_instance_id;
297:
298: IF SQL%notfound THEN
299: IF (l_debug=1) THEN

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

456:
457:
458: /**
459: *

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

461: * @param p_operation_instance_id - Plan Instance Id of all the Operations that has to be deleted
462: * @param x_return_status - Return Status
463: * @param x_msg_count - Returns Message Count
464: * @param x_msg_data - Returns Error Message

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

528:
529:
530: /**
531: *

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

533: * @param p_update_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype
534: * @param x_return_status - Return Status
535: * @param x_msg_count - Returns Message Count
536: * @param x_msg_data - Returns Error Message

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

642: END;
643:
644: /**
645: *

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

647: * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be archived.
648: * @param p_inventory_item_id Inventory Item Id of the Plan
649: * @param p_transaction_quantity Transaction Quantitity of the Plan
650: * @param p_transaction_uom Transaction UOM of the Plan

Line 690: INSERT INTO WMS_OP_PLAN_INSTANCES_HIST

686: print_debug('Archiving Plan Instances',l_module_name,9);
687: END IF;
688: l_progress:=20;
689:
690: INSERT INTO WMS_OP_PLAN_INSTANCES_HIST
691: (OP_PLAN_INSTANCE_ID,
692: OPERATION_PLAN_ID,
693: ACTIVITY_TYPE_ID,
694: PLAN_TYPE_ID,

Line 758: FROM WMS_OP_PLAN_INSTANCES

754: ATTRIBUTE12,
755: ATTRIBUTE13,
756: ATTRIBUTE14,
757: ATTRIBUTE15
758: FROM WMS_OP_PLAN_INSTANCES
759: WHERE op_plan_instance_id=p_op_plan_instance_id);
760:
761: IF (l_debug=1) THEN
762: print_debug('Records inserted into WMS_OP_PLAN_INSTANCES_HISTORY '||SQL%ROWCOUNT,l_module_name,9);

Line 762: print_debug('Records inserted into WMS_OP_PLAN_INSTANCES_HISTORY '||SQL%ROWCOUNT,l_module_name,9);

758: FROM WMS_OP_PLAN_INSTANCES
759: WHERE op_plan_instance_id=p_op_plan_instance_id);
760:
761: IF (l_debug=1) THEN
762: print_debug('Records inserted into WMS_OP_PLAN_INSTANCES_HISTORY '||SQL%ROWCOUNT,l_module_name,9);
763: END IF;
764: l_progress:=30;
765:
766: INSERT INTO WMS_OP_OPERTN_INSTANCES_HIST

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

900:
901:
902: /**
903: *

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

905: * @param p_op_plan_instance_id - Operation Plan Instance Id of the Plan that has to be completed.
906: * @param x_return_status - Return Status
907: * @param x_msg_count - Returns Message Count
908: * @param x_msg_data - Returns Error Message

Line 944: UPDATE WMS_OP_PLAN_INSTANCES

940: print_debug('Updating the Plan status to completed',l_module_name,9);
941: END IF;
942:
943: /*Updating the Plan Status to Completed*/
944: UPDATE WMS_OP_PLAN_INSTANCES
945: SET status=WMS_GLOBALS.G_OP_INS_STAT_COMPLETED
946: WHERE op_plan_instance_id=p_op_plan_instance_id;
947:
948: