[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT POSTED_YN
FROM OKL_TRNS_ACC_DSTRS
WHERE source_id = v_source_id
AND source_table = v_source_table;
SELECT gl_transfer_flag
FROM OKL_AE_HEADERS aeh, OKL_ACCOUNTING_EVENTS aet
WHERE aeh.accounting_event_id = aet.accounting_event_id
AND aet.source_id = v_source_id
AND aet.source_table = v_source_table;
PROCEDURE DELETE_DIST_AE(p_flag IN VARCHAR2,
p_source_id IN NUMBER,
p_source_table IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR dist_csr(v_source_id NUMBER, v_source_table VARCHAR2) IS
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE source_id = v_source_id
AND source_table = v_source_table;
SELECT accounting_event_id
FROM OKL_ACCOUNTING_EVENTS
WHERE source_id = v_source_id
AND source_table = v_source_table;
SELECT ID
FROM OKL_ACCT_SOURCES
WHERE source_id = v_source_id
AND source_table = v_source_table;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs(p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_tabv_tbl => l_dist_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Acct_Sources_Pvt.delete_acct_sources ');
Okl_Acct_Sources_Pvt.delete_acct_sources (
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_asev_rec => l_asev_rec);
Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Acct_Sources_Pvt.delete_acct_sources ');
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call Okl_Acct_Event_Pub.delete_acct_event ');
Okl_Acct_Event_Pub.delete_acct_event(p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,x_return_status => x_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_aetv_rec => l_aetv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call Okl_Acct_Event_Pub.delete_acct_event ');
END DELETE_DIST_AE;
SELECT AMOUNT
FROM OKL_TRX_CONTRACTS
WHERE ID = l_trx_id;
SELECT SUM(AMOUNT) SUM_AMOUNT
FROM OKL_TXL_CNTRCT_LNS
WHERE TCN_ID = l_trx_id;
SELECT SUM(AMOUNT) SUM_AMOUNT
FROM OKL_TXL_CNTRCT_LNS
WHERE TCN_ID = l_trx_id AND
ID <> l_txl_id;
SELECT tsu_code
FROM OKL_TRX_CONTRACTS
WHERE ID = v_tcn_id;
SELECT avl_id,
sty_id,
description,
amount
FROM OKL_TXL_CNTRCT_LNS
WHERE ID = v_tcl_id;
ELSE -- Update Mode
-- Determine what has changed
OPEN tcl_csr(l_tclv_rec_in.ID);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines(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_tclv_rec => l_tclv_rec_in,
x_tclv_rec => l_tclv_rec_out);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRMSCB.pls call OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines ');
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => l_tclv_rec_in.ID,
p_source_table => l_source_table,
x_return_status => l_return_status);
DELETE_DIST_AE(p_flag => 'AE',
p_source_id => l_tclv_rec_in.ID,
p_source_table => l_source_table,
x_return_status => l_return_status);
END IF; -- Of Update Mode
SELECT trunc(date_transaction_occurred),
-- Added by Santonyr on 22-Nov-2002 Multi-Currency
currency_code,
currency_conversion_type,
currency_conversion_rate,
currency_conversion_date
FROM OKL_TRX_CONTRACTS
WHERE ID = v_tcn_id;
SELECT ID
FROM OKL_PRODUCTS_V
WHERE aes_id = v_aes_id;
SELECT PDT_ID
FROM OKL_K_HEADERS
WHERE id = v_khr_id;
SELECT sty_id,
try_id,
aes_id,
syt_code,
-- Added by HKPATEL for bug# 2943310
inv_code,
-- Added code ends here
fac_code,
advance_arrears,
memo_yn,
prior_year_yn,
factoring_synd_flag
FROM OKL_AE_TEMPLATES
WHERE id = v_template_id;
SELECT mo_global.get_current_org_id()
from dual;
SELECT ct.object1_id1 id
from okc_contacts ct,
okc_contact_sources csrc,
okc_k_party_roles_b pty,
okc_k_headers_b chr
where ct.cpl_id = pty.id
and ct.cro_code = csrc.cro_code
and ct.jtot_object1_code = csrc.jtot_object_code
and ct.dnz_chr_id = chr.id
and pty.rle_code = csrc.rle_code
and csrc.cro_code = 'SALESPERSON'
and csrc.rle_code = 'LESSOR'
and csrc.buy_or_sell = chr.buy_or_sell
and pty.dnz_chr_id = chr.id
and pty.chr_id = chr.id
and chr.id = v_khr_id;
SELECT cust_trx_type_id
FROM ra_cust_trx_types
WHERE name = 'Invoice-OKL';
SELECT object1_id1 cust_acct_site_id
FROM okc_rules_b rul
WHERE rul.rule_information_category = 'BTO'
and exists (select '1'
from okc_rule_groups_b rgp
where rgp.id = rul.rgp_id
and rgp.rgd_code = 'LABILL'
and rgp.chr_id = rul.dnz_chr_id
and rgp.chr_id = v_khr_id );
SELECT transaction_date
FROM okl_trx_contracts
WHERE khr_id = cp_khr_id
AND trx_number = cp_trx_number;
PROCEDURE update_misc_transaction(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_jrnl_hdr_rec IN jrnl_hdr_rec_type,
p_jrnl_line_tbl IN jrnl_line_tbl_type) IS
l_prog_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'update_misc_transaction';
okl_trans_contracts_pub.update_trx_contracts(p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => lx_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_tcnv_rec => l_tcnv_rec,
x_tcnv_rec => lx_tcnv_rec);
END update_misc_transaction;