3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bsd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE bsd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
6: TYPE bsd_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
8: bsl_id NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
9: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
10: bsd_id NUMBER := OKC_API.G_MISS_NUM,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
11: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
12: ccr_id NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
13: cgr_id NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
14: start_reading NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: end_reading NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
16: base_reading NUMBER := OKC_API.G_MISS_NUM,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: unit_of_measure OKS_BILL_SUB_LINE_DTLS.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: amcv_yn OKS_BILL_SUB_LINE_DTLS.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
20: result NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
21: amount NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
22: object_version_number NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
23: created_by NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
24: creation_date OKS_BILL_SUB_LINE_DTLS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
25: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
26: last_update_date OKS_BILL_SUB_LINE_DTLS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
27: fixed NUMBER := OKC_API.G_MISS_NUM,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
28: actual NUMBER := OKC_API.G_MISS_NUM,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
29: default_default NUMBER := OKC_API.G_MISS_NUM,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
30: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
31: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
32: last_update_login NUMBER := OKC_API.G_MISS_NUM,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
33: attribute_category OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
34: attribute1 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
35: attribute2 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
36: attribute3 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
37: attribute4 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
38: attribute5 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
39: attribute6 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
40: attribute7 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
41: attribute8 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_bsd_rec bsd_rec_type;
42: attribute9 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_bsd_rec bsd_rec_type;
50: TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
43: attribute10 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_bsd_rec bsd_rec_type;
50: TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
51: INDEX BY BINARY_INTEGER;
44: attribute11 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
45: attribute12 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
46: attribute13 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
47: attribute14 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
48: attribute15 OKS_BILL_SUB_LINE_DTLS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR);
49: g_miss_bsd_rec bsd_rec_type;
50: TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE bsdv_rec_type IS RECORD (
49: g_miss_bsd_rec bsd_rec_type;
50: TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE bsdv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
50: TYPE bsd_tbl_type IS TABLE OF bsd_rec_type
51: INDEX BY BINARY_INTEGER;
52: TYPE bsdv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
51: INDEX BY BINARY_INTEGER;
52: TYPE bsdv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
52: TYPE bsdv_rec_type IS RECORD (
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
53: id NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
54: object_version_number NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
55: bsl_id NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
56: bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
57: bsd_id NUMBER := OKC_API.G_MISS_NUM,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
58: bsd_id_applied NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
59: ccr_id NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
60: cgr_id NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
61: start_reading NUMBER := OKC_API.G_MISS_NUM,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
62: end_reading NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
63: base_reading NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
64: estimated_quantity NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
65: unit_of_measure OKS_BILL_SUBLINE_DTLS_V.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
66: fixed NUMBER := OKC_API.G_MISS_NUM,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: actual NUMBER := OKC_API.G_MISS_NUM,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: default_default NUMBER := OKC_API.G_MISS_NUM,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: amcv_yn OKS_BILL_SUBLINE_DTLS_V.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: adjustment_level NUMBER := OKC_API.G_MISS_NUM,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: adjustment_minimum NUMBER := OKC_API.G_MISS_NUM,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: result NUMBER := OKC_API.G_MISS_NUM,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: amount NUMBER := OKC_API.G_MISS_NUM,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
83: attribute9 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
84: attribute10 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
85: attribute11 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
86: attribute12 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_update_login NUMBER := OKC_API.G_MISS_NUM);
87: attribute13 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_update_login NUMBER := OKC_API.G_MISS_NUM);
95: g_miss_bsdv_rec bsdv_rec_type;
88: attribute14 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_update_login NUMBER := OKC_API.G_MISS_NUM);
95: g_miss_bsdv_rec bsdv_rec_type;
96: TYPE bsdv_tbl_type IS TABLE OF bsdv_rec_type
89: attribute15 OKS_BILL_SUBLINE_DTLS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_update_login NUMBER := OKC_API.G_MISS_NUM);
95: g_miss_bsdv_rec bsdv_rec_type;
96: TYPE bsdv_tbl_type IS TABLE OF bsdv_rec_type
97: INDEX BY BINARY_INTEGER;
90: created_by NUMBER := OKC_API.G_MISS_NUM,
91: creation_date OKS_BILL_SUBLINE_DTLS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
92: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
93: last_update_date OKS_BILL_SUBLINE_DTLS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: last_update_login NUMBER := OKC_API.G_MISS_NUM);
95: g_miss_bsdv_rec bsdv_rec_type;
96: TYPE bsdv_tbl_type IS TABLE OF bsdv_rec_type
97: INDEX BY BINARY_INTEGER;
98: ---------------------------------------------------------------------------
97: INDEX BY BINARY_INTEGER;
98: ---------------------------------------------------------------------------
99: -- GLOBAL MESSAGE CONSTANTS
100: ---------------------------------------------------------------------------
101: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
98: ---------------------------------------------------------------------------
99: -- GLOBAL MESSAGE CONSTANTS
100: ---------------------------------------------------------------------------
101: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
99: -- GLOBAL MESSAGE CONSTANTS
100: ---------------------------------------------------------------------------
101: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
100: ---------------------------------------------------------------------------
101: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
101: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
102: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
103: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
104: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
112: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
105: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
112: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
113: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
106: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
107: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
108: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
109: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
110: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
111: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
112: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
113: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
114:
121: ---------------------------------------------------------------------------
122: -- GLOBAL VARIABLES
123: ---------------------------------------------------------------------------
124: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSD_PVT';
125: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
126: ---------------------------------------------------------------------------
127: -- Procedures and Functions
128: ---------------------------------------------------------------------------
129:
131: PROCEDURE change_version;
132: PROCEDURE api_copy;
133: PROCEDURE insert_row(
134: p_api_version IN NUMBER,
135: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136: x_return_status OUT NOCOPY VARCHAR2,
137: x_msg_count OUT NOCOPY NUMBER,
138: x_msg_data OUT NOCOPY VARCHAR2,
139: p_bsdv_rec IN bsdv_rec_type,
140: x_bsdv_rec OUT NOCOPY bsdv_rec_type);
141:
142: PROCEDURE insert_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_bsdv_tbl IN bsdv_tbl_type,
149: x_bsdv_tbl OUT NOCOPY bsdv_tbl_type);
150:
151: PROCEDURE lock_row(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_bsdv_rec IN bsdv_rec_type);
157: p_bsdv_rec IN bsdv_rec_type);
158:
159: PROCEDURE lock_row(
160: p_api_version IN NUMBER,
161: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_bsdv_tbl IN bsdv_tbl_type);
165: p_bsdv_tbl IN bsdv_tbl_type);
166:
167: PROCEDURE update_row(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_bsdv_rec IN bsdv_rec_type,
174: x_bsdv_rec OUT NOCOPY bsdv_rec_type);
175:
176: PROCEDURE update_row(
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2,
182: p_bsdv_tbl IN bsdv_tbl_type,
183: x_bsdv_tbl OUT NOCOPY bsdv_tbl_type);
184:
185: PROCEDURE delete_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_bsdv_rec IN bsdv_rec_type);
191: p_bsdv_rec IN bsdv_rec_type);
192:
193: PROCEDURE delete_row(
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
196: x_return_status OUT NOCOPY VARCHAR2,
197: x_msg_count OUT NOCOPY NUMBER,
198: x_msg_data OUT NOCOPY VARCHAR2,
199: p_bsdv_tbl IN bsdv_tbl_type);
199: p_bsdv_tbl IN bsdv_tbl_type);
200:
201: PROCEDURE validate_row(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_bsdv_rec IN bsdv_rec_type);
207: p_bsdv_rec IN bsdv_rec_type);
208:
209: PROCEDURE validate_row(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_bsdv_tbl IN bsdv_tbl_type);