16:
17: PROCEDURE Update_Row (
18: P_RESOURCE_ID IN pa_res_availability.resource_id%type
19: ,P_START_DATE IN pa_res_availability.start_date%type
20: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
21: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
22: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
23: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
24: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
18: P_RESOURCE_ID IN pa_res_availability.resource_id%type
19: ,P_START_DATE IN pa_res_availability.start_date%type
20: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
21: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
22: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
23: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
24: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: );
26:
19: ,P_START_DATE IN pa_res_availability.start_date%type
20: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
21: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
22: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
23: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
24: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
25: );
26:
27: PROCEDURE Delete_Row (