[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wfu.NAME, wfu.DISPLAY_NAME
FROM WF_USERS wfu, fnd_user fndu
WHERE wfu.orig_system_id = fndu.employee_id
AND fndu.employee_id = c_user_id
AND wfu.ORIG_SYSTEM = G_WF_USER_ORIG_SYSTEM_HR;
SELECT USER_NAME, DESCRIPTION
FROM FND_USER
WHERE user_id = c_user_id;
PROCEDURE l_update_funding_status(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_funding_status IN OKL_TRX_AP_INVOICES_B.TRX_STATUS_CODE%TYPE,
p_funding_id IN OKL_TRX_AP_INVOICES_B.ID%TYPE) IS
l_tapv_rec tapv_rec_type;
SELECT h.VENDOR_INVOICE_NUMBER,
h.PAY_GROUP_LOOKUP_CODE,
h.NETTABLE_YN,
h.FUNDING_TYPE_CODE,
h.INVOICE_TYPE,
--Bug# 5690875
h.KHR_ID
FROM OKL_TRX_AP_INVOICES_B h
WHERE h.id = p_funding_id
;
Select id funding_line_id
from OKL_TXL_AP_INV_LNS_B
Where tap_id = p_fund_id;
OKL_TRX_AP_INVOICES_PUB.UPDATE_TRX_AP_INVOICES(
p_api_version => p_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_tapv_rec => l_tapv_rec,
x_tapv_rec => x_tapv_rec);
END l_update_funding_status;
SELECT tap.vendor_invoice_number
FROM okl_trx_ap_invoices_b tap
WHERE tap.id = p_funding_id;
SELECT con.contract_number,con.id
FROM OKL_TRX_AP_INVOICES_B ap_inv
,OKC_K_HEADERS_B con
,okl_txl_ap_inv_lns_all_b tpl
WHERE ap_inv.id = tpl.tap_id
AND tpl.khr_id = con.id
AND ap_inv.id = p_funding_id;
SELECT APPLICATION_ID
FROM FND_APPLICATION
WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
SELECT B.TRANSACTION_TYPE_ID,
B.FND_APPLICATION_ID
FROM AME_CALLING_APPS B,
AME_CALLING_APPS_TL T
WHERE B.APPLICATION_ID = T.APPLICATION_ID
AND T.LANGUAGE = 'US'
AND T.APPLICATION_NAME = c_trx_type;
SELECT okl_wf_item_s.NEXTVAL item_key
FROM dual;
SELECT id
FROM okl_trx_types_b
WHERE trx_type_class = G_TRX_TYPE_FUNDING_APPROVAL;
l_update_funding_status(p_api_version => p_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_funding_status => 'PENDING_APPROVAL',
p_funding_id => p_funding_id);
l_parameter_list.DELETE;
l_update_funding_status(p_api_version => p_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_funding_status => 'PENDING_APPROVAL',
p_funding_id => p_funding_id);
SELECT chrb.id,
chrb.contract_number creditline,
chrb.currency_code
FROM okc_k_headers_b chrb
WHERE chrb.id = p_creditline_id
;
SELECT h.id,
h.funding_type_code,
h.vendor_invoice_number fund_number,
h.currency_code,
look1.MEANING payment_method_name,
look2.MEANING funding_type_name,
h.date_invoiced fund_due_date,
v.vendor_name,
vs.vendor_site_code,
khr.id contract_id,
khr.contract_number,
party.name customer_name
FROM OKL_TRX_AP_INVS_ALL_B h,
okl_txl_ap_inv_lns_all_b tpl,
OKC_K_HEADERS_ALL_B khr,
PO_VENDORS v,
PO_VENDOR_SITES_ALL vs,
FND_LOOKUPS look1,
FND_LOOKUPS look2,
okx_parties_v party,
okc_k_party_roles_b cpl
WHERE party.id1 = cpl.object1_id1
AND party.id2 = cpl.object1_id2
AND cpl.rle_code = 'LESSEE'
AND cpl.chr_id = khr.id
AND h.id = tpl.tap_id
and tpl.khr_id = khr.id
AND h.ipvs_id = vs.vendor_site_id
AND vs.vendor_id = v.vendor_id
AND h.payment_method_code = look1.LOOKUP_CODE
AND look1.LOOKUP_TYPE = 'OKL_AP_PAYMENT_METHOD'
AND h.funding_type_code = look2.LOOKUP_CODE
AND look2.LOOKUP_TYPE = 'OKL_FUNDING_TYPE'
AND h.id = p_funding_id;
SELECT KHR_ID,
TODO_ITEM_CODE,
TODO_ITEM_MEANING,
MANDATORY_FLAG_MEANING,
MANDATORY_FLAG,
CHECK_OFF_RESULTS,
FUNC_VAL_RSTS_MEANING,
FUNCTION_ID,
FUNCTION_NAME,
CHECKIST_RESULTS
FROM okl_funding_checklists_uv
WHERE FUND_REQ_ID = p_funding_id;
select 1
from okc_k_headers_b
where ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
and id = p_contract_id;
SELECT USER_NAME
FROM FND_USER
WHERE user_id = p_user_id;
PROCEDURE update_approval_status(itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2)
IS
CURSOR l_okl_trx_contracts_csr(p_trx_number IN VARCHAR2)
IS
SELECT id
FROM okl_trx_contracts
WHERE trx_number = p_trx_number
--rkuttiya added for 12.1.1 Multi GAAP Project
AND representation_type = 'PRIMARY';
SELECT org_id
FROM OKL_TRX_AP_INVS_ALL_B
where ID = p_funding_id;
l_api_name VARCHAR2(30) := 'update_approval_status';
l_update_funding_status
(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_funding_status => 'APPROVED',
p_funding_id => l_funding_id);
l_update_funding_status
(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_funding_status => 'REJECTED',
p_funding_id => l_funding_id);
Okl_Trx_Contracts_Pub.update_trx_contracts(
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_tcnv_rec => l_trxH_in_rec
,x_tcnv_rec => l_trxH_out_rec);
END update_approval_status;
SELECT okl_wf_item_s.NEXTVAL item_key
FROM dual;