DBA Data[Home] [Help]

APPS.CAC_VIEW_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 2316: l_AdminWFRole := FND_PROFILE.Value(name => 'JTF_CALENDAR_ADMINISTRATOR');

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

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

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

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

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