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_NUMBER

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 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 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 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 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;