[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
okl_vlr_pvt.insert_row (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_vlrv_tbl => l_error_tbl,
x_vlrv_tbl => lx_error_tbl
);
SELECT CURRENCY_CODE
from okc_k_headers_all_b
WHERE id = p_debit_doc_id
UNION
SELECT CURRENCY_CODE
from OKL_CNSLD_AR_HDRS_ALL_B
WHERE id = p_debit_doc_id
UNION
SELECT INVOICE_CURRENCY_CODE
FROM RA_CUSTOMER_TRX_ALL
WHERE CUSTOMER_TRX_ID = p_debit_doc_id;
SELECT rct.ID,
rca.ID,
rct.ile_id,
btc.irm_id,
rct.check_number,
rct.currency_code,
btc.currency_conversion_type,
btc.currency_conversion_rate,
btc.currency_conversion_date,
rct.amount,
btc.date_entered,
rca.cnr_id,
rca.khr_id,
rca.ar_invoice_id,
rca.org_id,
btc.date_gl_requested, --modified by akrangan for bug#6642533
rct.date_effective,
btc.remit_bank_id,
rct.attribute_category,
rct.attribute1,
rct.attribute2,
rct.attribute3,
rct.attribute4,
rct.attribute5,
rct.attribute6,
rct.attribute7,
rct.attribute8,
rct.attribute9,
rct.attribute10,
rct.attribute11,
rct.attribute12,
rct.attribute13,
rct.attribute14,
rct.attribute15
FROM okl_trx_csh_batch_v btc,
okl_trx_csh_receipt_v rct,
okl_txl_rcpt_apps_v rca
WHERE btc.ID = rct.btc_id
AND rct.ID = rca.rct_id_details
AND rct.btc_id = cp_btc_id;
SELECT account_number
FROM hz_cust_accounts
WHERE cust_account_id = c_acct_id;
UPDATE okl_trx_csh_receipt_b
SET rcpt_status_code = l_rcpt_status_code
WHERE ID = l_rct_id;
UPDATE okl_trx_csh_receipt_b
SET ID = l_cash_receipt_id
WHERE ID = l_rct_id;
UPDATE okl_trx_csh_receipt_tl
SET ID = l_cash_receipt_id
WHERE ID = l_rct_id;
UPDATE okl_txl_rcpt_apps_b
SET rct_id_details = l_cash_receipt_id
WHERE rct_id_details = l_rct_id;
SELECT rct.ID,
rca.ID,
rct.ile_id,
rct.irm_id,
rct.check_number,
rct.currency_code,
rct.exchange_rate,
rct.exchange_rate_date,
rct.exchange_rate_type,
rct.amount,
rct.date_effective,
rca.cnr_id,
rca.khr_id,
rca.ar_invoice_id,
rca.org_id,
rct.gl_date,
rct.date_effective
FROM okl_trx_csh_receipt_v rct, okl_txl_rcpt_apps_v rca
WHERE rct.ID = rca.rct_id_details
AND rct.btc_id IS NULL
AND rct.btc_id = -1; --to be reviewed and tested later
SELECT btc.ID,
btc.currency_conversion_type,
btc.currency_conversion_rate,
btc.currency_conversion_date
FROM okl_trx_csh_batch_v btc
WHERE btc.trx_status_code IN ('SUBMITTED', 'RESUBMITTED');
SELECT btc.ID, btc.NAME
FROM okl_trx_csh_batch_v btc
WHERE creation_date < (SYSDATE - 7)
AND btc.trx_status_code IN
('WORKING', 'RESUBMITTED') --akrangan added
AND btc.ID NOT IN (SELECT btc_id
FROM okl_trx_csh_receipt_v
WHERE btc_id = btc.ID);
SELECT bank_account_id
FROM okl_bpd_rcpt_mthds_uv rcpt
WHERE rcpt.currency_code = c_curr_code
AND rcpt.receipt_method_id = c_rcpt_method_id;
SELECT account_number
FROM hz_cust_accounts
WHERE cust_account_id = c_acct_id;
SELECT vb.ID,
vb.object_version_number,
vb.attribute_category,
vb.attribute1,
vb.attribute2,
vb.attribute3,
vb.attribute4,
vb.attribute5,
vb.attribute6,
vb.attribute7,
vb.attribute8,
vb.attribute9,
vb.attribute10,
vb.attribute11,
vb.attribute12,
vb.attribute13,
vb.attribute14,
vb.attribute15,
vb.parent_object_code,
vb.parent_object_id,
vb.validation_id,
vb.result_code,
vl.validation_text
FROM okl_validation_results_b vb,
okl_validation_results_tl vl,
okl_trx_csh_batch_v btc
WHERE vb.ID = vl.ID
AND vl.LANGUAGE = USERENV ('LANG')
AND vb.parent_object_code = 'RECEIPT_BATCH'
AND vb.parent_object_id = btc.ID
AND btc.ID = p_batch_id;
SELECT CURRENCY_CODE
from okc_k_headers_all_b
WHERE id = p_debit_doc_id
UNION
SELECT CURRENCY_CODE
from OKL_CNSLD_AR_HDRS_ALL_B
WHERE id = p_debit_doc_id
UNION
SELECT INVOICE_CURRENCY_CODE
FROM RA_CUSTOMER_TRX_ALL
WHERE CUSTOMER_TRX_ID = p_debit_doc_id;
l_old_error_tbl.DELETE;
okl_vlr_pvt.delete_row (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_vlrv_tbl => l_old_error_tbl
);
okl_trx_csh_batch_pub.update_trx_csh_batch (l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_btcv_rec,
x_btcv_rec
);
okl_trx_csh_batch_pub.delete_trx_csh_batch (l_api_version,
l_init_msg_list,
l_return_status,
l_msg_count,
l_msg_data,
l_btcv_rec
);