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.PA_RESOURCE_PVT dependencies on FND_PROFILE

Line 6: l_profile varchar2(30) := NVL(FND_PROFILE.value('PA_AVAILABILITY_CAL_PERIOD'), 'DAILY'); /* Added the global profile call for bug 4930256 */

2: -- $Header: PARRESVB.pls 120.8.12010000.2 2008/08/18 09:58:32 amehrotr ship $
3: g_profile_id NUMBER := 0;
4: g_person_id NUMBER := 0;
5:
6: l_profile varchar2(30) := NVL(FND_PROFILE.value('PA_AVAILABILITY_CAL_PERIOD'), 'DAILY'); /* Added the global profile call for bug 4930256 */
7:
8: Procedure Set_No_of_Days
9: (p_no_of_days IN NUMBER)
10: IS

Line 31: l_avl_profile VARCHAR2(240) := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));

27: IS
28: l_start_date DATE := '';
29: l_end_date DATE := '';
30: l_available_date DATE := '';
31: l_avl_profile VARCHAR2(240) := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));
32:
33: -- new cursor to get available from date using pa_res_availability
34: -- table (PA.K enhancements)
35: CURSOR get_available_from IS

Line 1120: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1116: , p_program_id
1117: , sysdate
1118: , sysdate
1119: /*----- Bug 1992257 commented
1120: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1121: , sysdate
1122: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1124: End of Comment, added next 4 lines */

Line 1122: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1118: , sysdate
1119: /*----- Bug 1992257 commented
1120: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1121: , sysdate
1122: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1124: End of Comment, added next 4 lines */
1125: , TO_NUMBER(FND_GLOBAL.USER_ID)
1126: , sysdate

Line 1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

1119: /*----- Bug 1992257 commented
1120: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1121: , sysdate
1122: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1123: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1124: End of Comment, added next 4 lines */
1125: , TO_NUMBER(FND_GLOBAL.USER_ID)
1126: , sysdate
1127: , TO_NUMBER(FND_GLOBAL.USER_ID)

Line 1241: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1237: , p_program_id
1238: , sysdate
1239: , sysdate
1240: /*----- Bug 1992257 commented
1241: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1242: , sysdate
1243: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1245: End of Comment, added next 4 lines */

Line 1243: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))

1239: , sysdate
1240: /*----- Bug 1992257 commented
1241: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1242: , sysdate
1243: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1245: End of Comment, added next 4 lines */
1246: , TO_NUMBER(FND_GLOBAL.USER_ID)
1247: , sysdate

Line 1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))

1240: /*----- Bug 1992257 commented
1241: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1242: , sysdate
1243: , TO_NUMBER(FND_PROFILE.VALUE('USER_ID'))
1244: , TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'))
1245: End of Comment, added next 4 lines */
1246: , TO_NUMBER(FND_GLOBAL.USER_ID)
1247: , sysdate
1248: , TO_NUMBER(FND_GLOBAL.USER_ID)

Line 1419: l_avl_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE')); -- 4725606

1415: p_avl_from_date IN DATE)
1416: RETURN DATE
1417: IS
1418: l_avl_to_date DATE;
1419: l_avl_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE')); -- 4725606
1420: BEGIN
1421:
1422: IF p_avl_from_date is not null THEN
1423:

Line 1430: -- Commented for 4725606 and percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));

1426: from pa_res_availability
1427: where resource_id = p_resource_id
1428: and record_type = 'C'
1429: and start_date > p_avl_from_date
1430: -- Commented for 4725606 and percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_RES_CAPACITY_PERCENTAGE'));
1431: and percent < l_avl_profile ; -- 4725606
1432:
1433: ELSE
1434: l_avl_to_date := null;

Line 1466: l_ovc_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE')); -- 4725606

1462: p_ovc_from_date IN DATE)
1463: RETURN DATE
1464: IS
1465: l_ovc_to_date DATE;
1466: l_ovc_profile NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE')); -- 4725606
1467: BEGIN
1468:
1469: IF p_ovc_from_date is not null THEN
1470: select min(start_date)-1

Line 1476: -- Commented for 4725606 and -1 * percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE'));

1472: from pa_res_availability
1473: where resource_id = p_resource_id
1474: and record_type = 'C'
1475: and start_date > p_ovc_from_date
1476: -- Commented for 4725606 and -1 * percent < FND_NUMBER.CANONICAL_TO_NUMBER(fnd_profile.value('PA_OVERCOMMITMENT_PERCENTAGE'));
1477: and -1 * percent < l_ovc_profile ; -- 4725606
1478: ELSE
1479: l_ovc_to_date := null;
1480: END IF;

Line 1741: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');

1737: l_last_updated_by := fnd_global.user_id;
1738: l_last_update_login := fnd_global.login_id;
1739:
1740: -- commented out for perf bug 4930256
1741: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');
1742:
1743: --Dynamic SQL is being used as Oracle 8i PL/SQL does not support
1744: --Analytic functions
1745:

Line 2902: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');

2898:
2899: END LOOP;
2900:
2901: -- commented out for perf bug 4930256
2902: -- l_profile := FND_PROFILE.VALUE_SPECIFIC('PA_AVAILABILITY_CAL_PERIOD');
2903:
2904: delete
2905: from PA_RES_AVAILABILITY where RESOURCE_ID = -1; --Added for bug 4928773
2906:

Line 2974: l_org_id := fnd_profile.value_specific(

2970: l_return_status VARCHAR2(1);
2971: l_error_message_code fnd_new_messages.message_name%TYPE;
2972: BEGIN
2973:
2974: l_org_id := fnd_profile.value_specific(
2975: name => 'PA_STAFF_HOME_DEF_ORG',
2976: user_id => p_user_id);
2977:
2978: IF l_org_id IS NULL THEN