3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE crj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE crj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
5: ---------------------------------------------------------------------------
6: TYPE crj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE crj_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
8: cle_id NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
9: chr_id NUMBER := OKC_API.G_MISS_NUM,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
10: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
12: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
13: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
14: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
17: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
21: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
22: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
23: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
24: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
25: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
26: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
27: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
28: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
29: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_crj_rec crj_rec_type;
30: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_crj_rec crj_rec_type;
38: TYPE crj_tbl_type IS TABLE OF crj_rec_type
31: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_crj_rec crj_rec_type;
38: TYPE crj_tbl_type IS TABLE OF crj_rec_type
39: INDEX BY BINARY_INTEGER;
32: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
33: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
34: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
35: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
36: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
37: g_miss_crj_rec crj_rec_type;
38: TYPE crj_tbl_type IS TABLE OF crj_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE crjv_rec_type IS RECORD (
37: g_miss_crj_rec crj_rec_type;
38: TYPE crj_tbl_type IS TABLE OF crj_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE crjv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
38: TYPE crj_tbl_type IS TABLE OF crj_rec_type
39: INDEX BY BINARY_INTEGER;
40: TYPE crjv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
39: INDEX BY BINARY_INTEGER;
40: TYPE crjv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
40: TYPE crjv_rec_type IS RECORD (
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
41: id NUMBER := OKC_API.G_MISS_NUM,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
42: object_version_number NUMBER := OKC_API.G_MISS_NUM,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
43: cle_id NUMBER := OKC_API.G_MISS_NUM,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
44: chr_id NUMBER := OKC_API.G_MISS_NUM,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
45: rty_code OKC_K_REL_OBJS.RTY_CODE%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
46: object1_id1 OKC_K_REL_OBJS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
47: object1_id2 OKC_K_REL_OBJS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
48: jtot_object1_id NUMBER := OKC_API.G_MISS_NUM,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
49: jtot_object1_code OKC_K_REL_OBJS.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
50: attribute_category OKC_K_REL_OBJS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
51: attribute1 OKC_K_REL_OBJS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
52: attribute2 OKC_K_REL_OBJS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
53: attribute3 OKC_K_REL_OBJS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
54: attribute4 OKC_K_REL_OBJS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
55: attribute5 OKC_K_REL_OBJS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
56: attribute6 OKC_K_REL_OBJS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
57: attribute7 OKC_K_REL_OBJS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
58: attribute8 OKC_K_REL_OBJS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
59: attribute9 OKC_K_REL_OBJS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
60: attribute10 OKC_K_REL_OBJS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
61: attribute11 OKC_K_REL_OBJS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: attribute12 OKC_K_REL_OBJS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_update_login NUMBER := OKC_API.G_MISS_NUM);
63: attribute13 OKC_K_REL_OBJS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_update_login NUMBER := OKC_API.G_MISS_NUM);
71: g_miss_crjv_rec crjv_rec_type;
64: attribute14 OKC_K_REL_OBJS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_update_login NUMBER := OKC_API.G_MISS_NUM);
71: g_miss_crjv_rec crjv_rec_type;
72: TYPE crjv_tbl_type IS TABLE OF crjv_rec_type
65: attribute15 OKC_K_REL_OBJS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_update_login NUMBER := OKC_API.G_MISS_NUM);
71: g_miss_crjv_rec crjv_rec_type;
72: TYPE crjv_tbl_type IS TABLE OF crjv_rec_type
73: INDEX BY BINARY_INTEGER;
66: created_by NUMBER := OKC_API.G_MISS_NUM,
67: creation_date OKC_K_REL_OBJS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
68: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
69: last_update_date OKC_K_REL_OBJS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_update_login NUMBER := OKC_API.G_MISS_NUM);
71: g_miss_crjv_rec crjv_rec_type;
72: TYPE crjv_tbl_type IS TABLE OF crjv_rec_type
73: INDEX BY BINARY_INTEGER;
74: ---------------------------------------------------------------------------
73: INDEX BY BINARY_INTEGER;
74: ---------------------------------------------------------------------------
75: -- GLOBAL MESSAGE CONSTANTS
76: ---------------------------------------------------------------------------
77: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
74: ---------------------------------------------------------------------------
75: -- GLOBAL MESSAGE CONSTANTS
76: ---------------------------------------------------------------------------
77: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
75: -- GLOBAL MESSAGE CONSTANTS
76: ---------------------------------------------------------------------------
77: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
76: ---------------------------------------------------------------------------
77: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
77: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
78: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
79: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
87: ---------------------------------------------------------------------------
80: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
81: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
82: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
83: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
84: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
85: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
86: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
90: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CRJ_PVT';
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
90: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CRJ_PVT';
91: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92: ---------------------------------------------------------------------------
93: -- Procedures and Functions
94: ---------------------------------------------------------------------------
95:
97: PROCEDURE change_version;
98: PROCEDURE api_copy;
99: PROCEDURE insert_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_crjv_rec IN crjv_rec_type,
106: x_crjv_rec OUT NOCOPY crjv_rec_type);
107:
108: PROCEDURE insert_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_crjv_tbl IN crjv_tbl_type,
115: x_crjv_tbl OUT NOCOPY crjv_tbl_type);
116:
117: PROCEDURE lock_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_crjv_rec IN crjv_rec_type);
123: p_crjv_rec IN crjv_rec_type);
124:
125: PROCEDURE lock_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_crjv_tbl IN crjv_tbl_type);
131: p_crjv_tbl IN crjv_tbl_type);
132:
133: PROCEDURE update_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_crjv_rec IN crjv_rec_type,
140: x_crjv_rec OUT NOCOPY crjv_rec_type);
141:
142: PROCEDURE update_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_crjv_tbl IN crjv_tbl_type,
149: x_crjv_tbl OUT NOCOPY crjv_tbl_type);
150:
151: PROCEDURE delete_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_crjv_rec IN crjv_rec_type);
157: p_crjv_rec IN crjv_rec_type);
158:
159: PROCEDURE delete_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_crjv_tbl IN crjv_tbl_type);
165: p_crjv_tbl IN crjv_tbl_type);
166:
167: PROCEDURE validate_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_crjv_rec IN crjv_rec_type);
173: p_crjv_rec IN crjv_rec_type);
174:
175: PROCEDURE validate_row(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_crjv_tbl IN crjv_tbl_type);
182:
183: PROCEDURE quote_is_renewal
184: (
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
187: ,x_return_status OUT NOCOPY VARCHAR2
188: ,x_msg_count OUT NOCOPY NUMBER
189: ,x_msg_data OUT NOCOPY VARCHAR2
190: ,p_crjv_rec IN crjv_rec_type
193:
194: PROCEDURE order_is_renewal
195: (
196: p_api_version IN NUMBER
197: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
198: ,x_return_status OUT NOCOPY VARCHAR2
199: ,x_msg_count OUT NOCOPY NUMBER
200: ,x_msg_data OUT NOCOPY VARCHAR2
201: ,p_crjv_rec IN crjv_rec_type
204:
205: PROCEDURE quote_is_subject
206: (
207: p_api_version IN NUMBER
208: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
209: ,x_return_status OUT NOCOPY VARCHAR2
210: ,x_msg_count OUT NOCOPY NUMBER
211: ,x_msg_data OUT NOCOPY VARCHAR2
212: ,p_crjv_rec IN crjv_rec_type
215:
216: PROCEDURE order_is_subject
217: (
218: p_api_version IN NUMBER
219: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
220: ,x_return_status OUT NOCOPY VARCHAR2
221: ,x_msg_count OUT NOCOPY NUMBER
222: ,x_msg_data OUT NOCOPY VARCHAR2
223: ,p_crjv_rec IN crjv_rec_type
226:
227: PROCEDURE quote_contract_is_ordered
228: (
229: p_api_version IN NUMBER
230: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
231: ,x_return_status OUT NOCOPY VARCHAR2
232: ,x_msg_count OUT NOCOPY NUMBER
233: ,x_msg_data OUT NOCOPY VARCHAR2
234: ,p_crjv_rec IN crjv_rec_type