[Home] [Help]
PACKAGE: APPS.AMS_LISTGENERATION_PUB
Source
1 PACKAGE AMS_ListGeneration_PUB AUTHID CURRENT_USER AS
2 /* $Header: amsplgns.pls 115.7 2004/04/26 23:58:47 sranka ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_ListGeneration_PUB
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 -- ==============================================================================
19 -- Start of Comments
20 -- ==============================================================================
21 -- API Name
22 -- Generate_List
23 -- Type
24 -- Public
25 -- Pre-Req
26 --
27 -- Parameters
28 --
29 -- IN
30 -- p_api_version_number IN NUMBER Required
31 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
32 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
33 -- p_validation_level IN NUMBER Optional Default =FND_API.G_VALID_LEVEL_FULL,
34
35 -- p_list_header_id IN ListHeaderId Required
36 --
37 -- OUT
38 -- x_return_status OUT VARCHAR2
39 -- x_msg_count OUT NUMBER
40 -- x_msg_data OUT VARCHAR2
41 -- Version : Current version 1.0
42 -- End of Comments
43 -- ==============================================================================
44 --
45
46 PROCEDURE Generate_List
47 ( p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_list_header_id IN NUMBER ,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2
55 );
56
57
58 PROCEDURE create_list_from_query
59 ( p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
61 p_commit IN VARCHAR2 := FND_API.G_FALSE,
62 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
63 p_list_name in varchar2,
64 p_list_type in varchar2,
65 p_owner_user_id in number,
66 p_list_header_id in number,
67 p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
68 p_primary_key in varchar2,
69 p_source_object_name in varchar2,
70 p_master_type in varchar2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2
74 ) ;
75
76 PROCEDURE create_list_from_query
77 ( p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 p_list_name in varchar2,
82 p_list_type in varchar2,
83 p_owner_user_id in number,
84 p_list_header_id in number,
85 p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
86 p_primary_key in varchar2,
87 p_source_object_name in varchar2,
88 p_master_type in varchar2,
89 p_query_param in AMS_List_Query_PVT.sql_string_tbl ,
90 x_return_status OUT NOCOPY VARCHAR2,
91 x_msg_count OUT NOCOPY NUMBER,
92 x_msg_data OUT NOCOPY VARCHAR2
93 ) ;
94 END AMS_ListGeneration_PUB;