[Home] [Help]
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: -------------------------------------------------------------------------------
36: deliverable.business_document_number,
37: deliverable.deliverable_name,
38: deliverable.notify_prior_due_date_value,
39: deliverable.notify_prior_due_date_uom
40: FROM okc_bus_doc_types_tl busDocTL, okc_deliverables deliverable
41: WHERE deliverable.deliverable_id = l_del_id
42: AND deliverable.business_document_type = busDocTL.document_type
43: AND busDocTL.language = userenv('LANG');
44: del_tokens_rec deliverable_tokens_cursor%ROWTYPE;
328: l_resp_party_code VARCHAR2(30);
329:
330: CURSOR del_cur IS
331: select external_party_id, external_party_role
332: from okc_deliverables
333: where deliverable_id = p_deliverable_id;
334: del_rec del_cur%ROWTYPE;
335: l_external_party_id okc_deliverables.external_party_id%TYPE;
336: l_external_party_role okc_deliverables.external_party_role%TYPE;
331: select external_party_id, external_party_role
332: from okc_deliverables
333: where deliverable_id = p_deliverable_id;
334: del_rec del_cur%ROWTYPE;
335: l_external_party_id okc_deliverables.external_party_id%TYPE;
336: l_external_party_role okc_deliverables.external_party_role%TYPE;
337: l_id_for_email NUMBER;
338:
339: --bug#4145213
332: from okc_deliverables
333: where deliverable_id = p_deliverable_id;
334: del_rec del_cur%ROWTYPE;
335: l_external_party_id okc_deliverables.external_party_id%TYPE;
336: l_external_party_role okc_deliverables.external_party_role%TYPE;
337: l_id_for_email NUMBER;
338:
339: --bug#4145213
340: CURSOR getRelationId IS
1160:
1161:
1162: cursor update_allowed is
1163: select 'X' -- removed into l_temp for 8174 compatability bug#3288934
1164: from okc_deliverables d,okc_del_status_combxns s where
1165: d.deliverable_id=l_deliverable_id and
1166: s.current_status_code=d.deliverable_status and
1167: s.allowable_status_code=l_new_status and
1168: s.status_changed_by='EXTERNAL' and
1198: ||l_new_status||' by external user. Exitting');
1199: end if;
1200:
1201: else
1202: update okc_deliverables set deliverable_status = l_new_status, status_change_notes=l_notes
1203: where deliverable_id = l_deliverable_id;
1204:
1205: insert into okc_del_status_history(deliverable_id,
1206: deliverable_status,
1280: --Start of Comments
1281: --Name: send_notification_bus_event
1282: --Function:
1283: -- 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.
1284: -- It will set the sent notification's id in the OKC_DELIVERABLES table
1285: --Testing:
1286: --
1287: --End of Comments
1288: -------------------------------------------------------------------------------
1301: l_event_status VARCHAR2(10);
1302:
1303: CURSOR del_cur IS
1304: SELECT *
1305: FROM okc_deliverables
1306: where deliverable_id = l_deliverable_id;
1307:
1308: l_del_rec del_cur%ROWTYPE;
1309:
1337: x_msg_count => l_msg_count,
1338: x_return_status => l_return_status);
1339:
1340: if (l_notification_id IS NOT NULL AND l_return_status = 'S') then
1341: update okc_deliverables set completed_notification_id = l_notification_id where deliverable_id = l_deliverable_id;
1342: l_event_status := 'SUCCESS';
1343: elsif l_notification_id IS NOT NULL then
1344: l_event_status :='WARNING';
1345: p_event.setErrorMessage(l_msg_data);