APPS.OKL_VSS_WF SQL Statements

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

Line: 19

  	SELECT okl_wf_item_s.nextval
  	FROM   DUAL;

Line: 63

    l_parameter_list.DELETE;

Line: 190

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');

Line: 218

SELECT user_name from fnd_user
WHERE user_id = p_id;

Line: 222

SELECT responsibility_id
FROM fnd_responsibility
WHERE responsibility_key = respKey
AND application_id = 540;

Line: 339

SELECT  CN.COUNTER_ID COUNTER_NUMBER,  CN.NAME COUNTER_NAME,
        KHR.CONTRACT_NUMBER CONTRACT_NUMBER,  ASSET.NAME ASSET_NUMBER
FROM
  OKC_K_LINES_TL ASSET,
  OKC_K_LINES_B USAGE,
  OKC_K_ITEMS UITEM,
  OKC_K_LINES_B OKS,
  OKC_K_LINES_B OKSU,
  OKC_K_ITEMS OKSITEM,
  CSI_COUNTERS_VL CN,
  OKC_K_ITEMS ASSET_ITEM,
  OKC_K_REL_OBJS REL,
  OKC_K_HEADERS_B KHR,
  OKC_K_LINES_B USUB_LINE
WHERE
  CN.COUNTER_ID = p_counter_id AND
  USAGE.DNZ_CHR_ID = KHR.ID AND
  KHR.ID = USAGE.CHR_ID AND
  USAGE.ID = UITEM.CLE_ID AND
  to_char(OKS.ID) = UITEM.OBJECT1_ID1 AND
  to_char(OKS.DNZ_CHR_ID) = REL.OBJECT1_ID1 AND
  OKS.ID = OKSU.CLE_ID AND
  OKS.DNZ_CHR_ID = OKSU.DNZ_CHR_ID AND
  OKSU.ID = OKSITEM.CLE_ID AND
  OKSITEM.OBJECT1_ID1 = to_char(CN.COUNTER_ID) AND
  OKSITEM.JTOT_OBJECT1_CODE = 'OKX_COUNTER' AND
  USUB_LINE.DNZ_CHR_ID = USAGE.CHR_ID AND
  USAGE.ID = USUB_LINE.CLE_ID AND
  USUB_LINE.ID = ASSET_ITEM.CLE_ID AND
  OKSU.dnz_chr_id = REL.OBJECT1_ID1 AND
  ASSET_ITEM.OBJECT1_ID1 = ASSET.ID AND
  ASSET.language = userenv ( 'LANG' ) AND
  REL.RTY_CODE = 'OKLUBB' AND
  REL.JTOT_OBJECT1_CODE = 'OKL_SERVICE' AND
  REL.CHR_ID = USAGE.DNZ_CHR_ID;

Line: 462

 PROCEDURE update_counter(
                            p_api_version                    IN  NUMBER,
                            p_init_msg_list                  IN  VARCHAR2,
                            p_trx_id                         IN  NUMBER,
                            x_return_status                  OUT NOCOPY VARCHAR2,
                            x_msg_count                      OUT NOCOPY NUMBER,
                            x_msg_data                       OUT NOCOPY VARCHAR2)
  AS


    l_counter_id                   NUMBER;

Line: 495

    select counter_id, counter_reading, reading_date, amount, clg_id
    from    dual;

Line: 505

                        'OKL_VSS_WF.update_counter.',
                        'Begin(+)');

Line: 534

     OKL_CNTR_GRP_BILLING_PUB.insert_cntr_grp_bill(
     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_cntr_bill_tbl    => l_cntr_bill_tbl,
     x_cntr_bill_tbl    => x_cntr_bill_tbl
    );

Line: 552

                        'OKL_VSS_WF.update_counter.',
                        'End(-)');

Line: 564

                             'OKL_VSS_WF.update_counter.',
                             'EXP - G_EXCEPTION_ERROR');

Line: 574

                             'OKL_VSS_WF.update_counter.',
                             'EXP - G_EXCEPTION_UNEXPECTED_ERROR');

Line: 580

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SSC_ASST_LOC_SERNUM_PUB','update_counter');

Line: 586

                             'OKL_VSS_WF.update_counter.',
                             'EXP - OTHERS');

Line: 590

  END update_counter;

Line: 592

procedure update_counter_fnc (itemtype in varchar2,
                             itemkey in varchar2,
                             actid in number,
                             funcmode in varchar2,
                             resultout out nocopy varchar2 ) is

x_return_status varchar2(1);

Line: 611

                        'OKL_VSS_WF.update_counter_fnc.',
                        'Begin(+)');

Line: 623

update_counter(p_api_version    => 1.0,
                     p_init_msg_list     => OKC_API.G_FALSE,
                     p_trx_id           => l_trx_id,
                     x_return_status    => x_return_status,
                     x_msg_count        => x_msg_count,
                     x_msg_data         => l_msg_data);

Line: 666

                        'OKL_VSS_WF.update_counter_fnc.',
                        'End(-)');

Line: 672

WF_CORE.CONTEXT ('okl_ssc_wf', 'update_counter_fnc:'||l_msg_data, itemtype, itemkey,actid,funcmode);

Line: 676

                             'OKL_VSS_WF.update_counter_fnc.',
                             'EXP - OTHERS');

Line: 681

end update_counter_fnc;

Line: 694

   SELECT contract_number
   FROM   okc_k_headers_b
   WHERE id = p_khr_id;

Line: 699

   SELECT name
   FROM okc_k_lines_v
   WHERE  id = p_kle_id;

Line: 705

   SELECT quote_number
   FROM okl_trx_quotes_v
   WHERE  id = p_qte_id;

Line: 710

   SELECT user_name FROM fnd_user
   WHERE user_id = p_requestor_id;

Line: 777

        SELECT responsibility_id INTO   l_resp_id
        FROM   fnd_responsibility
        WHERE  responsibility_key = l_resp_key
        AND    application_id = 540;   */

Line: 915

        okl_qte_pvt.update_row( 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,
                                p_qtev_rec        => p_qtev_rec,
                                x_qtev_rec        => x_qtev_rec);

Line: 1035

        okl_qte_pvt.update_row( 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,
                                p_qtev_rec        => p_qtev_rec,
                                x_qtev_rec        => x_qtev_rec);