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