APPS.QA_WEB_TXN_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

	SELECT 	qpt.plan_transaction_id,
	       	qpt.plan_id,
	       	qc.char_id,
               	qc.dependent_char_id,
	       	qc.datatype,
	       	qpct.operator,
	       	qpct.low_value,
	       	qpct.high_value
	FROM 	qa_plan_collection_triggers qpct,
		qa_plan_transactions qpt,
		qa_plans_val_v qp,
        	qa_chars qc,
		qa_txn_collection_triggers qtct
	WHERE 	qpt.plan_id = qp.plan_id
	AND 	qpct.plan_transaction_id(+) = qpt.plan_transaction_id
        AND 	qpct.collection_trigger_id = qtct.collection_trigger_id(+)
        AND 	qpct.collection_trigger_id = qc.char_id(+)
	AND 	qpt.transaction_number = p_txn_number
        AND 	qtct.transaction_number(+) = p_txn_number
        AND 	qp.organization_id = p_org_id
        AND 	qpt.enabled_flag = 1
        AND 	qpt.mandatory_collection_flag =
                NVL(p_mandatory_flag, qpt.mandatory_collection_flag)
        AND 	qpt.background_collection_flag =
                NVL(p_background_flag, qpt.background_collection_flag)
	ORDER BY qpt.plan_transaction_id;

Line: 168

        SELECT qpt.plan_transaction_id,
	    qpt.plan_id,
	    qc.char_id,
            qc.dependent_char_id,
	    qc.datatype,
	    qpct.operator,
	    qpct.low_value,
	    qpct.high_value
        FROM qa_plan_collection_triggers qpct,
	    qa_plan_transactions qpt,
	    qa_plans qp,
            qa_chars qc,
	    qa_txn_collection_triggers qtct
	WHERE qp.plan_id = p_plan_id
	and qpt.plan_id = qp.plan_id
	and qpct.plan_transaction_id(+) = qpt.plan_transaction_id
        and qpct.collection_trigger_id = qtct.collection_trigger_id(+)
        and qpct.collection_trigger_id = qc.char_id(+)
	and qpt.transaction_number = p_txn_number
        and qtct.transaction_number(+) = p_txn_number
        and qp.organization_id = p_org_id
        and qpt.enabled_flag = 1
        ORDER BY qpt.plan_transaction_id;

Line: 201

        SELECT qpt.plan_transaction_id,
	    qpt.plan_id,
	    qc.char_id,
            qc.dependent_char_id,
	    qc.datatype,
	    qpct.operator,
	    qpct.low_value,
	    qpct.high_value
        FROM qa_plan_collection_triggers qpct,
	    qa_plan_transactions qpt,
	    qa_plans qp,
            qa_chars qc
	WHERE qp.plan_id = p_plan_id
	and qpt.plan_id = qp.plan_id
	and qpct.plan_transaction_id(+) = qpt.plan_transaction_id
        and qpct.collection_trigger_id = qc.char_id(+)
	and qpt.transaction_number in (31, 32, 33)
        and qp.organization_id = p_org_id
        and qpt.enabled_flag = 1
        ORDER BY qpt.plan_transaction_id;

Line: 330

	SELECT qpt.plan_id
	FROM qa_plan_transactions qpt
	WHERE qpt.plan_id = p_plan_id
	AND qpt.transaction_number = p_txn_number;

Line: 336

	SELECT qpt.plan_id
	FROM qa_plan_transactions qpt
	WHERE qpt.plan_id = p_plan_id
	AND qpt.transaction_number in (31, 32, 33);

Line: 432

        SELECT decode(mandatory_collection_flag, 1, 'Mandatory', 2, 'Optional')
        FROM qa_plan_transactions
        WHERE plan_id = p_plan_id
        AND transaction_number = p_txn_number
        AND enabled_flag = 1;

Line: 462

	SELECT 'Y'
	FROM qa_plan_transactions
	WHERE plan_id = p_plan_id
        AND transaction_number = p_txn_number
        AND background_collection_flag = 1;

Line: 490

        SELECT NVL(customer_id, -1)
	FROM fnd_user
	WHERE user_id = p_user_id;

Line: 521

        SELECT PLAN_RELATIONSHIP_ID
        FROM QA_PC_PLAN_RELATIONSHIP
        WHERE CHILD_PLAN_ID = p_plan_id
        AND DATA_ENTRY_MODE = 4;

Line: 533

        p_function_name = 'QA_RESULTS_UPDATE' OR
        p_function_name = 'QA_RESULTS_DELETE') THEN
        OPEN c;

Line: 725

      select wip_entity_id into l_wip_entity_id
      from wip_entities where wip_entity_name = pk4
      and organization_id = p_organization_id;

Line: 748

        select 'Y' into l_results_entered
        from dual where exists (
        select collection_id from QA_RESULTS
        where organization_id = p_organization_id
        and work_order_id =l_wip_entity_id
        and (maintenance_op_seq is null or transaction_number = 31)
        and plan_id = l_plans_table(i)
        and (status is null or status=2 or --results be either enabled or belong to p_collection_id
        (p_collection_id is not null and collection_id = p_collection_id))
        );

Line: 759

        select 'Y' into l_results_entered from dual
        where exists (
        select collection_id from QA_RESULTS
        where organization_id = p_organization_id
        and work_order_id =l_wip_entity_id
        and maintenance_op_seq = pk5
        and transaction_number = 33
        and plan_id = l_plans_table(i)
        and (status is null or status=2 or --results be either enabled or belong to p_collection_id
        (p_collection_id is not null and collection_id = p_collection_id))
        );

Line: 829

        SELECT DISTINCT qpt.plan_id
        FROM  qa_plan_transactions qpt, qa_plans qp
        WHERE  qpt.transaction_number = txn_no
         AND    qpt.plan_id = qp.plan_id
         AND    qp.organization_id = org_id
         AND    trunc(sysdate) between
		nvl(trunc(qp.effective_from), trunc(sysdate)) and
		nvl(trunc(qp.effective_to), trunc(sysdate))
         AND    qpt.enabled_flag = 1
         AND qpt.background_collection_flag = 1
         AND NOT EXISTS
         (SELECT 1
          FROM   qa_results qr
          WHERE  qr.plan_id = qpt.plan_id
          AND qr.collection_id = col_id);

Line: 866

           qa_txn_grp.insert_results(l_plan_id, p_org_id, p_collection_id, elements);

Line: 913

           SELECT occurrence
           FROM QA_RESULTS
           WHERE plan_id = x_plan_id
           AND collection_id = x_collection_id
           AND status = x_status;