APPS.AMS_CELLS_ALL_PKG dependencies on AMS_CELLS_ALL_B

Line 21: cursor C is select ROWID from AMS_CELLS_ALL_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from AMS_CELLS_ALL_B
22: where CELL_ID = X_CELL_ID
23: ;
24: begin
25: insert into AMS_CELLS_ALL_B (

Line 25: insert into AMS_CELLS_ALL_B (

21: cursor C is select ROWID from AMS_CELLS_ALL_B
22: where CELL_ID = X_CELL_ID
23: ;
24: begin
25: insert into AMS_CELLS_ALL_B (
26: OWNER_ID,
27: CELL_ID,
28: OBJECT_VERSION_NUMBER,
29: CELL_CODE,

Line 115: from AMS_CELLS_ALL_B

111: MARKET_SEGMENT_FLAG,
112: ENABLED_FLAG,
113: ORIGINAL_SIZE,
114: PARENT_CELL_ID
115: from AMS_CELLS_ALL_B
116: where CELL_ID = X_CELL_ID
117: for update of CELL_ID nowait;
118: recinfo c%rowtype;
119:

Line 187: update AMS_CELLS_ALL_B set

183: X_LAST_UPDATED_BY in NUMBER,
184: X_LAST_UPDATE_LOGIN in NUMBER
185: ) is
186: begin
187: update AMS_CELLS_ALL_B set
188: OWNER_ID = X_OWNER_ID,
189: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
190: CELL_CODE = X_CELL_CODE,
191: MARKET_SEGMENT_FLAG = X_MARKET_SEGMENT_FLAG,

Line 230: delete from AMS_CELLS_ALL_B

226: if (sql%notfound) then
227: raise no_data_found;
228: end if;
229:
230: delete from AMS_CELLS_ALL_B
231: where CELL_ID = X_CELL_ID;
232:
233: if (sql%notfound) then
234: raise no_data_found;

Line 244: from AMS_CELLS_ALL_B B

240: begin
241: delete from AMS_CELLS_ALL_TL T
242: where not exists
243: (select NULL
244: from AMS_CELLS_ALL_B B
245: where B.CELL_ID = T.CELL_ID
246: );
247:
248: update AMS_CELLS_ALL_TL T set (

Line 344: FROM ams_cells_all_b

340: l_cell_id number;
341:
342: CURSOR c_obj_verno IS
343: SELECT object_version_number
344: FROM ams_cells_all_b
345: WHERE cell_id = x_cell_id;
346:
347: CURSOR c_chk_cel_exists is
348: SELECT 'x'

Line 349: FROM ams_cells_all_b

345: WHERE cell_id = x_cell_id;
346:
347: CURSOR c_chk_cel_exists is
348: SELECT 'x'
349: FROM ams_cells_all_b
350: WHERE cell_id = x_cell_id;
351:
352: CURSOR c_get_cel_id is
353: SELECT ams_cells_all_b_s.NEXTVAL

Line 353: SELECT ams_cells_all_b_s.NEXTVAL

349: FROM ams_cells_all_b
350: WHERE cell_id = x_cell_id;
351:
352: CURSOR c_get_cel_id is
353: SELECT ams_cells_all_b_s.NEXTVAL
354: FROM DUAL;
355: BEGIN
356: if X_OWNER = 'SEED' then
357: l_user_id := 1;