eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_SERVICE_K_INT_WF dependencies on FND_PROFILE

Line 829: -- Get/Set the proper date format from contract/fnd profile

825: -- RETURN Serviced asset(s) returned by lessee OKS Manager ASSET_ID
826: -- DISPOSE Serviced asset(s) sold OKS Manager ASSET_ID
827: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
828:
829: -- Get/Set the proper date format from contract/fnd profile
830:
831: --
832: -- RUN mode
833: --

Line 872: l_oks_agent := FND_PROFILE.value('OKC_K_APPROVER'); -- OKS: Notify Contract Approver

868: -- Get/Set the OKS AND OKL performing agents :
869: -- *********
870:
871: -- RMUNJULU 3061751 Set OKC APPROVER AS OKL and OKS managers
872: l_oks_agent := FND_PROFILE.value('OKC_K_APPROVER'); -- OKS: Notify Contract Approver
873:
874: IF l_oks_agent IS NULL THEN
875: l_oks_agent := 'SYSADMIN';
876: END IF;

Line 884: l_okl_agent := FND_PROFILE.value('OKC_K_APPROVER'); -- OKL: Notify Contract Approver

880: aname => 'OKS_PERFORMING_AGENT',
881: avalue => l_oks_agent);
882:
883:
884: l_okl_agent := FND_PROFILE.value('OKC_K_APPROVER'); -- OKL: Notify Contract Approver
885:
886: IF l_okl_agent IS NULL THEN
887: l_okl_agent := 'SYSADMIN';
888: END IF;

Line 1238: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1234: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
1235: -- Use NVL for NLS_CALENDAR
1236: l_dispose_date_text := '' ||
1237: to_char(l_dispose_date,
1238: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1239: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1240: || '';
1241:
1242: else

Line 1239: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

1235: -- Use NVL for NLS_CALENDAR
1236: l_dispose_date_text := '' ||
1237: to_char(l_dispose_date,
1238: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1239: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1240: || '';
1241:
1242: else
1243: -- Use NVL for NLS_CALENDAR

Line 1245: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1241:
1242: else
1243: -- Use NVL for NLS_CALENDAR
1244: l_dispose_date_text := to_char(l_dispose_date,
1245: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1246: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1247:
1248: end if;
1249:

Line 1246: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

1242: else
1243: -- Use NVL for NLS_CALENDAR
1244: l_dispose_date_text := to_char(l_dispose_date,
1245: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1246: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1247:
1248: end if;
1249:
1250: ELSE

Line 1438: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1434: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
1435: -- Use NVL for NLS_CALENDAR
1436: l_return_date_text := '' ||
1437: to_char(l_return_date,
1438: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1439: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1440: || '';
1441:
1442: else

Line 1439: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

1435: -- Use NVL for NLS_CALENDAR
1436: l_return_date_text := '' ||
1437: to_char(l_return_date,
1438: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1439: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1440: || '';
1441:
1442: else
1443: -- Use NVL for NLS_CALENDAR

Line 1445: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1441:
1442: else
1443: -- Use NVL for NLS_CALENDAR
1444: l_return_date_text := to_char(l_return_date,
1445: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1446: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1447:
1448: end if;
1449:

Line 1446: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

1442: else
1443: -- Use NVL for NLS_CALENDAR
1444: l_return_date_text := to_char(l_return_date,
1445: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1446: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1447:
1448: end if;
1449:
1450: ELSE

Line 1650: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1646: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
1647: -- Use NVL for NLS_CALENDAR
1648: l_termination_date_text := '' ||
1649: to_char(l_termination_date,
1650: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1651: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1652: || '';
1653:
1654: else

Line 1651: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

1647: -- Use NVL for NLS_CALENDAR
1648: l_termination_date_text := '' ||
1649: to_char(l_termination_date,
1650: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1651: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1652: || '';
1653:
1654: else
1655: -- Use NVL for NLS_CALENDAR

Line 1657: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1653:
1654: else
1655: -- Use NVL for NLS_CALENDAR
1656: l_termination_date_text := to_char(l_termination_date,
1657: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1658: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1659:
1660: end if;
1661:

Line 1658: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

1654: else
1655: -- Use NVL for NLS_CALENDAR
1656: l_termination_date_text := to_char(l_termination_date,
1657: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1658: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1659:
1660: end if;
1661:
1662: ELSE

Line 1864: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1860: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
1861: -- Use NVL for NLS_CALENDAR
1862: l_termination_date_text := '' ||
1863: to_char(l_termination_date,
1864: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1865: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1866: || '';
1867:
1868: else

Line 1865: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

1861: -- Use NVL for NLS_CALENDAR
1862: l_termination_date_text := '' ||
1863: to_char(l_termination_date,
1864: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1865: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
1866: || '';
1867:
1868: else
1869: -- Use NVL for NLS_CALENDAR

Line 1871: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

1867:
1868: else
1869: -- Use NVL for NLS_CALENDAR
1870: l_termination_date_text := to_char(l_termination_date,
1871: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1872: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1873:
1874: end if;
1875:

Line 1872: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

1868: else
1869: -- Use NVL for NLS_CALENDAR
1870: l_termination_date_text := to_char(l_termination_date,
1871: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
1872: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
1873:
1874: end if;
1875:
1876: ELSE

Line 2050: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

2046: -- For html notification in Hijrah calendar, the MMM date format would be displayed correctly only when tag is used.
2047: -- Use NVL for NLS_CALENDAR
2048: l_termination_date_text := '' ||
2049: to_char(l_termination_date,
2050: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
2051: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
2052: || '';
2053:
2054: else

Line 2051: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')

2047: -- Use NVL for NLS_CALENDAR
2048: l_termination_date_text := '' ||
2049: to_char(l_termination_date,
2050: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
2051: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''')
2052: || '';
2053:
2054: else
2055: -- Use NVL for NLS_CALENDAR

Line 2057: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),

2053:
2054: else
2055: -- Use NVL for NLS_CALENDAR
2056: l_termination_date_text := to_char(l_termination_date,
2057: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
2058: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
2059:
2060: end if;
2061:

Line 2058: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');

2054: else
2055: -- Use NVL for NLS_CALENDAR
2056: l_termination_date_text := to_char(l_termination_date,
2057: FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK', l_user_id),
2058: 'NLS_CALENDAR = ''' || NVL(FND_PROFILE.VALUE_SPECIFIC('FND_FORMS_USER_CALENDAR', l_user_id), 'GREGORIAN') || '''');
2059:
2060: end if;
2061:
2062: ELSE