DBA Data[Home] [Help]

APPS.AMS_EVENTOFFER_PVT dependencies on FND_GLOBAL

Line 479: l_user_id := FND_GLOBAL.User_Id;

475:
476: --------------- CHECK ACCESS FOR THE USER ONLY FOR EVENT AGENDA-------------------
477: ----------added sugupta 07/25/2000
478: IF l_evo_rec.event_level = 'SUB' THEN
479: l_user_id := FND_GLOBAL.User_Id;
480: IF (AMS_DEBUG_HIGH_ON) THEN
481:
482: AMS_Utility_PVT.debug_message(' CHECK ACCESS l_user_id is ' ||l_user_id );
483: END IF;

Line 812: FND_GLOBAL.user_id,

808: VALUES(
809: l_evo_rec.event_offer_id,
810: l_evo_rec.custom_setup_id,
811: SYSDATE,
812: FND_GLOBAL.user_id,
813: SYSDATE,
814: FND_GLOBAL.user_id,
815: FND_GLOBAL.conc_login_id,
816: l_ovn, -- object_version_number Bug 5171873 can be 2 for copy

Line 814: FND_GLOBAL.user_id,

810: l_evo_rec.custom_setup_id,
811: SYSDATE,
812: FND_GLOBAL.user_id,
813: SYSDATE,
814: FND_GLOBAL.user_id,
815: FND_GLOBAL.conc_login_id,
816: l_ovn, -- object_version_number Bug 5171873 can be 2 for copy
817: l_evo_rec.application_id,
818: l_evo_rec.event_header_id, -- will come from Interface

Line 815: FND_GLOBAL.conc_login_id,

811: SYSDATE,
812: FND_GLOBAL.user_id,
813: SYSDATE,
814: FND_GLOBAL.user_id,
815: FND_GLOBAL.conc_login_id,
816: l_ovn, -- object_version_number Bug 5171873 can be 2 for copy
817: l_evo_rec.application_id,
818: l_evo_rec.event_header_id, -- will come from Interface
819: NVL(l_evo_rec.private_flag,'N'), -- Value will come from the User Interface.

Line 964: FND_GLOBAL.user_id,

960: SELECT
961: l_evo_rec.event_offer_id,
962: l.language_code,
963: SYSDATE,
964: FND_GLOBAL.user_id,
965: SYSDATE,
966: FND_GLOBAL.user_id,
967: FND_GLOBAL.conc_login_id,
968: USERENV('LANG'),

Line 966: FND_GLOBAL.user_id,

962: l.language_code,
963: SYSDATE,
964: FND_GLOBAL.user_id,
965: SYSDATE,
966: FND_GLOBAL.user_id,
967: FND_GLOBAL.conc_login_id,
968: USERENV('LANG'),
969: l_evo_rec.event_offer_name,
970: l_evo_rec.event_mktg_message,

Line 967: FND_GLOBAL.conc_login_id,

963: SYSDATE,
964: FND_GLOBAL.user_id,
965: SYSDATE,
966: FND_GLOBAL.user_id,
967: FND_GLOBAL.conc_login_id,
968: USERENV('LANG'),
969: l_evo_rec.event_offer_name,
970: l_evo_rec.event_mktg_message,
971: l_evo_rec.description

Line 1216: l_user_id := FND_GLOBAL.User_Id;

1212:
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214: --------------- CHECK ACCESS FOR THE USER-------------------
1215: ----------added sugupta 07/25/2000
1216: l_user_id := FND_GLOBAL.User_Id;
1217: IF (AMS_DEBUG_HIGH_ON) THEN
1218:
1219: AMS_Utility_PVT.debug_message(' CHECK ACCESS l_user_id is ' ||l_user_id );
1220: END IF;

Line 1964: l_user_id := FND_GLOBAL.User_Id;

1960: END IF;
1961:
1962: --------------- CHECK ACCESS FOR THE USER-------------------
1963: ----------added sugupta 07/25/2000
1964: l_user_id := FND_GLOBAL.User_Id;
1965: IF (AMS_DEBUG_HIGH_ON) THEN
1966:
1967: AMS_Utility_PVT.debug_message(' CHECK ACCESS l_user_id is ' ||l_user_id );
1968: END IF;

Line 2507: last_updated_by = FND_GLOBAL.user_id,

2503:
2504: IF l_evo_rec.event_level = 'MAIN' THEN
2505: UPDATE ams_event_offers_all_b SET
2506: last_update_date = SYSDATE,
2507: last_updated_by = FND_GLOBAL.user_id,
2508: last_update_login = FND_GLOBAL.conc_login_id,
2509: object_version_number = l_evo_rec.object_version_number + 1,
2510: private_flag = l_evo_rec.private_flag,
2511: active_flag = l_evo_rec.active_flag,

Line 2508: last_update_login = FND_GLOBAL.conc_login_id,

2504: IF l_evo_rec.event_level = 'MAIN' THEN
2505: UPDATE ams_event_offers_all_b SET
2506: last_update_date = SYSDATE,
2507: last_updated_by = FND_GLOBAL.user_id,
2508: last_update_login = FND_GLOBAL.conc_login_id,
2509: object_version_number = l_evo_rec.object_version_number + 1,
2510: private_flag = l_evo_rec.private_flag,
2511: active_flag = l_evo_rec.active_flag,
2512: source_code = l_evo_rec.source_code,

Line 2628: last_updated_by = FND_GLOBAL.user_id,

2624: AND object_version_number = l_evo_rec.object_version_number;
2625: ELSIF l_evo_rec.event_level = 'SUB' THEN
2626: UPDATE ams_event_offers_all_b SET
2627: last_update_date = SYSDATE,
2628: last_updated_by = FND_GLOBAL.user_id,
2629: last_update_login = FND_GLOBAL.conc_login_id,
2630: object_version_number = l_evo_rec.object_version_number + 1,
2631: private_flag = l_evo_rec.private_flag,
2632: active_flag = l_evo_rec.active_flag,

Line 2629: last_update_login = FND_GLOBAL.conc_login_id,

2625: ELSIF l_evo_rec.event_level = 'SUB' THEN
2626: UPDATE ams_event_offers_all_b SET
2627: last_update_date = SYSDATE,
2628: last_updated_by = FND_GLOBAL.user_id,
2629: last_update_login = FND_GLOBAL.conc_login_id,
2630: object_version_number = l_evo_rec.object_version_number + 1,
2631: private_flag = l_evo_rec.private_flag,
2632: active_flag = l_evo_rec.active_flag,
2633: source_code = l_evo_rec.source_code,

Line 2761: last_updated_by = FND_GLOBAL.user_id,

2757: event_offer_name = l_evo_rec.event_offer_name,
2758: event_mktg_message = l_evo_rec.event_mktg_message,
2759: description = l_evo_rec.description,
2760: last_update_date = SYSDATE,
2761: last_updated_by = FND_GLOBAL.user_id,
2762: last_update_login = FND_GLOBAL.conc_login_id,
2763: source_lang = USERENV('LANG')
2764: WHERE event_offer_id = l_evo_rec.event_offer_id
2765: AND USERENV('LANG') IN (language, source_lang);

Line 2762: last_update_login = FND_GLOBAL.conc_login_id,

2758: event_mktg_message = l_evo_rec.event_mktg_message,
2759: description = l_evo_rec.description,
2760: last_update_date = SYSDATE,
2761: last_updated_by = FND_GLOBAL.user_id,
2762: last_update_login = FND_GLOBAL.conc_login_id,
2763: source_lang = USERENV('LANG')
2764: WHERE event_offer_id = l_evo_rec.event_offer_id
2765: AND USERENV('LANG') IN (language, source_lang);
2766:

Line 4701: p_requester_userid => FND_GLOBAL.user_id

4697: p_approval_for_id => p_evo_rec.event_offer_id,
4698: p_object_version_number => p_evo_rec.object_version_number,
4699: p_orig_stat_id => l_evo_rec.user_status_id,
4700: p_new_stat_id => p_evo_rec.user_status_id,
4701: p_requester_userid => FND_GLOBAL.user_id
4702: );
4703: END IF;
4704:
4705: -- need more specific rules on locking columns at different statuses