3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
5: ---------------------------------------------------------------------------
6: TYPE bsl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
6: TYPE bsl_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
8: bcl_id NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
9: cle_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
11: created_by NUMBER := OKC_API.G_MISS_NUM,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
12: creation_date OKS_BILL_SUB_LINES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
13: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
14: last_update_date OKS_BILL_SUB_LINES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
15: average NUMBER := OKC_API.G_MISS_NUM,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
16: amount NUMBER := OKC_API.G_MISS_NUM,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
17: manual_credit NUMBER := OKC_API.G_MISS_NUM,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
18: date_billed_from OKS_BILL_SUB_LINES.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
19: date_billed_to OKS_BILL_SUB_LINES.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
20: date_to_interface OKS_BILL_SUB_LINES.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
21: last_update_login NUMBER := OKC_API.G_MISS_NUM,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
22: attribute_category OKS_BILL_SUB_LINES.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
23: attribute1 OKS_BILL_SUB_LINES.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
24: attribute2 OKS_BILL_SUB_LINES.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
25: attribute3 OKS_BILL_SUB_LINES.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
26: attribute4 OKS_BILL_SUB_LINES.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
27: attribute5 OKS_BILL_SUB_LINES.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
28: attribute6 OKS_BILL_SUB_LINES.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
29: attribute7 OKS_BILL_SUB_LINES.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
30: attribute8 OKS_BILL_SUB_LINES.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_bsl_rec bsl_rec_type;
31: attribute9 OKS_BILL_SUB_LINES.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_bsl_rec bsl_rec_type;
39: TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
32: attribute10 OKS_BILL_SUB_LINES.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_bsl_rec bsl_rec_type;
39: TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
40: INDEX BY BINARY_INTEGER;
33: attribute11 OKS_BILL_SUB_LINES.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
34: attribute12 OKS_BILL_SUB_LINES.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
35: attribute13 OKS_BILL_SUB_LINES.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
36: attribute14 OKS_BILL_SUB_LINES.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
37: attribute15 OKS_BILL_SUB_LINES.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
38: g_miss_bsl_rec bsl_rec_type;
39: TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE bslv_rec_type IS RECORD (
38: g_miss_bsl_rec bsl_rec_type;
39: TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE bslv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
39: TYPE bsl_tbl_type IS TABLE OF bsl_rec_type
40: INDEX BY BINARY_INTEGER;
41: TYPE bslv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
40: INDEX BY BINARY_INTEGER;
41: TYPE bslv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
41: TYPE bslv_rec_type IS RECORD (
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
42: id NUMBER := OKC_API.G_MISS_NUM,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
43: object_version_number NUMBER := OKC_API.G_MISS_NUM,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
44: bcl_id NUMBER := OKC_API.G_MISS_NUM,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
45: cle_id NUMBER := OKC_API.G_MISS_NUM,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
46: average NUMBER := OKC_API.G_MISS_NUM,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
47: amount NUMBER := OKC_API.G_MISS_NUM,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
48: manual_credit NUMBER := OKC_API.G_MISS_NUM,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
49: date_billed_from OKS_BILL_SUB_LINES_V.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
50: date_billed_to OKS_BILL_SUB_LINES_V.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
51: date_to_interface OKS_BILL_SUB_LINES_V.DATE_TO_INTERFACE%TYPE := OKC_API.G_MISS_DATE,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
52: attribute_category OKS_BILL_SUB_LINES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
53: attribute1 OKS_BILL_SUB_LINES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
54: attribute2 OKS_BILL_SUB_LINES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
55: attribute3 OKS_BILL_SUB_LINES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
56: attribute4 OKS_BILL_SUB_LINES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
57: attribute5 OKS_BILL_SUB_LINES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
58: attribute6 OKS_BILL_SUB_LINES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
59: attribute7 OKS_BILL_SUB_LINES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
60: attribute8 OKS_BILL_SUB_LINES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
61: attribute9 OKS_BILL_SUB_LINES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
62: attribute10 OKS_BILL_SUB_LINES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
63: attribute11 OKS_BILL_SUB_LINES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
64: attribute12 OKS_BILL_SUB_LINES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
65: attribute13 OKS_BILL_SUB_LINES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_bslv_rec bslv_rec_type;
66: attribute14 OKS_BILL_SUB_LINES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_bslv_rec bslv_rec_type;
74: TYPE bslv_tbl_type IS TABLE OF bslv_rec_type
67: attribute15 OKS_BILL_SUB_LINES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_bslv_rec bslv_rec_type;
74: TYPE bslv_tbl_type IS TABLE OF bslv_rec_type
75: INDEX BY BINARY_INTEGER;
68: created_by NUMBER := OKC_API.G_MISS_NUM,
69: creation_date OKS_BILL_SUB_LINES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: last_update_date OKS_BILL_SUB_LINES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: last_update_login NUMBER := OKC_API.G_MISS_NUM);
73: g_miss_bslv_rec bslv_rec_type;
74: TYPE bslv_tbl_type IS TABLE OF bslv_rec_type
75: INDEX BY BINARY_INTEGER;
76: ---------------------------------------------------------------------------
75: INDEX BY BINARY_INTEGER;
76: ---------------------------------------------------------------------------
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
76: ---------------------------------------------------------------------------
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
77: -- GLOBAL MESSAGE CONSTANTS
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
78: ---------------------------------------------------------------------------
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
79: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
80: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
81: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
82: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
83: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
91: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
84: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
85: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
86: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
87: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
88: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
89: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
90: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
91: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
92: ---------------------------------------------------------------------------
97: ---------------------------------------------------------------------------
98: -- GLOBAL VARIABLES
99: ---------------------------------------------------------------------------
100: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSL_PVT';
101: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
102: ---------------------------------------------------------------------------
103: -- Procedures and Functions
104: ---------------------------------------------------------------------------
105:
107: PROCEDURE change_version;
108: PROCEDURE api_copy;
109: PROCEDURE insert_row(
110: p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_bslv_rec IN bslv_rec_type,
116: x_bslv_rec OUT NOCOPY bslv_rec_type);
117:
118: PROCEDURE insert_row(
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121: x_return_status OUT NOCOPY VARCHAR2,
122: x_msg_count OUT NOCOPY NUMBER,
123: x_msg_data OUT NOCOPY VARCHAR2,
124: p_bslv_tbl IN bslv_tbl_type,
125: x_bslv_tbl OUT NOCOPY bslv_tbl_type);
126:
127: PROCEDURE lock_row(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_bslv_rec IN bslv_rec_type);
133: p_bslv_rec IN bslv_rec_type);
134:
135: PROCEDURE lock_row(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_bslv_tbl IN bslv_tbl_type);
141: p_bslv_tbl IN bslv_tbl_type);
142:
143: PROCEDURE update_row(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_bslv_rec IN bslv_rec_type,
150: x_bslv_rec OUT NOCOPY bslv_rec_type);
151:
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_bslv_tbl IN bslv_tbl_type,
159: x_bslv_tbl OUT NOCOPY bslv_tbl_type);
160:
161: PROCEDURE delete_row(
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164: x_return_status OUT NOCOPY VARCHAR2,
165: x_msg_count OUT NOCOPY NUMBER,
166: x_msg_data OUT NOCOPY VARCHAR2,
167: p_bslv_rec IN bslv_rec_type);
167: p_bslv_rec IN bslv_rec_type);
168:
169: PROCEDURE delete_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_bslv_tbl IN bslv_tbl_type);
175: p_bslv_tbl IN bslv_tbl_type);
176:
177: PROCEDURE validate_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_bslv_rec IN bslv_rec_type);
183: p_bslv_rec IN bslv_rec_type);
184:
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_bslv_tbl IN bslv_tbl_type);