DBA Data[Home] [Help]

PACKAGE: APPS.JTF_TTY_CATCHALL_WORKFLOW

Source


1 PACKAGE JTF_TTY_CATCHALL_WORKFLOW AUTHID CURRENT_USER AS
2 /* $Header: jtfvwkfs.pls 120.0 2005/06/02 18:23:16 appldev ship $ */
3 --    Start of Comments
4 --    ---------------------------------------------------
5 --    PACKAGE NAME:   JTF_TTY_CATCHALL_WORKFLOW
6 --    PURPOSE
7 --
8 --      Procedures:
9 --         (see below for specification)
10 --
11 --
12 --
13 --
14 --    NOTES
15 --
16 --
17 --
18 --
19 --    HISTORY
20 --      12/15/02    JRADHAKR         CREATED
21 --
22 --
23 --    End of Comments
24 --
25 -- Data Types: Records
26 
27 TYPE workflow_param_rec_type IS RECORD
28 (
29     ACCESS_ID       NUMBER
30   , NAME            VARCHAR2(360)
31   , POSTAL_CODE     VARCHAR2(60)
32   , STATE           VARCHAR2(60)
33   , TERRGROUP_ID    NUMBER
34   , PARTY_ID        NUMBER
35 );
36 
37 Procedure Process_catch_all_rec
38     ( x_return_status         OUT NOCOPY  VARCHAR2
39     , x_error_message         OUT NOCOPY  VARCHAR2
40     );
41 
42 Procedure  Get_workflow_details
43     ( p_TERR_GROUP_ID         IN  NUMBER
44     , x_WORKFLOW_ITEM_TYPE    OUT NOCOPY  VARCHAR2
45     , x_WORKFLOW_PROCESS_NAME OUT NOCOPY  VARCHAR2
46     , x_return_status         OUT NOCOPY  VARCHAR2
47     , x_error_message         OUT NOCOPY  VARCHAR2
48     );
49 
50 Procedure Start_Workflow_Process
51   ( p_item_type         IN Varchar2
52    ,p_wf_process        IN Varchar2
53    ,p_wf_params         IN JTF_TTY_CATCHALL_WORKFLOW.workflow_param_rec_type
54    ,x_return_status     OUT NOCOPY  VARCHAR2
55   );
56 
57 
58 END  JTF_TTY_CATCHALL_WORKFLOW;