[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM wf_event_subscriptions a,
wf_events b
WHERE a.event_filter_guid = b.guid
AND a.status = 'ENABLED'
AND b.name = p_event_name
AND rownum = 1;
select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
l_parameter_list.DELETE;
select user_name name,user_name display_name
from fnd_user
where user_id=P_USER_ID
and employee_id is null
union all
select
USR.USER_NAME name, PER.FULL_NAME display_name
from
PER_PEOPLE_F PER,
FND_USER USR
where trunc(SYSDATE)
between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
and PER.PERSON_ID = USR.EMPLOYEE_ID
and USR.USER_ID = P_USER_ID;
select source_user_id
from ar_cmgt_credit_requests
where credit_request_id = b_credit_request_id;
select role, name
from
(select 1 num, FND_PROFILE.VALUE('OKL_CREDIT_ANALYST') role,
NVL(PER.FULL_NAME, USR.USER_NAME) name
from FND_USER USR, PER_PEOPLE_F PER
where USR.USER_NAME = FND_PROFILE.VALUE('OKL_CREDIT_ANALYST')
and USR.EMPLOYEE_ID = PER.PERSON_ID(+)
and trunc(sysdate) between nvl(per.effective_start_date, trunc(sysdate)) and
nvl(per.effective_end_date, trunc(sysdate))
);
SELECT
null quote_number
,null credit_req_number
,to_number(null) credit_amount
,to_date(null) requested_date
,null account_number
,null party_name
,to_number(null) id -- okl credit request id
,to_number(null) quote_id
,null status -- lookup code (not meaning)
,null currency_code
from dual;
SELECT
credit_recommendation
,recommendation_value1
,recommendation_value2
FROM ar_cmgt_cf_recommends
WHERE credit_request_id = b_credit_request_id;
SELECT id
FROM OKC_LINE_STYLES_b
WHERE LTY_CODE = 'FREE_FORM';
SELECT name
FROM okx_parties_v
WHERE id1 = b_party_id;
SELECT
limit_currency
,limit_amount
,trx_currency
,trx_amount
,party_id
,cust_account_id
,site_use_id
,application_date
FROM ar_cmgt_credit_requests
WHERE credit_request_id = b_credit_request_id;
SELECT
quote_id -- this is actually the contract id.
,credit_req_number
,credit_req_id
,credit_amount
,approved_by
,approved_date
,status
,credit_khr_id
,currency_code
,org_id
,created_by
FROM okl_credit_requests
WHERE credit_req_id = b_credit_request_id;
SELECT INV_ORGANIZATION_ID FROM OKC_K_HEADERS_B
WHERE ID = p_qte_id;
SELECT credit_recommendation,
recommendation_value1,
recommendation_value2
FROM ar_cmgt_cf_recommends
WHERE credit_request_id = b_request_id ;
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = b_user_id;
SELECT user_id
FROM fnd_user
WHERE user_name = b_user_name;
SELECT OBJECT_VERSION_NUMBER
INTO l_crqv_rec_type.OBJECT_VERSION_NUMBER
FROM OKL_CREDIT_REQUESTS
WHERE ID = l_okl_credit_req ;
okl_credit_request_pub.update_credit_request(
p_api_version => l_api_version
,p_init_msg_list => 'T'
,x_return_status =>x_return_status
,x_msg_count => x_msg_count
,x_msg_data =>x_msg_data
,p_crqv_rec =>l_crqv_rec_type
,x_crqv_rec => x_crqv_rec_type);
PROCEDURE UPDATE_STATUS(
itemtype IN VARCHAR2,
itemkey IN VARCHAR2,
actid IN NUMBER,
funcmode IN VARCHAR2,
resultout OUT NOCOPY VARCHAR2)
IS
-- Variables Declarations
l_api_version CONSTANT NUMBER DEFAULT G_INIT_VERSION;
l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_STATUS';
SELECT CCR.SOURCE_COLUMN1
, LAB.CREATED_BY
, LAB.PROSPECT_ID
, LAB.CUST_ACCT_ID
, LAB.ORG_ID
FROM AR_CMGT_CREDIT_REQUESTS CCR
, OKL_LEASE_APPS_ALL_B LAB
WHERE CCR.SOURCE_COLUMN3 = 'LEASEAPP'
AND CCR.SOURCE_COLUMN1 = LAB.ID
AND CCR.CREDIT_REQUEST_ID = cp_credit_req_id;
SELECT credit_recommendation, status
FROM ar_cmgt_cf_recommends
WHERE credit_request_id = p_credit_request_id
AND credit_recommendation IN ('REJECT','APPROVE');
SELECT ID
FROM OKL_LEASE_QUOTES_B
WHERE PARENT_OBJECT_ID = cp_lap_id
AND PARENT_OBJECT_CODE = 'LEASEAPP'
AND PRIMARY_QUOTE = 'Y';
SELECT DISTINCT STATUS
FROM okl_lease_quotes_b
WHERE status = 'CR-RECOMMENDATION'
AND parent_object_code = 'LEASEAPP'
AND PARENT_OBJECT_ID = cp_lap_id;
L_MODULE := 'OKL.PLSQL.OKL_SO_CREDIT_APP_WF.UPDATE_STATUS';
,'begin debug call OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE');
OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE(
p_api_version => l_api_version
,p_init_msg_list => OKL_API.G_FALSE
,p_transaction_control => OKL_API.G_TRUE
,p_lease_qte_rec => l_lsqv_rec
,x_lease_qte_rec => x_lsqv_rec
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
,'end debug call OKL_LEASE_QUOTE_PVT.UPDATE_LEASE_QTE');
,'begin debug call OKL_LAP_PVT.UPDATE_ROW');
OKL_LAP_PVT.UPDATE_ROW(
p_api_version => l_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_lapv_rec => l_lapv_rec
,x_lapv_rec => x_lapv_rec);
,'end debug call OKL_LAP_PVT.UPDATE_ROW');
,L_MODULE || ' Result of OKL_LAP_PVT.UPDATE_ROW'
,'l_return_status ' || l_return_status);
END UPDATE_STATUS ;
SELECT SUM(KLE.CAPITAL_AMOUNT) ,chr.contract_number
FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE, OKC_K_HEADERS_V CHR
WHERE chr.scs_code = 'QUOTE'
AND chr.ID = l_quote_id
AND CLEB.ID = KLE.ID
AND CLEB.DNZ_CHR_ID = chr.ID
AND CLEB.CLE_ID IS NULL
GROUP BY chr.ID , chr.contract_number;
select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
okl_credit_request_pub.insert_credit_request(
p_api_version => l_api_version
,p_init_msg_list => 'T'
,x_return_status =>x_return_status
,x_msg_count => x_msg_count
,x_msg_data =>x_msg_data
,p_crqv_rec =>l_crqv_rec_type
,x_crqv_rec => x_crqv_rec_type);