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 BODY PA_RES_AVL_PVT
2: -- $Header: PARRAVLB.pls 120.1 2005/08/19 16:59:49 mwasowic noship $
3: AS
4: -- Standard Table Handler procedures for PA_RES_AVAILABILITY table
5: PROCEDURE Insert_Row (
6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type

Line 6: P_RESOURCE_ID IN pa_res_availability.resource_id%type

2: -- $Header: PARRAVLB.pls 120.1 2005/08/19 16:59:49 mwasowic noship $
3: AS
4: -- Standard Table Handler procedures for PA_RES_AVAILABILITY table
5: PROCEDURE Insert_Row (
6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type

Line 7: ,P_START_DATE IN pa_res_availability.start_date%type

3: AS
4: -- Standard Table Handler procedures for PA_RES_AVAILABILITY table
5: PROCEDURE Insert_Row (
6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type
11: ,P_HOURS IN pa_res_availability.hours%type

Line 8: ,P_END_DATE IN pa_res_availability.end_date%type

4: -- Standard Table Handler procedures for PA_RES_AVAILABILITY table
5: PROCEDURE Insert_Row (
6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type
11: ,P_HOURS IN pa_res_availability.hours%type
12: ,X_ROW_ID OUT NOCOPY ROWID --File.Sql.39 bug 4440895

Line 9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

5: PROCEDURE Insert_Row (
6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type
11: ,P_HOURS IN pa_res_availability.hours%type
12: ,X_ROW_ID OUT NOCOPY ROWID --File.Sql.39 bug 4440895
13: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 10: ,P_PERCENT IN pa_res_availability.percent%type

6: P_RESOURCE_ID IN pa_res_availability.resource_id%type
7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type
11: ,P_HOURS IN pa_res_availability.hours%type
12: ,X_ROW_ID OUT NOCOPY ROWID --File.Sql.39 bug 4440895
13: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
14: )

Line 11: ,P_HOURS IN pa_res_availability.hours%type

7: ,P_START_DATE IN pa_res_availability.start_date%type
8: ,P_END_DATE IN pa_res_availability.end_date%type
9: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
10: ,P_PERCENT IN pa_res_availability.percent%type
11: ,P_HOURS IN pa_res_availability.hours%type
12: ,X_ROW_ID OUT NOCOPY ROWID --File.Sql.39 bug 4440895
13: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
14: )
15: IS

Line 23: insert into PA_RES_AVAILABILITY (

19:
20: -- Initialize the return status to success
21: x_return_status := FND_API.G_RET_STS_SUCCESS;
22:
23: insert into PA_RES_AVAILABILITY (
24: RESOURCE_ID
25: ,START_DATE
26: ,END_DATE
27: ,RECORD_TYPE

Line 63: P_RESOURCE_ID IN pa_res_availability.resource_id%type

59: END Insert_Row;
60:
61:
62: PROCEDURE Update_Row (
63: P_RESOURCE_ID IN pa_res_availability.resource_id%type
64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM

Line 64: ,P_START_DATE IN pa_res_availability.start_date%type

60:
61:
62: PROCEDURE Update_Row (
63: P_RESOURCE_ID IN pa_res_availability.resource_id%type
64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
68: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM

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

61:
62: PROCEDURE Update_Row (
63: P_RESOURCE_ID IN pa_res_availability.resource_id%type
64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
68: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
69: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

62: PROCEDURE Update_Row (
63: P_RESOURCE_ID IN pa_res_availability.resource_id%type
64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
68: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
69: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70: )

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

63: P_RESOURCE_ID IN pa_res_availability.resource_id%type
64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
68: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
69: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70: )
71: IS

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

64: ,P_START_DATE IN pa_res_availability.start_date%type
65: ,P_END_DATE IN pa_res_availability.end_date%type := FND_API.G_MISS_DATE
66: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
67: ,P_PERCENT IN pa_res_availability.percent%type := FND_API.G_MISS_NUM
68: ,P_HOURS IN pa_res_availability.hours%type := FND_API.G_MISS_NUM
69: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
70: )
71: IS
72: BEGIN

Line 79: update PA_RES_AVAILABILITY

75:
76: -- Initialize the return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78:
79: update PA_RES_AVAILABILITY
80: set END_DATE = DECODE(p_end_date, FND_API.G_MISS_DATE, END_DATE, p_end_date)
81: ,PERCENT = DECODE(p_percent, FND_API.G_MISS_NUM, PERCENT, p_percent)
82: ,HOURS = DECODE(p_hours, FND_API.G_MISS_NUM, HOURS, p_hours)
83: ,LAST_UPDATE_DATE = sysdate

Line 103: P_RESOURCE_ID IN pa_res_availability.resource_id%type

99:
100: END Update_Row;
101:
102: PROCEDURE Delete_Row (
103: P_RESOURCE_ID IN pa_res_availability.resource_id%type
104: ,P_START_DATE IN pa_res_availability.start_date%type
105: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
106: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107: )

Line 104: ,P_START_DATE IN pa_res_availability.start_date%type

100: END Update_Row;
101:
102: PROCEDURE Delete_Row (
103: P_RESOURCE_ID IN pa_res_availability.resource_id%type
104: ,P_START_DATE IN pa_res_availability.start_date%type
105: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
106: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107: )
108: IS

Line 105: ,P_RECORD_TYPE IN pa_res_availability.record_type%type

101:
102: PROCEDURE Delete_Row (
103: P_RESOURCE_ID IN pa_res_availability.resource_id%type
104: ,P_START_DATE IN pa_res_availability.start_date%type
105: ,P_RECORD_TYPE IN pa_res_availability.record_type%type
106: ,X_RETURN_STATUS OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
107: )
108: IS
109: BEGIN

Line 116: delete from PA_RES_AVAILABILITY

112:
113: -- Initialize the return status to success
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: delete from PA_RES_AVAILABILITY
117: where
118: RESOURCE_ID = p_resource_id
119: and START_DATE = p_start_date
120: and RECORD_TYPE = p_record_type;