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: 321

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

Line: 489

       SELECT  party_name, status
       FROM    hz_parties
       WHERE   party_id = p_party_id
       AND     party_type = 'ORGANIZATION';

Line: 496

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

Line: 697

       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: 714

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

Line: 724

      SELECT full_name contact_name
      FROM   per_workforce_v
      WHERE  person_id = p_contact_id;

Line: 729

      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: 987

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

Line: 1153

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

Line: 1330

        SELECT contract_effective_date
        FROM okc_rep_contracts_all
        WHERE contract_id = p_contract_id;

Line: 1336

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

Line: 1343

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

Line: 1349

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

Line: 1703

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

Line: 2000

  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: 2010

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

Line: 2018

         'Entered insert_deliverables_qa_checks');

Line: 2064

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

Line: 2067

      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: 2090

        'After inserting a row into OKC_DOC_QA_LISTS');

Line: 2100

                      'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');

Line: 2108

                        'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_ERROR');

Line: 2122

                       'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_UNEXPECTED_ERROR');

Line: 2136

                       'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with  OTHERS EXCEPTION');

Line: 2153

  END insert_deliverables_qa_checks;