DBA Data[Home] [Help]

APPS.AMS_LIST_OPTIONS_PVT dependencies on AMS_LIST_OPTIONS_PVT

Line 1: PACKAGE BODY AMS_List_Options_Pvt AS

1: PACKAGE BODY AMS_List_Options_Pvt AS
2: /* $Header: amsvlopb.pls 120.6 2005/12/21 01:43 bmuthukr noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_List_Options_Pvt

2: /* $Header: amsvlopb.pls 120.6 2005/12/21 01:43 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.

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LIST_OPTIONS_PVT';

14: --
15: -- End of Comments
16: -- ===============================================================
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):='AMS_LIST_OPTIONS_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(12):='amsvlopb.pls';
20:
21: CURSOR c_get_header_info(p_list_header_id in number) IS
22: SELECT *

Line 88: p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,

84:
85: PROCEDURE Control_Group_Generation(
86: p_list_header_id IN NUMBER,
87: p_log_level IN varchar2 DEFAULT NULL,
88: p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,
89: x_ctrl_grp_status OUT NOCOPY VARCHAR2,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 474: p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,

470:
471: procedure apply_size_reduction
472: (p_list_header_id IN number,
473: p_log_level IN varchar2 DEFAULT NULL,
474: p_msg_tbl OUT NOCOPY AMS_LIST_OPTIONS_PVT.G_MSG_TBL_TYPE,
475: x_return_status OUT NOCOPY VARCHAR2,
476: x_msg_count OUT NOCOPY NUMBER,
477: x_msg_data OUT NOCOPY VARCHAR2) is
478:

Line 553: END AMS_List_Options_Pvt;

549: x_msg_data := 'Error while executing procedure apply_size_reduction '||sqlcode||' '||sqlerrm;
550: x_msg_count := 1;
551: end apply_size_reduction;
552:
553: END AMS_List_Options_Pvt;