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_SCHEDULE_PVT dependencies on FND_PROFILE

Line 1299: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');

1295: PA_SCHEDULE_UTILS.log_message(1,'get_org_defaults');
1296: END IF;
1297:
1298: if (l_calendar_id is null) then
1299: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');
1300: end if;
1301:
1302: -- Fix dates.
1303:

Line 5994: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

5990: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5991: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5992: IS
5993:
5994: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5995: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5996:
5997: CURSOR c1 IS
5998: SELECT resource_id, start_date, end_date

Line 5995: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;

5991: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5992: IS
5993:
5994: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5995: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5996:
5997: CURSOR c1 IS
5998: SELECT resource_id, start_date, end_date
5999: FROM pa_project_assignments

Line 6191: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

6187: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6188: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6189: IS
6190:
6191: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6192: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6193:
6194: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6195: l_conflict_group_id NUMBER := p_conflict_group_id;

Line 6192: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;

6188: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6189: IS
6190:
6191: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6192: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6193:
6194: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
6195: l_conflict_group_id NUMBER := p_conflict_group_id;
6196: -- added for bug fix: 4537865

Line 6464: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

6460: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6461: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6462: IS
6463:
6464: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6465: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6466:
6467: l_week_start_date DATE;
6468: l_week_end_date DATE;

Line 6465: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;

6461: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6462: IS
6463:
6464: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6465: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6466:
6467: l_week_start_date DATE;
6468: l_week_end_date DATE;
6469:

Line 6598: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

6594: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6595: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6596: IS
6597:
6598: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6599: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6600:
6601: -- Cursor c1 is used to resolve_conflicts_action_code.
6602: CURSOR c1 IS

Line 6599: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;

6595: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6596: IS
6597:
6598: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6599: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6600:
6601: -- Cursor c1 is used to resolve_conflicts_action_code.
6602: CURSOR c1 IS
6603: SELECT DISTINCT resolve_conflicts_action_code

Line 8100: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

8096: -- AND b.project_id = c.project_id
8097:
8098: BEGIN
8099:
8100: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
8101:
8102: -- Start of Debugging Statements
8103: IF l_debug_mode = 'Y' THEN -- 4387388
8104: PA_SCHEDULE_UTILS.log_message(1, 'p_start_date: ' || p_start_date);

Line 8948: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');

8944: p_resource_id IN NUMBER,
8945: p_conflict_group_id IN NUMBER) RETURN NUMBER
8946: IS
8947:
8948: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
8949: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
8950:
8951: l_count NUMBER := 0;
8952: l_start_date DATE;

Line 8949: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;

8945: p_conflict_group_id IN NUMBER) RETURN NUMBER
8946: IS
8947:
8948: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
8949: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
8950:
8951: l_count NUMBER := 0;
8952: l_start_date DATE;
8953: l_end_date DATE;