APPS.AMS_LIST_QUERY_PVT dependencies on AMS_LIST_QUERIES_PKG

Line 153: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)

149: IF (AMS_DEBUG_HIGH_ON) THEN
150:
151: AMS_UTILITY_PVT.debug_message( 'Private API: Call create table handler');
152: END IF;
153: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)
154: AMS_LIST_QUERIES_PKG.Insert_Row(
155: px_list_query_id => l_list_query_id,
156: p_last_update_date => SYSDATE,
157: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 154: AMS_LIST_QUERIES_PKG.Insert_Row(

150:
151: AMS_UTILITY_PVT.debug_message( 'Private API: Call create table handler');
152: END IF;
153: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)
154: AMS_LIST_QUERIES_PKG.Insert_Row(
155: px_list_query_id => l_list_query_id,
156: p_last_update_date => SYSDATE,
157: p_last_updated_by => FND_GLOBAL.USER_ID,
158: p_creation_date => SYSDATE,

Line 331: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)

327: p_list_query_rec_tbl.SOURCE_OBJECT_NAME;
328: l_list_query_rec.PARENT_LIST_QUERY_ID := x_parent_list_query_id ;
329: l_list_query_rec.SEQUENCE_ORDER := i;
330: --IF (AMS_DEBUG_HIGH_ON) THENAMS_UTILITY_PVT.debug_message( 'Private API: Call create Query - Child');END IF;
331: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Insert_Row)
332: Create_List_Query(
333: p_api_version_number => p_api_version_number,
334: p_init_msg_list => p_init_msg_list,
335: p_commit => p_commit ,

Line 723: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Update_Row)

719: -- Debug Message
720: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
721:
722:
723: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Update_Row)
724: AMS_LIST_QUERIES_PKG.Update_Row(
725: p_list_query_id => l_list_query_rec.list_query_id,
726: p_last_update_date => SYSDATE,
727: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 724: AMS_LIST_QUERIES_PKG.Update_Row(

720: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler'); END IF;
721:
722:
723: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Update_Row)
724: AMS_LIST_QUERIES_PKG.Update_Row(
725: p_list_query_id => l_list_query_rec.list_query_id,
726: p_last_update_date => SYSDATE,
727: p_last_updated_by => FND_GLOBAL.USER_ID,
728: p_creation_date => l_list_query_rec.creation_date,

Line 1159: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)

1155:
1156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1157: END IF;
1158:
1159: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)
1160: AMS_LIST_QUERIES_PKG.Delete_Row(
1161: p_LIST_QUERY_ID => p_LIST_QUERY_ID);
1162: --
1163: -- End of API body

Line 1160: AMS_LIST_QUERIES_PKG.Delete_Row(

1156: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1157: END IF;
1158:
1159: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)
1160: AMS_LIST_QUERIES_PKG.Delete_Row(
1161: p_LIST_QUERY_ID => p_LIST_QUERY_ID);
1162: --
1163: -- End of API body
1164: --

Line 1288: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)

1284: open c_get_child_ids;
1285: loop
1286: fetch c_get_child_ids into l_list_query_id ;
1287: exit when c_get_child_ids%notfound;
1288: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)
1289: AMS_LIST_QUERIES_PKG.Delete_Row(
1290: p_LIST_QUERY_ID => l_LIST_QUERY_ID);
1291: end loop;
1292: --

Line 1289: AMS_LIST_QUERIES_PKG.Delete_Row(

1285: loop
1286: fetch c_get_child_ids into l_list_query_id ;
1287: exit when c_get_child_ids%notfound;
1288: -- Invoke table handler(AMS_LIST_QUERIES_PKG.Delete_Row)
1289: AMS_LIST_QUERIES_PKG.Delete_Row(
1290: p_LIST_QUERY_ID => l_LIST_QUERY_ID);
1291: end loop;
1292: --
1293: -- End of API body