1: Package OKS_BSL_PRINT_PREVIEW_PVT AUTHID CURRENT_USER AS
2: /* $Header: OKSBSLPS.pls 120.1 2006/09/19 18:48:51 hvaladip noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
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
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
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
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
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:
74:
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: ---------------------------------------------------------------------------
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);
187: END OKS_BSL_PRINT_PREVIEW_PVT;