APPS.WMS_TASK_MGMT_PUB dependencies on WMS_OP_PLAN_INSTANCES

Line 589: SELECT STATUS FROM wms_op_plan_instances

585: FROM WMS_OP_PLANS_B
586: WHERE operation_plan_id=v_operation_plan_id;
587:
588: CURSOR C_OP_OPERATIONS_STATUS(v_source_task_id NUMBER) IS
589: SELECT STATUS FROM wms_op_plan_instances
590: WHERE ((
591: source_task_id in
592: (SELECT parent_line_id
593: FROM mtl_material_transactions_temp

Line 922: inv_trx_util_pub.trace('updating wms_op_plan_instances.........');

918: RETURN;
919: END IF;
920: CLOSE C_OP_PLANS_B;
921: ELSE
922: inv_trx_util_pub.trace('updating wms_op_plan_instances.........');
923: UPDATE wms_op_plan_instances
924: SET OPERATION_PLAN_ID=l_op_plan_b_rec.OPERATION_PLAN_ID,
925: SYSTEM_TASK_TYPE =l_op_plan_b_rec.SYSTEM_TASK_TYPE ,
926: ACTIVITY_TYPE_ID =l_op_plan_b_rec.ACTIVITY_TYPE_ID ,

Line 923: UPDATE wms_op_plan_instances

919: END IF;
920: CLOSE C_OP_PLANS_B;
921: ELSE
922: inv_trx_util_pub.trace('updating wms_op_plan_instances.........');
923: UPDATE wms_op_plan_instances
924: SET OPERATION_PLAN_ID=l_op_plan_b_rec.OPERATION_PLAN_ID,
925: SYSTEM_TASK_TYPE =l_op_plan_b_rec.SYSTEM_TASK_TYPE ,
926: ACTIVITY_TYPE_ID =l_op_plan_b_rec.ACTIVITY_TYPE_ID ,
927: PLAN_TYPE_ID =l_op_plan_b_rec.PLAN_TYPE_ID

Line 973: l_msg := 'STATUS in wms_op_plan_instances is not pending';

969: ELSE
970: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
971: fnd_msg_pub.ADD;
972: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
973: l_msg := 'STATUS in wms_op_plan_instances is not pending';
974: IF(l_debug = 1) THEN
975: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
976: END IF;
977: p_output_task_rec.RESULT := 'E';

Line 4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec

4598: l_return_status VARCHAR2(1);
4599: l_transaction_number NUMBER ;
4600: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4601: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4602: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4603: exc_not_deleted EXCEPTION;
4604: l_op_plan_status NUMBER ;
4605: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4606: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

Line 4661: FROM WMS_OP_PLAN_INSTANCES

4657: IS
4658: SELECT status ,
4659: orig_dest_sub_code ,
4660: orig_dest_loc_id
4661: FROM WMS_OP_PLAN_INSTANCES
4662: WHERE source_task_id = l_transaction_record.parent_line_id;
4663: BEGIN
4664: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4665: x_return_status := fnd_api.g_ret_sts_success;

Line 4740: FROM wms_op_plan_instances

4736: IF l_move_order_rec.backorder_delivery_detail_id IS NULL THEN
4737: l_progress := '350';
4738: --delete operation plan tables (wopi and wooi)
4739: DELETE
4740: FROM wms_op_plan_instances
4741: WHERE source_task_id = l_transaction_record.parent_line_id;
4742: IF SQL%ROWCOUNT =0 THEN
4743: IF l_debug =1 THEN
4744: debug_print('Count not delete the Plan Instance of this task');