DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_PVT dependencies on QA_RESULTS

Line 12400: from qa_results qr,qa_plans qp

12396: BEGIN
12397:
12398: select qp.plan_id,name bulk collect
12399: into l_plan_id_tbl,l_plan_name_tbl
12400: from qa_results qr,qa_plans qp
12401: where qr.plan_id = qp.plan_id
12402: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12403:
12404: END;

Line 12655: from qa_results qr,qa_plans qp

12651: begin
12652: --BUG12914431. commented below code and moved it above
12653: /*
12654: select qp.plan_id,name bulk collect into l_plan_id_tbl,l_plan_name_tbl
12655: from qa_results qr,qa_plans qp
12656: where qr.plan_id = qp.plan_id
12657: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12658: */
12659: IF l_plan_id_tbl.COUNT > 0 THEN

Line 13263: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Calling qa_results_pub.enable_and_fire_action . . .'); END IF;

13259:
13260: raise EXC_SEV_QUIT_RECORD;
13261: END ;
13262:
13263: IF GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Operation Completeion Calling qa_results_pub.enable_and_fire_action . . .'); END IF;
13264:
13265: qa_result_grp.enable_and_fire_action(
13266: p_api_version => 1.0 ,
13267: p_collection_id => l_eam_op_comp_rec.qa_collection_id ,