47: PROCEDURE create_resource_group
48: (P_API_VERSION IN NUMBER,
49: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
48: (P_API_VERSION IN NUMBER,
49: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
49: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
50: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
50: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
51: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59: X_MSG_COUNT OUT NOCOPY NUMBER,
52: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59: X_MSG_COUNT OUT NOCOPY NUMBER,
60: X_MSG_DATA OUT NOCOPY VARCHAR2,
53: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
54: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
55: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
56: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59: X_MSG_COUNT OUT NOCOPY NUMBER,
60: X_MSG_DATA OUT NOCOPY VARCHAR2,
61: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
57: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59: X_MSG_COUNT OUT NOCOPY NUMBER,
60: X_MSG_DATA OUT NOCOPY VARCHAR2,
61: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
62: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
63: );
64:
65:
58: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
59: X_MSG_COUNT OUT NOCOPY NUMBER,
60: X_MSG_DATA OUT NOCOPY VARCHAR2,
61: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
62: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
63: );
64:
65:
66: --Create Resource Group Migration API, used for one-time migration of resource group data
108: PROCEDURE create_resource_group_migrate
109: (P_API_VERSION IN NUMBER,
110: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
109: (P_API_VERSION IN NUMBER,
110: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
110: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
111: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
111: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
112: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
112: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
113: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
114: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
115: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
116: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
117: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
118: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
119: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
120: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
121: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
122: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
123: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
124: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
125: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
126: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
127: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
128: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
129: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
130: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
138: X_MSG_DATA OUT NOCOPY VARCHAR2,
131: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
132: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
133: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
134: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
138: X_MSG_DATA OUT NOCOPY VARCHAR2,
139: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
135: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
138: X_MSG_DATA OUT NOCOPY VARCHAR2,
139: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
140: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
141: );
142:
143: --Creating a Global Variable to be used for setting the flag,
136: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
137: X_MSG_COUNT OUT NOCOPY NUMBER,
138: X_MSG_DATA OUT NOCOPY VARCHAR2,
139: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
140: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE
141: );
142:
143: --Creating a Global Variable to be used for setting the flag,
144: --when the create_resource_group_migrate gets called
143: --Creating a Global Variable to be used for setting the flag,
144: --when the create_resource_group_migrate gets called
145:
146: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
147: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
144: --when the create_resource_group_migrate gets called
145:
146: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
147: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
145:
146: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
147: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
146: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
147: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
147: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
148: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
149: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
150: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
151: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
152: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
153: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
154: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
155: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
163: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
156: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
163: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
164:
157: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
163: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
164:
165: /* Procedure to update the resource group based on input values
158: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
163: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
164:
165: /* Procedure to update the resource group based on input values
166: passed by calling routines. */
159: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
160: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
161: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
162: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
163: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
164:
165: /* Procedure to update the resource group based on input values
166: passed by calling routines. */
167: /*#
190: PROCEDURE update_resource_group
191: (P_API_VERSION IN NUMBER,
192: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
191: (P_API_VERSION IN NUMBER,
192: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
192: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
193: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
193: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
194: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
194: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
195: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
196: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
204: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
197: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
204: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
205: X_MSG_COUNT OUT NOCOPY NUMBER,
198: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
204: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
205: X_MSG_COUNT OUT NOCOPY NUMBER,
206: X_MSG_DATA OUT NOCOPY VARCHAR2
199: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
200: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
201: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
202: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
204: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
205: X_MSG_COUNT OUT NOCOPY NUMBER,
206: X_MSG_DATA OUT NOCOPY VARCHAR2
207: );