APPS.OKC_REP_QA_CHECK_PVT SQL Statements

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

Line: 43

     SELECT 'X'
     FROM okc_rep_contract_parties
     WHERE contract_id = p_contract_id
     and party_role_code <> l_party_role_code;

Line: 59

	  SELECT CONTRACT_TYPE
	  FROM okc_rep_contracts_all
	  WHERE CONTRACT_id = p_contract_id;

Line: 243

	  SELECT CONTRACT_TYPE
	  FROM okc_rep_contracts_all
	  WHERE CONTRACT_id = p_contract_id;

Line: 410

 	           SELECT CONTRACT_TYPE
 	           FROM okc_rep_contracts_all
 	           WHERE CONTRACT_id = p_contract_id;

Line: 570

       SELECT signature_workflow_name
       FROM okc_bus_doc_types_b
       WHERE  document_type = p_contract_type;

Line: 575

     SELECT Count(*) contact_count FROM okc_rep_party_contacts WHERE contract_id=p_contract_id AND
      ESIGNATURE_TYPE   IS NOT NULL AND  SIGNATURE_SEQUENCE IS NOT NULL ;

Line: 579

   select contact_id,party_id,PARTY_ROLE_CODE,SIGNATURE_SEQUENCE,ESIGNATURE_TYPE
   from
   okc_rep_party_contacts opc WHERE contract_id=p_contract_id AND
   ESIGNATURE_TYPE   IS NOT NULL AND  SIGNATURE_SEQUENCE IS NOT NULL ;

Line: 586

  SELECT f.user_name ,(pvc.first_name || ' ' || pvc.middle_name || ' ' || pvc.last_name)  contact_name
  FROM po_vendor_contacts pvc,FND_USER  f
  where pvc.PER_PARTY_ID= f.person_party_id
  AND pvc.vendor_contact_id=p_contact_id;

Line: 592

  SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
       hz_relationships hr,
    	 hz_parties  hz,
       FND_USER f
WHERE
 hr.party_id = p_contact_id
 AND hr.subject_id = hz.party_id
 AND  hr.object_id = p_object_id
AND         hr.object_type = 'ORGANIZATION'
AND   	hr.object_table_name = 'HZ_PARTIES'
AND   	hr.subject_type = 'PERSON'
AND   	hz.party_id = hr.subject_id
AND         hr.relationship_code = 'CONTACT_OF'
AND         hr.status = 'A'
AND         hr.start_date <= sysdate
AND         nvl(hr.end_date, sysdate + 1) > SYSDATE
AND f.person_party_id(+) = hz.party_id ;

Line: 612

SELECT f.user_name,p.full_name contact_name from
per_workforce_v p,
fnd_user f
WHERE f.employee_id(+)=p.person_id and
p.person_id=p_contact_id;

Line: 860

       SELECT  name, start_date, end_date
       FROM    okc_bus_doc_types_vl
       WHERE   document_type = p_contract_type;

Line: 1028

       SELECT  party_name, status
       FROM    hz_parties
       WHERE   party_id = p_party_id
	AND     party_type IN ('ORGANIZATION', 'PERSON');       /*--10334886: Added person party Type*/

Line: 1035

       SELECT  vendor_name, enabled_flag,
               start_date_active,
               end_date_active
       FROM    po_vendors
       WHERE vendor_id = p_party_id;

Line: 1236

       SELECT hz.party_name contact_name,
              hr.status     relationship_status,
              hr.start_date start_date,
              hr.end_date   end_date
       FROM   hz_parties  hz,
              hz_relationships hr
       WHERE  hr.object_id = p_party_id  -- The party being passsed
       AND    hz.party_id = p_contact_id -- The contact id
       AND    hr.object_type = 'ORGANIZATION'
       AND    hr.object_table_name = 'HZ_PARTIES'
       AND    hr.subject_type = 'PERSON'
       AND    ((hr.relationship_code = 'CONTACT_OF') OR (hr.relationship_code = 'EMPLOYEE_OF'))
       AND    hz.party_id = hr.party_id;

Line: 1253

       SELECT (first_name || ' ' || middle_name || ' ' || last_name)  contact_name,
              inactive_date
       FROM   po_vendor_contacts
       WHERE  vendor_contact_id=p_contact_id;

Line: 1263

      SELECT full_name contact_name
      FROM   per_workforce_v
      WHERE  person_id = p_contact_id;

Line: 1268

      SELECT per.full_name contact_name
      FROM   per_all_people_f per
      WHERE  per.person_id = p_contact_id
      AND    per.effective_start_date = (SELECT MAX(effective_start_date)
                                         FROM   per_all_people_f
                                         WHERE  person_id = per.person_id);

Line: 1526

       SELECT  name, start_date, end_date
       FROM    okc_rep_contact_roles_vl
       WHERE   contact_role_id = p_contact_role_id;

Line: 1692

       SELECT  name, start_date, end_date
       FROM    okc_risk_events_vl
       WHERE   risk_event_id = p_risk_event_id;

Line: 1861

	select count(*) from okc_deliverables
	where business_document_type = p_contract_type
	  and business_document_id = p_contract_id;

Line: 1867

      SELECT Count(*)
      FROM (SELECT Count(contact_id) AS contact_count FROM OKC_REP_PARTY_CONTACTS
            WHERE contract_id = p_contract_id
              GROUP BY contact_role_id)
      WHERE contact_count >1;

Line: 1944

    SELECT Count(contact_id) INTO l_con_count FROM OKC_REP_PARTY_CONTACTS
            WHERE contract_id = p_contract_id ;

Line: 1976

      SELECT Count(*) INTO l_attr_count
      FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG
      WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ACQ_HIST', 'SBCR_PRE_ACQ')
      AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
      AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
      AND  assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)
                                        FROM OKC_REP_CONTRACTS_ALL
                                        WHERE contract_id =  p_contract_id)
      AND assoc.CLASSIFICATION_CODE = pg.CLASSIFICATION_CODE;

Line: 1993

      SELECT fcu.application_column_name INTO l_acq_type_col_name
      FROM fnd_descr_flex_column_usages fcu
      WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND fcu.descriptive_flex_context_code = 'SBCR_ACQ_HIST'
            AND fcu.end_user_column_name = 'SBCR_ACQ_TYPE';

Line: 1999

      SELECT attr_group_id INTO l_acq_hist_ag_id
      FROM ego_fnd_dsc_flx_ctx_ext
      WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND descriptive_flex_context_code = 'SBCR_ACQ_HIST';

Line: 2004

      SELECT attr_group_id INTO l_prev_acq_ag_id
      FROM ego_fnd_dsc_flx_ctx_ext
      WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';

Line: 2009

      l_sql := 'SELECT ' || l_acq_type_col_name  ||
              ' FROM okc_rep_contracts_all_ext_b' ||
              ' WHERE contract_id = ' || p_contract_id ||
              ' AND attr_group_id = ' || l_acq_hist_ag_id;

Line: 2023

      SELECT Count(*) INTO l_pre_acq_count
      FROM okc_rep_contracts_all_ext_b
      WHERE contract_id = p_contract_id
      AND attr_group_id =  l_prev_acq_ag_id;

Line: 2053

      SELECT Count(*) INTO l_attr_count
      FROM EGO_OBJ_AG_ASSOCS_B assoc, ego_attr_groups_v egv, EGO_PAGE_ENTRIES_B PG
      WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ADD_INFO', 'SBCR_REC_AG')
      AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
      AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
      AND  assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)
                                        FROM OKC_REP_CONTRACTS_ALL
                                        WHERE contract_id =  p_contract_id)
      AND assoc.CLASSIFICATION_CODE = pg.CLASSIFICATION_CODE;

Line: 2070

      SELECT fcu.application_column_name INTO l_remarks_col_name
      FROM fnd_descr_flex_column_usages fcu
      WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND fcu.descriptive_flex_context_code = 'SBCR_ADD_INFO'
            AND fcu.end_user_column_name = 'SBCR_REMARKS';

Line: 2076

      SELECT attr_group_id INTO l_rec_ag_id
      FROM ego_fnd_dsc_flx_ctx_ext
      WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND descriptive_flex_context_code = 'SBCR_REC_AG';

Line: 2081

      SELECT attr_group_id INTO l_add_info_ag_id
      FROM ego_fnd_dsc_flx_ctx_ext
      WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
            AND descriptive_flex_context_code = 'SBCR_ADD_INFO';

Line: 2086

      SELECT Count(*) INTO l_rec_count
      FROM okc_rep_contracts_all_ext_b
      WHERE contract_id = p_contract_id
      AND attr_group_id =  l_rec_ag_id;

Line: 2094

      l_sql := 'SELECT ' || l_remarks_col_name  ||
              ' FROM okc_rep_contracts_all_ext_b' ||
              ' WHERE contract_id = ' || p_contract_id ||
              ' AND attr_group_id = ' || l_add_info_ag_id;

Line: 2248

       SELECT approval_workflow_name
       FROM okc_bus_doc_types_b
       WHERE  document_type = p_contract_type;

Line: 2420

        SELECT contract_effective_date,esignature_required
        FROM okc_rep_contracts_all
        WHERE contract_id = p_contract_id;

Line: 2426

 	      SELECT contract_expiration_date
 	      FROM okc_rep_contracts_all
 	      WHERE contract_id = p_contract_id;

Line: 2433

        SELECT party_id, party_role_code
        FROM okc_rep_contract_parties
        WHERE contract_id = p_contract_id
        AND party_role_code <> 'INTERNAL_ORG';

Line: 2440

        SELECT party_id, party_role_code, contact_id, contact_role_id
        FROM okc_rep_party_contacts
        WHERE contract_id = p_contract_id;

Line: 2446

        SELECT risk_event_id
        FROM okc_contract_risks
        WHERE business_document_type = p_contract_type
        AND business_document_id = p_contract_id;

Line: 2959

    SELECT contract_type, contract_expiration_date, contract_effective_date
    FROM okc_rep_contracts_all
    WHERE contract_id = p_contract_id;

Line: 3256

  PROCEDURE insert_deliverables_qa_checks (
             p_api_version           IN NUMBER,
             p_init_msg_list         IN VARCHAR2,
             p_contract_type         IN VARCHAR2,
             x_msg_count             OUT NOCOPY NUMBER,
             x_msg_data              OUT NOCOPY VARCHAR2,
             x_return_status         OUT NOCOPY VARCHAR2)
  IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3266

    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_deliverables_qa_checks';

Line: 3274

         'Entered insert_deliverables_qa_checks');

Line: 3320

        'Inserting pl/sql table record: ' || i);

Line: 3323

      insert into OKC_DOC_QA_LISTS(
        QA_CODE,
        DOCUMENT_TYPE,
        SEVERITY_FLAG,
        OBJECT_VERSION_NUMBER,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        ENABLE_QA_YN)
      values(
        l_okc_doc_qa_lists_tbl(i).qa_code,
        p_contract_type,
        l_okc_doc_qa_lists_tbl(i).severity_flag,
        1,
        l_user_id,
        sysdate,
        l_user_id,
        sysdate,
        l_okc_doc_qa_lists_tbl(i).enable_qa_yn);

Line: 3346

        'After inserting a row into OKC_DOC_QA_LISTS');

Line: 3356

                      'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');

Line: 3364

                        'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_ERROR');

Line: 3378

                       'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_UNEXPECTED_ERROR');

Line: 3392

                       'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with  OTHERS EXCEPTION');

Line: 3409

  END insert_deliverables_qa_checks;