1 PACKAGE AMS_List_Options_Pvt AS
2 /* $Header: amsvlops.pls 120.1 2005/08/11 09:41 bmuthukr noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_List_Options_Pvt
7 -- Purpose
8 -- Created to move all the code related to optional processes
9 -- like random list generation, suppression, max size restriction
10 -- control group generation from the list generation engine code.
11 -- History
12 -- Created bmuthukr 19-Jul-2005.
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17 TYPE G_MSG_TBL_TYPE IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
18 PROCEDURE CG_Gen_Process(errbuf OUT NOCOPY VARCHAR2,
19 retcode OUT NOCOPY VARCHAR2,
20 p_list_header_id IN NUMBER
21 );
22 PROCEDURE Control_Group_Generation(
23 p_list_header_id IN NUMBER,
24 p_log_level IN varchar2 DEFAULT NULL,
25 p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,
26 x_ctrl_grp_status OUT NOCOPY VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_msg_count OUT NOCOPY NUMBER,
29 x_msg_data OUT NOCOPY VARCHAR2) ;
30
31 PROCEDURE Control_Group_Generation(
32 p_list_header_id IN NUMBER,
33 p_log_level IN varchar2 DEFAULT NULL,
34 x_ctrl_grp_status OUT NOCOPY VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2) ;
38
39 procedure apply_size_reduction
40 (p_list_header_id IN number,
41 p_log_level IN varchar2 DEFAULT NULL,
42 p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2);
46
47 procedure apply_size_reduction
48 (p_list_header_id IN number,
49 p_log_level IN varchar2 DEFAULT NULL,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54 END AMS_List_Options_Pvt;