DBA Data[Home] [Help]

APPS.PA_SCHEDULE_PVT dependencies on FND_NUMBER

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