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

Line 1: PACKAGE BODY JTF_RS_RES_AVAILABILITY_PVT AS

1: PACKAGE BODY JTF_RS_RES_AVAILABILITY_PVT AS
2: /* $Header: jtfrsvzb.pls 120.2 2005/07/26 21:01:45 repuri ship $ */
3:
4: /*****************************************************************************************
5: Its main procedures are as following:

Line 9: Calls to these procedures will invoke procedures from JTF_RS_RES_AVAILABILITY_PUB

5: Its main procedures are as following:
6: Create resource availability
7: Update resource availability
8: Delete resource availability
9: Calls to these procedures will invoke procedures from JTF_RS_RES_AVAILABILITY_PUB
10: to do business validations and to do actual inserts, updates and deletes into tables.
11: ******************************************************************************************/
12: /* Package variables. */
13:

Line 14: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RES_AVAILABILITY_PVT';

10: to do business validations and to do actual inserts, updates and deletes into tables.
11: ******************************************************************************************/
12: /* Package variables. */
13:
14: G_PKG_NAME VARCHAR2(30) := 'JTF_RS_RES_AVAILABILITY_PVT';
15: G_NAME VARCHAR2(240);
16:
17: /* Procedure to create the resource availability
18: based on input values passed by calling routines. */

Line 24: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,

20: PROCEDURE create_res_availability
21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2,
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,

Line 25: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,

21: (P_API_VERSION IN NUMBER,
22: P_INIT_MSG_LIST IN VARCHAR2,
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,

Line 26: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE,

22: P_INIT_MSG_LIST IN VARCHAR2,
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,

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 28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE,

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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,

Line 29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,

Line 30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,

Line 31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,

Line 32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,

Line 33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%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,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,

Line 34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,

30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,

Line 35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,

31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,

Line 36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,

32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,

Line 37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,

33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,

Line 38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,

34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,

Line 39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,

35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,

Line 40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,

36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,

Line 41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,

37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,

Line 42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,

38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,

39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,

40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,

41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,
49: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE

Line 49: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE

45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
46: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47: X_MSG_COUNT OUT NOCOPY NUMBER,
48: X_MSG_DATA OUT NOCOPY VARCHAR2,
49: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE
50: )IS
51:
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RES_AVAILABILITY';
53: l_api_version CONSTANT NUMBER := 1.0;

Line 54: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;

50: )IS
51:
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RES_AVAILABILITY';
53: l_api_version CONSTANT NUMBER := 1.0;
54: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;
55: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := P_MODE_OF_AVAILABILITY;
56: l_object_version_number NUMBER;
57: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE;
58: l_return_status VARCHAR2(200);

Line 55: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := P_MODE_OF_AVAILABILITY;

51:
52: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RES_AVAILABILITY';
53: l_api_version CONSTANT NUMBER := 1.0;
54: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;
55: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := P_MODE_OF_AVAILABILITY;
56: l_object_version_number NUMBER;
57: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE;
58: l_return_status VARCHAR2(200);
59: l_msg_count NUMBER;

Line 57: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE;

53: l_api_version CONSTANT NUMBER := 1.0;
54: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;
55: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := P_MODE_OF_AVAILABILITY;
56: l_object_version_number NUMBER;
57: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE;
58: l_return_status VARCHAR2(200);
59: l_msg_count NUMBER;
60: l_msg_data VARCHAR2(200);
61: l_rowid VARCHAR2(200);

Line 68: FROM JTF_RS_RES_AVAILABILITY

64: -- uncommenting and modifying the cursor and the related code for fixing bug 4309007.
65: CURSOR c_dup_res_avail (l_resource_id IN NUMBER, l_mode_of_availability IN VARCHAR2)
66: IS
67: SELECT 1
68: FROM JTF_RS_RES_AVAILABILITY
69: WHERE resource_id = l_resource_id
70: AND mode_of_availability = l_mode_of_availability;
71:
72: l_date Date;

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 107: JTF_RS_RES_AVAILABILITY_PKG.INSERT_ROW(

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(
108: X_ROWID => l_rowid,
109: X_AVAILABILITY_ID => l_availability_id,
110: X_RESOURCE_ID => l_resource_id,
111: X_AVAILABLE_FLAG => P_AVAILABLE_FLAG,

Line 194: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

190: PROCEDURE update_res_availability
191: (P_API_VERSION IN NUMBER,
192: P_INIT_MSG_LIST IN VARCHAR2,
193: P_COMMIT IN VARCHAR2,
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,

Line 195: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,

191: (P_API_VERSION IN NUMBER,
192: P_INIT_MSG_LIST IN VARCHAR2,
193: P_COMMIT IN VARCHAR2,
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,

Line 196: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,

192: P_INIT_MSG_LIST IN VARCHAR2,
193: P_COMMIT IN VARCHAR2,
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,

Line 197: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE,

193: P_COMMIT IN VARCHAR2,
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,

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 199: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,

Line 200: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,

Line 201: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,

Line 202: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,

Line 203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,

Line 204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,

Line 205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%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,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,

Line 206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,

202: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE,
203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,

Line 207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,

203: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE,
204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,

Line 208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,

204: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE,
205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,

Line 209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,

205: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE,
206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,

Line 210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,

206: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE,
207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,

Line 211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,

207: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE,
208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,

Line 212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,

208: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE,
209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,

Line 213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,

209: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE,
210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,

Line 214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,

210: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE,
211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
218: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,

211: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE,
212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
218: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
219: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,

212: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE,
213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
218: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
219: X_MSG_COUNT OUT NOCOPY NUMBER,
220: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,

213: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE,
214: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE,
215: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE,
216: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE,
217: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE,
218: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
219: X_MSG_COUNT OUT NOCOPY NUMBER,
220: X_MSG_DATA OUT NOCOPY VARCHAR2
221: )IS

Line 225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;

221: )IS
222: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RES_AVAILABILITY';
223: l_api_version CONSTANT NUMBER := 1.0;
224:
225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;
226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;

Line 226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;

222: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RES_AVAILABILITY';
223: l_api_version CONSTANT NUMBER := 1.0;
224:
225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;
226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;

Line 227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;

223: l_api_version CONSTANT NUMBER := 1.0;
224:
225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;
226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;

Line 228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;

224:
225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;
226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;

Line 229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;

225: L_ATTRIBUTE1 JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE;
226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;

Line 230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;

226: L_ATTRIBUTE2 JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE;
227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;

Line 231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;

227: L_ATTRIBUTE3 JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE;
228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;

Line 232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;

228: L_ATTRIBUTE4 JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE;
229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;

Line 233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;

229: L_ATTRIBUTE5 JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE;
230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;

Line 234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;

230: L_ATTRIBUTE6 JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE;
231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;

Line 235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;

231: L_ATTRIBUTE7 JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE;
232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;

Line 236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;

232: L_ATTRIBUTE8 JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE;
233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;

Line 237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;

233: L_ATTRIBUTE9 JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE;
234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;
241:

Line 238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;

234: L_ATTRIBUTE10 JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE;
235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;
241:
242:

Line 239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;

235: L_ATTRIBUTE11 JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE;
236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;
241:
242:
243: CURSOR resource_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)

Line 240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;

236: L_ATTRIBUTE12 JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE;
237: L_ATTRIBUTE13 JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE;
238: L_ATTRIBUTE14 JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE;
239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;
241:
242:
243: CURSOR resource_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)
244: IS

Line 243: CURSOR resource_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)

239: L_ATTRIBUTE15 JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE;
240: L_ATTRIBUTE_CATEGORY JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE;
241:
242:
243: CURSOR resource_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)
244: IS
245: SELECT AVAILABILITY_ID,
246: RESOURCE_ID,
247: AVAILABLE_FLAG,

Line 274: FROM jtf_rs_res_availability

270: CREATION_DATE,
271: LAST_UPDATED_BY,
272: LAST_UPDATE_DATE,
273: LAST_UPDATE_LOGIN
274: FROM jtf_rs_res_availability
275: WHERE availability_id = ll_availability_id;
276:
277: resource_rec resource_cur%rowtype;
278:

Line 282: FROM jtf_rs_res_availability

278:
279: -- Cursor to check duplicates.
280: CURSOR c_dup_res_avail (l_resource_id IN NUMBER, l_mode_of_availability IN VARCHAR2) IS
281: SELECT 1
282: FROM jtf_rs_res_availability
283: WHERE resource_id = l_resource_id
284: AND mode_of_availability = l_mode_of_availability;
285:
286: l_availability_id JTF_RS_RES_AVAILABILITY.availability_ID%TYPE := p_availability_id;

Line 286: l_availability_id JTF_RS_RES_AVAILABILITY.availability_ID%TYPE := p_availability_id;

282: FROM jtf_rs_res_availability
283: WHERE resource_id = l_resource_id
284: AND mode_of_availability = l_mode_of_availability;
285:
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;

Line 287: l_resource_id JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE := p_resource_id;

283: WHERE resource_id = l_resource_id
284: AND mode_of_availability = l_mode_of_availability;
285:
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;

Line 288: l_available_flag JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE := p_available_flag;

284: AND mode_of_availability = l_mode_of_availability;
285:
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;

Line 289: l_reason_code JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE := p_reason_code;

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

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:

Line 291: l_end_date JTF_RS_RES_AVAILABILITY.END_DATE%TYPE := p_end_date;

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:
295: l_return_status VARCHAR2(200);

Line 292: l_mode_of_availability JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE := p_mode_of_availability;

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:
295: l_return_status VARCHAR2(200);
296: l_msg_count NUMBER;

Line 293: l_object_version_number JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

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:
295: l_return_status VARCHAR2(200);
296: l_msg_count NUMBER;
297: l_msg_data VARCHAR2(200);

Line 504: jtf_rs_res_availability_pkg.lock_row(

500: END IF;
501:
502: BEGIN
503:
504: jtf_rs_res_availability_pkg.lock_row(
505: x_availability_id => l_availability_id,
506: x_object_version_number => p_object_version_num
507: );
508:

Line 522: jtf_rs_res_availability_pkg.update_row(

518:
519:
520: l_object_version_number := l_object_version_number +1;
521:
522: jtf_rs_res_availability_pkg.update_row(
523: X_AVAILABILITY_ID => l_availability_id,
524: X_RESOURCE_ID => l_resource_id,
525: X_AVAILABLE_FLAG => l_AVAILABLE_FLAG,
526: X_REASON_CODE => l_REASON_CODE,

Line 602: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

598: PROCEDURE delete_res_availability
599: (P_API_VERSION IN NUMBER,
600: P_INIT_MSG_LIST IN VARCHAR2,
601: P_COMMIT IN VARCHAR2,
602: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
603: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
604: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
605: X_MSG_COUNT OUT NOCOPY NUMBER,
606: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 603: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

599: (P_API_VERSION IN NUMBER,
600: P_INIT_MSG_LIST IN VARCHAR2,
601: P_COMMIT IN VARCHAR2,
602: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
603: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
604: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
605: X_MSG_COUNT OUT NOCOPY NUMBER,
606: X_MSG_DATA OUT NOCOPY VARCHAR2
607: )IS

Line 610: CURSOR chk_res_exist_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)

606: X_MSG_DATA OUT NOCOPY VARCHAR2
607: )IS
608:
609:
610: CURSOR chk_res_exist_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)
611: IS
612: SELECT resource_id
613: FROM JTF_RS_RES_AVAILABILITY
614: WHERE availability_id = ll_availability_id;

Line 613: FROM JTF_RS_RES_AVAILABILITY

609:
610: CURSOR chk_res_exist_cur(ll_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE)
611: IS
612: SELECT resource_id
613: FROM JTF_RS_RES_AVAILABILITY
614: WHERE availability_id = ll_availability_id;
615:
616: chk_res_exist_rec chk_res_exist_cur%rowtype;
617:

Line 618: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE := p_availability_id;

614: WHERE availability_id = ll_availability_id;
615:
616: chk_res_exist_rec chk_res_exist_cur%rowtype;
617:
618: l_availability_id JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE := p_availability_id;
619:
620: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RES_AVAILABILITY';
621: l_api_version CONSTANT NUMBER := 1.0;
622:

Line 654: JTF_RS_RES_AVAILABILITY_PKG.DELETE_ROW(

650: FETCH chk_res_exist_cur INTO chk_res_exist_rec;
651: IF (chk_res_exist_cur%FOUND)
652: THEN
653:
654: JTF_RS_RES_AVAILABILITY_PKG.DELETE_ROW(
655: X_AVAILABILITY_ID => l_availability_id);
656:
657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;

Line 698: END JTF_RS_RES_AVAILABILITY_PVT;

694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: END delete_res_availability;
697:
698: END JTF_RS_RES_AVAILABILITY_PVT;