APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_QUERY_PVT

Line 7850: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;

7846: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
7847: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
7848: l_api_version number := 1.0;
7849: l_api_name constant varchar2(30) := 'Create_List';
7850: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;
7851: l_list_query_id number ;
7852: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7853: l_action_id number;
7854: cursor c_mapping_types(p_master_type varchar2) is

Line 7943: AMS_List_Query_PVT.Create_List_Query(

7939: l_list_query_rec.sql_string := p_sql_string ;
7940: l_list_query_rec.primary_key := p_primary_key ;
7941: l_list_query_rec.type := p_master_type ;
7942: l_list_query_rec.source_object_name := p_source_object_name ;
7943: AMS_List_Query_PVT.Create_List_Query(
7944: p_api_version_number => 1.0,
7945: p_init_msg_list => l_init_msg_list,
7946: p_commit => p_commit,
7947: p_validation_level => p_validation_level,

Line 8265: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

8261: p_list_name in varchar2,
8262: p_list_type in varchar2,
8263: p_owner_user_id in number,
8264: p_list_header_id in number,
8265: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8266: p_primary_key in varchar2,
8267: p_source_object_name in varchar2,
8268: p_master_type in varchar2,
8269: x_return_status OUT NOCOPY VARCHAR2,

Line 8277: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

8273: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8274: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8275: l_api_version number := 1.0;
8276: l_api_name constant varchar2(30) := 'Create_List';
8277: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8278: l_list_query_id number ;
8279: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8280: l_action_id number;
8281:

Line 8316: AMS_List_Query_PVT.Create_List_Query(

8312: -- l_list_query_rec_tbl.sql_string := p_sql_string ;
8313: l_list_query_rec_tbl.primary_key := p_primary_key ;
8314: l_list_query_rec_tbl.type := p_master_type ;
8315: l_list_query_rec_tbl.source_object_name := p_source_object_name ;
8316: AMS_List_Query_PVT.Create_List_Query(
8317: p_api_version_number => 1.0,
8318: p_init_msg_list => l_init_msg_list,
8319: p_commit => p_commit,
8320: p_validation_level => p_validation_level,

Line 8443: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

8439: p_list_name in varchar2,
8440: p_list_type in varchar2,
8441: p_owner_user_id in number,
8442: p_list_header_id in number,
8443: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8444: p_primary_key in varchar2,
8445: p_source_object_name in varchar2,
8446: p_master_type in varchar2,
8447: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,

Line 8447: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,

8443: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8444: p_primary_key in varchar2,
8445: p_source_object_name in varchar2,
8446: p_master_type in varchar2,
8447: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,
8448: x_return_status OUT NOCOPY VARCHAR2,
8449: x_msg_count OUT NOCOPY NUMBER,
8450: x_msg_data OUT NOCOPY VARCHAR2
8451: ) is

Line 8456: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

8452: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8453: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8454: l_api_version number := 1.0;
8455: l_api_name constant varchar2(30) := 'Create_List';
8456: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8457: l_list_query_id number ;
8458: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8459: l_action_id number;
8460:

Line 8496: AMS_List_Query_PVT.Create_List_Query(

8492: l_list_query_rec_tbl.primary_key := p_primary_key ;
8493: l_list_query_rec_tbl.type := p_master_type ;
8494: l_list_query_rec_tbl.source_object_name := p_source_object_name ;
8495:
8496: AMS_List_Query_PVT.Create_List_Query(
8497: p_api_version_number => 1.0,
8498: p_init_msg_list => l_init_msg_list,
8499: p_commit => p_commit,
8500: p_validation_level => p_validation_level,