eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DELIVERABLE_WF_PVT dependencies on OKC_DELIVERABLES

Line 13: --document_id : of the form 'MESSAGE_CODE:DELIVERABLE_ID', where message_code comes from FND_NEW_MESSAGES, and deliverable_id will be used to query OKC_DELIVERABLES and populate the tokens of the message.

9: --Function:
10: -- This is a callback procedure for a PL/SQL Document attribute in workflow. It is used to populate the subject text of a deliverable notification.
11: --
12: --Parameters:
13: --document_id : of the form 'MESSAGE_CODE:DELIVERABLE_ID', where message_code comes from FND_NEW_MESSAGES, and deliverable_id will be used to query OKC_DELIVERABLES and populate the tokens of the message.
14: --Testing:
15: --
16: --End of Comments
17: -------------------------------------------------------------------------------

Line 41: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable

37: deliverable.business_document_number,
38: deliverable.deliverable_name,
39: deliverable.notify_prior_due_date_value,
40: deliverable.notify_prior_due_date_uom
41: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable
42: WHERE deliverable.deliverable_id = l_del_id
43: AND deliverable.business_document_type = busDocTL.document_type
44: AND busDocTL.language = userenv('LANG');
45: del_tokens_rec deliverable_tokens_cursor%ROWTYPE;

Line 347: from okc_deliverables

343: l_resp_party_code VARCHAR2(30);
344:
345: CURSOR del_cur IS
346: select external_party_id, external_party_role
347: from okc_deliverables
348: where deliverable_id = p_deliverable_id;
349: del_rec del_cur%ROWTYPE;
350: l_external_party_id okc_deliverables.external_party_id%TYPE;
351: l_external_party_role okc_deliverables.external_party_role%TYPE;

Line 350: l_external_party_id okc_deliverables.external_party_id%TYPE;

346: select external_party_id, external_party_role
347: from okc_deliverables
348: where deliverable_id = p_deliverable_id;
349: del_rec del_cur%ROWTYPE;
350: l_external_party_id okc_deliverables.external_party_id%TYPE;
351: l_external_party_role okc_deliverables.external_party_role%TYPE;
352: l_id_for_email NUMBER;
353:
354: --bug#4145213

Line 351: l_external_party_role okc_deliverables.external_party_role%TYPE;

347: from okc_deliverables
348: where deliverable_id = p_deliverable_id;
349: del_rec del_cur%ROWTYPE;
350: l_external_party_id okc_deliverables.external_party_id%TYPE;
351: l_external_party_role okc_deliverables.external_party_role%TYPE;
352: l_id_for_email NUMBER;
353:
354: --bug#4145213
355: CURSOR getRelationId IS

Line 383: FROM okc_deliverable_types_tl oktl, okc_deliverables okd

379: where party_id=p_external_contact;*/
380:
381: CURSOR c_del_type(p_del_id IN NUMBER) IS
382: SELECT name
383: FROM okc_deliverable_types_tl oktl, okc_deliverables okd
384: WHERE oktl.deliverable_type_code =okd.DELIVERABLE_TYPE
385: AND okd.deliverable_id=p_del_id
386: AND oktl.language = userenv('LANG') ;
387:

Line 979: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='

975: l_resp_party_name||':'||l_int_contact_name||':'||l_ext_contact_name);
976:
977: l_mode:='EDIT_DOC_DETAILS';
978: /*skuchima*/
979: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='
980: ||p_deliverable_id||'&deliverableName='||p_deliverable_name||'&delBusDocNum='||p_business_document_number
981: ||'&delBusDocVersion='||p_business_document_version||'&delBusDocTypeCode='||p_business_document_type||'&busDocId='||p_business_document_id||'&docViewDetailsFunction='||l_header_function_name ||'&pmode='||l_mode||'&docClass='||l_doc_class;
982:
983: wf_engine.SetItemAttrText (itemtype => l_item_type,

Line 991: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='

987:
988:
989: l_mode:='VIEW_DOC_DETAILS';
990: /*skuchima*/
991: l_ui_region := 'JSP:/OA_HTML/OA.jsp?page=/oracle/apps/okc/deliverables/webui/NotificationDelRN&deliverableId='
992: ||p_deliverable_id||'&deliverableName='||p_deliverable_name||'&delBusDocNum='||p_business_document_number
993: ||'&delBusDocVersion='||p_business_document_version||'&delBusDocTypeCode='||p_business_document_type||'&busDocId='||p_business_document_id||'&docViewDetailsFunction='||l_header_function_name ||'&pmode='||l_mode||'&docClass='||l_doc_class;
994:
995: wf_engine.SetItemAttrText (itemtype => l_item_type,

Line 1305: from okc_deliverables d,okc_del_status_combxns s where

1301:
1302:
1303: cursor update_allowed is
1304: select 'X' -- removed into l_temp for 8174 compatability bug#3288934
1305: from okc_deliverables d,okc_del_status_combxns s where
1306: d.deliverable_id=l_deliverable_id and
1307: s.current_status_code=d.deliverable_status and
1308: s.allowable_status_code=l_new_status and
1309: s.status_changed_by='EXTERNAL' and

Line 1343: update okc_deliverables set deliverable_status = l_new_status, status_change_notes=l_notes

1339: ||l_new_status||' by external user. Exitting');
1340: end if;
1341:
1342: else
1343: update okc_deliverables set deliverable_status = l_new_status, status_change_notes=l_notes
1344: where deliverable_id = l_deliverable_id;
1345:
1346: insert into okc_del_status_history(deliverable_id,
1347: deliverable_status,

Line 1425: -- It will set the sent notification's id in the OKC_DELIVERABLES table

1421: --Start of Comments
1422: --Name: send_notification_bus_event
1423: --Function:
1424: -- This function is called from an business event subscription. The two parameters are DELIVERABLE_ID and MSG_CODE. It will query all the rest of the required info and call deliverables_notifier.
1425: -- It will set the sent notification's id in the OKC_DELIVERABLES table
1426: --Testing:
1427: --
1428: --End of Comments
1429: -------------------------------------------------------------------------------

Line 1446: FROM okc_deliverables

1442: l_event_status VARCHAR2(10);
1443:
1444: CURSOR del_cur IS
1445: SELECT *
1446: FROM okc_deliverables
1447: where deliverable_id = l_deliverable_id;
1448:
1449: l_del_rec del_cur%ROWTYPE;
1450:

Line 1482: update okc_deliverables set completed_notification_id = l_notification_id where deliverable_id = l_deliverable_id;

1478: x_msg_count => l_msg_count,
1479: x_return_status => l_return_status);
1480:
1481: if (l_notification_id IS NOT NULL AND l_return_status = 'S') then
1482: update okc_deliverables set completed_notification_id = l_notification_id where deliverable_id = l_deliverable_id;
1483: l_event_status := 'SUCCESS';
1484: elsif l_notification_id IS NOT NULL then
1485: l_event_status :='WARNING';
1486: p_event.setErrorMessage(l_msg_data);

Line 1518: l_bus_doc_type okc_deliverables.business_document_type%TYPE;

1514: document_type IN OUT NOCOPY VARCHAR2) IS
1515:
1516: l_msgbody VARCHAR2(32000);
1517:
1518: l_bus_doc_type okc_deliverables.business_document_type%TYPE;
1519: l_del_name okc_deliverables.deliverable_name%TYPE;
1520: l_del_type okc_deliverable_types_tl.name%TYPE;
1521: l_resp_party okc_resp_parties_tl.name%TYPE;
1522: l_int_contact_name per_all_people_f.full_name%TYPE;

Line 1519: l_del_name okc_deliverables.deliverable_name%TYPE;

1515:
1516: l_msgbody VARCHAR2(32000);
1517:
1518: l_bus_doc_type okc_deliverables.business_document_type%TYPE;
1519: l_del_name okc_deliverables.deliverable_name%TYPE;
1520: l_del_type okc_deliverable_types_tl.name%TYPE;
1521: l_resp_party okc_resp_parties_tl.name%TYPE;
1522: l_int_contact_name per_all_people_f.full_name%TYPE;
1523: l_ext_contact_name per_all_people_f.full_name%TYPE;