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_GROUPS_PUB dependencies on JTF_RS_GROUPS_VL

Line 52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

48: PROCEDURE create_resource_group
49: (P_API_VERSION IN NUMBER,
50: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,

49: (P_API_VERSION IN NUMBER,
50: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',

50: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
51: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

Line 55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,

51: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

52: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

53: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

54: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
55: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
56: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
57: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 62: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

58: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
63: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
64: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
65: );
66:

Line 63: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

59: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
63: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
64: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
65: );
66:
67:

Line 64: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL

60: X_MSG_COUNT OUT NOCOPY NUMBER,
61: X_MSG_DATA OUT NOCOPY VARCHAR2,
62: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
63: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
64: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
65: );
66:
67:
68: --Create Resource Group Migration API, used for one-time migration of resource group data

Line 115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,

111: PROCEDURE create_resource_group_migrate
112: (P_API_VERSION IN NUMBER,
113: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

Line 116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,

112: (P_API_VERSION IN NUMBER,
113: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

Line 117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',

113: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

Line 118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,

114: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,

115: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE,
116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,

Line 120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,

116: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT NULL,
117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,

Line 121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,

117: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT 'N',
118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

118: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT NULL,
119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,

119: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE,
120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,

120: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT NULL,
121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,

121: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT NULL,
122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,

122: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,

123: P_ATTRIBUTE1 IN JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE DEFAULT NULL,
124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,

124: P_ATTRIBUTE2 IN JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE DEFAULT NULL,
125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,

125: P_ATTRIBUTE3 IN JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE DEFAULT NULL,
126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,

126: P_ATTRIBUTE4 IN JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE DEFAULT NULL,
127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,

127: P_ATTRIBUTE5 IN JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE DEFAULT NULL,
128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,

128: P_ATTRIBUTE6 IN JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE DEFAULT NULL,
129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,

129: P_ATTRIBUTE7 IN JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE DEFAULT NULL,
130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,

130: P_ATTRIBUTE8 IN JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE DEFAULT NULL,
131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,

131: P_ATTRIBUTE9 IN JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE DEFAULT NULL,
132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,

132: P_ATTRIBUTE10 IN JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE DEFAULT NULL,
133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,

133: P_ATTRIBUTE11 IN JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE DEFAULT NULL,
134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

134: P_ATTRIBUTE12 IN JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE DEFAULT NULL,
135: P_ATTRIBUTE13 IN JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE DEFAULT NULL,
136: P_ATTRIBUTE14 IN JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE DEFAULT NULL,
137: P_ATTRIBUTE15 IN JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE DEFAULT NULL,
138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2,
142: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

Line 142: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

138: P_ATTRIBUTE_CATEGORY IN JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2,
142: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
143: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
144: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
145: );
146:

Line 143: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

139: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2,
142: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
143: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
144: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
145: );
146:
147: --Creating a Global Variable to be used for setting the flag,

Line 144: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL

140: X_MSG_COUNT OUT NOCOPY NUMBER,
141: X_MSG_DATA OUT NOCOPY VARCHAR2,
142: X_GROUP_ID OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
143: X_GROUP_NUMBER OUT NOCOPY JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
144: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT NULL
145: );
146:
147: --Creating a Global Variable to be used for setting the flag,
148: --when the create_resource_group_migrate gets called

Line 151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;

147: --Creating a Global Variable to be used for setting the flag,
148: --when the create_resource_group_migrate gets called
149:
150: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;

Line 152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;

148: --when the create_resource_group_migrate gets called
149:
150: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;

Line 153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;

149:
150: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;

Line 154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;

150: G_RS_GRP_ID_PUB_FLAG VARCHAR2(1) := 'Y';
151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;

Line 155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;

151: G_GROUP_ID JTF_RS_GROUPS_VL.GROUP_ID%TYPE := NULL;
152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;

Line 156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;

152: G_ATTRIBUTE1 JTF_RS_GROUPS_VL.ATTRIBUTE1%TYPE := NULL;
153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;

Line 157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;

153: G_ATTRIBUTE2 JTF_RS_GROUPS_VL.ATTRIBUTE2%TYPE := NULL;
154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;

Line 158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;

154: G_ATTRIBUTE3 JTF_RS_GROUPS_VL.ATTRIBUTE3%TYPE := NULL;
155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;

Line 159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;

155: G_ATTRIBUTE4 JTF_RS_GROUPS_VL.ATTRIBUTE4%TYPE := NULL;
156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;

Line 160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;

156: G_ATTRIBUTE5 JTF_RS_GROUPS_VL.ATTRIBUTE5%TYPE := NULL;
157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;

Line 161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;

157: G_ATTRIBUTE6 JTF_RS_GROUPS_VL.ATTRIBUTE6%TYPE := NULL;
158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;

Line 162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;

158: G_ATTRIBUTE7 JTF_RS_GROUPS_VL.ATTRIBUTE7%TYPE := NULL;
159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;

Line 163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;

159: G_ATTRIBUTE8 JTF_RS_GROUPS_VL.ATTRIBUTE8%TYPE := NULL;
160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;

Line 164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;

160: G_ATTRIBUTE9 JTF_RS_GROUPS_VL.ATTRIBUTE9%TYPE := NULL;
161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
168:

Line 165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;

161: G_ATTRIBUTE10 JTF_RS_GROUPS_VL.ATTRIBUTE10%TYPE := NULL;
162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
168:
169: /* Procedure to update the resource group based on input values

Line 166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;

162: G_ATTRIBUTE11 JTF_RS_GROUPS_VL.ATTRIBUTE11%TYPE := NULL;
163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
168:
169: /* Procedure to update the resource group based on input values
170: passed by calling routines. */

Line 167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;

163: G_ATTRIBUTE12 JTF_RS_GROUPS_VL.ATTRIBUTE12%TYPE := NULL;
164: G_ATTRIBUTE13 JTF_RS_GROUPS_VL.ATTRIBUTE13%TYPE := NULL;
165: G_ATTRIBUTE14 JTF_RS_GROUPS_VL.ATTRIBUTE14%TYPE := NULL;
166: G_ATTRIBUTE15 JTF_RS_GROUPS_VL.ATTRIBUTE15%TYPE := NULL;
167: G_ATTRIBUTE_CATEGORY JTF_RS_GROUPS_VL.ATTRIBUTE_CATEGORY%TYPE := NULL;
168:
169: /* Procedure to update the resource group based on input values
170: passed by calling routines. */
171: /*#

Line 199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,

195: PROCEDURE update_resource_group
196: (P_API_VERSION IN NUMBER,
197: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,

196: (P_API_VERSION IN NUMBER,
197: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

197: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,

198: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

Line 203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,

199: P_GROUP_ID IN JTF_RS_GROUPS_VL.GROUP_ID%TYPE,
200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,

200: P_GROUP_NUMBER IN JTF_RS_GROUPS_VL.GROUP_NUMBER%TYPE,
201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,

Line 205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

201: P_GROUP_NAME IN JTF_RS_GROUPS_VL.GROUP_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,

202: P_GROUP_DESC IN JTF_RS_GROUPS_VL.GROUP_DESC%TYPE DEFAULT FND_API.G_MISS_CHAR,
203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

203: P_EXCLUSIVE_FLAG IN JTF_RS_GROUPS_VL.EXCLUSIVE_FLAG%TYPE DEFAULT FND_API.G_MISS_CHAR,
204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210: X_MSG_COUNT OUT NOCOPY NUMBER,
211: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,

204: P_EMAIL_ADDRESS IN JTF_RS_GROUPS_VL.EMAIL_ADDRESS%TYPE DEFAULT FND_API.G_MISS_CHAR,
205: P_START_DATE_ACTIVE IN JTF_RS_GROUPS_VL.START_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
206: P_END_DATE_ACTIVE IN JTF_RS_GROUPS_VL.END_DATE_ACTIVE%TYPE DEFAULT FND_API.G_MISS_DATE,
207: P_ACCOUNTING_CODE IN JTF_RS_GROUPS_VL.ACCOUNTING_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210: X_MSG_COUNT OUT NOCOPY NUMBER,
211: X_MSG_DATA OUT NOCOPY VARCHAR2,
212: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM

Line 212: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM

208: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_GROUPS_VL.OBJECT_VERSION_NUMBER%TYPE,
209: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
210: X_MSG_COUNT OUT NOCOPY NUMBER,
211: X_MSG_DATA OUT NOCOPY VARCHAR2,
212: P_TIME_ZONE IN JTF_RS_GROUPS_VL.TIME_ZONE%TYPE DEFAULT FND_API.G_MISS_NUM
213: );
214:
215:
216: END jtf_rs_groups_pub;