DBA Data[Home] [Help]

APPS.QA_RESULTS_INTERFACE_PKG SQL Statements

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

Line: 29

	cursor CES is select result_column_name, qpc.char_id
			from qa_plan_chars qpc, qa_chars qc
			where plan_id = given_plan_id
			and qpc.char_id = qc.char_id
			and qpc.enabled_flag = 1
                        order by prompt_sequence;
Line: 39

        select_clause 	VARCHAR2(32000);
Line: 47

  select_clause := 'SELECT ';
Line: 81

      		select_clause := select_clause || column_name;
Line: 84

      		select_clause := select_clause || ', ' || column_name;
Line: 93

  select_clause :=  select_clause || ', ' || 'QA_CREATED_BY_NAME'
			 	   || ', ' || 'COLLECTION_ID'
				   || ', ' || 'fnd_date.date_to_chardt(LAST_UPDATE_DATE,2) LAST_UPDATE_DATE';
Line: 97

  select_clause := select_clause || from_clause || where_clause;
Line: 98

  return select_clause;
Line: 107

FUNCTION build_select_clause (p_plan_id IN NUMBER)
    RETURN VARCHAR2 IS

    cursor CES is
        SELECT   result_column_name, qpc.char_id, qc.datatype
        FROM     qa_plan_chars qpc, qa_chars qc
        WHERE    plan_id = p_plan_id
        AND      qpc.char_id = qc.char_id
        AND      qpc.enabled_flag = 1
        ORDER BY prompt_sequence;
Line: 120

    select_clause 	VARCHAR2(32000);
Line: 203

      	    select_clause := select_clause || column_name;
Line: 206

      	  select_clause := select_clause || ', ' || column_name;
Line: 212

    select_clause := select_clause || ', OCCURRENCE, PLAN_ID, STATUS ';
Line: 213

    RETURN select_clause;
Line: 215

END build_select_clause;
Line: 223

        SELECT collection_trigger_id
        FROM qa_txn_collection_triggers
        WHERE transaction_number = p_txn_number
        AND search_flag = 1;
Line: 312

    select_clause 	VARCHAR2(32000);
Line: 320

    values_table.delete();
Line: 334

    select_clause := 'SELECT ';
Line: 339

    select_clause := select_clause || build_select_clause(p_plan_id);
Line: 342

    select_clause :=  select_clause || ', '
        || 'QA_CREATED_BY_NAME'
        || ', ' || 'COLLECTION_ID' || ', '
        || 'LAST_UPDATE_DATE';
Line: 362

    select_clause := select_clause || from_clause || where_clause
        || order_by_clause;
Line: 365

    RETURN select_clause;
Line: 390

    select_clause 	VARCHAR2(32000);
Line: 399

    values_table.delete();
Line: 416

    select_clause := 'SELECT ';
Line: 421

    select_clause := select_clause || build_select_clause(p_plan_id);
Line: 424

    select_clause :=  select_clause || ', '
        || 'QA_CREATED_BY_NAME'
        || ', ' || 'COLLECTION_ID' || ', '
        || 'LAST_UPDATE_DATE';
Line: 443

    select_clause := select_clause || from_clause || where_clause
        || order_by_clause;
Line: 446

    RETURN select_clause;
Line: 457

    select_clause 	VARCHAR2(32000);
Line: 466

    select_clause := 'SELECT ';
Line: 471

    select_clause := select_clause || build_select_clause(p_plan_id);
Line: 474

    select_clause :=  select_clause || ', '
        || 'QA_CREATED_BY_NAME'
        || ', ' || 'COLLECTION_ID' || ', '
        || 'LAST_UPDATE_DATE';
Line: 491

    select_clause := select_clause || from_clause || where_clause
        || order_by_clause;
Line: 494

    RETURN select_clause;
Line: 502

    select_clause 	VARCHAR2(32000);
Line: 507

    select_clause := 'SELECT ';
Line: 510

    select_clause := select_clause || build_select_clause(p_plan_id);
Line: 511

    select_clause := select_clause || ' , name ';
Line: 515

    select_clause :=  select_clause || ', ' || 'QA_CREATED_BY_NAME' || ', '
        || 'COLLECTION_ID' || ', ' || 'LAST_UPDATE_DATE';
Line: 520

    RETURN select_clause || from_clause;
Line: 530

    select_clause 	VARCHAR2(32000);
Line: 537

    select_clause := 'SELECT ';
Line: 542

    select_clause := select_clause || build_select_clause(p_plan_id);
Line: 544

    select_clause :=  select_clause || ', '
        || 'QA_CREATED_BY_NAME'
        || ', ' || 'COLLECTION_ID' || ', '
        || 'fnd_date.date_to_chardt(LAST_UPDATE_DATE,2) LAST_UPDATE_DATE';
Line: 551

    select_clause := select_clause || from_clause;
Line: 556

    RETURN select_clause;
Line: 580

 	select organization_code into org_code
  	from mtl_parameters
	where organization_id = org_id;
Line: 585

      	select name into plan_name
	from qa_plans
	where plan_id = given_plan_id;
Line: 594

      	script := 'Insert into qa_results_interface ' ||
                '(process_status, organization_code, plan_name, source_code, source_line_id, po_agent_id';
Line: 788

      SELECT mso.sales_order_id
      FROM mtl_sales_orders mso,
           oe_order_headers_all oe,
           qa_customers_lov_v rc,
           oe_transaction_types_tl ot,
           fnd_languages fl
      WHERE mso.segment1 = to_char(oe.order_number)
            AND oe.order_type_id = ot.transaction_type_id
            AND ot.language = fl.language_code
            AND fl.installed_flag = 'B'
            AND oe.sold_to_org_id = rc.customer_id (+)
            AND mso.segment2 = ot.name
            AND mso.segment3 = fnd_profile.value('ONT_SOURCE_CODE')
            AND oe.header_id = p_oe_header_id;