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_RES_AVL_PVT dependencies on PA_RES_AVAILABILITY

Line 4: -- Standard Table Handler procedures for PA_RES_AVAILABILITY table

1: PACKAGE PA_RES_AVL_PVT
2: -- $Header: PARRAVLS.pls 120.1 2005/08/19 16:59:52 mwasowic noship $
3: 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

Line 7: P_RESOURCE_ID IN pa_res_availability.resource_id%type

3: 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

Line 8: ,P_START_DATE IN pa_res_availability.start_date%type

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

Line 9: ,P_END_DATE IN pa_res_availability.end_date%type

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

Line 10: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

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

Line 11: ,P_PERCENT IN pa_res_availability.percent%type

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

Line 12: ,P_HOURS IN pa_res_availability.hours%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:

Line 18: P_RESOURCE_ID IN pa_res_availability.resource_id%type

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

Line 19: ,P_START_DATE IN pa_res_availability.start_date%type

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

Line 20: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE

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

Line 21: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

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

Line 22: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM

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:

Line 23: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM

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 (

Line 28: P_RESOURCE_ID IN pa_res_availability.resource_id%type

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

Line 29: ,P_START_DATE IN pa_res_availability.start_date%type

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:

Line 30: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

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;