APPS.AMS_CHANNEL_PVT dependencies on AMS_CHANNELS_B

Line 65: SELECT ams_channels_b_s.NEXTVAL

61: l_chan_rec chan_rec_type := p_chan_rec;
62: l_chan_count NUMBER;
63:
64: CURSOR c_chan_seq IS
65: SELECT ams_channels_b_s.NEXTVAL
66: FROM DUAL;
67:
68: CURSOR c_chan_count(chan_id IN NUMBER) IS
69: SELECT COUNT(*)

Line 149: INSERT INTO ams_channels_b(

145: l_chan_rec.outbound_flag := 'Y';
146: l_chan_rec.inbound_flag := 'Y';
147: -- end 12/07/00
148:
149: INSERT INTO ams_channels_b(
150: channel_id,
151: last_update_date,
152: last_updated_by,
153: creation_date,

Line 439: DELETE FROM ams_channels_b

435:
436: AMS_Utility_PVT.debug_message(l_full_name ||': delete');
437: END IF;
438:
439: DELETE FROM ams_channels_b
440: WHERE channel_id = p_chan_id
441: AND object_version_number = p_object_version;
442:
443: IF (SQL%NOTFOUND) THEN

Line 549: FROM ams_channels_b

545: l_chan_id NUMBER;
546:
547: CURSOR c_chan_b IS
548: SELECT channel_id
549: FROM ams_channels_b
550: WHERE channel_id = p_chan_id
551: AND object_version_number = p_object_version
552: FOR UPDATE NOWAIT;
553:

Line 779: UPDATE ams_channels_b SET

775: l_chan_rec.inbound_flag := 'Y';
776: -- end 12/07/00
777:
778:
779: UPDATE ams_channels_b SET
780: last_update_date = SYSDATE,
781: last_updated_by = FND_GLOBAL.user_id,
782: last_update_login = FND_GLOBAL.conc_login_id,
783: object_version_number = l_chan_rec.object_version_number + 1,