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_PUB dependencies on JTF_RS_RES_AVAILABILITY

Line 1: PACKAGE jtf_rs_res_availability_pub AUTHID CURRENT_USER AS

1: PACKAGE jtf_rs_res_availability_pub AUTHID CURRENT_USER AS
2: /* $Header: jtfrspzs.pls 120.0 2005/05/11 08:21:32 appldev ship $ */
3: /*#
4: * Resource Availability create, update and delete API
5: * This API contains the procedures to insert, update and delete resource availability record.

Line 13: It provides procedures for managing seed data of jtf_rs_res_availability tables

9: * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE_AVAILABILITY
10: */
11: /*****************************************************************************************
12: This is a public API that user API will invoke.
13: It provides procedures for managing seed data of jtf_rs_res_availability tables
14: create, update and delete rows
15: Its main procedures are as following:
16: Create res_availability
17: Update res_availability

Line 19: Calls to these procedures will call procedures of jtf_rs_res_availability_pvt

15: Its main procedures are as following:
16: Create res_availability
17: Update res_availability
18: Delete res_availability
19: Calls to these procedures will call procedures of jtf_rs_res_availability_pvt
20: to do inserts, updates and deletes into tables.
21: ******************************************************************************************/
22:
23:

Line 68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,

64: PROCEDURE create_res_availability
65: (P_API_VERSION IN NUMBER,
66: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,

Line 69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,

65: (P_API_VERSION IN NUMBER,
66: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,

Line 70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,

66: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
67: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,

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

67: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,

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

68: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,

69: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,

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

70: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT NULL,
71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,

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

71: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT NULL,
72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,

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

72: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT NULL,
73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,

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

73: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,

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

74: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT NULL,
75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,

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

75: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT NULL,
76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,

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

76: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT NULL,
77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,

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

77: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT NULL,
78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,

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

78: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT NULL,
79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,

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

79: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT NULL,
80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,

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

80: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT NULL,
81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,

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

81: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT NULL,
82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

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

82: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT NULL,
83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

83: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT NULL,
84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,

84: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT NULL,
85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,
92: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

85: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT NULL,
86: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT NULL,
87: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT NULL,
88: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT NULL,
89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,
92: X_MSG_DATA OUT NOCOPY VARCHAR2,
93: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE );

Line 93: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE );

89: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
90: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
91: X_MSG_COUNT OUT NOCOPY NUMBER,
92: X_MSG_DATA OUT NOCOPY VARCHAR2,
93: X_AVAILABILITY_ID OUT NOCOPY JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE );
94:
95:
96: /* Procedure to update resource availability
97: based on input values passed by calling routines. */

Line 111: * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.

107: * @param p_reason_code Reason Code
108: * @param p_start_date Date on which the resource is not available.
109: * @param p_end_date Date on which the resource is available.
110: * @param p_mode_of_availability Mode of Availability
111: * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.
112: * @param p_attribute1 Descriptive flexfield Segment 1
113: * @param p_attribute2 Descriptive flexfield Segment 2
114: * @param p_attribute3 Descriptive flexfield Segment 3
115: * @param p_attribute4 Descriptive flexfield Segment 4

Line 139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

135: PROCEDURE update_res_availability
136: (P_API_VERSION IN NUMBER,
137: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

136: (P_API_VERSION IN NUMBER,
137: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,

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

137: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
138: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

138: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

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

139: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

140: P_RESOURCE_ID IN JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE DEFAULT FND_API.G_MISS_NUM,
141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

141: P_AVAILABLE_FLAG IN JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

142: P_REASON_CODE IN JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

143: P_START_DATE IN JTF_RS_RES_AVAILABILITY.START_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

144: P_END_DATE IN JTF_RS_RES_AVAILABILITY.END_DATE%TYPE DEFAULT FND_API.G_MISS_DATE,
145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

145: P_MODE_OF_AVAILABILITY IN JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE DEFAULT FND_API.G_MISS_CHAR,
146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

146: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

147: P_ATTRIBUTE1 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

148: P_ATTRIBUTE2 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

149: P_ATTRIBUTE3 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

150: P_ATTRIBUTE4 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

151: P_ATTRIBUTE5 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

152: P_ATTRIBUTE6 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

153: P_ATTRIBUTE7 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

154: P_ATTRIBUTE8 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

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

155: P_ATTRIBUTE9 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

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

156: P_ATTRIBUTE10 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
164: X_MSG_COUNT OUT NOCOPY NUMBER,

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

157: P_ATTRIBUTE11 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
164: X_MSG_COUNT OUT NOCOPY NUMBER,
165: X_MSG_DATA OUT NOCOPY VARCHAR2

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

158: P_ATTRIBUTE12 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
159: P_ATTRIBUTE13 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE14 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_ATTRIBUTE15 IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_ATTRIBUTE_CATEGORY IN JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
163: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
164: X_MSG_COUNT OUT NOCOPY NUMBER,
165: X_MSG_DATA OUT NOCOPY VARCHAR2
166: );

Line 179: * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.

175: * @param p_api_version API version
176: * @param p_init_msg_list Initialization of the message list
177: * @param p_commit Commit
178: * @param p_availability_id Availability Identifier
179: * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.
180: * @param x_return_status Output parameter for return status
181: * @param x_msg_count Output parameter for number of user messages from this procedure
182: * @param x_msg_data Output parameter containing last user message from this procedure
183: * @rep:scope internal

Line 191: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,

187: PROCEDURE delete_res_availability
188: (P_API_VERSION IN NUMBER,
189: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
191: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
192: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
193: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
194: X_MSG_COUNT OUT NOCOPY NUMBER,
195: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 192: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,

188: (P_API_VERSION IN NUMBER,
189: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
190: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
191: P_AVAILABILITY_ID IN JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
192: P_OBJECT_VERSION_NUM IN JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
193: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
194: X_MSG_COUNT OUT NOCOPY NUMBER,
195: X_MSG_DATA OUT NOCOPY VARCHAR2
196: );

Line 198: END JTF_RS_RES_AVAILABILITY_PUB;

194: X_MSG_COUNT OUT NOCOPY NUMBER,
195: X_MSG_DATA OUT NOCOPY VARCHAR2
196: );
197:
198: END JTF_RS_RES_AVAILABILITY_PUB;