[Home] [Help]
736:
737: -- Get the Organization ID of the Counter Reading Plan
738: SELECT organization_id
739: INTO l_organization_id
740: FROM QA_PLANS
741: WHERE plan_id = G_CTR_READING_PLAN_ID;
742:
743: -- Post the Results for the Counter Reading Plan in Oracle Quality
744: -- Note :- The p_commit flag is TRUE because, actions have to fired for
5628: SELECT qa.plan_id from qa_results qa
5629: where qa.collection_id = p_collection_id and rownum < 2;
5630:
5631: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
5632: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
5633: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
5634: AND QP.organization_id = p_org_id
5635: AND QPT.transaction_number in (9999,2001)
5636: AND QPCT.collection_trigger_id = 87
7839: SELECT qa.plan_id from qa_results qa
7840: where qa.collection_id = p_collection_id and rownum < 2;
7841:
7842: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
7843: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
7844: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
7845: AND QP.organization_id = p_org_id
7846: AND QPT.transaction_number in (9999,2001)
7847: AND QPCT.collection_trigger_id = 87
10934: SELECT qa.plan_id from qa_results qa
10935: where qa.collection_id = p_collection_id and rownum < 2;
10936:
10937: CURSOR get_qa_plan_id_csr2(p_org_id IN NUMBER, p_qa_inspection_type IN VARCHAR2)IS
10938: SELECT QP.plan_id FROM QA_PLANS_VAL_V QP, QA_PLAN_TRANSACTIONS QPT, QA_PLAN_COLLECTION_TRIGGERS QPCT
10939: WHERE QP.plan_id = QPT.plan_id AND QPT.plan_transaction_id = QPCT.plan_transaction_id
10940: AND QP.organization_id = p_org_id
10941: AND QPT.transaction_number in (9999,2001)
10942: AND QPCT.collection_trigger_id = 87