5: -- NAME
6: -- ASF_USER_PREFERENCE_PUB
7: --
8: TYPE user_preference_rec_type IS RECORD
9: (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
6: -- ASF_USER_PREFERENCE_PUB
7: --
8: TYPE user_preference_rec_type IS RECORD
9: (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
7: --
8: TYPE user_preference_rec_type IS RECORD
9: (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
8: TYPE user_preference_rec_type IS RECORD
9: (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
9: (PREFERENCE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
10: ,USER_ID NUMBER := FND_API.G_MISS_NUM
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
11: ,CREATED_BY NUMBER := FND_API.G_MISS_NUM
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
12: ,CREATION_DATE DATE := FND_API.G_MISS_DATE
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
13: ,LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
14: ,LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: ,LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: ,OWNER_TABLE_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: ,OWNER_TABLE_ID NUMBER := FND_API.G_MISS_NUM
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: ,CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: ,PREFERENCE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: ,PREFERENCE_VALUE VARCHAR2(80) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: ,ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: ,ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: ,ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: ,ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: ,ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: ,ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: ,ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: ,ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: ,ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: );
30: ,ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: );
38:
31: ,ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: );
38:
39: G_MISS_USER_PREFERENCE_REC user_preference_rec_type;
32: ,ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: ,ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: ,ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: ,ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: ,ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: );
38:
39: G_MISS_USER_PREFERENCE_REC user_preference_rec_type;
40: