2: /* $Header: iexsreps.pls 120.1 2005/12/21 15:39:53 jypark noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- IEX_REPOS_OBJECTS_V Record Spec
7: TYPE repv_rec_type IS RECORD (
8: repos_object_id NUMBER := 9.99E125
9: ,repossession_id NUMBER := 9.99E125
10: ,asset_id NUMBER := 9.99E125
10: ,asset_id NUMBER := 9.99E125
11: ,rna_id NUMBER := 9.99E125
12: ,rna_site_id NUMBER := 9.99E125
13: ,art_id NUMBER := 9.99E125
14: ,active_yn IEX_REPOS_OBJECTS_V.ACTIVE_YN%TYPE := chr(0)
15: ,object_version_number NUMBER := 9.99E125
16: ,org_id NUMBER := 9.99E125
17: ,request_id NUMBER := 9.99E125
18: ,program_application_id NUMBER := 9.99E125
16: ,org_id NUMBER := 9.99E125
17: ,request_id NUMBER := 9.99E125
18: ,program_application_id NUMBER := 9.99E125
19: ,program_id NUMBER := 9.99E125
20: ,program_update_date IEX_REPOS_OBJECTS_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
17: ,request_id NUMBER := 9.99E125
18: ,program_application_id NUMBER := 9.99E125
19: ,program_id NUMBER := 9.99E125
20: ,program_update_date IEX_REPOS_OBJECTS_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
18: ,program_application_id NUMBER := 9.99E125
19: ,program_id NUMBER := 9.99E125
20: ,program_update_date IEX_REPOS_OBJECTS_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
19: ,program_id NUMBER := 9.99E125
20: ,program_update_date IEX_REPOS_OBJECTS_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
20: ,program_update_date IEX_REPOS_OBJECTS_V.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
21: ,attribute_category IEX_REPOS_OBJECTS_V.ATTRIBUTE_CATEGORY%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
22: ,attribute1 IEX_REPOS_OBJECTS_V.ATTRIBUTE1%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
23: ,attribute2 IEX_REPOS_OBJECTS_V.ATTRIBUTE2%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
24: ,attribute3 IEX_REPOS_OBJECTS_V.ATTRIBUTE3%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
25: ,attribute4 IEX_REPOS_OBJECTS_V.ATTRIBUTE4%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
26: ,attribute5 IEX_REPOS_OBJECTS_V.ATTRIBUTE5%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
27: ,attribute6 IEX_REPOS_OBJECTS_V.ATTRIBUTE6%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
28: ,attribute7 IEX_REPOS_OBJECTS_V.ATTRIBUTE7%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
29: ,attribute8 IEX_REPOS_OBJECTS_V.ATTRIBUTE8%TYPE := chr(0)
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
30: ,attribute9 IEX_REPOS_OBJECTS_V.ATTRIBUTE9%TYPE := chr(0)
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
38: ,creation_date IEX_REPOS_OBJECTS_V.CREATION_DATE%TYPE := TO_DATE('1','j')
31: ,attribute10 IEX_REPOS_OBJECTS_V.ATTRIBUTE10%TYPE := chr(0)
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
38: ,creation_date IEX_REPOS_OBJECTS_V.CREATION_DATE%TYPE := TO_DATE('1','j')
39: ,last_updated_by NUMBER := 9.99E125
32: ,attribute11 IEX_REPOS_OBJECTS_V.ATTRIBUTE11%TYPE := chr(0)
33: ,attribute12 IEX_REPOS_OBJECTS_V.ATTRIBUTE12%TYPE := chr(0)
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
38: ,creation_date IEX_REPOS_OBJECTS_V.CREATION_DATE%TYPE := TO_DATE('1','j')
39: ,last_updated_by NUMBER := 9.99E125
40: ,last_update_date IEX_REPOS_OBJECTS_V.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
34: ,attribute13 IEX_REPOS_OBJECTS_V.ATTRIBUTE13%TYPE := chr(0)
35: ,attribute14 IEX_REPOS_OBJECTS_V.ATTRIBUTE14%TYPE := chr(0)
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
38: ,creation_date IEX_REPOS_OBJECTS_V.CREATION_DATE%TYPE := TO_DATE('1','j')
39: ,last_updated_by NUMBER := 9.99E125
40: ,last_update_date IEX_REPOS_OBJECTS_V.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
41: ,last_update_login NUMBER := 9.99E125
42: ,security_group_id NUMBER := 9.99E125);
36: ,attribute15 IEX_REPOS_OBJECTS_V.ATTRIBUTE15%TYPE := chr(0)
37: ,created_by NUMBER := 9.99E125
38: ,creation_date IEX_REPOS_OBJECTS_V.CREATION_DATE%TYPE := TO_DATE('1','j')
39: ,last_updated_by NUMBER := 9.99E125
40: ,last_update_date IEX_REPOS_OBJECTS_V.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
41: ,last_update_login NUMBER := 9.99E125
42: ,security_group_id NUMBER := 9.99E125);
43: G_MISS_repv_rec repv_rec_type;
44: TYPE repv_tbl_type IS TABLE OF repv_rec_type
42: ,security_group_id NUMBER := 9.99E125);
43: G_MISS_repv_rec repv_rec_type;
44: TYPE repv_tbl_type IS TABLE OF repv_rec_type
45: INDEX BY BINARY_INTEGER;
46: -- IEX_REPOS_OBJECTS Record Spec
47: TYPE rep_rec_type IS RECORD (
48: repos_object_id NUMBER := 9.99E125
49: ,repossession_id NUMBER := 9.99E125
50: ,asset_id NUMBER := 9.99E125
50: ,asset_id NUMBER := 9.99E125
51: ,rna_id NUMBER := 9.99E125
52: ,rna_site_id NUMBER := 9.99E125
53: ,art_id NUMBER := 9.99E125
54: ,active_yn IEX_REPOS_OBJECTS.ACTIVE_YN%TYPE := chr(0)
55: ,object_version_number NUMBER := 9.99E125
56: ,org_id NUMBER := 9.99E125
57: ,request_id NUMBER := 9.99E125
58: ,program_application_id NUMBER := 9.99E125
56: ,org_id NUMBER := 9.99E125
57: ,request_id NUMBER := 9.99E125
58: ,program_application_id NUMBER := 9.99E125
59: ,program_id NUMBER := 9.99E125
60: ,program_update_date IEX_REPOS_OBJECTS.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
57: ,request_id NUMBER := 9.99E125
58: ,program_application_id NUMBER := 9.99E125
59: ,program_id NUMBER := 9.99E125
60: ,program_update_date IEX_REPOS_OBJECTS.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
58: ,program_application_id NUMBER := 9.99E125
59: ,program_id NUMBER := 9.99E125
60: ,program_update_date IEX_REPOS_OBJECTS.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
59: ,program_id NUMBER := 9.99E125
60: ,program_update_date IEX_REPOS_OBJECTS.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
60: ,program_update_date IEX_REPOS_OBJECTS.PROGRAM_UPDATE_DATE%TYPE := TO_DATE('1','j')
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
61: ,attribute_category IEX_REPOS_OBJECTS.ATTRIBUTE_CATEGORY%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
62: ,attribute1 IEX_REPOS_OBJECTS.ATTRIBUTE1%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
63: ,attribute2 IEX_REPOS_OBJECTS.ATTRIBUTE2%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
64: ,attribute3 IEX_REPOS_OBJECTS.ATTRIBUTE3%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
65: ,attribute4 IEX_REPOS_OBJECTS.ATTRIBUTE4%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
66: ,attribute5 IEX_REPOS_OBJECTS.ATTRIBUTE5%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
67: ,attribute6 IEX_REPOS_OBJECTS.ATTRIBUTE6%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
68: ,attribute7 IEX_REPOS_OBJECTS.ATTRIBUTE7%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
69: ,attribute8 IEX_REPOS_OBJECTS.ATTRIBUTE8%TYPE := chr(0)
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
70: ,attribute9 IEX_REPOS_OBJECTS.ATTRIBUTE9%TYPE := chr(0)
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
78: ,creation_date IEX_REPOS_OBJECTS.CREATION_DATE%TYPE := TO_DATE('1','j')
71: ,attribute10 IEX_REPOS_OBJECTS.ATTRIBUTE10%TYPE := chr(0)
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
78: ,creation_date IEX_REPOS_OBJECTS.CREATION_DATE%TYPE := TO_DATE('1','j')
79: ,last_updated_by NUMBER := 9.99E125
72: ,attribute11 IEX_REPOS_OBJECTS.ATTRIBUTE11%TYPE := chr(0)
73: ,attribute12 IEX_REPOS_OBJECTS.ATTRIBUTE12%TYPE := chr(0)
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
78: ,creation_date IEX_REPOS_OBJECTS.CREATION_DATE%TYPE := TO_DATE('1','j')
79: ,last_updated_by NUMBER := 9.99E125
80: ,last_update_date IEX_REPOS_OBJECTS.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
74: ,attribute13 IEX_REPOS_OBJECTS.ATTRIBUTE13%TYPE := chr(0)
75: ,attribute14 IEX_REPOS_OBJECTS.ATTRIBUTE14%TYPE := chr(0)
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
78: ,creation_date IEX_REPOS_OBJECTS.CREATION_DATE%TYPE := TO_DATE('1','j')
79: ,last_updated_by NUMBER := 9.99E125
80: ,last_update_date IEX_REPOS_OBJECTS.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
81: ,last_update_login NUMBER := 9.99E125);
82: G_MISS_rep_rec rep_rec_type;
76: ,attribute15 IEX_REPOS_OBJECTS.ATTRIBUTE15%TYPE := chr(0)
77: ,created_by NUMBER := 9.99E125
78: ,creation_date IEX_REPOS_OBJECTS.CREATION_DATE%TYPE := TO_DATE('1','j')
79: ,last_updated_by NUMBER := 9.99E125
80: ,last_update_date IEX_REPOS_OBJECTS.LAST_UPDATE_DATE%TYPE := TO_DATE('1','j')
81: ,last_update_login NUMBER := 9.99E125);
82: G_MISS_rep_rec rep_rec_type;
83: TYPE rep_tbl_type IS TABLE OF rep_rec_type
84: INDEX BY BINARY_INTEGER;