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.JTF_RS_RES_AVAILABILITY_PVT dependencies on JTF_RS_RES_AVAILABILITY_S

Line 27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE,

23: P_COMMIT IN VARCHAR2,
24: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
25: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
26: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,

Line 103: SELECT jtf_rs_res_availability_s.nextval

99: OPEN c_dup_res_avail (l_resource_id, l_mode_of_availability);
100: FETCH c_dup_res_avail into l_availability_id;
101: IF (c_dup_res_avail%NOTFOUND) THEN
102:
103: SELECT jtf_rs_res_availability_s.nextval
104: INTO l_availability_id
105: FROM dual;
106:
107: JTF_RS_RES_AVAILABILITY_PKG.INSERT_ROW(

Line 198: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE,

194: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
195: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
196: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
197: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE,
198: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE,
199: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE,
200: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
201: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
202: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE,

Line 290: l_start_date JTF_RS_RES_AVAILABILITY.START_DATE%TYPE := p_start_date;

286: l_availability_id JTF_RS_RES_AVAILABILITY.availability_ID%TYPE := p_availability_id;
287: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;
288: l_available_flag JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE := p_available_flag;
289: l_reason_code JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE := p_reason_code;
290: l_start_date JTF_RS_RES_AVAILABILITY.START_DATE%TYPE := p_start_date;
291: l_end_date JTF_RS_RES_AVAILABILITY.END_DATE%TYPE := p_end_date;
292: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := p_mode_of_availability;
293: l_object_version_number JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
294: