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 FND_API

Line 21: x_return_status := FND_API.G_RET_STS_SUCCESS;

17:
18: PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Insert_Row');
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

Line 57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

53: FND_MSG_PUB.add_exc_msg
54: (p_pkg_name => 'PA_RES_AVL_PVT'
55: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
56:
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58:
59: END Insert_Row;
60:
61:

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 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 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73:
74: PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Update_Row');
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)

Line 80: set END_DATE = DECODE(p_end_date, FND_API.G_MISS_DATE, END_DATE, p_end_date)

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
84: ,LAST_UPDATED_BY = fnd_global.user_id

Line 81: ,PERCENT = DECODE(p_percent, FND_API.G_MISS_NUM, PERCENT, p_percent)

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
84: ,LAST_UPDATED_BY = fnd_global.user_id
85: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 82: ,HOURS = DECODE(p_hours, FND_API.G_MISS_NUM, HOURS, p_hours)

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
84: ,LAST_UPDATED_BY = fnd_global.user_id
85: ,LAST_UPDATE_LOGIN = fnd_global.login_id
86: where

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

94: FND_MSG_PUB.add_exc_msg
95: (p_pkg_name => 'PA_RES_AVL_PVT'
96: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
97:
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
100: END Update_Row;
101:
102: PROCEDURE Delete_Row (

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110:
111: PA_DEBUG.init_err_stack('PA_RES_AVL_PVT.Delete_Row');
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

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: FND_MSG_PUB.add_exc_msg
126: (p_pkg_name => 'PA_RES_AVL_PVT'
127: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
128:
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130:
131: END Delete_Row;
132:
133: