[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT khr.khr_id
FROM okl_k_headers khr
WHERE khr.id = p_id;
SELECT st.item_catalog_group_id
FROM MTL_SYSTEM_ITEMS_VL st, OKX_MODEL_LINES_V ml
WHERE ml.inventory_item_id = st.inventory_item_id
AND ml.parent_line_id = p_id;
SELECT RC.rmr_id
FROM OKL_DF_CTGY_RMK_TMS RC, OKL_AM_REMARKET_TEAMS_UV T
WHERE RC.rmr_id = T.ORIG_SYSTEM_ID
AND RC.ico_id = p_id
AND RC.date_effective_from <= SYSDATE
AND NVL(RC.date_effective_to, SYSDATE+1) >= SYSDATE;
SELECT chr_id, name, item_description
FROM okc_k_lines_v
WHERE id = p_id;
SELECT qtb.qtp_code
FROM okl_trx_quotes_b qtb
WHERE qtb.id = p_quote_id;
SELECT legal_entity_id
FROM okl_k_headers
WHERE id = p_khr_id;
SELECT SYSDATE INTO l_sysdate FROM DUAL;
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_ASSET_RETURNS_PUB.insert_asset_returns');
OKL_ASSET_RETURNS_PUB.insert_asset_returns(
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_artv_rec => lp_artv_rec,
x_artv_rec => lx_artv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_ASSET_RETURNS_PUB.insert_asset_returns, x_return_status: ' || x_return_status);
SELECT sts_code
FROM okc_k_lines_b
WHERE id = p_kle_id;
PROCEDURE update_asset_return(
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_artv_rec IN artv_rec_type,
x_artv_rec OUT NOCOPY artv_rec_type) AS
lp_artv_rec artv_rec_type := p_artv_rec;
l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
SELECT kle.name asset_number,
cim.number_of_items quantity,
oar.ars_code ars_code,
kle.id kle_id,
kle.chr_id chr_id,
msi.segment1 inventory_item_number
FROM okl_k_lines_full_v kle,
okl_asset_returns_all_b oar,
mtl_system_items_b msi,
okc_k_lines_b kle2,
okc_line_styles_b lse,
okc_k_items cim
WHERE oar.kle_id = kle.id
AND oar.imr_id = msi.inventory_item_id(+)
AND kle.id = kle2.cle_id
AND kle2.lse_id = lse.id
AND lse.lty_code = 'ITEM'
AND kle2.id = cim.cle_id
AND oar.id = p_id;
SELECT art_id, ordered_quantity
FROM okl_am_asset_sale_uv
WHERE art_id = p_art_id
AND order_status = 'BOOKED';
SELECT OTQB.ID QUOTE_ID , OTQB.ACCEPTED_YN ACCEPTED_YN
FROM OKL_TRX_QUOTES_B OTQB ,
OKL_ASSET_RETURNS_B OAR
WHERE OTQB.ART_ID = OAR.ID
AND OTQB.ART_ID = p_art_id;
SELECT meaning
FROM fnd_lookups
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code;
SELECT 'x'
FROM MTL_SYSTEM_ITEMS_B
WHERE segment1 = cp_inv_item_number;
SELECT REMK_PROCESS_CODE
FROM OKL_SYSTEM_PARAMS ;
SELECT IT.display_name
, RP.display_name
FROM WF_EVENTS WFEV,
WF_EVENT_SUBSCRIPTIONS WFES,
wf_runnable_processes_v RP,
wf_item_types_vl IT
WHERE WFEV.guid = WFES.event_filter_guid
AND WFES.WF_PROCESS_TYPE = RP.ITEM_TYPE
AND WFES.WF_PROCESS_NAME = RP.PROCESS_NAME
AND RP.ITEM_TYPE = IT.NAME
AND WFEV.NAME = c_event_name;
SELECT imr_id, new_item_number
FROM okl_asset_returns_b
WHERE id = cp_id;
SELECT legal_entity_id, deal_type --6674730
FROM okl_k_headers
WHERE id = p_khr_id;
SELECT sts_code
FROM okc_k_lines_b
WHERE id = p_kle_id;
SELECT cle.id ID,
mtlb.description item_description,
mtlb.asset_category_id asset_category_id,
hrou.name organization_name
FROM OKC_K_LINES_B CLE,
OKC_K_ITEMS CIM,
OKC_LINE_STYLES_B LSE,
MTL_SYSTEM_ITEMS_B MTLB ,
OKC_K_LINES_B KLE,
HR_OPERATING_UNITS HROU
WHERE kle.id = p_kle_id
AND cle.cle_id = kle.id
AND cle.id = cim.cle_id
AND cle.lse_id = lse.id
AND lse.lty_code = 'ITEM'
AND cim.dnz_chr_id = cle.dnz_chr_id
AND cim.object1_id1 = mtlb.inventory_item_id
AND cim.object1_id2 = to_char(mtlb.organization_id)
AND mtlb.organization_id = hrou.organization_id;
SELECT syp.asst_add_book_type_code corp_book,
syp.tax_book_1 tax_book_1,
syp.fa_location_id fa_location_id
FROM OKL_SYSTEM_PARAMS SYP;
p_msg_name => 'OKL_CONFIRM_UPDATE');
AND l_wf_new_item_number IS NOT NULL THEN -- custom wf API updated item no.
lp_artv_rec.new_item_number := l_wf_new_item_number; -- SECHAWLA 03-DEC-04 4047159 : Moved here
--You cannot update the return status to Repossessed. Please enter the Date Returned.
OKL_API.set_message( p_app_name => 'OKL',
p_msg_name => 'OKL_AM_ASSET_DATE_RET_REQ');
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling OKL_ASSET_RETURNS_PUB.update_asset_returns');
OKL_ASSET_RETURNS_PUB.update_asset_returns(
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_artv_rec => lp_artv_rec,
x_artv_rec => lx_artv_rec);
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called OKL_ASSET_RETURNS_PUB.update_asset_returns, x_return_status: ' || x_return_status);
END update_asset_return;
l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
PROCEDURE update_asset_return(
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_artv_tbl IN artv_tbl_type,
x_artv_tbl OUT NOCOPY artv_tbl_type) AS
l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'update_asset_return';
l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_asset_return';
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'calling update_asset_return');
update_asset_return (
p_api_version => p_api_version,
p_init_msg_list => OKL_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_artv_rec => p_artv_tbl(i),
x_artv_rec => x_artv_tbl(i));
OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name, 'called update_asset_return, l_return_status: ' || l_return_status);
END update_asset_return;