[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ACCOUNT_DERIVATION
FROM okl_sys_acct_opts;
select o.set_of_books_id ledger_id,
g.short_name rep_code,
'PRIMARY' rep_type
FROM okl_sys_acct_opts o,
gl_ledgers g
WHERE o.set_of_books_id = g.ledger_id
UNION ALL
select f.set_of_books_id ledger_id,
g.short_name rep_code,
'SECONDARY' rep_type
FROM okl_sys_acct_opts o,
okl_system_params_all s,
fa_book_controls f,
gl_ledgers g
WHERE o.org_id = s.org_id
AND s.RPT_PROD_BOOK_TYPE_CODE = f.book_type_code
AND f.set_of_books_id = g.ledger_id
AND o.secondary_rep_method = 'AUTOMATED';
,tmpl_rec.LAST_UPDATED_BY
,tmpl_rec.LAST_UPDATE_DATE
,tmpl_rec.LAST_UPDATE_LOGIN
,tmpl_rec.INV_CODE;
SELECT aes_id
FROM OKL_PRODUCTS_V
WHERE ID = v_prod_id;
l_stmt := ' SELECT ID
,NAME
,SET_OF_BOOKS_ID
,STY_ID
,TRY_ID
,AES_ID
,SYT_CODE
,FAC_CODE
,FMA_ID
,ADVANCE_ARREARS
,POST_TO_GL
,VERSION
,START_DATE
,OBJECT_VERSION_NUMBER
,MEMO_YN
,PRIOR_YEAR_YN
,DESCRIPTION
,FACTORING_SYND_FLAG
,END_DATE
,ACCRUAL_YN
,ORG_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,INV_CODE
FROM OKL_AE_TEMPLATES A WHERE 1 = 1 ';
SELECT name
FROM okl_formulae_v
WHERE id = v_id;
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;
SELECT POSTED_YN
FROM OKL_TRNS_ACC_DSTRS
WHERE source_id = v_source_id
AND source_table = v_source_table;
SELECT distinct xle.event_status_code
FROM OKL_TRNS_ACC_DSTRS dist,
XLA_EVENTS xle
WHERE dist.SOURCE_ID = v_source_id
AND dist.SOURCE_TABLE = v_source_table
AND dist.accounting_event_id = xle.event_id;
SELECT ID,
CODE_COMBINATION_ID
,AE_LINE_TYPE
,CRD_CODE
,ACCOUNT_BUILDER_YN
,PERCENTAGE
FROM OKL_AE_TMPT_LNES
WHERE avl_id = v_avl_id;
SELECT rounding_ccid
,cc_apply_rounding_difference
,ael_apply_rounding_difference
FROM OKL_SYS_ACCT_OPTS;
SELECT ROUNDING_CCID rounding_code_combination_id
FROM GL_LEDGERS_PUBLIC_V
WHERE ledger_id = v_set_of_books_id;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(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_tabv_tbl => l_tabv_tbl
,x_tabv_tbl => l_tabv_tbl_out);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
SELECT rounding_ccid
,cc_apply_rounding_difference
,ael_apply_rounding_difference
FROM OKL_SYS_ACCT_OPTS;
SELECT ROUNDING_CCID rounding_code_combination_id
FROM GL_LEDGERS_PUBLIC_V
WHERE ledger_id = v_set_of_books_id;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to INSERT_TRNS_ACC_DSTRS, the parameters passed are :');
Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS(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_tabv_tbl => l_tabv_tbl
,x_tabv_tbl => l_tabv_tbl_out);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'The return status after the call to Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS'||l_return_status);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.INSERT_TRNS_ACC_DSTRS ');
PROCEDURE UPDATE_POST_TO_GL(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_source_id IN NUMBER,
p_source_table IN VARCHAR2)
IS
l_tabv_tbl_in TABV_TBL_TYPE;
SELECT ID
FROM OKL_TRNS_ACC_DSTRS
WHERE source_id = p_source_id
AND source_table = p_source_table;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs(p_api_version => l_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_tabv_tbl => l_tabv_tbl_in,
x_tabv_tbl => l_tabv_tbl_out);
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.update_trns_acc_dstrs ');
END UPDATE_POST_TO_GL;
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;
OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRTDTB.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 OKLRTDTB.pls call Okl_Trns_Acc_Dstrs_Pub.delete_trns_acc_dstrs ');
END DELETE_DIST_AE;
x_template_rec.last_updated_by := p_temp_rec.last_updated_by;
x_template_rec.last_update_date := p_temp_rec.last_update_date;
x_template_rec.last_update_login := p_temp_rec.last_update_login;
SELECT name
FROM okl_formulae_v
WHERE id = v_id;
SELECT name
FROM okl_products
WHERE id = l_pdt_id ;
SELECT name
FROM okl_trx_types_tl
WHERE id = l_trx_type_id ;
SELECT name
FROM okl_strm_type_tl
WHERE id = l_sty_type_id ;
SELECT tcl.tcn_id
FROM OKL_TXL_CNTRCT_LNS_ALL tcl
WHERE tcl.id = p_source_id;
SELECT TXL.TAI_ID
FROM OKL_TXL_AR_INV_LNS_B TXL,
OKL_TXD_AR_LN_DTLS_B TXD
WHERE TXD.TIL_ID_DETAILS = TXL.ID
AND TXD.ID = p_source_id;
SELECT ADJ_ID
FROM OKL_TXL_ADJSTS_LNS_ALL_B
WHERE ID = p_source_id;
SELECT tai.id tai_id
,tld.khr_id khr_id
,tld.kle_id kle_id
,tld.sty_id sty_id
,tai.try_id try_id
,tll.description trans_line_description
FROM okl_trx_ar_invoices_b tai
,okl_txl_ar_inv_lns_b til
,okl_txd_ar_ln_dtls_b tld
,okl_txd_ar_ln_dtls_tl tll
WHERE tll.id = tld.id
AND tld.til_id_details = til.id
AND til.tai_id = tai.id
AND tld.id = p_source_id;
SELECT adj.id adj_id
,adjl.khr_id khr_id
,adjl.kle_id kle_id
,adjl.sty_id sty_id
,adj.try_id try_id
FROM okl_trx_ar_adjsts_all_b adj
,okl_txl_adjsts_lns_all_b adjl
WHERE adjl.adj_id = adj.id
AND adjl.id = p_source_id;
SELECT tpl.tap_id
FROM okl_txl_ap_inv_lns_b tpl
WHERE TPL.ID = p_source_id;
SELECT tpl.id tap_id
,tpl.khr_id khr_id
,tpl.kle_id kle_id
,tpl.sty_id sty_id
,tap.try_id try_id
,tap.vendor_invoice_number trans_number
,tll.description trans_line_description
FROM okl_trx_ap_invoices_b tap
,okl_txl_ap_inv_lns_b tpl
,okl_txl_ap_inv_lns_tl tll
WHERE tll.id = tpl.id
AND tap.id = tpl.tap_id
AND tpl.id = p_source_id;
SELECT GL.SHORT_NAME
FROM OKL_SYS_ACCT_OPTS SAO,
GL_LEDGERS GL
WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
SELECT TRY.AEP_CODE
FROM OKL_TRX_TYPES_B TRY
WHERE TRY.ID = p_try_id;
SELECT 1
FROM OKL_TRNS_ACC_DSTRS_ALL
WHERE SOURCE_ID = p_source_id
AND SOURCE_TABLE = p_source_table;
SELECT HEADER_EXTENSION_ID
FROM OKL_TRX_EXTENSION_B
WHERE SOURCE_ID = p_source_id;
SELECT set_of_books_id
FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns
WHERE hdr.id = lns.tcn_id
AND lns.id = p_tcl_id;
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => p_dist_info_rec.source_id,
p_source_table => p_dist_info_rec.source_table,
x_return_status => l_return_status);
okl_sla_acc_sources_pvt.delete_trx_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_trans_hdr_rec => l_tcnv_rec
,x_trans_line_tbl => l_tclv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_rec
,x_rxlv_tbl => x_rxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_adj_rec
,x_rxlv_tbl => x_rxlv_adj_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ap_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_pxhv_rec => l_pxhv_rec
,x_pxlv_tbl => x_pxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => p_dist_info_rec.source_id,
p_source_table => p_dist_info_rec.source_table,
x_return_status => l_return_status);
okl_sla_acc_sources_pvt.delete_trx_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_trans_hdr_rec => l_tcnv_rec
,x_trans_line_tbl => l_tclv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_rec
,x_rxlv_tbl => x_rxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_adj_rec
,x_rxlv_tbl => x_rxlv_adj_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ap_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_pxhv_rec => l_pxhv_rec
,x_pxlv_tbl => x_pxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(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_tabv_tbl => l_tabv_tbl
,x_tabv_tbl => x_tabv_tbl
);
SELECT name
FROM okl_formulae_v
WHERE id = v_id;
SELECT name
FROM okl_products
WHERE id = l_pdt_id ;
SELECT name
FROM okl_trx_types_tl
WHERE id = l_trx_type_id
AND language = USERENV('LANG');
SELECT name
FROM okl_strm_type_tl
WHERE id = l_sty_type_id
AND language = USERENV('LANG');
SELECT tcl.tcn_id
FROM OKL_TXL_CNTRCT_LNS tcl
WHERE tcl.id = p_source_id;
SELECT set_of_books_id
FROM okl_trx_contracts hdr, okl_txl_cntrct_lns lns
WHERE hdr.id = lns.tcn_id
AND lns.id = p_tcl_id;
SELECT GL.SHORT_NAME
FROM OKL_SYS_ACCT_OPTS SAO,
GL_LEDGERS GL
WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => l_dist_info_tbl(i).source_id,
p_source_table => l_dist_info_tbl(i).source_table,
x_return_status => l_return_status);
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => l_dist_info_tbl(i).source_id,
p_source_table => l_dist_info_tbl(i).source_table,
x_return_status => l_return_status);
OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(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_tabv_tbl => l_Tabv_tbl_final
,x_tabv_tbl => x_tabv_tbl
);
SELECT name
FROM okl_formulae_v
WHERE id = v_id;
SELECT name
FROM okl_products
WHERE id = l_pdt_id ;
SELECT name
FROM okl_trx_types_tl
WHERE id = l_trx_type_id
AND language = USERENV('LANG');
SELECT name
FROM okl_strm_type_tl
WHERE id = l_sty_type_id
AND language = USERENV('LANG');
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => l_dist_info_tbl(i).source_id,
p_source_table => l_dist_info_tbl(i).source_table,
x_return_status => l_return_status);
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => l_dist_info_tbl(i).source_id,
p_source_table => l_dist_info_tbl(i).source_table,
x_return_status => l_return_status);
SELECT name
FROM okl_formulae_v
WHERE id = v_id;
SELECT name
FROM okl_products
WHERE id = l_pdt_id ;
SELECT name
FROM okl_trx_types_tl
WHERE id = l_trx_type_id ;
SELECT name
FROM okl_strm_type_tl
WHERE id = l_sty_type_id ;
SELECT tcl.tcn_id
FROM OKL_TXL_CNTRCT_LNS_ALL tcl
WHERE tcl.id = p_source_id;
SELECT set_of_books_id
FROM okl_trx_contracts
WHERE id = p_trx_header_id;
SELECT GL.SHORT_NAME
FROM OKL_SYS_ACCT_OPTS SAO,
GL_LEDGERS GL
WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
SELECT TRY.AEP_CODE
FROM OKL_TRX_TYPES_B TRY
WHERE TRY.ID = p_try_id;
SELECT distinct dist.accounting_event_id
FROM okl_trns_acc_dstrs_all dist,
okl_txl_cntrct_lns_all txl,
okl_trx_contracts_all trx
WHERE dist.source_id = txl.id
AND txl.tcn_id = trx.id
and trx.id = p_tcn_id;
SELECT 1
FROM OKL_EXT_AR_HEADER_SOURCES_B RXH
WHERE RXH.SOURCE_ID = p_trx_header_id;
SELECT 1
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
WHERE PXH.SOURCE_ID = p_trx_header_id;
l_dist_info_temp_tbl.DELETE;
l_ctxt_val_temp_tbl.DELETE;
l_acc_gen_temp_tbl.DELETE;
okl_sla_acc_sources_pvt.delete_trx_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_trans_hdr_rec => l_tcnv_rec
,x_trans_line_tbl => x_tclv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
OKL_TRNS_ACC_DSTRS_PUB.update_trns_acc_dstrs(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_tabv_tbl => l_tabv_tbl
,x_tabv_tbl => x_tabv_tbl
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_rec
,x_rxlv_tbl => x_rxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ar_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_rxhv_rec => l_rxhv_adj_rec
,x_rxlv_tbl => x_rxlv_adj_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
okl_sla_acc_sources_pvt.delete_ap_extension(
p_api_version => l_api_version
,p_init_msg_list => l_init_msg_list
,p_pxhv_rec => l_pxhv_rec
,x_pxlv_tbl => x_pxlv_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
);
PROCEDURE DELETE_ACCT_ENTRIES(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_source_id IN NUMBER,
p_source_table IN VARCHAR2)
IS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name VARCHAR2(30) := 'DELETE_ACCT_ENTRIES';
DELETE_DIST_AE(p_flag => 'DIST',
p_source_id => p_source_id,
p_source_table => p_source_table,
x_return_status => l_return_status);
END DELETE_ACCT_ENTRIES;
Okl_Acct_Sources_Pvt. insert_acct_sources (
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_asev_tbl => l_asev_tbl
,x_asev_tbl => x_asev_tbl);
Okl_Acct_Sources_Pvt. insert_acct_sources_bulk (
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_asev_tbl => l_asev_full_tbl
,x_asev_tbl => x_asev_tbl);