[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 user_name INTO l_user_name
FROM (
SELECT user_name FROM fnd_user fu, per_all_assignments_f asg, per_all_people_f per
WHERE asg.position_id = l_next_approvers (i).orig_system_id
AND per.person_id = asg.person_id
AND fu.employee_id = per.person_id
AND TRUNC(SYSDATE) BETWEEN per.effective_start_date AND NVL(per.effective_end_date, TRUNC( SYSDATE))
AND asg.primary_flag = 'Y'
AND asg.assignment_type IN ( 'E', 'C' )
AND ( per.current_employee_flag = 'Y' OR per.current_npw_flag = 'Y' )
AND asg.assignment_status_type_id NOT IN
( SELECT assignment_status_type_id
FROM per_assignment_status_types
WHERE per_system_status = 'TERM_ASSIGN' )
AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
ORDER BY per.last_name )
WHERE ROWNUM = 1;
PROCEDURE update_ame_status(
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout OUT nocopy varchar2
) IS
l_contract_id OKC_REP_CON_APPROVALS.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 ;
l_api_name := 'update_ame_status';
'Entered OKC_REP_WF_PVT.update_ame_status');
ame_api2.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE);
'Calling ame_api2.updateApprovalStatus');
ame_api2.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE);
'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');
'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
'Calling ame_api2.updateApprovalStatus');
ame_api2.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE);
'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
'618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
'update_ame_status',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_ame_status;
PROCEDURE update_ame_status_detailed(
itemtype IN varchar2,
itemkey IN varchar2,
actid IN number,
funcmode IN varchar2,
resultout OUT nocopy varchar2
) IS
l_contract_id OKC_REP_CON_APPROVALS.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 ;
l_api_name := 'update_ame_status';
'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
'Calling ame_api6.updateApprovalStatus');
ame_api6.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE,
notificationIn => l_notification_record);
'Calling ame_api6.updateApprovalStatus');
ame_api6.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE,
notificationIn => l_notification_record);
SELECT user_id INTO l_recipient_id
FROM fnd_user
WHERE user_name = l_recipient_record2.name;
'Calling ame_api6.updateApprovalStatus');
ame_api6.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE,
notificationIn => l_notification_record,
forwardeeIn => l_recipient_record2);
'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');
'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
'Calling ame_api6.updateApprovalStatus');
ame_api6.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE,
notificationIn => l_notification_record);
'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
SELECT user_id INTO l_recipient_id
FROM fnd_user
WHERE user_name = l_recipient_record2.name;
'Calling ame_api6.updateApprovalStatus');
ame_api6.updateApprovalStatus(
applicationIdIn => G_APPLICATION_ID,
transactionIdIn => fnd_number.number_to_canonical(l_contract_id),
approverIn => l_approver_record2,
transactionTypeIn => G_TRANSACTION_TYPE,
notificationIn => l_notification_record,
forwardeeIn => l_recipient_record2);
'618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
'update_ame_status_detailed',
itemtype,
itemkey,
to_char(actid),
funcmode);
END update_ame_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,esignature_required
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 item_key FROM wf_items
WHERE item_type=itemtype
AND item_key like itemkey || '_' || '%'
and end_date is null;
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 decode(category, 'EMPLOYEE', source_id, null) person_id from jtf_rs_resource_extns where user_id =p_user_id ;
SELECT Nvl(ALLOW_APPROVER_EDIT_YN,'N') FROM okc_bus_doc_types_b WHERE document_type=l_contract_type;
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;