APPS.AMS_CHANNELS_PKG dependencies on AMS_CHANNELS_B

Line 41: cursor C is select ROWID from AMS_CHANNELS_B

37: X_LAST_UPDATE_DATE in DATE,
38: X_LAST_UPDATED_BY in NUMBER,
39: X_LAST_UPDATE_LOGIN in NUMBER
40: ) is
41: cursor C is select ROWID from AMS_CHANNELS_B
42: where CHANNEL_ID = X_CHANNEL_ID
43: ;
44: begin
45: insert into AMS_CHANNELS_B (

Line 45: insert into AMS_CHANNELS_B (

41: cursor C is select ROWID from AMS_CHANNELS_B
42: where CHANNEL_ID = X_CHANNEL_ID
43: ;
44: begin
45: insert into AMS_CHANNELS_B (
46: CHANNEL_ID,
47: OBJECT_VERSION_NUMBER,
48: CHANNEL_TYPE_CODE,
49: ORDER_SEQUENCE,

Line 215: from AMS_CHANNELS_B

211: ATTRIBUTE12,
212: ATTRIBUTE13,
213: ATTRIBUTE14,
214: ATTRIBUTE15
215: from AMS_CHANNELS_B
216: where CHANNEL_ID = X_CHANNEL_ID
217: for update of CHANNEL_ID nowait;
218: recinfo c%rowtype;
219:

Line 344: update AMS_CHANNELS_B set

340: X_LAST_UPDATED_BY in NUMBER,
341: X_LAST_UPDATE_LOGIN in NUMBER
342: ) is
343: begin
344: update AMS_CHANNELS_B set
345: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
346: CHANNEL_TYPE_CODE = X_CHANNEL_TYPE_CODE,
347: ORDER_SEQUENCE = X_ORDER_SEQUENCE,
348: MANAGED_BY_PERSON_ID = X_MANAGED_BY_PERSON_ID,

Line 407: delete from AMS_CHANNELS_B

403: if (sql%notfound) then
404: raise no_data_found;
405: end if;
406:
407: delete from AMS_CHANNELS_B
408: where CHANNEL_ID = X_CHANNEL_ID;
409:
410: if (sql%notfound) then
411: raise no_data_found;

Line 421: from AMS_CHANNELS_B B

417: begin
418: delete from AMS_CHANNELS_TL T
419: where not exists
420: (select NULL
421: from AMS_CHANNELS_B B
422: where B.CHANNEL_ID = T.CHANNEL_ID
423: );
424:
425: update AMS_CHANNELS_TL T set (

Line 541: from AMS_CHANNELS_B

537: l_chan_id number;
538:
539: cursor c_obj_verno is
540: select object_version_number
541: from AMS_CHANNELS_B
542: where CHANNEL_id = x_channel_ID;
543:
544: cursor c_chk_cha_exists is
545: select 'x'

Line 546: from AMS_CHANNELS_B

542: where CHANNEL_id = x_channel_ID;
543:
544: cursor c_chk_cha_exists is
545: select 'x'
546: from AMS_CHANNELS_B
547: where channel_id = x_channel_ID;
548:
549: cursor c_get_chanid is
550: select AMS_CHANNELS_B_S.nextval

Line 550: select AMS_CHANNELS_B_S.nextval

546: from AMS_CHANNELS_B
547: where channel_id = x_channel_ID;
548:
549: cursor c_get_chanid is
550: select AMS_CHANNELS_B_S.nextval
551: from dual;
552:
553: BEGIN
554: