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 , Bug#8978253
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 , Bug#8978253
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 4691: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec

4687: l_return_status VARCHAR2(1);
4688: l_transaction_number NUMBER ;
4689: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4690: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4691: l_op_plan_rec wms_op_plan_instances%rowtype ; --WOPI rec
4692: exc_not_deleted EXCEPTION;
4693: l_op_plan_status NUMBER ;
4694: l_g_ret_sts_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_error;
4695: l_g_ret_sts_unexp_error CONSTANT VARCHAR2(30) := fnd_api.g_ret_sts_unexp_error;

Line 4750: FROM WMS_OP_PLAN_INSTANCES

4746: IS
4747: SELECT status ,
4748: orig_dest_sub_code ,
4749: orig_dest_loc_id
4750: FROM WMS_OP_PLAN_INSTANCES
4751: WHERE source_task_id = l_transaction_record.parent_line_id;
4752: BEGIN
4753: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
4754: x_return_status := fnd_api.g_ret_sts_success;

Line 4829: FROM wms_op_plan_instances

4825: IF l_move_order_rec.backorder_delivery_detail_id IS NULL THEN
4826: l_progress := '350';
4827: --delete operation plan tables (wopi and wooi)
4828: DELETE
4829: FROM wms_op_plan_instances
4830: WHERE source_task_id = l_transaction_record.parent_line_id;
4831: IF SQL%ROWCOUNT =0 THEN
4832: IF l_debug =1 THEN
4833: debug_print('Count not delete the Plan Instance of this task');