DBA Data[Home] [Help]

APPS.JTF_CAL_WF_PVT dependencies on FND_PROFILE

Line 332: l_cal_admin_role := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

328: /*****************************************************************************
329: ** Look up the Calendar Administrator from the Profile (this should be an
330: ** existing WF_ROLE)
331: *****************************************************************************/
332: l_cal_admin_role := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
333:
334: l_adhoc_role := fnd_message.get_string('JTF', 'JTF_CAL_WF_GROUP_ADMIN')
335: || ' ' || l_item_key;
336:

Line 624: l_cal_admin_role := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

620: /*****************************************************************************
621: ** Look up the Calendar Administrator from the Profile (this should be an
622: ** existing WF_ROLE)
623: *****************************************************************************/
624: l_cal_admin_role := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
625: l_task_type_name := get_type_name(l_invitor.task_type_id);
626: l_task_priority_name := get_type_name(l_invitor.task_priority_id);
627: l_timezone := GetTimezone(p_timezone_id => l_invitor.timezone_id);
628:

Line 988: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

984: /*****************************************************************************
985: ** Look up the Calendar Administrator from the Profile (this should be an
986: ** existing WF_ROLE)
987: *****************************************************************************/
988: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
989:
990: /*****************************************************************************
991: ** Look up the WF Role and Name of the requestor
992: *****************************************************************************/

Line 1526: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

1522: /*****************************************************************************
1523: ** Look up the Calendar Administrator from the Profile (this should be an
1524: ** existing WF_ROLE)
1525: *****************************************************************************/
1526: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
1527:
1528: /*****************************************************************************
1529: ** Get Appointment details for every invitee and start a notification WF for
1530: ** all of them.

Line 1775: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

1771: /*****************************************************************************
1772: ** Look up the Calendar Administrator from the Profile (this should be an
1773: ** existing WF_ROLE)
1774: *****************************************************************************/
1775: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
1776:
1777: /*****************************************************************************
1778: ** Get Appointment details for every invitee and start a notification WF for
1779: ** all of them.

Line 2313: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

2309: /*****************************************************************************
2310: ** Look up the Calendar Administrator from the Profile (this should be an
2311: ** existing WF_ROLE)
2312: *****************************************************************************/
2313: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');
2314:
2315: /***************************************************************************
2316: ** we need an itemkey
2317: ***************************************************************************/

Line 2458: ,(NVL( FND_PROFILE.Value('SERVER_TIMEZONE_ID')

2454: , jtl.description TASK_DESCRIPTION
2455: , jtb.calendar_start_date START_DATE
2456: , jtb.calendar_end_date END_DATE
2457: , NVL( jtb.timezone_id
2458: ,(NVL( FND_PROFILE.Value('SERVER_TIMEZONE_ID')
2459: , 4)
2460: )
2461: ) SourceTimezoneID
2462: FROM jtf_tasks_b jtb

Line 2560: l_DestTimezoneID := NVL(FND_PROFILE.Value_Specific( name => 'CLIENT_TIMEZONE_ID'

2556: --
2557: -- I need to get the user_id for the INVITEE
2558: --
2559: l_user_id := JTF_CAL_UTILITY_PVT.GetUserID(r_Task.INVITEE);
2560: l_DestTimezoneID := NVL(FND_PROFILE.Value_Specific( name => 'CLIENT_TIMEZONE_ID'
2561: , user_id => l_user_id
2562: )
2563: ,4 -- If not set on any level, default to PST
2564: );