DBA Data[Home] [Help]

APPS.AMS_CHANNEL_PVT dependencies on FND_GLOBAL

Line 192: FND_GLOBAL.user_id,

188: )
189: VALUES(
190: l_chan_rec.channel_id,
191: SYSDATE,
192: FND_GLOBAL.user_id,
193: SYSDATE,
194: FND_GLOBAL.user_id,
195: FND_GLOBAL.conc_login_id,
196: 1, -- object_version_number

Line 194: FND_GLOBAL.user_id,

190: l_chan_rec.channel_id,
191: SYSDATE,
192: FND_GLOBAL.user_id,
193: SYSDATE,
194: FND_GLOBAL.user_id,
195: FND_GLOBAL.conc_login_id,
196: 1, -- object_version_number
197: l_chan_rec.channel_type_code,
198: l_chan_rec.order_sequence,

Line 195: FND_GLOBAL.conc_login_id,

191: SYSDATE,
192: FND_GLOBAL.user_id,
193: SYSDATE,
194: FND_GLOBAL.user_id,
195: FND_GLOBAL.conc_login_id,
196: 1, -- object_version_number
197: l_chan_rec.channel_type_code,
198: l_chan_rec.order_sequence,
199: -- no validation for order.This column is for upgrade purposes only

Line 255: FND_GLOBAL.user_id,

251: SELECT
252: l_chan_rec.channel_id,
253: l.language_code,
254: SYSDATE,
255: FND_GLOBAL.user_id,
256: SYSDATE,
257: FND_GLOBAL.user_id,
258: FND_GLOBAL.conc_login_id,
259: USERENV('LANG'),

Line 257: FND_GLOBAL.user_id,

253: l.language_code,
254: SYSDATE,
255: FND_GLOBAL.user_id,
256: SYSDATE,
257: FND_GLOBAL.user_id,
258: FND_GLOBAL.conc_login_id,
259: USERENV('LANG'),
260: l_chan_rec.channel_name,
261: l_chan_rec.description

Line 258: FND_GLOBAL.conc_login_id,

254: SYSDATE,
255: FND_GLOBAL.user_id,
256: SYSDATE,
257: FND_GLOBAL.user_id,
258: FND_GLOBAL.conc_login_id,
259: USERENV('LANG'),
260: l_chan_rec.channel_name,
261: l_chan_rec.description
262: FROM fnd_languages l

Line 781: last_updated_by = FND_GLOBAL.user_id,

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,
784: channel_type_code = l_chan_rec.channel_type_code,
785: order_sequence = l_chan_rec.order_sequence,

Line 782: last_update_login = FND_GLOBAL.conc_login_id,

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,
784: channel_type_code = l_chan_rec.channel_type_code,
785: order_sequence = l_chan_rec.order_sequence,
786: managed_by_person_id = l_chan_rec.managed_by_person_id,

Line 835: last_updated_by = FND_GLOBAL.user_id,

831: update ams_channels_tl set
832: channel_name = l_chan_rec.channel_name,
833: description = l_chan_rec.description,
834: last_update_date = SYSDATE,
835: last_updated_by = FND_GLOBAL.user_id,
836: last_update_login = FND_GLOBAL.conc_login_id,
837: source_lang = USERENV('LANG')
838: WHERE channel_id = l_chan_rec.channel_id
839: AND USERENV('LANG') IN (language, source_lang);

Line 836: last_update_login = FND_GLOBAL.conc_login_id,

832: channel_name = l_chan_rec.channel_name,
833: description = l_chan_rec.description,
834: last_update_date = SYSDATE,
835: last_updated_by = FND_GLOBAL.user_id,
836: last_update_login = FND_GLOBAL.conc_login_id,
837: source_lang = USERENV('LANG')
838: WHERE channel_id = l_chan_rec.channel_id
839: AND USERENV('LANG') IN (language, source_lang);
840: