[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT contract_type, contract_number, contract_name, contract_version_num
FROM okc_rep_contracts_all
WHERE contract_id = l_contract_id;
SELECT owner_role from wf_items wf WHERE wf.item_type=itemtype AND wf.item_key=itemkey;
SELECT Min(SIGNATURE_SEQUENCE)
FROM okc_rep_party_contacts opc
WHERE opc.contract_id=p_contract_id
AND NOT EXISTS
(SELECT 1 FROM okc_rep_signature_details orsd, okc_rep_contracts_all orca
WHERE orsd.contract_id=opc.contract_id AND sequence_level=opc.SIGNATURE_SEQUENCE
AND orca.contract_id = orsd.contract_id
AND orca.contract_version_num = orsd.contract_version_num);
SELECT contact_id,party_id,PARTY_ROLE_CODE,SIGNATURE_SEQUENCE,ESIGNATURE_TYPE
FROM okc_rep_party_contacts opc
WHERE opc.contract_id=p_contract_id
AND signature_sequence=p_seq;
SELECT f.user_name ,(pvc.first_name || ' ' || pvc.middle_name || ' ' || pvc.last_name) contact_name
FROM po_vendor_contacts pvc,FND_USER f
where pvc.PER_PARTY_ID= f.person_party_id
AND pvc.vendor_contact_id=p_contact_id;
SELECT f.user_name ,( hz.person_first_name||' '||hz.person_last_name ) contact_name FROM
hz_relationships hr,
hz_parties hz,
FND_USER f
WHERE
hr.party_id = p_contact_id
AND hr.subject_id = hz.party_id
AND hr.object_id = p_object_id
AND hr.object_type = 'ORGANIZATION'
AND hr.object_table_name = 'HZ_PARTIES'
AND hr.subject_type = 'PERSON'
AND hz.party_id = hr.subject_id
AND hr.relationship_code = 'CONTACT_OF'
AND hr.status = 'A'
AND hr.start_date <= sysdate
AND nvl(hr.end_date, sysdate + 1) > SYSDATE
AND f.person_party_id(+) = hz.party_id ;
SELECT f.user_name,p.full_name contact_name from
per_workforce_v p,
fnd_user f
WHERE f.employee_id(+)=p.person_id and
p.person_id=p_contact_id;
SELECT f.user_name FROM
OKC_REP_CONTRACTS_ALL okr ,
fnd_user f
WHERE okr.contract_id=p_contract_id
AND okr.owner_id=f.user_id;
l_next_signers.DELETE;
PROCEDURE update_hist_status_detailed(
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout OUT nocopy varchar2
) IS
l_contract_id okc_rep_signature_details.contract_id%type;
SELECT fu.user_id user_id, fu.user_name user_name,
fu1.user_id original_user_id,fu1.user_name original_user_name
FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
WHERE fu.user_name = wfn.recipient_role
AND fu1.user_name = wfn.original_recipient
AND wfn.notification_id = p_notification_id ;
SELECT Count(item_key) FROM wf_items
WHERE item_type=itemtype
AND item_key like p_master_key || '!_' || '%' ESCAPE '!'
and end_date is null;
SELECT CONTRACT_TYPE, org_id
FROM OKC_REP_CONTRACTS_ALL
WHERE contract_id = p_contract_id;
l_api_name := 'update_hist_status_detailed';
'Entered OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');
SELECT contract_id INTO l_exist_id FROM okc_rep_contracts_all orca
WHERE orca.contract_type = l_contract_type
AND org_id = l_org_id
AND contract_number = l_control_number
AND contract_id <> l_contract_id;
UPDATE okc_rep_contracts_all SET contract_number = l_control_number
WHERE contract_id = l_contract_id
AND contract_version_num = 1;
'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed from funcmode=RUN');
'In OKC_REP_SIGN_WF_PVT.update_hist_status_detailed funcmode=TIMEOUT');
'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');
'618: Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed with exceptions ' || sqlerrm);
'update_hist_status_detailed',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_hist_status_detailed;
l_update_event_tbl EVENT_TBL_TYPE;
SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
FROM OKC_REP_CONTRACTS_ALL
WHERE contract_id = p_contract_id;
SELECT contract_effective_date, contract_expiration_date
FROM OKC_REP_CONTRACT_VERS
WHERE contract_id = p_contract_id
AND contract_version_num = l_contract_version;
'Before checking if we need to call updateDeliverable and disableDeliverable()');
l_update_event_tbl(1).event_code := G_CONTRACT_EFFECTIVE_EVENT;
l_update_event_tbl(1).event_date := contract_rec.contract_effective_date;
l_update_event_tbl(2).event_code := G_CONTRACT_EXPIRE_EVENT;
l_update_event_tbl(2).event_date := contract_rec.contract_expiration_date;
'Calling OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables');
OKC_MANAGE_DELIVERABLES_GRP.updateDeliverables (
p_api_version => 1.0,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
p_bus_doc_id => l_contract_id,
p_bus_doc_type => contract_rec.contract_type,
p_bus_doc_version => contract_rec.contract_version_num,
p_bus_doc_date_events_tbl => l_update_event_tbl,
x_msg_data => l_msg_data,
x_msg_count => l_msg_count,
x_return_status => l_return_status);
'OKC_DELIVERABLE_PROCESS_PVT.updateDeliverables return status is : '
|| l_return_status);
UPDATE okc_rep_contracts_all
SET latest_signed_ver_number = contract_rec.contract_version_num
WHERE contract_id = l_contract_id;
select 'Y'
from okc_contract_docs
where business_document_type = l_contract_type
and business_document_id = l_contract_id
AND request_id = l_con_req_id;
SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;
SELECT org_id INTO l_org_id
FROM okc_rep_contracts_all
WHERE contract_id = l_contract_id;