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 1129: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');

1125: PA_SCHEDULE_UTILS.log_message(1,'get_org_defaults');
1126: END IF;
1127:
1128: if (l_calendar_id is null) then
1129: l_calendar_id := fnd_profile.value_specific('PA_PRM_DEFAULT_CALENDAR');
1130: end if;
1131:
1132: -- Fix dates.
1133:

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

5702: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5703: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5704: IS
5705:
5706: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5707: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5708:
5709: CURSOR c1 IS
5710: SELECT resource_id, start_date, end_date

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

5703: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5704: IS
5705:
5706: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5707: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5708:
5709: CURSOR c1 IS
5710: SELECT resource_id, start_date, end_date
5711: FROM pa_project_assignments

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

5894: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
5895: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5896: IS
5897:
5898: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5899: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5900:
5901: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5902: l_conflict_group_id NUMBER := p_conflict_group_id;

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

5895: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
5896: IS
5897:
5898: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
5899: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
5900:
5901: l_assignment_id_tbl PA_PLSQL_DATATYPES.NumTabTyp;
5902: l_conflict_group_id NUMBER := p_conflict_group_id;
5903: -- added for bug fix: 4537865

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

6167: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6168: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6169: IS
6170:
6171: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6172: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6173:
6174: l_week_start_date DATE;
6175: l_week_end_date DATE;

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

6168: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6169: IS
6170:
6171: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6172: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6173:
6174: l_week_start_date DATE;
6175: l_week_end_date DATE;
6176:

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

6301: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
6302: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6303: IS
6304:
6305: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6306: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6307:
6308: -- Cursor c1 is used to resolve_conflicts_action_code.
6309: CURSOR c1 IS

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

6302: x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
6303: IS
6304:
6305: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
6306: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
6307:
6308: -- Cursor c1 is used to resolve_conflicts_action_code.
6309: CURSOR c1 IS
6310: SELECT DISTINCT resolve_conflicts_action_code

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

7803: -- AND b.project_id = c.project_id
7804:
7805: BEGIN
7806:
7807: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
7808:
7809: -- Start of Debugging Statements
7810: IF l_debug_mode = 'Y' THEN -- 4387388
7811: PA_SCHEDULE_UTILS.log_message(1, 'p_start_date: ' || p_start_date);

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

8651: p_resource_id IN NUMBER,
8652: p_conflict_group_id IN NUMBER) RETURN NUMBER
8653: IS
8654:
8655: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
8656: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
8657:
8658: l_count NUMBER := 0;
8659: l_start_date DATE;

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

8652: p_conflict_group_id IN NUMBER) RETURN NUMBER
8653: IS
8654:
8655: G_AVAILABILITY_CAL_PERIOD VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
8656: G_OVERCOMMITMENT_PERCENTAGE NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
8657:
8658: l_count NUMBER := 0;
8659: l_start_date DATE;
8660: l_end_date DATE;