Workflow

WFLOAD apps/pwd 0 Y DOWNLOAD file.wft ITEMTYPE1

Use the following command:
WFLOAD <apps_user_name>/<password>@db 0 Y DOWNLOAD line.wft OEOL
WFLOAD <apps_user_name>/<password>@db 0 Y DOWNLOAD header.wft OEOH.


Upload workflow definition /d01/app/DEV/apdev/apps/apps_st/appl/fnd/12.0.0/bin/WFLOAD apps/$password@DEV 0 Y UPLOAD OEOL.wft

/d01/app/DEV/apdev/apps/apps_st/appl/fnd/12.0.0/bin=> $FND_TOP/bin

***Checked for relevance on 13-JUL-2010***

References

NOTE:113570.1 - OM-INV: Invoice/Crediting - FAQ
NOTE:113581.1 - Control - Workflow: FAQ
NOTE:121054.1 - How to generate a debug file in OM
NOTE:133464.1 - HTMOMSE Sales Order Diagnostic Script
NOTE:156860.1 - OMCHECK.SQL Oracle Order Management Diagnostic Tool
NOTE:170889.1 - Header Level Invoicing
NOTE:183643.1 - Workflow Scripts
NOTE:270765.1 - Obsolete Workflow Runtime Data Is Not Purging All Data
NOTE:353991.1 - OMSuiteDataChk.sql
NOTE:397548.1 - PATCH 5601698 DATA FIX CLOSES ELIGIBLE ORDER HEADERS & PURGE ASSOCIATED OMERROR & WFERROR & ORPHAN LINE WORKFLOWS


----------------------------------
Helpful Workflow Packages

CREATE OR REPLACE PACKAGE BODY apps.workflowPackage
AS
--workflow code for activity with one result -
   PROCEDURE wf_one_result (
      p_item_type   IN              VARCHAR2,
      p_item_key    IN              VARCHAR2,
      p_actid       IN              NUMBER,
      p_funmode     IN              VARCHAR2,
      p_result      OUT NOCOPY      VARCHAR2
   )
   IS

--declare variables

   BEGIN
      x_report_header_id := TO_NUMBER (p_item_key);


-- if else conditions
      p_result := wf_engine.eng_completed || ':' || 'SUCCESS';

   EXCEPTION
      WHEN OTHERS
      THEN
         wf_core.CONTEXT (pkg_name       => 'workflowPackage',
                          proc_name      => 'set_counter',
                          arg1           =>    'Error with item key '
                                            || p_item_key
                                            || ' ERROR :'
                                            || SUBSTR (SQLERRM, 1, 300),
                          arg2           => p_item_type,
                          arg3           => p_item_key
                         );
         RAISE;
   END set_counter;

--*******************************************************************
   PROCEDURE determineProcess (
      p_item_type   IN              VARCHAR2,
      p_item_key    IN              VARCHAR2,
      p_actid       IN              NUMBER,
      p_funmode     IN              VARCHAR2,
      p_result      OUT NOCOPY      VARCHAR2
   )
   IS
--declare variables

   BEGIN
      ap_web_utilities_pkg.logprocedure ('AP_WEB_EXPENSE_WF','start determineProcess');

      IF (p_funmode = 'RUN')
      THEN
         l_report_header_id :=   wf_engine.getitemattrnumber (
                                                                p_item_type,
                                                                p_item_key,
                                                                'EXPENSE_REPORT_ID'
                                                                                         );
         IF true
         THEN
            p_result := 'COMPLETE:Y';
         ELSE
            p_result := 'COMPLETE:N';
         END IF;

      ELSIF (p_funmode = 'CANCEL')
      THEN
         p_result := 'COMPLETE';
      END IF;

      ap_web_utilities_pkg.logprocedure ('AP_WEB_EXPENSE_WF',
                                         'end Process'
                                        );
   EXCEPTION
      WHEN OTHERS
      THEN
         ap_web_db_util_pkg.raiseexception ('determine Process');
         app_exception.raise_exception;
   END determineProcess;

END workflowPackage;
/

------------------------------------------

How To Send Notification To Multiple Users
https://sites.google.com/site/shareapps4u/learning-topic/workflow-tutorial/how-to-send-notification-to-multiple-user