APPS.AMS_CELL_PVT dependencies on AMS_ACT_DISCOVERER_ALL

Line 1316: select ams_act_discoverer_all_s.NEXTVAL

1312:
1313: l_discoverer_sql_rec c_discoverer_sql%ROWTYPE;
1314:
1315: cursor c_act_disc_seq is
1316: select ams_act_discoverer_all_s.NEXTVAL
1317: from DUAL;
1318: BEGIN
1319:
1320: --------------------- initialize -----------------------

Line 1425: INSERT INTO ams_act_discoverer_all(

1421: OPEN c_act_disc_seq;
1422: FETCH c_act_disc_seq INTO l_act_disc_id;
1423: CLOSE c_act_disc_seq;
1424:
1425: INSERT INTO ams_act_discoverer_all(
1426: activity_discoverer_id,
1427: last_update_date,
1428: last_updated_by,
1429: creation_date,

Line 1732: FROM ams_act_discoverer_all

1728: l_sql_string VARCHAR2(20000) := '';
1729:
1730: CURSOR c_act_discoverer (p_cell_id IN NUMBER) IS
1731: SELECT workbook_name, worksheet_name, workbook_owner
1732: FROM ams_act_discoverer_all
1733: WHERE arc_act_discoverer_used_by = 'CELL'
1734: AND act_discoverer_used_by_id = p_cell_id;
1735:
1736: l_act_discoverer_rec c_act_discoverer%ROWTYPE;

Line 3013: DELETE FROM ams_act_discoverer_all

3009: IF 'DIWB' = upper(l_sql_cell_rec.sel_type) THEN
3010: IF l_sql_cell_rec.discoverer_sql_id IS NULL AND
3011: l_sql_cell_rec_old.discoverer_sql_id IS NOT NULL THEN
3012:
3013: DELETE FROM ams_act_discoverer_all
3014: WHERE act_discoverer_used_by_id = l_sql_cell_rec.cell_id
3015: AND arc_act_discoverer_used_by = 'CELL';
3016:
3017: IF (SQL%NOTFOUND) THEN

Line 3022: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');

3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3019: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3020: FND_MSG_PUB.add;
3021: END IF;
3022: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3023: RAISE FND_API.g_exc_error;
3024: END IF;
3025: ELSIF l_sql_cell_rec.discoverer_sql_id IS NOT NULL AND
3026: l_sql_cell_rec_old.discoverer_sql_id IS NULL THEN

Line 3047: DELETE FROM ams_act_discoverer_all

3043: END IF;
3044:
3045: ELSIF l_sql_cell_rec.discoverer_sql_id <> l_sql_cell_rec_old.discoverer_sql_id THEN
3046: -- remove the old workbook relationship
3047: DELETE FROM ams_act_discoverer_all
3048: WHERE act_discoverer_used_by_id = l_sql_cell_rec.cell_id
3049: AND arc_act_discoverer_used_by = 'CELL';
3050:
3051: IF (SQL%NOTFOUND) THEN

Line 3056: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');

3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3053: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3054: FND_MSG_PUB.add;
3055: END IF;
3056: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3057: RAISE FND_API.g_exc_error;
3058: END IF;
3059: -- add new workbook relationship
3060: add_sel_workbook(