152: p_doc_dir IN VARCHAR2,
153: p_coll_id IN NUMBER,
154: x_dtl_coll_id IN OUT NOCOPY VARCHAR2,
155: p_collaboration_standard IN VARCHAR2,
156: p_notification_event IN WF_EVENT_T,
157: p_application_id IN NUMBER )
158: IS
159: l_application_id NUMBER(10);
160: l_application_name VARCHAR2(100);
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.
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:
805: -- RAISE FND_API.G_EXC_ERROR;
806: END;
807: ELSIF c_actions.action_code = 'RAISE_EVENT' THEN
808: l_cln_not_parameters := wf_parameter_list_t();
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
806: END;
807: ELSIF c_actions.action_code = 'RAISE_EVENT' THEN
808: l_cln_not_parameters := wf_parameter_list_t();
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
807: ELSIF c_actions.action_code = 'RAISE_EVENT' THEN
808: l_cln_not_parameters := wf_parameter_list_t();
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
808: l_cln_not_parameters := wf_parameter_list_t();
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
818: -- User defined parameters
811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
818: -- User defined parameters
819: IF c_actions.attribute2 IS NOT NULL THEN
812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
818: -- User defined parameters
819: IF c_actions.attribute2 IS NOT NULL THEN
820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, l_cln_not_parameters);
813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
818: -- User defined parameters
819: IF c_actions.attribute2 IS NOT NULL THEN
820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, l_cln_not_parameters);
821: END IF;
816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
817: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
818: -- User defined parameters
819: IF c_actions.attribute2 IS NOT NULL THEN
820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, l_cln_not_parameters);
821: END IF;
822: IF c_actions.attribute3 IS NOT NULL THEN
823: WF_EVENT.AddParameterToList('Attribute2', c_actions.attribute3, l_cln_not_parameters);
824: END IF;
819: IF c_actions.attribute2 IS NOT NULL THEN
820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, l_cln_not_parameters);
821: END IF;
822: IF c_actions.attribute3 IS NOT NULL THEN
823: WF_EVENT.AddParameterToList('Attribute2', c_actions.attribute3, l_cln_not_parameters);
824: END IF;
825: IF c_actions.attribute4 IS NOT NULL THEN
826: WF_EVENT.AddParameterToList('Attribute3', c_actions.attribute4, l_cln_not_parameters);
827: END IF;
822: IF c_actions.attribute3 IS NOT NULL THEN
823: WF_EVENT.AddParameterToList('Attribute2', c_actions.attribute3, l_cln_not_parameters);
824: END IF;
825: IF c_actions.attribute4 IS NOT NULL THEN
826: WF_EVENT.AddParameterToList('Attribute3', c_actions.attribute4, l_cln_not_parameters);
827: END IF;
828: IF c_actions.attribute5 IS NOT NULL THEN
829: WF_EVENT.AddParameterToList('Attribute4', c_actions.attribute5, l_cln_not_parameters);
830: END IF;
825: IF c_actions.attribute4 IS NOT NULL THEN
826: WF_EVENT.AddParameterToList('Attribute3', c_actions.attribute4, l_cln_not_parameters);
827: END IF;
828: IF c_actions.attribute5 IS NOT NULL THEN
829: WF_EVENT.AddParameterToList('Attribute4', c_actions.attribute5, l_cln_not_parameters);
830: END IF;
831: IF c_actions.attribute6 IS NOT NULL THEN
832: WF_EVENT.AddParameterToList('Attribute5', c_actions.attribute6, l_cln_not_parameters);
833: END IF;
828: IF c_actions.attribute5 IS NOT NULL THEN
829: WF_EVENT.AddParameterToList('Attribute4', c_actions.attribute5, l_cln_not_parameters);
830: END IF;
831: IF c_actions.attribute6 IS NOT NULL THEN
832: WF_EVENT.AddParameterToList('Attribute5', c_actions.attribute6, l_cln_not_parameters);
833: END IF;
834: IF c_actions.attribute7 IS NOT NULL THEN
835: WF_EVENT.AddParameterToList('Attribute6', c_actions.attribute7, l_cln_not_parameters);
836: END IF;
831: IF c_actions.attribute6 IS NOT NULL THEN
832: WF_EVENT.AddParameterToList('Attribute5', c_actions.attribute6, l_cln_not_parameters);
833: END IF;
834: IF c_actions.attribute7 IS NOT NULL THEN
835: WF_EVENT.AddParameterToList('Attribute6', c_actions.attribute7, l_cln_not_parameters);
836: END IF;
837: IF c_actions.attribute8 IS NOT NULL THEN
838: WF_EVENT.AddParameterToList('Attribute7', c_actions.attribute8, l_cln_not_parameters);
839: END IF;
834: IF c_actions.attribute7 IS NOT NULL THEN
835: WF_EVENT.AddParameterToList('Attribute6', c_actions.attribute7, l_cln_not_parameters);
836: END IF;
837: IF c_actions.attribute8 IS NOT NULL THEN
838: WF_EVENT.AddParameterToList('Attribute7', c_actions.attribute8, l_cln_not_parameters);
839: END IF;
840: IF c_actions.attribute9 IS NOT NULL THEN
841: WF_EVENT.AddParameterToList('Attribute8', c_actions.attribute9, l_cln_not_parameters);
842: END IF;
837: IF c_actions.attribute8 IS NOT NULL THEN
838: WF_EVENT.AddParameterToList('Attribute7', c_actions.attribute8, l_cln_not_parameters);
839: END IF;
840: IF c_actions.attribute9 IS NOT NULL THEN
841: WF_EVENT.AddParameterToList('Attribute8', c_actions.attribute9, l_cln_not_parameters);
842: END IF;
843: IF c_actions.attribute10 IS NOT NULL THEN
844: WF_EVENT.AddParameterToList('Attribute9', c_actions.attribute10, l_cln_not_parameters);
845: END IF;
840: IF c_actions.attribute9 IS NOT NULL THEN
841: WF_EVENT.AddParameterToList('Attribute8', c_actions.attribute9, l_cln_not_parameters);
842: END IF;
843: IF c_actions.attribute10 IS NOT NULL THEN
844: WF_EVENT.AddParameterToList('Attribute9', c_actions.attribute10, l_cln_not_parameters);
845: END IF;
846: IF c_actions.attribute11 IS NOT NULL THEN
847: WF_EVENT.AddParameterToList('Attribute10', c_actions.attribute11, l_cln_not_parameters);
848: END IF;
843: IF c_actions.attribute10 IS NOT NULL THEN
844: WF_EVENT.AddParameterToList('Attribute9', c_actions.attribute10, l_cln_not_parameters);
845: END IF;
846: IF c_actions.attribute11 IS NOT NULL THEN
847: WF_EVENT.AddParameterToList('Attribute10', c_actions.attribute11, l_cln_not_parameters);
848: END IF;
849: IF c_actions.attribute12 IS NOT NULL THEN
850: WF_EVENT.AddParameterToList('Attribute11', c_actions.attribute12, l_cln_not_parameters);
851: END IF;
846: IF c_actions.attribute11 IS NOT NULL THEN
847: WF_EVENT.AddParameterToList('Attribute10', c_actions.attribute11, l_cln_not_parameters);
848: END IF;
849: IF c_actions.attribute12 IS NOT NULL THEN
850: WF_EVENT.AddParameterToList('Attribute11', c_actions.attribute12, l_cln_not_parameters);
851: END IF;
852: IF c_actions.attribute13 IS NOT NULL THEN
853: WF_EVENT.AddParameterToList('Attribute12', c_actions.attribute13, l_cln_not_parameters);
854: END IF;
849: IF c_actions.attribute12 IS NOT NULL THEN
850: WF_EVENT.AddParameterToList('Attribute11', c_actions.attribute12, l_cln_not_parameters);
851: END IF;
852: IF c_actions.attribute13 IS NOT NULL THEN
853: WF_EVENT.AddParameterToList('Attribute12', c_actions.attribute13, l_cln_not_parameters);
854: END IF;
855: IF c_actions.attribute14 IS NOT NULL THEN
856: WF_EVENT.AddParameterToList('Attribute13', c_actions.attribute14, l_cln_not_parameters);
857: END IF;
852: IF c_actions.attribute13 IS NOT NULL THEN
853: WF_EVENT.AddParameterToList('Attribute12', c_actions.attribute13, l_cln_not_parameters);
854: END IF;
855: IF c_actions.attribute14 IS NOT NULL THEN
856: WF_EVENT.AddParameterToList('Attribute13', c_actions.attribute14, l_cln_not_parameters);
857: END IF;
858: IF c_actions.attribute15 IS NOT NULL THEN
859: WF_EVENT.AddParameterToList('Attribute14', c_actions.attribute15, l_cln_not_parameters);
860: END IF;
855: IF c_actions.attribute14 IS NOT NULL THEN
856: WF_EVENT.AddParameterToList('Attribute13', c_actions.attribute14, l_cln_not_parameters);
857: END IF;
858: IF c_actions.attribute15 IS NOT NULL THEN
859: WF_EVENT.AddParameterToList('Attribute14', c_actions.attribute15, l_cln_not_parameters);
860: END IF;
861: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);
863: ELSIF c_actions.action_code = 'PROCEDURE_CALL' THEN
858: IF c_actions.attribute15 IS NOT NULL THEN
859: WF_EVENT.AddParameterToList('Attribute14', c_actions.attribute15, l_cln_not_parameters);
860: END IF;
861: SELECT cln_np_notification_workflow_s.nextval INTO l_notification_flow_key FROM dual;
862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);
863: ELSIF c_actions.action_code = 'PROCEDURE_CALL' THEN
864: IF (l_Debug_Level <= 1) THEN
865: ecx_cln_debug_pub.Add('UserDefined PL/SQL API :' || c_actions.attribute1, 1);
866: ecx_cln_debug_pub.Add('UserDefined PL/SQL API Mode:' || c_actions.attribute3, 1);
897: END IF;
898:
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();
901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
898:
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();
901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
899: ELSE
900: l_cln_not_parameters := wf_parameter_list_t();
901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
900: l_cln_not_parameters := wf_parameter_list_t();
901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
909: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_id, l_cln_not_parameters);
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
909: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
910: l_procedure_call_statement := 'begin ' || c_actions.attribute1 || '(:l_cln_not_parameters); end;';
903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, l_cln_not_parameters);
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
909: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
910: l_procedure_call_statement := 'begin ' || c_actions.attribute1 || '(:l_cln_not_parameters); end;';
911: execute immediate l_procedure_call_statement using l_cln_not_parameters;
904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, l_cln_not_parameters);
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
909: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
910: l_procedure_call_statement := 'begin ' || c_actions.attribute1 || '(:l_cln_not_parameters); end;';
911: execute immediate l_procedure_call_statement using l_cln_not_parameters;
912: END IF;
905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, l_cln_not_parameters);
906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, l_cln_not_parameters);
907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, l_cln_not_parameters);
908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, l_cln_not_parameters);
909: WF_EVENT.AddParameterToList('Status', p_statuslvl, l_cln_not_parameters);
910: l_procedure_call_statement := 'begin ' || c_actions.attribute1 || '(:l_cln_not_parameters); end;';
911: execute immediate l_procedure_call_statement using l_cln_not_parameters;
912: END IF;
913: ELSE
1492: p_collaboration_pt IN VARCHAR2,
1493: p_notification_code IN VARCHAR2,
1494: p_notification_desc IN VARCHAR2,
1495: p_notification_status IN VARCHAR2,
1496: p_notification_event IN WF_EVENT_T )
1497:
1498: IS
1499: l_coll_id NUMBER;
1500: l_error_code NUMBER;