3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bcl_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE bcl_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
5: ---------------------------------------------------------------------------
6: TYPE bcl_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
6: TYPE bcl_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
8: ,cle_id NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
9: ,btn_id NUMBER := OKC_API.G_MISS_NUM
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
10: ,date_billed_from OKS_BCL_PR.DATE_BILLED_FROM%TYPE := OKC_API.G_MISS_DATE
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
11: ,date_billed_to OKS_BCL_PR.DATE_BILLED_TO%TYPE := OKC_API.G_MISS_DATE
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
12: ,sent_yn OKS_BCL_PR.SENT_YN%TYPE := OKC_API.G_MISS_CHAR
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
13: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,created_by NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
15: ,creation_date OKS_BCL_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
16: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
17: ,last_update_date OKS_BCL_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
18: ,amount NUMBER := OKC_API.G_MISS_NUM
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
19: ,bill_action OKS_BCL_PR.BILL_ACTION%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
20: ,date_next_invoice OKS_BCL_PR.DATE_NEXT_INVOICE%TYPE := OKC_API.G_MISS_DATE
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
21: ,currency_code OKS_BCL_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
22: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
23: ,attribute_category OKS_BCL_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
24: ,attribute1 OKS_BCL_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
25: ,attribute2 OKS_BCL_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
26: ,attribute3 OKS_BCL_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute4 OKS_BCL_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute5 OKS_BCL_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute6 OKS_BCL_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute7 OKS_BCL_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute8 OKS_BCL_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
32: ,attribute9 OKS_BCL_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_bcl_pr_rec bcl_pr_rec_type;
33: ,attribute10 OKS_BCL_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_bcl_pr_rec bcl_pr_rec_type;
41: TYPE bcl_pr_tbl_type IS TABLE OF bcl_pr_rec_type
34: ,attribute11 OKS_BCL_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_bcl_pr_rec bcl_pr_rec_type;
41: TYPE bcl_pr_tbl_type IS TABLE OF bcl_pr_rec_type
42: INDEX BY BINARY_INTEGER;
35: ,attribute12 OKS_BCL_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute13 OKS_BCL_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute14 OKS_BCL_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute15 OKS_BCL_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
39: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
40: G_MISS_bcl_pr_rec bcl_pr_rec_type;
41: TYPE bcl_pr_tbl_type IS TABLE OF bcl_pr_rec_type
42: INDEX BY BINARY_INTEGER;
43:
55:
56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
56: ---------------------------------------------------------------------------
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
57: -- GLOBAL MESSAGE CONSTANTS
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
58: ---------------------------------------------------------------------------
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
59: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
60: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
61: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
62: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
63: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
64: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
65: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
66: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
67: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
68: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
72:
78: ---------------------------------------------------------------------------
79: -- GLOBAL VARIABLES
80: ---------------------------------------------------------------------------
81: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BCL_PRINT_PREVIEW_PVT';
82: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
83: ---------------------------------------------------------------------------
84: -- Procedures and Functions
85: ---------------------------------------------------------------------------
86:
88: PROCEDURE change_version;
89: PROCEDURE api_copy;
90: PROCEDURE insert_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_bcl_pr_rec IN bcl_pr_rec_type,
96: p_bcl_pr_rec IN bcl_pr_rec_type,
97: x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
98: /* PROCEDURE insert_row(
99: p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_bcl_pr_tbl IN bcl_pr_tbl_type,
105: x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type,
106: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
107: PROCEDURE insert_row(
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_bcl_pr_tbl IN bcl_pr_tbl_type,
114: x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
115: */
116: PROCEDURE lock_row(
117: p_api_version IN NUMBER,
118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_bcl_pr_rec IN bcl_pr_rec_type);
121: x_msg_data OUT NOCOPY VARCHAR2,
122: p_bcl_pr_rec IN bcl_pr_rec_type);
123: PROCEDURE lock_row(
124: p_api_version IN NUMBER,
125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2,
129: p_bcl_pr_tbl IN bcl_pr_tbl_type,
129: p_bcl_pr_tbl IN bcl_pr_tbl_type,
130: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_bcl_pr_tbl IN bcl_pr_tbl_type);
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_bcl_pr_tbl IN bcl_pr_tbl_type);
138: PROCEDURE update_row(
139: p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_bcl_pr_rec IN bcl_pr_rec_type,
144: p_bcl_pr_rec IN bcl_pr_rec_type,
145: x_bcl_pr_rec OUT NOCOPY bcl_pr_rec_type);
146: PROCEDURE update_row(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_bcl_pr_tbl IN bcl_pr_tbl_type,
153: x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type,
154: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
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_bcl_pr_tbl IN bcl_pr_tbl_type,
161: p_bcl_pr_tbl IN bcl_pr_tbl_type,
162: x_bcl_pr_tbl OUT NOCOPY bcl_pr_tbl_type);
163: PROCEDURE delete_row(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_bcl_pr_rec IN bcl_pr_rec_type);
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_bcl_pr_rec IN bcl_pr_rec_type);
170: PROCEDURE delete_row(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_bcl_pr_tbl IN bcl_pr_tbl_type,
176: p_bcl_pr_tbl IN bcl_pr_tbl_type,
177: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
178: PROCEDURE delete_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_bcl_pr_tbl IN bcl_pr_tbl_type);
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_bcl_pr_tbl IN bcl_pr_tbl_type);
185: PROCEDURE validate_row(
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_bcl_pr_rec IN bcl_pr_rec_type);
190: x_msg_data OUT NOCOPY VARCHAR2,
191: p_bcl_pr_rec IN bcl_pr_rec_type);
192: PROCEDURE validate_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_bcl_pr_tbl IN bcl_pr_tbl_type,
198: p_bcl_pr_tbl IN bcl_pr_tbl_type,
199: px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
200: PROCEDURE validate_row(
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_bcl_pr_tbl IN bcl_pr_tbl_type);