DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on WF_ENGINE

Line 92: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE');

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;

Line 98: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_SOMEONE_EMBEDDED_RGN');

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);

Line 101: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'TO_TP_OR_ADMIN', p_admin_or_tp);

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);

Line 102: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);

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);

Line 103: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);

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);

Line 104: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_mesg);

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);

Line 105: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', p_application_name);

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);

Line 106: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ORG_ID', p_org_id);

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);

Line 107: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'DOCUMENT_NUMBER', p_document_number);

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);

Line 108: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'REVISION_NUMBER', p_revision_number);

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);

Line 109: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'RELEASE_NUMBER', p_release_number);

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);

Line 110: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_ID', p_collaboration_id);

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:

Line 111: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_TYPE', p_collaboration_type);

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

Line 112: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', p_role);

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

Line 113: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);

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:

Line 553: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key

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);

Line 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:

Line 559: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':' || c_actions.attribute1 || l_notification_flow_key || ':' || 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:
562: -- Set attributes
563: -- pass on the object of type wf_event_t also here.

Line 565: WF_ENGINE.SetItemAttrEvent(c_actions.attribute1,l_notification_flow_key, 'EVENT_OBJ', p_notification_event);

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);

Line 568: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'APPLICATION_ID', l_application_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);

Line 569: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_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);

Line 570: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);

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);

Line 571: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'REFERENCE_ID', p_reference);

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);

Line 572: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);

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);

Line 573: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'HEADER_DESCRIPTION', p_header_desc);

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

Line 574: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_DESCRIPTION', p_notification_desc);

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);

Line 575: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);

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;

Line 576: WF_ENGINE.SetItemAttrText(c_actions.attribute1,l_notification_flow_key, 'STATUS', p_statuslvl);

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:

Line 578: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || c_actions.attribute1 || ':' || l_notification_flow_key, 2);

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

Line 581: WF_ENGINE.StartProcess(c_actions.attribute1,l_notification_flow_key);

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

Line 583: ecx_cln_debug_pub.Add('COMPLETED 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
586: l_notify_default_admin_flag := TRUE;
587: IF c_actions.attribute1 IS NOT NULL THEN

Line 872: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.CreateProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);

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

Line 875: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'CALL_API_CONC');

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:

Line 877: ecx_cln_debug_pub.Add('COMPLETED 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:
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);

Line 880: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'PROCEDURE_NAME', c_actions.attribute1);

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);

Line 881: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'APPLICATION_ID', l_application_id);

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);

Line 882: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_ID', l_collaboration_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);

Line 883: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'COLLABORATION_TYPE', l_collaboration_type);

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);

Line 884: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'REFERENCE_ID', p_reference);

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);

Line 885: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'TRADING_PARTNER_ID', l_tp_id);

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);

Line 886: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'HEADER_DESC', p_header_desc);

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

Line 887: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_DESC', p_notification_desc);

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);

Line 888: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);

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;

Line 889: WF_ENGINE.SetItemAttrText('CLN_NPNP',l_notification_flow_key, 'STATUS', p_statuslvl);

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:

Line 891: ecx_cln_debug_pub.Add('INVOKING WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key || ':CALL_API_CONC', 2);

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

Line 894: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);

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:

Line 896: ecx_cln_debug_pub.Add('COMPLETED WF_ENGINE.StartProcess:' || ':CLN_NP' || l_notification_flow_key, 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:
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();

Line 1436: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY');

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:

Line 1437: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CONTENT', p_message);

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

Line 1438: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_role );

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);

Line 1439: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);

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;

Line 2080: WF_ENGINE.CreateProcess('CLN_NPNP', l_notification_flow_key, 'NOTIFY_BATCH');

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);

Line 2081: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_NAME', l_application_name);

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);

Line 2082: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'APPLICATION_ID', l_application_id);

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);

Line 2083: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'COLLABORATION_STD', p_collaboration_std);

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);

Line 2084: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_CODE', p_notification_code);

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);

Line 2085: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_MESSAGE', p_notification_msg);

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);

Line 2086: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DESC', l_notification_desc);

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);

Line 2087: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'NOTIFICATION_DTLS', l_notification_dtls);

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);

Line 2088: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_NAME', p_attribute_name);

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);

Line 2089: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_COL_VALUE', l_attribute_col_value);

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:

Line 2090: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'ATTRIBUTE_VALUE', p_attribute_value);

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

Line 2091: WF_ENGINE.SetItemAttrText('CLN_NPNP', l_notification_flow_key, 'CLN_PERFORMER', l_notif_receiver_role);

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);

Line 2092: WF_ENGINE.StartProcess('CLN_NPNP', l_notification_flow_key);

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;