1: Package OKS_BTN_PRINT_PREVIEW_PVT AUTHID CURRENT_USER AS
2: /* $Header: OKSBTNPS.pls 120.1 2006/09/19 18:50:01 hvaladip noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE btn_pr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,currency_code OKS_BTN_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,creation_date OKS_BTN_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
7: id NUMBER := OKC_API.G_MISS_NUM
8: ,currency_code OKS_BTN_PR.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,creation_date OKS_BTN_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,last_update_date OKS_BTN_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,trx_date OKS_BTN_PR.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,trx_number OKS_BTN_PR.TRX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
9: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
10: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,creation_date OKS_BTN_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,last_update_date OKS_BTN_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,trx_date OKS_BTN_PR.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,trx_number OKS_BTN_PR.TRX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
17: ,trx_class OKS_BTN_PR.TRX_CLASS%TYPE := OKC_API.G_MISS_CHAR
10: ,created_by NUMBER := OKC_API.G_MISS_NUM
11: ,creation_date OKS_BTN_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,last_update_date OKS_BTN_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,trx_date OKS_BTN_PR.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,trx_number OKS_BTN_PR.TRX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
17: ,trx_class OKS_BTN_PR.TRX_CLASS%TYPE := OKC_API.G_MISS_CHAR
18: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
11: ,creation_date OKS_BTN_PR.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
13: ,last_update_date OKS_BTN_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,trx_date OKS_BTN_PR.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,trx_number OKS_BTN_PR.TRX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
17: ,trx_class OKS_BTN_PR.TRX_CLASS%TYPE := OKC_API.G_MISS_CHAR
18: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
13: ,last_update_date OKS_BTN_PR.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
14: ,trx_date OKS_BTN_PR.TRX_DATE%TYPE := OKC_API.G_MISS_DATE
15: ,trx_number OKS_BTN_PR.TRX_NUMBER%TYPE := OKC_API.G_MISS_CHAR
16: ,trx_amount NUMBER := OKC_API.G_MISS_NUM
17: ,trx_class OKS_BTN_PR.TRX_CLASS%TYPE := OKC_API.G_MISS_CHAR
18: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
19: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
20: G_MISS_btn_pr_rec btn_pr_rec_type;
21: TYPE btn_pr_tbl_type IS TABLE OF btn_pr_rec_type
56:
57: ---------------------------------------------------------------------------
58: -- GLOBAL VARIABLES
59: ---------------------------------------------------------------------------
60: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BTN_PRINT_PREVIEW_PVT';
61: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
62: ---------------------------------------------------------------------------
63: -- Procedures and Functions
64: ---------------------------------------------------------------------------
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_btn_pr_tbl IN btn_pr_tbl_type);
172: END OKS_BTN_PRINT_PREVIEW_PVT;