52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55:
56: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
57: x_list_query_id OUT NOCOPY NUMBER
58: );
59:
60: PROCEDURE Create_List_Query(
64: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,
69: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
70:
71: x_parent_list_query_id OUT NOCOPY NUMBER
72: );
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl ,
69: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
70:
71: x_parent_list_query_id OUT NOCOPY NUMBER
72: );
73:
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113:
114: p_list_query_rec IN AMS_List_Query_PVT.list_query_rec_type,
115: x_object_version_number OUT NOCOPY NUMBER
116: );
117:
118: PROCEDURE Update_List_Query(
122: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,
127: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
128:
129: x_object_version_number OUT NOCOPY NUMBER
130: );
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_list_query_rec_tbl IN AMS_List_Query_PVT.list_query_rec_type_tbl,
127: p_sql_string_tbl in AMS_List_Query_PVT.sql_string_tbl ,
128:
129: x_object_version_number OUT NOCOPY NUMBER
130: );
131: