1 PACKAGE AMS_LIST_SRC_TYPES_PVT AS
2 /* $Header: amsvstvs.pls 120.0 2005/06/01 23:45:14 appldev noship $ */
3
4 -----------------------------------------------------------
5 -- PACKAGE
6 -- AMS_LIST_SRC_TYPES_PVT
7 --
8 -- PURPOSE
9 -- The purpose of this package is to creat and update the
10 -- views for Master list source type.
11 -- The following cases are handled.
12 -- 1. Create Master view for new source type.
13 -- 2. Update the Master view for new source type.
14 -- 3. Create/Update the Master view in case a new
15 -- Sub source type is added or deleted.
16 -- 4. Create/Update ALL the Master view in case a new
17 -- item is added/deleted from the Sub source type.
18 --
19 --
20 -- PROCEDURES
21 --
22 --
23 -- PARAMETERS
24 -- INPUT
25 --
26 --
27 -- OUTPUT
28 --
29 -- HISTORY
30 -- 19-Apr-2001 usingh Created.
31 -- 18-Feb-2005 musman added api standard parameters to procedures
32 -- ---------------------------------------------------------
33
34
35 -- This procedure create or updates the Master source type view.
36
37 PROCEDURE master_source_type_view(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
40 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2,
44 p_list_source_type_id IN NUMBER
45 );
46
47
48 PROCEDURE update_all_master_views(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
51 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_list_source_type_id IN NUMBER
56 );
57
58 PROCEDURE process_views(
59 p_api_version_number IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_list_source_type_id IN NUMBER
68 );
69
70 end AMS_LIST_SRC_TYPES_PVT;