APPS.AMS_LISTGENERATION_PKG dependencies on AMS_LIST_QUERY_PVT

Line 7938: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;

7934: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
7935: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
7936: l_api_version number := 1.0;
7937: l_api_name constant varchar2(30) := 'Create_List';
7938: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type ;
7939: l_list_query_id number ;
7940: l_action_rec AMS_ListAction_PVT.action_rec_type ;
7941: l_action_id number;
7942: cursor c_mapping_types(p_master_type varchar2) is

Line 8031: AMS_List_Query_PVT.Create_List_Query(

8027: l_list_query_rec.sql_string := p_sql_string ;
8028: l_list_query_rec.primary_key := p_primary_key ;
8029: l_list_query_rec.type := p_master_type ;
8030: l_list_query_rec.source_object_name := p_source_object_name ;
8031: AMS_List_Query_PVT.Create_List_Query(
8032: p_api_version_number => 1.0,
8033: p_init_msg_list => l_init_msg_list,
8034: p_commit => p_commit,
8035: p_validation_level => p_validation_level,

Line 8353: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

8349: p_list_name in varchar2,
8350: p_list_type in varchar2,
8351: p_owner_user_id in number,
8352: p_list_header_id in number,
8353: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8354: p_primary_key in varchar2,
8355: p_source_object_name in varchar2,
8356: p_master_type in varchar2,
8357: x_return_status OUT NOCOPY VARCHAR2,

Line 8365: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

8361: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8362: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8363: l_api_version number := 1.0;
8364: l_api_name constant varchar2(30) := 'Create_List';
8365: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8366: l_list_query_id number ;
8367: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8368: l_action_id number;
8369:

Line 8404: AMS_List_Query_PVT.Create_List_Query(

8400: -- l_list_query_rec_tbl.sql_string := p_sql_string ;
8401: l_list_query_rec_tbl.primary_key := p_primary_key ;
8402: l_list_query_rec_tbl.type := p_master_type ;
8403: l_list_query_rec_tbl.source_object_name := p_source_object_name ;
8404: AMS_List_Query_PVT.Create_List_Query(
8405: p_api_version_number => 1.0,
8406: p_init_msg_list => l_init_msg_list,
8407: p_commit => p_commit,
8408: p_validation_level => p_validation_level,

Line 8531: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,

8527: p_list_name in varchar2,
8528: p_list_type in varchar2,
8529: p_owner_user_id in number,
8530: p_list_header_id in number,
8531: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8532: p_primary_key in varchar2,
8533: p_source_object_name in varchar2,
8534: p_master_type in varchar2,
8535: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,

Line 8535: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,

8531: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
8532: p_primary_key in varchar2,
8533: p_source_object_name in varchar2,
8534: p_master_type in varchar2,
8535: p_query_param in AMS_List_Query_PVT.sql_string_tbl ,
8536: x_return_status OUT NOCOPY VARCHAR2,
8537: x_msg_count OUT NOCOPY NUMBER,
8538: x_msg_data OUT NOCOPY VARCHAR2
8539: ) is

Line 8544: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;

8540: l_list_header_rec AMS_ListHeader_PVT.list_header_rec_type;
8541: l_init_msg_list varchar2(2000) := FND_API.G_FALSE;
8542: l_api_version number := 1.0;
8543: l_api_name constant varchar2(30) := 'Create_List';
8544: l_list_query_rec_tbl AMS_List_Query_PVT.list_query_rec_type_tbl ;
8545: l_list_query_id number ;
8546: l_action_rec AMS_ListAction_PVT.action_rec_type ;
8547: l_action_id number;
8548:

Line 8584: AMS_List_Query_PVT.Create_List_Query(

8580: l_list_query_rec_tbl.primary_key := p_primary_key ;
8581: l_list_query_rec_tbl.type := p_master_type ;
8582: l_list_query_rec_tbl.source_object_name := p_source_object_name ;
8583:
8584: AMS_List_Query_PVT.Create_List_Query(
8585: p_api_version_number => 1.0,
8586: p_init_msg_list => l_init_msg_list,
8587: p_commit => p_commit,
8588: p_validation_level => p_validation_level,