[Home] [Help]
581: SELECT OPERATION_PLAN_ID,
582: SYSTEM_TASK_TYPE,
583: ACTIVITY_TYPE_ID,
584: PLAN_TYPE_ID
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
839:
840: IF (p_task_rec.OPERATION_PLAN_ID IS NOT NULL AND p_op_plan_rec.plan_type_id IS NOT NULL) THEN
841: SELECT PLAN_TYPE_ID
842: INTO l_operation_plan_type_id
843: FROM wms_op_plans_b
844: WHERE OPERATION_PLAN_ID=p_task_rec.OPERATION_PLAN_ID;
845:
846: IF (l_operation_plan_type_id IS NOT NULL ) THEN
847: /* An inspection operation plan can be replaced with another inspection operation plan and
904: FETCH C_OP_PLANS_B
905: INTO l_op_plan_b_rec;
906: IF (C_OP_PLANS_B%NOTFOUND) THEN
907: IF (l_debug=1) THEN
908: inv_trx_util_pub.trace('Records not found in WMS_OP_PLANS_B for given p_new_operation_plan_id');
909: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
910: fnd_msg_pub.ADD;
911: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
912: l_msg := 'No of Records found in WMS_OP_PLANS_B for given operation plan id';
908: inv_trx_util_pub.trace('Records not found in WMS_OP_PLANS_B for given p_new_operation_plan_id');
909: fnd_message.set_name('WMS', ' WMS_INVALID_TASK');--new message
910: fnd_msg_pub.ADD;
911: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE,p_count => l_msg_count, p_data => l_err_msg );
912: l_msg := 'No of Records found in WMS_OP_PLANS_B for given operation plan id';
913: IF(l_debug = 1) THEN
914: inv_trx_util_pub.trace(l_api_name|| ': '||l_msg);
915: END IF;
916: p_output_task_rec.RESULT := 'E';
7200: enabled_flag ,
7201: activity_type_id ,
7202: common_to_all_org,
7203: plan_type_id
7204: FROM wms_op_plans_b
7205: WHERE operation_plan_id=c_op_plan_id;
7206: --Cursor to lock the mmtt record before updation.
7207: Cursor c_lock_mmtt (p_transaction_number NUMBER)
7208: IS