DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on FND_PROFILE

Line 532: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');

528: l_cancel_boolean := Chk_Event_Cancelled_for_Person(p_event_id => p_event_id
529: ,p_delegate_person_id => l_delegate_id
530: ,p_booking_id => l_booking_id);
531:
532: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
533: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
534: l_user := FND_PROFILE.value('USER_ID');
535:
536: -- --------------------------------------------

Line 533: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');

529: ,p_delegate_person_id => l_delegate_id
530: ,p_booking_id => l_booking_id);
531:
532: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
533: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
534: l_user := FND_PROFILE.value('USER_ID');
535:
536: -- --------------------------------------------
537: -- Dynamic Notification Text for Workflow

Line 534: l_user := FND_PROFILE.value('USER_ID');

530: ,p_booking_id => l_booking_id);
531:
532: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
533: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
534: l_user := FND_PROFILE.value('USER_ID');
535:
536: -- --------------------------------------------
537: -- Dynamic Notification Text for Workflow
538: -- --------------------------------------------

Line 1211: l_current_username varchar2(80):= fnd_profile.value('USERNAME');

1207: l_item_key wf_items.item_key%type;
1208:
1209:
1210: l_user_name varchar2(80);
1211: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1212: l_current_user_Id number := fnd_profile.value('USER_ID');
1213: l_creator_person_id per_all_people_f.person_id%type;
1214:
1215: CURSOR C_USER IS

Line 1212: l_current_user_Id number := fnd_profile.value('USER_ID');

1208:
1209:
1210: l_user_name varchar2(80);
1211: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1212: l_current_user_Id number := fnd_profile.value('USER_ID');
1213: l_creator_person_id per_all_people_f.person_id%type;
1214:
1215: CURSOR C_USER IS
1216: SELECT