APPS.AMV_C_CHANNELS_PKG dependencies on AMV_C_CHANNELS_B

Line 250: cursor C is select ROWID from AMV_C_CHANNELS_B

246: X_LAST_UPDATE_DATE in DATE,
247: X_LAST_UPDATED_BY in NUMBER,
248: X_LAST_UPDATE_LOGIN in NUMBER
249: ) is
250: cursor C is select ROWID from AMV_C_CHANNELS_B
251: where CHANNEL_ID = X_CHANNEL_ID
252: ;
253: begin
254: insert into AMV_C_CHANNELS_B (

Line 254: insert into AMV_C_CHANNELS_B (

250: cursor C is select ROWID from AMV_C_CHANNELS_B
251: where CHANNEL_ID = X_CHANNEL_ID
252: ;
253: begin
254: insert into AMV_C_CHANNELS_B (
255: CHANNEL_ID,
256: OBJECT_VERSION_NUMBER,
257: CHANNEL_TYPE,
258: CHANNEL_CATEGORY_ID,

Line 476: from AMV_C_CHANNELS_B

472: ATTRIBUTE12,
473: ATTRIBUTE13,
474: ATTRIBUTE14,
475: ATTRIBUTE15
476: from AMV_C_CHANNELS_B
477: where CHANNEL_ID = X_CHANNEL_ID
478: for update of CHANNEL_ID nowait;
479: recinfo c%rowtype;
480:

Line 633: update AMV_C_CHANNELS_B set

629: X_LAST_UPDATED_BY in NUMBER,
630: X_LAST_UPDATE_LOGIN in NUMBER
631: ) is
632: begin
633: update AMV_C_CHANNELS_B set
634: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
635: CHANNEL_TYPE = X_CHANNEL_TYPE,
636: CHANNEL_CATEGORY_ID = X_CHANNEL_CATEGORY_ID,
637: STATUS = X_STATUS,

Line 709: delete from AMV_C_CHANNELS_B

705: if (sql%notfound) then
706: raise no_data_found;
707: end if;
708:
709: delete from AMV_C_CHANNELS_B
710: where CHANNEL_ID = X_CHANNEL_ID;
711:
712: if (sql%notfound) then
713: raise no_data_found;

Line 723: from AMV_C_CHANNELS_B B

719: begin
720: delete from AMV_C_CHANNELS_TL T
721: where not exists
722: (select NULL
723: from AMV_C_CHANNELS_B B
724: where B.CHANNEL_ID = T.CHANNEL_ID
725: );
726:
727: update AMV_C_CHANNELS_TL T set (