APPS.EAM_ASSET_OPERATION_TXN_PVT dependencies on QA_RESULTS

Line 300: qa_results_pub.insert_row(

296: END IF;
297: END LOOP;
298:
299:
300: qa_results_pub.insert_row(
301: p_api_version => 1.0,
302: p_init_msg_list => fnd_api.g_true,
303: p_org_id => l_org_id,
304: p_plan_id => l_header_plan_id_tbl(plan_id),

Line 330: qa_results qr

326:
327: BEGIN
328: select qp.name into l_plan_name
329: from qa_plans qp,
330: qa_results qr
331: where
332: qr.collection_id = l_collection_id
333: and
334: qr.plan_id = qp.plan_id;

Line 392: QA_RESULTS

388: SELECT distinct plan_id
389: bulk collect into
390: l_planid_tbl
391: from
392: QA_RESULTS
393: where
394: collection_id = l_collection_id;
395:
396: IF l_planid_tbl.COUNT>0 THEN

Line 935: qa_results qr

931:
932: CURSOR get_plan_name(qa_collection_id IN NUMBER) IS
933: (select qp.name
934: from qa_plans qp,
935: qa_results qr
936: where
937: qr.collection_id = qa_collection_id
938: and
939: qr.plan_id = qp.plan_id);

Line 945: QA_RESULTS

941: CURSOR get_plan_id(p_qa_collection_id IN NUMBER) IS
942: (SELECT
943: distinct Plan_Id
944: from
945: QA_RESULTS
946: where
947: collection_id = p_qa_collection_id
948: );
949: