427: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
428: IS
429:
430: g_availability_cal_period VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
431: g_res_capacity_percentage NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE'))/100;
432: g_overcommitment_percentage NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
433: l_row_label_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
434: l_count NUMBER;
435: prm_license VARCHAR(1);
428: IS
429:
430: g_availability_cal_period VARCHAR2(15) := FND_PROFILE.VALUE('PA_AVAILABILITY_CAL_PERIOD');
431: g_res_capacity_percentage NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_RES_CAPACITY_PERCENTAGE'))/100;
432: g_overcommitment_percentage NUMBER := FND_NUMBER.CANONICAL_TO_NUMBER(FND_PROFILE.VALUE('PA_OVERCOMMITMENT_PERCENTAGE'))/100;
433: l_row_label_id_tbl PA_PLSQL_DATATYPES.IdTabTyp;
434: l_count NUMBER;
435: prm_license VARCHAR(1);
436: