APPS.AMS_CELL_PVT dependencies on AMS_CELLS_ALL_B

Line 41: SELECT ams_cells_all_b_s.NEXTVAL

37: l_cell_rec cell_rec_type := p_cell_rec;
38: l_cell_count NUMBER;
39:
40: CURSOR c_cell_seq IS
41: SELECT ams_cells_all_b_s.NEXTVAL
42: FROM DUAL;
43:
44: CURSOR c_cell_count(p_cell_id IN NUMBER) IS
45: SELECT COUNT(*)

Line 123: INSERT INTO ams_cells_all_b(

119: -------------------------- insert --------------------------
120: AMS_Utility_PVT.debug_message(l_full_name ||': insert');
121: AMS_Utility_PVT.debug_message('CELLiD' ||l_cell_rec.cell_id);
122:
123: INSERT INTO ams_cells_all_b(
124: cell_id,
125: sel_type,
126: last_update_date,
127: last_updated_by,

Line 299: UPDATE ams_cells_all_b

295:
296: ------------------------ delete ------------------------
297: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
298:
299: UPDATE ams_cells_all_b
300: SET enabled_flag = 'N'
301: WHERE cell_id = p_cell_id
302: AND object_version_number = p_object_version;
303:

Line 393: FROM ams_cells_all_b

389: l_cell_id NUMBER;
390:
391: CURSOR c_cell_b IS
392: SELECT cell_id
393: FROM ams_cells_all_b
394: WHERE cell_id = p_cell_id
395: AND object_version_number = p_object_version
396: FOR UPDATE NOWAIT;
397:

Line 577: UPDATE ams_cells_all_b SET

573: -- record level
574: -------------------------- update --------------------
575: AMS_Utility_PVT.debug_message(l_full_name ||': update' ||l_cell_rec.cell_id);
576:
577: UPDATE ams_cells_all_b SET
578: sel_type = l_cell_rec.sel_type,
579: last_update_date = SYSDATE,
580: last_updated_by = FND_GLOBAL.user_id,
581: last_update_login = FND_GLOBAL.conc_login_id,

Line 1022: from ams_cells_all_b

1018: l_active_children_count NUMBER;
1019: l_count number;
1020: cursor c_check_parent(l_id in number,l_child_id in number) is
1021: select count(1)
1022: from ams_cells_all_b
1023: where cell_id in (select a.cell_id
1024: from ams_cells_all_b a
1025: connect by prior a.cell_id = a.parent_cell_id
1026: start with parent_cell_id = l_id)

Line 1024: from ams_cells_all_b a

1020: cursor c_check_parent(l_id in number,l_child_id in number) is
1021: select count(1)
1022: from ams_cells_all_b
1023: where cell_id in (select a.cell_id
1024: from ams_cells_all_b a
1025: connect by prior a.cell_id = a.parent_cell_id
1026: start with parent_cell_id = l_id)
1027: and cell_id = l_child_id ;
1028:

Line 1776: FROM ams_cells_all_b

1772: ---------------------- get sel type --------------------
1773: AMS_Utility_PVT.debug_message(l_full_name ||': get sel type');
1774:
1775: SELECT sel_type into l_sel_type
1776: FROM ams_cells_all_b
1777: WHERE cell_id = l_cell_id;
1778:
1779: ------------------- get sql string ---------------------
1780: AMS_Utility_PVT.debug_message(l_full_name ||': get sql string');

Line 1965: FROM ams_cells_all_b

1961: END LOOP;
1962:
1963: ---------- get sql string for parent cell -------------
1964: SELECT parent_cell_id INTO l_parent_cell_id
1965: FROM ams_cells_all_b
1966: WHERE cell_id = l_cell_id;
1967:
1968: WHILE l_parent_cell_id is not NULL
1969: LOOP

Line 2022: FROM ams_cells_all_b

2018:
2019: -- keep going
2020: l_temp_cell_id := l_parent_cell_id;
2021: SELECT parent_cell_id INTO l_parent_cell_id
2022: FROM ams_cells_all_b
2023: WHERE cell_id = l_temp_cell_id;
2024: END LOOP;
2025:
2026: ------------------- Parse the result sql ----------------------

Line 3276: UPDATE ams_cells_all_b

3272:
3273: -- Update cell record
3274: AMS_Utility_PVT.Debug_Message(l_api_name||' update_cell');
3275:
3276: UPDATE ams_cells_all_b
3277: SET object_version_number = object_version_number + 1 ,
3278: original_size = l_segment_size
3279: WHERE cell_id = l_cell_id;
3280:

Line 3328: UPDATE ams_cells_all_b

3324:
3325: -- Do bulk update
3326: AMS_Utility_PVT.Debug_Message(l_api_name||' get segment size for cell ');
3327: FORALL I in t_cell_id.first .. t_cell_id.last
3328: UPDATE ams_cells_all_b
3329: SET object_version_number = t_object_version_number(i) ,
3330: original_size = t_segment_size(i)
3331: WHERE cell_id = t_cell_id(i);
3332: