APPS.GMO_CBR_GRP dependencies on QA_RESULTS

Line 671: cursor cur_qa_results IS

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

Line 678: FROM QA_RESULTS

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

Line 759: OPEN cur_qa_results;

755: -- check current NCM is related to production batch
756: -- if current is not belogns to production batch then
757: -- we do not require to process
758: --
759: OPEN cur_qa_results;
760: 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;
761: CLOSE cur_qa_results;
762: IF l_batch_id is null THEN
763: RETURN 'SUCCESS';

Line 760: 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;

756: -- if current is not belogns to production batch then
757: -- we do not require to process
758: --
759: OPEN cur_qa_results;
760: 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;
761: CLOSE cur_qa_results;
762: IF l_batch_id is null THEN
763: RETURN 'SUCCESS';
764: END IF;

Line 761: CLOSE cur_qa_results;

757: -- we do not require to process
758: --
759: OPEN cur_qa_results;
760: 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;
761: CLOSE cur_qa_results;
762: IF l_batch_id is null THEN
763: RETURN 'SUCCESS';
764: END IF;
765: l_message_prod := 'GMO';