[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT busDocTL.name,
deliverable.business_document_number,
deliverable.deliverable_name,
deliverable.notify_prior_due_date_value,
deliverable.notify_prior_due_date_uom
FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable
WHERE deliverable.deliverable_id = l_del_id
AND deliverable.business_document_type = busDocTL.document_type
AND busDocTL.language = userenv('LANG');
select meaning into l_uom_text from fnd_lookups
where lookup_type = 'OKC_DELIVERABLE_TIME_UNITS'
and lookup_code = del_tokens_rec.notify_prior_due_date_uom;
select email_address, full_name from PER_PEOPLE_F where person_id = x_employee_id;
SELECT tl.name,b.document_type_class,
b.external_userlist_proc,b.notification_header_function
FROM okc_bus_doc_types_b b, okc_bus_doc_types_tl tl
WHERE b.document_type = tl.document_type
AND tl.language = userenv('LANG')
AND b.document_type = p_business_document_type;
select user_id
from fnd_user
where person_party_id=p_external_contact;
select delType.internal_flag
from okc_deliverable_types_b delType,
okc_bus_doc_types_b docType,
okc_del_bus_doc_combxns delComb
where delType.deliverable_type_code = p_deliverable_type
and docType.document_type = p_business_document_type
and docType.document_type_class = delComb.document_type_class
and delType.deliverable_type_code = delComb.deliverable_type_code;
select resp_party_code
from
okc_resp_parties_b delrsp
,okc_bus_doc_types_b docType
where delrsp.resp_party_code = p_resp_party
and doctype.document_type = p_business_document_type
and delrsp.document_type_class = docType.document_type_class
and delrsp.intent = docType.intent;
select external_party_id, external_party_role
from okc_deliverables
where deliverable_id = p_deliverable_id;
select relation.party_id party_id
from hz_parties relation
,hz_parties person
,hz_relationships hz
where relation.party_id = hz.party_id
and person.party_id = hz.subject_id
and hz.subject_type = 'PERSON'
and hz.object_type = 'ORGANIZATION'
and hz.subject_table_name ='HZ_PARTIES'
and hz.object_table_name ='HZ_PARTIES'
and person.party_id = p_external_contact;
SELECT hc.email_address
FROM hz_contact_points hc
WHERE hc.owner_table_name = 'HZ_PARTIES'
AND hc.primary_flag = 'Y'
AND hc.contact_point_type = 'EMAIL'
AND hc.owner_table_id = x;
select email_address
from hz_parties
where party_id=p_external_contact;*/
select to_char(okc_wf_notify_s1.nextval) into l_item_key from dual;
||'&_MANAGE_MODE=Y&_UPDATE_STATUS_MODE=N&_HIDE_NTF=Y&OKC_DEL_HIDE_ATTACHMENTS=Y&OKC_DEL_HIDE_STATUS_DISC=Y&_FLEX_DISPLAY=N&_DELIVERABLE_ID='||p_deliverable_id||'&OKC_DEL_NO_ENCRYPT=Y';
select notification_id into x_notification_id from wf_item_activity_statuses
where item_type = l_item_type and
item_key = l_item_key and
assigned_user = l_external_role_name;
procedure update_status (itemtype in varchar2,
itemkey in varchar2,
actid in number,
funcmode in varchar2,
resultout out nocopy varchar2 )
IS
l_old_status VARCHAR2(100);
cursor update_allowed is
select 'X' -- removed into l_temp for 8174 compatability bug#3288934
from okc_deliverables d,okc_del_status_combxns s where
d.deliverable_id=l_deliverable_id and
s.current_status_code=d.deliverable_status and
s.allowable_status_code=l_new_status and
s.status_changed_by='EXTERNAL' and
d.manage_yn = 'Y'; --from bug 3696869
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'100: Entering update status for deliverable id:'||l_deliverable_id);
open update_allowed;
fetch update_allowed into l_temp;
if update_allowed%NOTFOUND then
resultout:='COMPLETE';
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'200: Update is not allow from current status to '
||l_new_status||' by external user. Exitting');
update okc_deliverables set deliverable_status = l_new_status, status_change_notes=l_notes
where deliverable_id = l_deliverable_id;
insert into okc_del_status_history(deliverable_id,
deliverable_status,
status_change_date,
status_change_notes,
object_version_number,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login,
status_changed_by)
values (l_deliverable_id,
l_new_status,
sysdate,
l_notes,
1,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.login_id,
fnd_global.user_id);
FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module,'200: Deliverable updated and row inserted into status history');
close update_allowed;
WF_CORE.CONTEXT ('OKCDELWF', 'update_status', itemtype, itemkey,actid,funcmode);
end update_status;
SELECT *
FROM okc_deliverables
where deliverable_id = l_deliverable_id;
update okc_deliverables set completed_notification_id = l_notification_id where deliverable_id = l_deliverable_id;