APPS.AMS_CELL_PVT dependencies on AMS_LIST_QUERY_PVT

Line 1515: -- 04/10/01 yxliu Modified. Use AMS_List_Query_PVT.Create_List_Query.

1511: -- add_sel_sql
1512: --
1513: -- HISTORY
1514: -- 02/02/01 yxliu Created.
1515: -- 04/10/01 yxliu Modified. Use AMS_List_Query_PVT.Create_List_Query.
1516: ---------------------------------------------------------------------
1517: PROCEDURE add_sel_sql(
1518: p_api_version IN NUMBER,
1519: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 1543: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := AMS_List_Query_PVT.g_miss_list_query_rec;

1539: l_return_status VARCHAR2(1);
1540:
1541: l_sql_string VARCHAR2(20000) := p_sql_string;
1542:
1543: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type := AMS_List_Query_PVT.g_miss_list_query_rec;
1544: l_list_query_id NUMBER := FND_API.G_MISS_NUM;
1545:
1546: l_from_position NUMBER := 0;
1547:

Line 1629: AMS_List_Query_PVT.Create_List_Query(

1625: l_list_query_rec.primary_key := 'PARTY_ID';
1626: l_list_query_rec.act_list_query_used_by_id := p_cell_id;
1627: l_list_query_rec.arc_act_list_query_used_by := 'CELL';
1628:
1629: AMS_List_Query_PVT.Create_List_Query(
1630: p_api_version_number => l_api_version,
1631: p_init_msg_list => p_init_msg_list,
1632: p_commit => p_commit,
1633: p_validation_level => p_validation_level,

Line 2874: -- 04/10/01 yxliu modified. 1. Use AMS_List_Query_PVT.Update_list_Query

2870: --
2871: -- HISTORY
2872: -- 03/01/01 yxliu created, update the segment and based on the sel_type,
2873: -- update the corresponding mapping tables
2874: -- 04/10/01 yxliu modified. 1. Use AMS_List_Query_PVT.Update_list_Query
2875: -- 2. Remove the checking for change of sel_type. End user
2876: -- cannot change sel_type from GUI.
2877: -- 04/17/01 yxliu add verify sql string for update list query
2878: -- 08/31/01 yxliu added source object name for update list sql

Line 2913: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type;

2909: WHERE cell_id = p_sql_cell_rec.cell_id;
2910:
2911: l_sql_cell_rec_old c_cell%ROWTYPE;
2912:
2913: l_list_query_rec AMS_List_Query_PVT.list_query_rec_type;
2914: l_object_version_number NUMBER;
2915: l_list_object_version_number NUMBER;
2916:
2917: CURSOR c_get_list_query(p_list_query_id NUMBER) IS

Line 3129: AMS_List_Query_PVT.Update_List_Query(

3125: l_list_query_rec.source_object_name := l_sql_cell_rec.source_object_name;
3126:
3127: AMS_UTILITY_PVT.debug_message('l_full_name: update_list_query');
3128:
3129: AMS_List_Query_PVT.Update_List_Query(
3130: p_api_version_number => l_api_version,
3131: p_init_msg_list => p_init_msg_list,
3132: p_commit => FND_API.g_false,
3133: p_validation_level => p_validation_level,