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