APPS.AMS_CELL_PVT dependencies on AMS_CELLS_VL

Line 46: FROM ams_cells_vl ACV

42: FROM DUAL;
43:
44: CURSOR c_cell_count(p_cell_id IN NUMBER) IS
45: SELECT COUNT(*)
46: FROM ams_cells_vl ACV
47: WHERE ACV.cell_id = p_cell_id;
48:
49: CURSOR c_default_cell_user_status_id IS
50: SELECT user_status_id

Line 845: 'ams_cells_vl',

841: IF p_validation_mode = JTF_PLSQL_API.g_create
842: AND p_cell_rec.cell_id IS NOT NULL
843: THEN
844: IF AMS_Utility_PVT.check_uniqueness(
845: 'ams_cells_vl',
846: 'cell_id = ' || p_cell_rec.cell_id
847: ) = FND_API.g_false
848: THEN
849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 864: 'ams_cells_vl',

860: -- Check if cell_name is unique. Need to handle create and
861: -- update differently.
862: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
863: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
864: 'ams_cells_vl',
865: 'cell_name = ''' || p_cell_rec.cell_name ||''''
866: );
867: ELSE
868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 869: 'ams_cells_vl',

865: 'cell_name = ''' || p_cell_rec.cell_name ||''''
866: );
867: ELSE
868: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
869: 'ams_cells_vl',
870: 'cell_name = ''' || p_cell_rec.cell_name ||
871: ''' AND cell_id <> ' || p_cell_rec.cell_id
872: );
873: END IF;

Line 888: 'ams_cells_vl',

884: -- Check if cell_code is unique. Need to handle create and
885: -- update differently.
886: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
887: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
888: 'ams_cells_vl',
889: 'cell_code = ''' || p_cell_rec.cell_code||''''
890: );
891: ELSE
892: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 893: 'ams_cells_vl',

889: 'cell_code = ''' || p_cell_rec.cell_code||''''
890: );
891: ELSE
892: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
893: 'ams_cells_vl',
894: 'cell_code = ''' || p_cell_rec.cell_name ||
895: ''' AND cell_id <> ' || p_cell_rec.cell_id
896: );
897: END IF;

Line 947: 'ams_cells_vl',

943:
944: --------------------- parent_cell_id ------------------------
945: IF p_cell_rec.parent_cell_id <> FND_API.g_miss_num THEN
946: IF AMS_Utility_PVT.check_fk_exists(
947: 'ams_cells_vl',
948: 'cell_id',
949: p_cell_rec.parent_cell_id
950: ) = FND_API.g_false
951: THEN

Line 1037: FROM ams_cells_vl

1033: ----------------------- status ------------------------
1034: IF p_cell_rec.status_code = 'CANCELLED'
1035: THEN
1036: SELECT COUNT(*) INTO l_active_children_count
1037: FROM ams_cells_vl
1038: WHERE parent_cell_id = p_cell_rec.cell_id
1039: AND (status_code = 'DRAFT' or status_code = 'AVAILABLE');
1040:
1041: IF l_active_children_count > 0

Line 1193: FROM ams_cells_vl

1189: IS
1190:
1191: CURSOR c_cell IS
1192: SELECT *
1193: FROM ams_cells_vl
1194: WHERE cell_id = p_cell_rec.cell_id;
1195:
1196: l_cell_rec c_cell%ROWTYPE;
1197:

Line 3239: FROM ams_cells_vl;

3235: l_iterator NUMBER := 1;
3236:
3237: CURSOR c_all_cell_rec IS
3238: SELECT cell_id, object_version_number
3239: FROM ams_cells_vl;
3240:
3241: l_cell_rec cell_rec_type;
3242:
3243: BEGIN