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