1: Package OKS_BSD_PRINT_PREVIEW_PVT AS
2: /* $Header: OKSBSDPS.pls 120.1 2006/09/19 18:57:57 hvaladip noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
8: ,bsl_id NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
9: ,bsl_id_averaged NUMBER := OKC_API.G_MISS_NUM
10: ,bsd_id NUMBER := OKC_API.G_MISS_NUM
11: ,bsd_id_applied NUMBER := OKC_API.G_MISS_NUM
12: ,unit_of_measure OKS_BSD_PR.UNIT_OF_MEASURE%TYPE := OKC_API.G_MISS_CHAR
13: ,amcv_yn OKS_BSD_PR.AMCV_YN%TYPE := OKC_API.G_MISS_CHAR
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
14: ,result NUMBER := OKC_API.G_MISS_NUM
15: ,amount NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
16: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
17: ,created_by NUMBER := OKC_API.G_MISS_NUM
18: ,creation_date OKS_BSD_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
19: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
20: ,last_update_date OKS_BSD_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
21: ,fixed NUMBER := OKC_API.G_MISS_NUM
22: ,actual NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
23: ,default_default NUMBER := OKC_API.G_MISS_NUM
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
24: ,adjustment_level NUMBER := OKC_API.G_MISS_NUM
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
25: ,adjustment_minimum NUMBER := OKC_API.G_MISS_NUM
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
26: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
27: ,attribute_category OKS_BSD_PR.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
28: ,attribute1 OKS_BSD_PR.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
29: ,attribute2 OKS_BSD_PR.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
30: ,attribute3 OKS_BSD_PR.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
31: ,attribute4 OKS_BSD_PR.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
32: ,attribute5 OKS_BSD_PR.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
33: ,attribute6 OKS_BSD_PR.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
34: ,attribute7 OKS_BSD_PR.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
35: ,attribute8 OKS_BSD_PR.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
36: ,attribute9 OKS_BSD_PR.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
37: ,attribute10 OKS_BSD_PR.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
38: ,attribute11 OKS_BSD_PR.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR
39: ,attribute12 OKS_BSD_PR.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR
40: ,attribute13 OKS_BSD_PR.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR
41: ,attribute14 OKS_BSD_PR.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR
42: ,attribute15 OKS_BSD_PR.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR
43: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
44: ,start_reading NUMBER := OKC_API.G_MISS_NUM
45: ,end_reading NUMBER := OKC_API.G_MISS_NUM
46: ,base_reading NUMBER := OKC_API.G_MISS_NUM
86:
87: ---------------------------------------------------------------------------
88: -- GLOBAL VARIABLES
89: ---------------------------------------------------------------------------
90: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BSD_PRINT_PREVIEW_PVT';
91: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
92: ---------------------------------------------------------------------------
93: -- Procedures and Functions
94: ---------------------------------------------------------------------------
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_bsd_pr_tbl IN bsd_pr_tbl_type);
199: END OKS_BSD_PRINT_PREVIEW_PVT;