APPS.AMV_C_CATEGORIES_PKG dependencies on AMV_C_CATEGORIES_B

Line 25: from AMV_C_CATEGORIES_B

21: l_row_id varchar2(64);
22:
23: CURSOR Check_Lub (v_ch_cat_id NUMBER) IS
24: select last_updated_by
25: from AMV_C_CATEGORIES_B
26: where channel_category_id = v_ch_cat_id;
27:
28: l_lub NUMBER;
29: l_upd VARCHAR2(5);

Line 126: cursor C is select ROWID from AMV_C_CATEGORIES_B

122: X_LAST_UPDATE_DATE in DATE,
123: X_LAST_UPDATED_BY in NUMBER,
124: X_LAST_UPDATE_LOGIN in NUMBER
125: ) is
126: cursor C is select ROWID from AMV_C_CATEGORIES_B
127: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID
128: ;
129: begin
130: insert into AMV_C_CATEGORIES_B (

Line 130: insert into AMV_C_CATEGORIES_B (

126: cursor C is select ROWID from AMV_C_CATEGORIES_B
127: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID
128: ;
129: begin
130: insert into AMV_C_CATEGORIES_B (
131: APPLICATION_ID,
132: CHANNEL_CATEGORY_ID,
133: OBJECT_VERSION_NUMBER,
134: CHANNEL_CATEGORY_ORDER,

Line 212: from AMV_C_CATEGORIES_B

208: OBJECT_VERSION_NUMBER,
209: CHANNEL_CATEGORY_ORDER,
210: PARENT_CHANNEL_CATEGORY_ID,
211: CHANNEL_COUNT
212: from AMV_C_CATEGORIES_B
213: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID
214: for update of CHANNEL_CATEGORY_ID nowait;
215: recinfo c%rowtype;
216:

Line 277: update AMV_C_CATEGORIES_B set

273: X_LAST_UPDATED_BY in NUMBER,
274: X_LAST_UPDATE_LOGIN in NUMBER
275: ) is
276: begin
277: update AMV_C_CATEGORIES_B set
278: APPLICATION_ID = X_APPLICATION_ID,
279: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
280: CHANNEL_CATEGORY_ORDER = X_CHANNEL_CATEGORY_ORDER,
281: PARENT_CHANNEL_CATEGORY_ID = X_PARENT_CHANNEL_CATEGORY_ID,

Line 333: update AMV_C_CATEGORIES_B set

329: X_LAST_UPDATED_BY in NUMBER,
330: X_LAST_UPDATE_LOGIN in NUMBER
331: ) is
332: begin
333: update AMV_C_CATEGORIES_B set
334: APPLICATION_ID = X_APPLICATION_ID,
335: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
336: CHANNEL_CATEGORY_ORDER = X_CHANNEL_CATEGORY_ORDER,
337: PARENT_CHANNEL_CATEGORY_ID = X_PARENT_CHANNEL_CATEGORY_ID,

Line 374: delete from AMV_C_CATEGORIES_B

370: if (sql%notfound) then
371: raise no_data_found;
372: end if;
373:
374: delete from AMV_C_CATEGORIES_B
375: where CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 389: from AMV_C_CATEGORIES_B B

385: begin
386: delete from AMV_C_CATEGORIES_TL T
387: where not exists
388: (select NULL
389: from AMV_C_CATEGORIES_B B
390: where B.CHANNEL_CATEGORY_ID = T.CHANNEL_CATEGORY_ID
391: );
392:
393: update AMV_C_CATEGORIES_TL T set (