16: -- * ------------------------------------------------------------------+
17:
18: TYPE QUOTA_CATEGORIES_REC_TYPE IS RECORD
19: (
20: QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
17:
18: TYPE QUOTA_CATEGORIES_REC_TYPE IS RECORD
19: (
20: QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
18: TYPE QUOTA_CATEGORIES_REC_TYPE IS RECORD
19: (
20: QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
19: (
20: QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20: QUOTA_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21: NAME VARCHAR2(80) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22: DESCRIPTION VARCHAR2(80) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23: TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24: COMPUTE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25: INTERVAL_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26: QUOTA_UNIT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
36: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
37: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
38: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
39: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
40: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
41: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
49: );
42: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
49: );
50:
43: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: G_MISS_QUOTA_CATEGORIES_REC QUOTA_CATEGORIES_REC_TYPE;
44: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
45: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
46: CREATION_DATE DATE := FND_API.G_MISS_DATE,
47: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
48: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
49: );
50:
51: G_MISS_QUOTA_CATEGORIES_REC QUOTA_CATEGORIES_REC_TYPE;
52: