522: l_cancel_boolean := Chk_Event_Cancelled_for_Person(p_event_id => p_event_id
523: ,p_delegate_person_id => l_delegate_id
524: ,p_booking_id => l_booking_id);
525:
526: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
527: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
528: l_user := FND_PROFILE.value('USER_ID');
529:
530: -- --------------------------------------------
523: ,p_delegate_person_id => l_delegate_id
524: ,p_booking_id => l_booking_id);
525:
526: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
527: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
528: l_user := FND_PROFILE.value('USER_ID');
529:
530: -- --------------------------------------------
531: -- Dynamic Notification Text for Workflow
524: ,p_booking_id => l_booking_id);
525:
526: l_auto_create_finance := FND_PROFILE.value('OTA_AUTO_CREATE_FINANCE');
527: l_automatic_transfer_gl := FND_PROFILE.value('OTA_SSHR_AUTO_GL_TRANSFER');
528: l_user := FND_PROFILE.value('USER_ID');
529:
530: -- --------------------------------------------
531: -- Dynamic Notification Text for Workflow
532: -- --------------------------------------------
1201: l_item_key wf_items.item_key%type;
1202:
1203:
1204: l_user_name varchar2(80);
1205: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1206: l_current_user_Id number := fnd_profile.value('USER_ID');
1207: l_creator_person_id per_all_people_f.person_id%type;
1208:
1209: CURSOR C_USER IS
1202:
1203:
1204: l_user_name varchar2(80);
1205: l_current_username varchar2(80):= fnd_profile.value('USERNAME');
1206: l_current_user_Id number := fnd_profile.value('USER_ID');
1207: l_creator_person_id per_all_people_f.person_id%type;
1208:
1209: CURSOR C_USER IS
1210: SELECT