PACKAGE: APPS.PA_RES_AVL_PVT

Source

1 PACKAGE PA_RES_AVL_PVT
2 -- $Header: PARRAVLS.pls 120.1 2005/08/19 16:59:52 mwasowic noship $
3 AUTHID CURRENT_USER AS
4 -- Standard Table Handler procedures for PA_RES_AVAILABILITY table
5 
6 PROCEDURE Insert_Row (
7           P_RESOURCE_ID            IN     pa_res_availability.resource_id%type
8          ,P_START_DATE             IN     pa_res_availability.start_date%type
9          ,P_END_DATE               IN     pa_res_availability.end_date%type
10          ,P_RECORD_TYPE            IN     pa_res_availability.record_type%type
11          ,P_PERCENT                IN     pa_res_availability.percent%type
12          ,P_HOURS                  IN     pa_res_availability.hours%type
13          ,X_ROW_ID                 OUT    NOCOPY ROWID --File.Sql.39 bug 4440895
14          ,X_RETURN_STATUS          OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15 );
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
25 );
26 
27 PROCEDURE Delete_Row (
28           P_RESOURCE_ID            IN     pa_res_availability.resource_id%type
29          ,P_START_DATE             IN     pa_res_availability.start_date%type
30          ,P_RECORD_TYPE            IN     pa_res_availability.record_type%type
31          ,X_RETURN_STATUS          OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32 );
33 
34 END PA_RES_AVL_PVT;