APPS.OKL_UPDT_CASH_DTLS SQL Statements

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

Line: 8

PROCEDURE update_cash_details ( p_api_version	   IN  NUMBER
		                       ,p_init_msg_list    IN  VARCHAR2 DEFAULT Okc_Api.G_FALSE
				               ,x_return_status    OUT NOCOPY VARCHAR2
				               ,x_msg_count	       OUT NOCOPY NUMBER
				               ,x_msg_data	       OUT NOCOPY VARCHAR2
                               ,p_strm_tbl         IN  okl_cash_dtls_tbl_type
                               ,x_strm_tbl         OUT NOCOPY okl_cash_dtls_tbl_type
    					       ) IS

---------------------------
-- DECLARE Local Variables
---------------------------

  l_strm_tbl                 okl_cash_dtls_tbl_type;

Line: 55

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

Line: 77

     SELECT OVER_PAYMENT_ALLOCATION_CODE
     FROM   OKL_CASH_ALLCTN_RLS;

Line: 85

     SELECT rca_id, xcr_id_details
     FROM   okl_xtl_csh_apps_v
     WHERE  id = cp_xca_id;

Line: 93

     SELECT rct_id_details, cnr_id, khr_id
     FROM   okl_txl_rcpt_apps_v
     WHERE  id = cp_rca_id;

Line: 101

     SELECT id, lsm_id
     FROM   okl_txl_rcpt_apps_v
     WHERE  rct_id_details = cp_rct_id_details;

Line: 111

     SELECT a.id, a.rct_id, a.remittance_amount, a.check_number, a.receipt_date,
            a.gl_date, a.customer_number, a.currency_code, a.org_id, a.exchange_rate_type,
            a.exchange_rate_date, a.attribute1
     FROM   okl_ext_csh_rcpts_b a, okl_xtl_csh_apps_b b
     WHERE  a.id = b.xcr_id_details
     AND    b.xcr_id_details = cp_xcr_id_details;

Line: 122

     SELECT a.exchange_rate
     FROM   okl_ext_csh_rcpts_b a
     WHERE  a.id = cp_xcr_id;

Line: 130

     SELECT a.currency_code, a.amount,                      -- rcpt currency
            b.currency_code, b.remittance_amount            -- functional currency
     FROM   okl_trx_csh_receipt_b a,
            okl_ext_csh_rcpts_b b
     WHERE  a.id = cp_rct_id
     AND    a.id = b.rct_id;

Line: 175

        DELETE FROM OKL_TRX_CSH_RECEIPT_B
        WHERE ID = l_rct_id_details;

Line: 179

        DELETE FROM OKL_TXL_RCPT_APPS_B
        WHERE RCT_ID_DETAILS = l_rct_id_details;

Line: 183

        DELETE FROM OKL_EXT_CSH_RCPTS_B
        WHERE ID = l_xcr_id_details;

Line: 187

        DELETE FROM OKL_XTL_CSH_APPS_B
        WHERE XCR_ID_DETAILS = l_xcr_id_details;

Line: 269

        Okl_Txl_Rcpt_Apps_Pub.delete_txl_rcpt_apps( l_api_version
                                                   ,l_init_msg_list
                                                   ,l_return_status
                                                   ,l_msg_count
                                                   ,l_msg_data
                                                   ,l_rcav_tbl
                                                   );

Line: 312

        Okl_Txl_Rcpt_Apps_Pub.insert_txl_rcpt_apps( l_api_version
                                                   ,l_init_msg_list
                                                   ,l_return_status
                                                   ,l_msg_count
                                                   ,l_msg_data
                                                   ,l_rcav_tbl
                                                   ,x_rcav_tbl
                                                   );

Line: 373

        Okl_Xtl_Csh_Apps_Pub.update_xtl_csh_apps(   l_api_version
                                                   ,l_init_msg_list
                                                   ,l_return_status
                                                   ,l_msg_count
                                                   ,l_msg_data
                                                   ,l_xcav_tbl
                                                   ,x_xcav_tbl
                                                );

Line: 457

        Okl_Xcr_Pub.update_ext_csh_txns( p_api_version
                                        ,p_init_msg_list
                                        ,x_return_status
                                        ,x_msg_count
                                        ,x_msg_data
                                        ,l_xcrv_rec
                                        ,x_xcrv_rec
                                       );

Line: 483

    DELETE
    FROM    OKL_XTL_CSH_APPS_B
    WHERE   AMOUNT_APPLIED = 0
    AND     XCR_ID_DETAILS = l_xcr_id_details;

Line: 520

END update_cash_details;