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 JTF_RS_RES_AVAILABILITY_PVT AUTHID CURRENT_USER AS

1: PACKAGE JTF_RS_RES_AVAILABILITY_PVT AUTHID CURRENT_USER AS
2: /* $Header: jtfrsvzs.pls 120.0 2005/05/11 08:23:24 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that public API will invoke.

Line 6: It provides procedures for managing data of JTF_RS_RES_AVAILABILITY table

2: /* $Header: jtfrsvzs.pls 120.0 2005/05/11 08:23:24 appldev ship $ */
3:
4: /*****************************************************************************************
5: This is a private API that public API will invoke.
6: It provides procedures for managing data of JTF_RS_RES_AVAILABILITY table
7: create, update and delete rows
8: Its main procedures are as following:
9: Create resource availability
10: Update resource availability

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

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

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 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,

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 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
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 DEFAULT NULL,

22: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,

23: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,

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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,

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 DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,

26: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,

27: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,

28: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,

29: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
30: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
31: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
32: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
33: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 34: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,

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

Line 35: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,

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

Line 36: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,

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

Line 37: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,

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

Line 38: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,

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

Line 39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,

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

Line 40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,

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

Line 41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,

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

Line 42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,

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

Line 43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,

39: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
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 DEFAULT NULL,

40: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
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 DEFAULT NULL,

41: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
42: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
43: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
44: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
45: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
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 DEFAULT NULL,
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: );
51:
52:
53: /* Procedure to update resource availability

Line 60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

56: PROCEDURE update_res_availability
57: (P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,

57: (P_API_VERSION IN NUMBER,
58: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

58: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

59: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

Line 64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

60: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

61: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,

62: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

63: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

64: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

65: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

66: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

67: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

68: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

69: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

70: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

71: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

72: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

73: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

74: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

75: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

76: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

77: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

78: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

79: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
80: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
81: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
82: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
83: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
84: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
85: X_MSG_COUNT OUT NOCOPY NUMBER,
86: X_MSG_DATA OUT NOCOPY VARCHAR2
87: );

Line 96: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

92: PROCEDURE delete_res_availability
93: (P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
97: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
99: X_MSG_COUNT OUT NOCOPY NUMBER,
100: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 97: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

93: (P_API_VERSION IN NUMBER,
94: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
95: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
96: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
97: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
98: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
99: X_MSG_COUNT OUT NOCOPY NUMBER,
100: X_MSG_DATA OUT NOCOPY VARCHAR2
101: );

Line 103: END JTF_RS_RES_AVAILABILITY_PVT;

99: X_MSG_COUNT OUT NOCOPY NUMBER,
100: X_MSG_DATA OUT NOCOPY VARCHAR2
101: );
102:
103: END JTF_RS_RES_AVAILABILITY_PVT;