41: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
42: G_MISS_ieav_rec ieav_rec_type;
43: TYPE ieav_tbl_type IS TABLE OF ieav_rec_type
44: INDEX BY BINARY_INTEGER;
45: -- IEX_EXT_AGNCY_B Record Spec
46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
44: INDEX BY BINARY_INTEGER;
45: -- IEX_EXT_AGNCY_B Record Spec
46: TYPE iea_rec_type IS RECORD (
47: external_agency_id NUMBER := OKC_API.G_MISS_NUM
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
48: ,external_agency_name IEX_EXT_AGNCY_B.EXTERNAL_AGENCY_NAME%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
49: ,vendor_id NUMBER := OKC_API.G_MISS_NUM
50: ,vendor_site_id NUMBER := OKC_API.G_MISS_NUM
51: ,rank NUMBER := OKC_API.G_MISS_NUM
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
52: ,effective_start_date IEX_EXT_AGNCY_B.EFFECTIVE_START_DATE%TYPE := OKC_API.G_MISS_DATE
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
53: ,effective_end_date IEX_EXT_AGNCY_B.EFFECTIVE_END_DATE%TYPE := OKC_API.G_MISS_DATE
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
54: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
55: ,org_id NUMBER := OKC_API.G_MISS_NUM
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
56: ,attribute_category IEX_EXT_AGNCY_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
57: ,attribute1 IEX_EXT_AGNCY_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
58: ,attribute2 IEX_EXT_AGNCY_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
59: ,attribute3 IEX_EXT_AGNCY_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
60: ,attribute4 IEX_EXT_AGNCY_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
61: ,attribute5 IEX_EXT_AGNCY_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
62: ,attribute6 IEX_EXT_AGNCY_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
63: ,attribute7 IEX_EXT_AGNCY_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
64: ,attribute8 IEX_EXT_AGNCY_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
65: ,attribute9 IEX_EXT_AGNCY_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
66: ,attribute10 IEX_EXT_AGNCY_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
67: ,attribute11 IEX_EXT_AGNCY_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
68: ,attribute12 IEX_EXT_AGNCY_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
69: ,attribute13 IEX_EXT_AGNCY_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
70: ,attribute14 IEX_EXT_AGNCY_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;
71: ,attribute15 IEX_EXT_AGNCY_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
72: ,created_by NUMBER := OKC_API.G_MISS_NUM
73: ,creation_date IEX_EXT_AGNCY_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
74: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
75: ,last_update_date IEX_EXT_AGNCY_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_update_login NUMBER := OKC_API.G_MISS_NUM);
77: G_MISS_iea_rec iea_rec_type;
78: TYPE iea_tbl_type IS TABLE OF iea_rec_type
79: INDEX BY BINARY_INTEGER;