DBA Data[Home] [Help]

APPS.CLN_NP_PROCESSOR_PKG dependencies on WF_EVENT

Line 156: p_notification_event IN WF_EVENT_T,

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

Line 563: -- pass on the object of type wf_event_t also here.

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:

Line 809: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);

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

Line 810: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_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);

Line 811: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, 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);

Line 812: WF_EVENT.AddParameterToList('ReferenceId', p_reference, 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);

Line 813: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, 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);

Line 814: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, 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

Line 815: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, 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
819: IF c_actions.attribute2 IS NOT NULL THEN

Line 816: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, 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
820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, l_cln_not_parameters);

Line 817: WF_EVENT.AddParameterToList('Status', p_statuslvl, 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;

Line 820: WF_EVENT.AddParameterToList('Attribute1', c_actions.attribute2, 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;
822: IF c_actions.attribute3 IS NOT NULL THEN
823: WF_EVENT.AddParameterToList('Attribute2', c_actions.attribute3, l_cln_not_parameters);
824: END IF;

Line 823: WF_EVENT.AddParameterToList('Attribute2', c_actions.attribute3, l_cln_not_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;
825: IF c_actions.attribute4 IS NOT NULL THEN
826: WF_EVENT.AddParameterToList('Attribute3', c_actions.attribute4, l_cln_not_parameters);
827: END IF;

Line 826: WF_EVENT.AddParameterToList('Attribute3', c_actions.attribute4, l_cln_not_parameters);

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;

Line 829: WF_EVENT.AddParameterToList('Attribute4', c_actions.attribute5, l_cln_not_parameters);

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;

Line 832: WF_EVENT.AddParameterToList('Attribute5', c_actions.attribute6, l_cln_not_parameters);

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;

Line 835: WF_EVENT.AddParameterToList('Attribute6', c_actions.attribute7, l_cln_not_parameters);

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;

Line 838: WF_EVENT.AddParameterToList('Attribute7', c_actions.attribute8, l_cln_not_parameters);

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;

Line 841: WF_EVENT.AddParameterToList('Attribute8', c_actions.attribute9, l_cln_not_parameters);

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;

Line 844: WF_EVENT.AddParameterToList('Attribute9', c_actions.attribute10, l_cln_not_parameters);

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;

Line 847: WF_EVENT.AddParameterToList('Attribute10', c_actions.attribute11, l_cln_not_parameters);

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;

Line 850: WF_EVENT.AddParameterToList('Attribute11', c_actions.attribute12, l_cln_not_parameters);

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;

Line 853: WF_EVENT.AddParameterToList('Attribute12', c_actions.attribute13, l_cln_not_parameters);

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;

Line 856: WF_EVENT.AddParameterToList('Attribute13', c_actions.attribute14, l_cln_not_parameters);

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;

Line 859: WF_EVENT.AddParameterToList('Attribute14', c_actions.attribute15, l_cln_not_parameters);

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

Line 862: WF_EVENT.Raise(c_actions.attribute1, l_notification_flow_key, NULL, l_cln_not_parameters, NULL);

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

Line 901: WF_EVENT.AddParameterToList('ApplicationId', l_application_id, l_cln_not_parameters);

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

Line 902: WF_EVENT.AddParameterToList('CollaborationId', l_collaboration_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);

Line 903: WF_EVENT.AddParameterToList('CollaborationType', l_collaboration_type, 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);

Line 904: WF_EVENT.AddParameterToList('ReferenceId', p_reference, 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);

Line 905: WF_EVENT.AddParameterToList('TradingPartnerID', l_tp_id, 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);

Line 906: WF_EVENT.AddParameterToList('HeaderDescription', p_header_desc, 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;';

Line 907: WF_EVENT.AddParameterToList('NotificationDescription', p_notification_desc, 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;';
911: execute immediate l_procedure_call_statement using l_cln_not_parameters;

Line 908: WF_EVENT.AddParameterToList('NotificationCode', p_notification_code, 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;

Line 909: WF_EVENT.AddParameterToList('Status', p_statuslvl, 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;
913: ELSE

Line 1496: p_notification_event IN WF_EVENT_T )

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;