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