2: /* $Header: OKLSXMPS.pls 120.0 2007/01/04 11:21:05 udhenuko noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKL_XMLP_PARAMS Record Spec
7: TYPE xmp_rec_type IS RECORD (
8: id NUMBER
9: ,batch_id NUMBER
10: ,param_name OKL_XMLP_PARAMS.PARAM_NAME%TYPE
6: -- OKL_XMLP_PARAMS Record Spec
7: TYPE xmp_rec_type IS RECORD (
8: id NUMBER
9: ,batch_id NUMBER
10: ,param_name OKL_XMLP_PARAMS.PARAM_NAME%TYPE
11: ,object_version_number NUMBER
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
8: id NUMBER
9: ,batch_id NUMBER
10: ,param_name OKL_XMLP_PARAMS.PARAM_NAME%TYPE
11: ,object_version_number NUMBER
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
9: ,batch_id NUMBER
10: ,param_name OKL_XMLP_PARAMS.PARAM_NAME%TYPE
11: ,object_version_number NUMBER
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
10: ,param_name OKL_XMLP_PARAMS.PARAM_NAME%TYPE
11: ,object_version_number NUMBER
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
11: ,object_version_number NUMBER
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
12: ,param_type_code OKL_XMLP_PARAMS.PARAM_TYPE_CODE%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
13: ,param_value OKL_XMLP_PARAMS.PARAM_VALUE%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
14: ,attribute_category OKL_XMLP_PARAMS.ATTRIBUTE_CATEGORY%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
15: ,attribute1 OKL_XMLP_PARAMS.ATTRIBUTE1%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
16: ,attribute2 OKL_XMLP_PARAMS.ATTRIBUTE2%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
17: ,attribute3 OKL_XMLP_PARAMS.ATTRIBUTE3%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
18: ,attribute4 OKL_XMLP_PARAMS.ATTRIBUTE4%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
19: ,attribute5 OKL_XMLP_PARAMS.ATTRIBUTE5%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
20: ,attribute6 OKL_XMLP_PARAMS.ATTRIBUTE6%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
21: ,attribute7 OKL_XMLP_PARAMS.ATTRIBUTE7%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
22: ,attribute8 OKL_XMLP_PARAMS.ATTRIBUTE8%TYPE
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
23: ,attribute9 OKL_XMLP_PARAMS.ATTRIBUTE9%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
24: ,attribute10 OKL_XMLP_PARAMS.ATTRIBUTE10%TYPE
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
32: ,last_updated_by NUMBER
25: ,attribute11 OKL_XMLP_PARAMS.ATTRIBUTE11%TYPE
26: ,attribute12 OKL_XMLP_PARAMS.ATTRIBUTE12%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
32: ,last_updated_by NUMBER
33: ,last_update_date OKL_XMLP_PARAMS.LAST_UPDATE_DATE%TYPE
27: ,attribute13 OKL_XMLP_PARAMS.ATTRIBUTE13%TYPE
28: ,attribute14 OKL_XMLP_PARAMS.ATTRIBUTE14%TYPE
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
32: ,last_updated_by NUMBER
33: ,last_update_date OKL_XMLP_PARAMS.LAST_UPDATE_DATE%TYPE
34: ,last_update_login OKL_XMLP_PARAMS.LAST_UPDATE_LOGIN%TYPE);
35: G_MISS_xmp_rec xmp_rec_type;
29: ,attribute15 OKL_XMLP_PARAMS.ATTRIBUTE15%TYPE
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
32: ,last_updated_by NUMBER
33: ,last_update_date OKL_XMLP_PARAMS.LAST_UPDATE_DATE%TYPE
34: ,last_update_login OKL_XMLP_PARAMS.LAST_UPDATE_LOGIN%TYPE);
35: G_MISS_xmp_rec xmp_rec_type;
36: TYPE xmp_tbl_type IS TABLE OF xmp_rec_type
37: INDEX BY BINARY_INTEGER;
30: ,created_by NUMBER
31: ,creation_date OKL_XMLP_PARAMS.CREATION_DATE%TYPE
32: ,last_updated_by NUMBER
33: ,last_update_date OKL_XMLP_PARAMS.LAST_UPDATE_DATE%TYPE
34: ,last_update_login OKL_XMLP_PARAMS.LAST_UPDATE_LOGIN%TYPE);
35: G_MISS_xmp_rec xmp_rec_type;
36: TYPE xmp_tbl_type IS TABLE OF xmp_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------