APPS.OKL_CREDIT_LINE_WF SQL Statements

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

Line: 97

    SELECT NAME, DISPLAY_NAME
    FROM   WF_USERS
    WHERE  orig_system_id = c_user_id
   	AND    ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;

Line: 104

    SELECT USER_NAME, DESCRIPTION
    FROM   FND_USER
    WHERE  user_id = c_user_id;

Line: 173

    OKL_CREDIT_PUB.update_credit_line_status(
                            p_api_version    => p_api_version,
                            p_init_msg_list  => p_init_msg_list,
                            x_return_status  => x_return_status,
                            x_msg_count      => x_msg_count,
                            x_msg_data       => x_msg_data,
                            x_status_code    => lx_khr_status,
                            p_status_code    => p_khr_status,
                            p_credit_line_id => p_chr_id);

Line: 278

    SELECT chrv.contract_number,
           chrv.sts_code
    FROM okc_k_headers_v chrv
    WHERE chrv.id = p_contract_id;

Line: 286

    SELECT APPLICATION_ID
    FROM   FND_APPLICATION
    WHERE  APPLICATION_SHORT_NAME = G_APP_NAME;

Line: 294

    SELECT B.TRANSACTION_TYPE_ID,
           B.FND_APPLICATION_ID
      FROM AME_CALLING_APPS B,
           AME_CALLING_APPS_TL T
     WHERE B.APPLICATION_ID = T.APPLICATION_ID
       AND T.LANGUAGE = 'US'
       AND T.APPLICATION_NAME = c_trx_type;

Line: 303

    SELECT transaction_type_id,
           fnd_application_id
    FROM   AME_CALLING_APPS
    WHERE  application_name = c_trx_type; */

Line: 309

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;

Line: 313

    SELECT id
    FROM   okl_trx_types_b
    WHERE  trx_type_class = G_TRX_TYPE_CONTRACT_APPROVAL;

Line: 508

     l_parameter_list.DELETE;

Line: 596

      SELECT ID,
             CONTRACT_NUMBER,
             DESCRIPTION,
             STS_MEANING,
             CURRENCY_CODE,
             CUSTOMER_NAME,
             CUST_ACCT_NUMBER,
             TOTAL_LIMIT,
             START_DATE,
             END_DATE
      FROM okl_creditlines_uv
      WHERE id =  p_contract_id;

Line: 611

      SELECT KHR_ID,
             TODO_ITEM_CODE,
             TODO_ITEM_MEANING,
             MANDATORY_FLAG_MEANING,
             MANDATORY_FLAG,
             CHECK_OFF_RESULTS,
             FUNC_VAL_RSTS_MEANING,
             FUNCTION_ID,
             FUNCTION_NAME,
             CHECKIST_RESULTS
      FROM okl_credit_checklists_uv
      WHERE khr_id =  p_contract_id;

Line: 638

     select chr.org_id
       from okc_k_headers_all_b chr
      where chr.id = p_contract_id;

Line: 907

    SELECT USER_NAME
    FROM   FND_USER
    WHERE  user_id = p_user_id;

Line: 1075

  PROCEDURE update_approval_status(itemtype  IN  VARCHAR2,
                                   itemkey   IN  VARCHAR2,
                                   actid     IN  NUMBER,
                                   funcmode  IN  VARCHAR2,
                                   resultout OUT NOCOPY VARCHAR2)
  IS
    CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
    IS
   	SELECT id
    FROM   okl_trx_contracts
   	WHERE  trx_number = p_trx_number
    --rkuttiya added for 12.1.1. Multi GAAP Project
        AND  representation_type = 'PRIMARY';

Line: 1095

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

Line: 1166

      Okl_Trx_Contracts_Pub.update_trx_contracts(
           p_api_version      => l_api_version
          ,p_init_msg_list    => l_init_msg_list
          ,x_return_status    => l_return_status
          ,x_msg_count        => l_msg_count
          ,x_msg_data         => l_msg_data
          ,p_tcnv_rec         => l_trxH_in_rec
          ,x_tcnv_rec         => l_trxH_out_rec);

Line: 1224

  END update_approval_status;

Line: 1395

    SELECT okl_wf_item_s.NEXTVAL item_key
    FROM  dual;