APPS.GMO_CBR_GRP dependencies on QA_RESULTS

Line 670: cursor cur_qa_results IS

666: l_smpl_source VARCHAR2(1) :=NULL;
667: l_include_in_CBR VARCHAR2(10) := 'XML';
668: l_external_event VARCHAR2(1) :='N';
669: l_compare_XML VARCHAR2(1) :='Y';
670: cursor cur_qa_results IS
671: SELECT PROCESS_BATCH_ID
672: ,PROCESS_BATCHSTEP_ID
673: ,PROCESS_OPERATION_ID
674: ,PROCESS_ACTIVITY_ID

Line 677: FROM QA_RESULTS

673: ,PROCESS_OPERATION_ID
674: ,PROCESS_ACTIVITY_ID
675: ,PROCESS_RESOURCE_ID
676: ,PROCESS_PARAMETER_ID
677: FROM QA_RESULTS
678: WHERE
679: plan_id = l_plan_id
680: AND collection_id = l_collection_id
681: AND occurrence = l_occurrence ;

Line 733: OPEN cur_qa_results;

729: -- check current NCM is related to production batch
730: -- if current is not belogns to production batch then
731: -- we do not require to process
732: --
733: OPEN cur_qa_results;
734: FETCH cur_qa_results INTO l_batch_id,l_batchstep_id,l_operation_id,l_batch_activity_id,l_batch_rsrc_id,l_parameter_id;
735: CLOSE cur_qa_results;
736: IF l_batch_id is null THEN
737: RETURN 'SUCCESS';

Line 734: FETCH cur_qa_results INTO l_batch_id,l_batchstep_id,l_operation_id,l_batch_activity_id,l_batch_rsrc_id,l_parameter_id;

730: -- if current is not belogns to production batch then
731: -- we do not require to process
732: --
733: OPEN cur_qa_results;
734: FETCH cur_qa_results INTO l_batch_id,l_batchstep_id,l_operation_id,l_batch_activity_id,l_batch_rsrc_id,l_parameter_id;
735: CLOSE cur_qa_results;
736: IF l_batch_id is null THEN
737: RETURN 'SUCCESS';
738: END IF;

Line 735: CLOSE cur_qa_results;

731: -- we do not require to process
732: --
733: OPEN cur_qa_results;
734: FETCH cur_qa_results INTO l_batch_id,l_batchstep_id,l_operation_id,l_batch_activity_id,l_batch_rsrc_id,l_parameter_id;
735: CLOSE cur_qa_results;
736: IF l_batch_id is null THEN
737: RETURN 'SUCCESS';
738: END IF;
739: l_message_prod := 'GMO';