[Home] [Help]
28: qpct.low_value,
29: qpct.high_value
30: FROM qa_plan_collection_triggers qpct,
31: qa_plan_transactions qpt,
32: qa_plans_val_v qp,
33: qa_chars qc,
34: qa_txn_collection_triggers qtct
35: WHERE qpt.plan_id = qp.plan_id
36: AND qpct.plan_transaction_id(+) = qpt.plan_transaction_id
167: qpct.low_value,
168: qpct.high_value
169: FROM qa_plan_collection_triggers qpct,
170: qa_plan_transactions qpt,
171: qa_plans qp,
172: qa_chars qc,
173: qa_txn_collection_triggers qtct
174: WHERE qp.plan_id = p_plan_id
175: and qpt.plan_id = qp.plan_id
200: qpct.low_value,
201: qpct.high_value
202: FROM qa_plan_collection_triggers qpct,
203: qa_plan_transactions qpt,
204: qa_plans qp,
205: qa_chars qc
206: WHERE qp.plan_id = p_plan_id
207: and qpt.plan_id = qp.plan_id
208: and qpct.plan_transaction_id(+) = qpt.plan_transaction_id
546: -- saugupta Mon, 27 Jun 2005 06:21:00 -0700 PDT
547: l_result := fnd_data_security.check_function
548: (p_api_version => 1.0,
549: p_function => p_function_name,
550: p_object_name => 'QA_PLANS',
551: p_instance_pk1_value => p_plan_id,
552: p_instance_pk2_value => NULL,
553: p_instance_pk3_value => NULL,
554: p_instance_pk4_value => NULL,
762: i := l_plans_table.NEXT(i);
763: END LOOP;
764: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
765: 'Exiting ' || l_module
766: || '. No mandatory qa plans remain. Return value: '|| return_value );
767: end if;
768: RETURN return_value;
769: END quality_mandatory_plans_remain;
770:
799: elements qa_txn_grp.ElementsArray;
800:
801: Cursor c1(txn_no number, org_id number, col_id number) is
802: SELECT DISTINCT qpt.plan_id
803: FROM qa_plan_transactions qpt, qa_plans qp
804: WHERE qpt.transaction_number = txn_no
805: AND qpt.plan_id = qp.plan_id
806: AND qp.organization_id = org_id
807: AND trunc(sysdate) between