[Home] [Help]
PACKAGE: APPS.IEM_TAG_RUN_PROC_PVT
Source
1 Package IEM_TAG_RUN_PROC_PVT AUTHID CURRENT_USER AS
2 /* $Header: iemvrprs.pls 115.2 2002/12/22 03:46:32 sboorela shipped $ */
3
4 --
5 --
6 -- Purpose: Assistant api to dynamically run procedure.
7 --
8 -- MODIFICATION HISTORY
9 -- Person Date Comments
10 -- Liang Xia 3/26/2002 created
11 -- --------- ------ ------------------------------------------
12
13 G_key_value IEM_TAGPROCESS_PUB.keyVals_tbl_type;
14
15 -- Start of Comments
16 -- API name : validProcedure
17 -- Type : Private
18 -- Function : This procedure valid a procedure
19 -- Pre-reqs : None.
20 -- Parameters :
21 PROCEDURE validProcedure
22 ( p_api_version_number IN NUMBER,
23 P_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
24 p_commit IN VARCHAR2 := FND_API.G_FALSE,
25 p_ProcName IN VARCHAR2,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2);
29
30
31 -- Start of Comments
32 -- API name : run_Procedure
33 -- Type : Private
34 -- Function : This procedure run a procedure
35 -- Pre-reqs : None.
36 -- Parameters :
37 PROCEDURE run_Procedure (
38 p_api_version_number IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40 p_commit IN VARCHAR2 := FND_API.G_FALSE,
41 p_procedure_name IN VARCHAR2,
42 p_key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
43 x_result OUT NOCOPY VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2
47 ) ;
48
49 procedure dummy_procedure( key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
50 result OUT NOCOPY VARCHAR2) ;
51
52 procedure dummy_procedure2( key_value IN IEM_TAGPROCESS_PUB.keyVals_tbl_type,
53 result OUT NOCOPY VARCHAR2) ;
54 -- ***********************************************************************
55
56 END IEM_TAG_RUN_PROC_PVT; -- Package Specification IEM_TAG_RUN_PROC_PVT