11999: l_asset_ops_return_status VARCHAR2(1);
12000: begin
12001:
12002: select qp.plan_id,name bulk collect into l_plan_id_tbl,l_plan_name_tbl 12003: from qa_results qr,qa_plans qp 12004: where qr.plan_id = qp.plan_id
12005: and collection_id = l_eam_wo_comp_rec.qa_collection_id;
12006:
12007: IF l_plan_id_tbl.COUNT > 0 THEN