DBA Data[Home] [Help]

APPS.AMS_CAMPAIGN_PVT dependencies on FND_GLOBAL

Line 392: FND_GLOBAL.user_id,

388: )
389: VALUES(
390: l_camp_rec.campaign_id,
391: SYSDATE,
392: FND_GLOBAL.user_id,
393: SYSDATE,
394: FND_GLOBAL.user_id,
395: FND_GLOBAL.conc_login_id,
396: 1, -- object_version_number

Line 394: FND_GLOBAL.user_id,

390: l_camp_rec.campaign_id,
391: SYSDATE,
392: FND_GLOBAL.user_id,
393: SYSDATE,
394: FND_GLOBAL.user_id,
395: FND_GLOBAL.conc_login_id,
396: 1, -- object_version_number
397: l_camp_rec.owner_user_id,
398: l_camp_rec.user_status_id,

Line 395: FND_GLOBAL.conc_login_id,

391: SYSDATE,
392: FND_GLOBAL.user_id,
393: SYSDATE,
394: FND_GLOBAL.user_id,
395: FND_GLOBAL.conc_login_id,
396: 1, -- object_version_number
397: l_camp_rec.owner_user_id,
398: l_camp_rec.user_status_id,
399: l_camp_rec.status_code,

Line 524: FND_GLOBAL.user_id,

520: SELECT
521: l_camp_rec.campaign_id,
522: l.language_code,
523: SYSDATE,
524: FND_GLOBAL.user_id,
525: SYSDATE,
526: FND_GLOBAL.user_id,
527: FND_GLOBAL.conc_login_id,
528: USERENV('LANG'),

Line 526: FND_GLOBAL.user_id,

522: l.language_code,
523: SYSDATE,
524: FND_GLOBAL.user_id,
525: SYSDATE,
526: FND_GLOBAL.user_id,
527: FND_GLOBAL.conc_login_id,
528: USERENV('LANG'),
529: l_camp_rec.campaign_name,
530: l_camp_rec.campaign_theme,

Line 527: FND_GLOBAL.conc_login_id,

523: SYSDATE,
524: FND_GLOBAL.user_id,
525: SYSDATE,
526: FND_GLOBAL.user_id,
527: FND_GLOBAL.conc_login_id,
528: USERENV('LANG'),
529: l_camp_rec.campaign_name,
530: l_camp_rec.campaign_theme,
531: l_camp_rec.description

Line 1342: last_updated_by = FND_GLOBAL.user_id,

1338: -- channel_id are commented out by julou on 01/23/00
1339: -----------------------------------------------------------------
1340: UPDATE ams_campaigns_all_b SET
1341: last_update_date = SYSDATE,
1342: last_updated_by = FND_GLOBAL.user_id,
1343: last_update_login = FND_GLOBAL.conc_login_id,
1344: object_version_number = l_camp_rec.object_version_number + 1,
1345: owner_user_id = l_camp_rec.owner_user_id,
1346: active_flag = NVL(l_camp_rec.active_flag, 'Y'),

Line 1343: last_update_login = FND_GLOBAL.conc_login_id,

1339: -----------------------------------------------------------------
1340: UPDATE ams_campaigns_all_b SET
1341: last_update_date = SYSDATE,
1342: last_updated_by = FND_GLOBAL.user_id,
1343: last_update_login = FND_GLOBAL.conc_login_id,
1344: object_version_number = l_camp_rec.object_version_number + 1,
1345: owner_user_id = l_camp_rec.owner_user_id,
1346: active_flag = NVL(l_camp_rec.active_flag, 'Y'),
1347: private_flag = NVL(l_camp_rec.private_flag, 'N'),

Line 1461: last_updated_by = FND_GLOBAL.user_id,

1457: campaign_name = l_camp_rec.campaign_name,
1458: campaign_theme = l_camp_rec.campaign_theme,
1459: description = l_camp_rec.description,
1460: last_update_date = SYSDATE,
1461: last_updated_by = FND_GLOBAL.user_id,
1462: last_update_login = FND_GLOBAL.conc_login_id,
1463: source_lang = USERENV('LANG')
1464: WHERE campaign_id = l_camp_rec.campaign_id
1465: AND USERENV('LANG') IN (language, source_lang);

Line 1462: last_update_login = FND_GLOBAL.conc_login_id,

1458: campaign_theme = l_camp_rec.campaign_theme,
1459: description = l_camp_rec.description,
1460: last_update_date = SYSDATE,
1461: last_updated_by = FND_GLOBAL.user_id,
1462: last_update_login = FND_GLOBAL.conc_login_id,
1463: source_lang = USERENV('LANG')
1464: WHERE campaign_id = l_camp_rec.campaign_id
1465: AND USERENV('LANG') IN (language, source_lang);
1466: