18: based on input values passed by calling routines. */
19:
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,
19:
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,
54: based on input values passed by calling routines. */
55:
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,
55:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
90: /* Procedure to delete the resource availability */
91:
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,
91:
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,