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_OPERATION_INSTANCES

Line 328: * This procedure inserts data into the table WMS_OP_OPERATION_INSTANCES.

324: END;
325:
326: /**
327: *

Procedure:Insert_operation_instance
328: * This procedure inserts data into the table WMS_OP_OPERATION_INSTANCES.

329: * @param p_insert_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype
330: * @param x_return_status - Return Status
331: * @param x_msg_count - Returns Message Count
332: * @param x_msg_data - Returns Error Message

Line 329: * @param p_insert_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype

325:
326: /**
327: *

Procedure:Insert_operation_instance
328: * This procedure inserts data into the table WMS_OP_OPERATION_INSTANCES.

329: * @param p_insert_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype
330: * @param x_return_status - Return Status
331: * @param x_msg_count - Returns Message Count
332: * @param x_msg_data - Returns Error Message
333: */

Line 336: (p_insert_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,

332: * @param x_msg_data - Returns Error Message
333: */
334:
335: PROCEDURE insert_operation_instance
336: (p_insert_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE) IS
340:

Line 351: print_debug('Inserting records into WMS_OP_OPERATION_INSTANCES',l_module_name,9);

347: print_debug('Operation Instance Id:'||p_insert_rec.operation_instance_id,l_module_name,3);
348: END IF;
349:
350: IF (l_debug=1) THEN
351: print_debug('Inserting records into WMS_OP_OPERATION_INSTANCES',l_module_name,9);
352: END IF;
353:
354: INSERT INTO WMS_OP_OPERATION_INSTANCES (
355: OPERATION_INSTANCE_ID,

Line 354: INSERT INTO WMS_OP_OPERATION_INSTANCES (

350: IF (l_debug=1) THEN
351: print_debug('Inserting records into WMS_OP_OPERATION_INSTANCES',l_module_name,9);
352: END IF;
353:
354: INSERT INTO WMS_OP_OPERATION_INSTANCES (
355: OPERATION_INSTANCE_ID,
356: OPERATION_PLAN_DETAIL_ID,
357: OPERATION_SEQUENCE,
358: OPERATION_TYPE_ID,

Line 491: print_debug('Deleting Records from WMS_OP_OPERATION_INSTANCES',l_module_name,9);

487: RAISE fnd_api.G_exc_error;
488: END IF;
489:
490: IF (l_debug=1) THEN
491: print_debug('Deleting Records from WMS_OP_OPERATION_INSTANCES',l_module_name,9);
492: END IF;
493:
494: DELETE FROM wms_op_operation_instances
495: WHERE operation_instance_id = p_operation_instance_id;

Line 494: DELETE FROM wms_op_operation_instances

490: IF (l_debug=1) THEN
491: print_debug('Deleting Records from WMS_OP_OPERATION_INSTANCES',l_module_name,9);
492: END IF;
493:
494: DELETE FROM wms_op_operation_instances
495: WHERE operation_instance_id = p_operation_instance_id;
496:
497: IF (SQL%notfound) THEN
498: IF (l_debug=1) THEN

Line 533: * @param p_update_rec - Record Variable of type WMS_OP_OPERATION_INSTANCES%rowtype

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

Line 539: (p_update_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,

535: * @param x_msg_count - Returns Message Count
536: * @param x_msg_data - Returns Error Message
537: */
538: PROCEDURE update_operation_instance
539: (p_update_rec IN WMS_OP_OPERATION_INSTANCES%ROWTYPE,
540: x_return_status OUT NOCOPY VARCHAR2,
541: x_msg_count OUT NOCOPY NUMBER,
542: x_msg_data OUT NOCOPY FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE)IS
543:

Line 568: UPDATE wms_op_operation_instances

564: print_debug('Updating Operation instance',l_module_name,9);
565: END IF;
566:
567: /**Updating Operation Instances*/
568: UPDATE wms_op_operation_instances
569: SET
570: OPERATION_INSTANCE_ID =decode(p_update_rec.OPERATION_INSTANCE_ID,G_MISS_NUM,NULL,NULL,OPERATION_INSTANCE_ID,p_update_rec.OPERATION_INSTANCE_ID),
571: OPERATION_PLAN_DETAIL_ID=decode(p_update_rec.OPERATION_PLAN_DETAIL_ID,G_MISS_NUM,NULL,NULL,OPERATION_PLAN_DETAIL_ID,p_update_rec.OPERATION_PLAN_DETAIL_ID),
572: OPERATION_SEQUENCE =decode(p_update_rec.OPERATION_SEQUENCE,G_MISS_NUM,NULL,NULL,OPERATION_SEQUENCE,p_update_rec.OPERATION_SEQUENCE),

Line 849: FROM WMS_OP_OPERATION_INSTANCES

845: ,ATTRIBUTE12
846: ,ATTRIBUTE13
847: ,ATTRIBUTE14
848: ,ATTRIBUTE15
849: FROM WMS_OP_OPERATION_INSTANCES
850: WHERE OP_PLAN_INSTANCE_ID=p_op_plan_instance_id);
851:
852: l_progress:=40;
853:

Line 857: print_debug('Deleting Operation Instances from WMS_OP_OPERATION_INSTANCES',l_module_name,9);

853:
854:
855: IF (l_debug=1) THEN
856: print_debug('Records inserted into WMS_OP_OPERTN_INSTANCES_HIST '||SQL%ROWCOUNT,l_module_name,9);
857: print_debug('Deleting Operation Instances from WMS_OP_OPERATION_INSTANCES',l_module_name,9);
858: END IF;
859:
860:
861: DELETE FROM WMS_OP_OPERATION_INSTANCES

Line 861: DELETE FROM WMS_OP_OPERATION_INSTANCES

857: print_debug('Deleting Operation Instances from WMS_OP_OPERATION_INSTANCES',l_module_name,9);
858: END IF;
859:
860:
861: DELETE FROM WMS_OP_OPERATION_INSTANCES
862: WHERE op_plan_instance_id=p_op_plan_instance_id;
863:
864: l_progress:=50;
865:

Line 867: print_debug('Deleted records form WMS_OP_OPERATION_INSTANCES'||SQL%ROWCOUNT,l_module_name,9);

863:
864: l_progress:=50;
865:
866: IF (l_debug=1) THEN
867: print_debug('Deleted records form WMS_OP_OPERATION_INSTANCES'||SQL%ROWCOUNT,l_module_name,9);
868: print_debug('Calling Delete_plan_instance to delete the Plan instance record',l_module_name,9);
869: END IF;
870:
871: DELETE_PLAN_INSTANCE(p_op_plan_instance_id,x_return_status,x_msg_data,x_msg_count);