88: IF (l_Debug_Level <= 1) THEN
89: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE', 1);
90: END IF;
91:
92: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE');
93: ELSE
94: IF (l_Debug_Level <= 1) THEN
95: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE_EMBEDDED_RGN', 1);
96: END IF;
94: IF (l_Debug_Level <= 1) THEN
95: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_SOMEONE_EMBEDDED_RGN', 1);
96: END IF;
97:
98: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE_EMBEDDED_RGN');
99: END IF;
100:
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
97:
98: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE_EMBEDDED_RGN');
99: END IF;
100:
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
98: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE_EMBEDDED_RGN');
99: END IF;
100:
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
99: END IF;
100:
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
100:
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
114:
107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
114:
115: -- check the profile option whether the embedded region shd be sent or not
108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
114:
115: -- check the profile option whether the embedded region shd be sent or not
116: -- if not then continue with the old code and if no, then we call different process
109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);
110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);
111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);
112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);
113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
114:
115: -- check the profile option whether the embedded region shd be sent or not
116: -- if not then continue with the old code and if no, then we call different process
117:
549: IF c_actions.action_code = 'START_WORKFLOW' THEN
550: -- attribute1 => Item , attribute2 => Process
551: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
552: IF (l_Debug_Level <= 2) THEN
553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key
554: || ':' || c_actions.attribute2, 2);
555: END IF;
556:
557: WF_ENGINE.CreateProcess(c_actions.attribute1, l_notification_flow_key, c_actions.attribute2);
553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key
554: || ':' || c_actions.attribute2, 2);
555: END IF;
556:
557: WF_ENGINE.CreateProcess(c_actions.attribute1, l_notification_flow_key, c_actions.attribute2);
558: IF (l_Debug_Level <= 2) THEN
559: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key || ':' || c_actions.attribute2, 2);
560: END IF;
561:
555: END IF;
556:
557: WF_ENGINE.CreateProcess(c_actions.attribute1, l_notification_flow_key, c_actions.attribute2);
558: IF (l_Debug_Level <= 2) THEN
559: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key || ':' || c_actions.attribute2, 2);
560: END IF;
561:
562: -- Set attributes
563: -- pass on the object of type wf_event_t also here.
561:
562: -- Set attributes
563: -- pass on the object of type wf_event_t also here.
564: IF(p_notification_event IS NOT NULL) THEN
565: WF_ENGINE.SetItemAttrEvent(c_actions.attribute1,l_notification_flow_key, 'EVENT_OBJ', p_notification_event);
566: END IF;
567:
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
564: IF(p_notification_event IS NOT NULL) THEN
565: WF_ENGINE.SetItemAttrEvent(c_actions.attribute1,l_notification_flow_key, 'EVENT_OBJ', p_notification_event);
566: END IF;
567:
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
565: WF_ENGINE.SetItemAttrEvent(c_actions.attribute1,l_notification_flow_key, 'EVENT_OBJ', p_notification_event);
566: END IF;
567:
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
566: END IF;
567:
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
567:
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_id);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
579: END IF;
572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
579: END IF;
580:
574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);
575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
579: END IF;
580:
581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);
582: IF (l_Debug_Level <= 2) THEN
577: IF (l_Debug_Level <= 2) THEN
578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
579: END IF;
580:
581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);
582: IF (l_Debug_Level <= 2) THEN
583: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
584: END IF;
585: ELSIF c_actions.action_code = 'NOTIFY_ADMINISTRATOR' THEN
579: END IF;
580:
581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);
582: IF (l_Debug_Level <= 2) THEN
583: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);
584: END IF;
585: ELSIF c_actions.action_code = 'NOTIFY_ADMINISTRATOR' THEN
586: l_notify_default_admin_flag := TRUE;
587: IF c_actions.attribute1 IS NOT NULL THEN
868:
869: IF c_actions.attribute3 = 'CONCURRENT' THEN
870: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
871: IF (l_Debug_Level <= 2) THEN
872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
873: END IF;
874:
875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');
876: IF (l_Debug_Level <= 2) THEN
871: IF (l_Debug_Level <= 2) THEN
872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
873: END IF;
874:
875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');
876: IF (l_Debug_Level <= 2) THEN
877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
878: END IF;
879:
873: END IF;
874:
875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');
876: IF (l_Debug_Level <= 2) THEN
877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
878: END IF;
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
876: IF (l_Debug_Level <= 2) THEN
877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
878: END IF;
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
877: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
878: END IF;
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
878: END IF;
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
879:
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_id);
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
892: END IF;
885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);
886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
892: END IF;
893:
887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);
888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
892: END IF;
893:
894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
895: IF (l_Debug_Level <= 2) THEN
890: IF (l_Debug_Level <= 2) THEN
891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);
892: END IF;
893:
894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
895: IF (l_Debug_Level <= 2) THEN
896: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key, 2);
897: END IF;
898:
892: END IF;
893:
894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
895: IF (l_Debug_Level <= 2) THEN
896: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key, 2);
897: END IF;
898:
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();
1432: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
1433: IF (l_Debug_Level <= 1) THEN
1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');
1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);
1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );
1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
1440:
1433: IF (l_Debug_Level <= 1) THEN
1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');
1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);
1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );
1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
1440:
1441: IF (l_Debug_Level <= 2) THEN
1434: ecx_cln_debug_pub.Add('Process Item Key to send a mail to administrator:' || l_notification_flow_key, 1);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');
1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);
1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );
1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
1440:
1441: IF (l_Debug_Level <= 2) THEN
1442: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1435: END IF;
1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');
1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);
1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );
1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
1440:
1441: IF (l_Debug_Level <= 2) THEN
1442: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR', 2);
1443: END IF;
2076: ecx_cln_debug_pub.Add('Calling CLN_NPNP/NOTIFY_BATCH', 1);
2077: END IF;
2078:
2079:
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2077: END IF;
2078:
2079:
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2078:
2079:
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2079:
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2093:
2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2093:
2094: IF (l_Debug_Level <= 2) THEN
2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2093:
2094: IF (l_Debug_Level <= 2) THEN
2095: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);
2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);
2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);
2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);
2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);
2093:
2094: IF (l_Debug_Level <= 2) THEN
2095: ecx_cln_debug_pub.Add('EXITING CLN_NP_PROCESSOR_PKG.SEND_MAIL', 2);
2096: END IF;