1 PACKAGE IEM_ROUTE_RUN_PROC_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvruns.pls 115.6 2002/12/14 02:25:08 liangxia noship $ */
3
4 --
5 --
6 -- Purpose: Assistant api to dynamically run procedure.
7 --
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- Liang Xia 5/29/2002 created
11 -- Liang Xia 12/6/2002 Fixed GSCC warning: NOCOPY, no G_MISS ..
12 -- Liang Xia 12/13/2002 Shipped dummy procedures for testing Dyanmic Classification,
13 -- Route and Excecute External Procedure/workflow
14 -- --------- ------ ------------------------------------------
15
16 G_key_value IEM_ROUTE_PUB.keyVals_tbl_type;
17
18
19 -- Start of Comments
20 -- API name : run_Procedure
21 -- Type : Private
22 -- Function : This procedure run a procedure
23 -- Pre-reqs : None.
24 -- Parameters :
25
26 PROCEDURE run_Procedure (
27 p_api_version_number IN NUMBER,
28 p_init_msg_list IN VARCHAR2 := null,
29 p_commit IN VARCHAR2 := null,
30 p_procedure_name IN VARCHAR2,
31 p_key_value IN IEM_ROUTE_PUB.keyVals_tbl_type,
32 p_param_type IN VARCHAR2,
33 x_result OUT NOCOPY VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE validProcedure
40 ( p_api_version_number IN NUMBER,
41 P_init_msg_list IN VARCHAR2 := null,
42 p_commit IN VARCHAR2 := null,
43 p_ProcName IN VARCHAR2,
44 p_return_type IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2);
48
49
50 -- Start of Comments
51 -- API name : dummy_procedure_number
52 -- Type : Private
53 -- Function : This procedure is used to test Dynamic Classification, Route
54 -- Pre-reqs : None.
55 -- Parameters :
56 procedure dummy_procedure_number( key_value IN IEM_ROUTE_PUB.keyVals_tbl_type,
57 result OUT NOCOPY NUMBER) ;
58
59
60 -- Start of Comments
61 -- API name : dummy_procedure_varchar
62 -- Type : Private
63 -- Function : This procedure is used to test Dynamic Classification, Route
64 -- Pre-reqs : None.
65 -- Parameters :
66 procedure dummy_procedure_varchar( key_value IN IEM_ROUTE_PUB.keyVals_tbl_type,
67 result OUT NOCOPY VARCHAR2) ;
68
69 -- Start of Comments
70 -- API name : dummy_procedure_stop
71 -- Type : Private
72 -- Function : This procedure is used to test Dyanmic Tag, Email Process Rule:Execute
73 -- External Procedure/Workflow.
74 -- Pre-reqs : None.
75 -- Parameters :
76 procedure dummy_procedure_stop( key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
77 result OUT NOCOPY VARCHAR2);
78
79 -- Start of Comments
80 -- API name : dummy_procedure_stop
81 -- Type : Private
82 -- Function : This procedure is used to test Dynamic Tag, Email Process Rule:Execute
83 -- External Procedure/Workflow.
84 -- Pre-reqs : None.
85 -- Parameters :
86 procedure dummy_procedure_continue( key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
87 result OUT NOCOPY VARCHAR2);
88
89 -- Start of Comments
90 -- API name : dummy_procedure
91 -- Type : Private
92 -- Function : This procedure is used to test, Dyanmic Tag, Email Process Rule:Execute
93 -- External Procedure/Workflow.
94 -- Pre-reqs : None.
95 -- Parameters :
96 procedure dummy_procedure( key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
97 result OUT NOCOPY VARCHAR2);
98
99 END IEM_ROUTE_RUN_PROC_PVT;