[Home] [Help]
PACKAGE: APPS.OKS_BTN_PRINT_PREVIEW_PVT
Source
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 ---------------------------------------------------------------------------
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
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
22 INDEX BY BINARY_INTEGER;
23
24 TYPE ERROR_REC_TYPE IS RECORD (
25 msg_data VARCHAR2(2000),
26 msg_count NUMBER,
27 error_type VARCHAR2(1),
28 api_name VARCHAR2(200),
29 api_package VARCHAR2(60),
30 idx NUMBER,
31 sqlcode NUMBER
32 );
33 TYPE ERROR_TBL_TYPE IS TABLE OF ERROR_REC_TYPE
34 INDEX BY BINARY_INTEGER;
35 ---------------------------------------------------------------------------
36 -- GLOBAL MESSAGE CONSTANTS
37 ---------------------------------------------------------------------------
38 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
39 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
40 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
41 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
42 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
43 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
44 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
45 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
46 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
47 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
48 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_CONTRACTS_UNEXPECTED_ERROR';
49 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
50 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
51
52 ---------------------------------------------------------------------------
53 -- GLOBAL EXCEPTIONS
54 ---------------------------------------------------------------------------
55 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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 ---------------------------------------------------------------------------
65
66 PROCEDURE qc;
67 PROCEDURE change_version;
68 PROCEDURE api_copy;
69 PROCEDURE insert_row(
70 p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
72 x_return_status OUT NOCOPY VARCHAR2,
73 x_msg_count OUT NOCOPY NUMBER,
74 x_msg_data OUT NOCOPY VARCHAR2,
75 p_btn_pr_rec IN btn_pr_rec_type,
76 x_btn_pr_rec OUT NOCOPY btn_pr_rec_type);
77
78 PROCEDURE lock_row(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_btn_pr_rec IN btn_pr_rec_type);
85
86 PROCEDURE lock_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_btn_pr_tbl IN btn_pr_tbl_type,
93 px_error_tbl IN OUT NOCOPY ERROR_TBL_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_btn_pr_tbl IN btn_pr_tbl_type);
102
103 PROCEDURE update_row(
104 p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 x_return_status OUT NOCOPY VARCHAR2,
107 x_msg_count OUT NOCOPY NUMBER,
108 x_msg_data OUT NOCOPY VARCHAR2,
109 p_btn_pr_rec IN btn_pr_rec_type,
110 x_btn_pr_rec OUT NOCOPY btn_pr_rec_type);
111 PROCEDURE update_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_btn_pr_tbl IN btn_pr_tbl_type,
118 x_btn_pr_tbl OUT NOCOPY btn_pr_tbl_type,
119 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
120 PROCEDURE update_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_btn_pr_tbl IN btn_pr_tbl_type,
127 x_btn_pr_tbl OUT NOCOPY btn_pr_tbl_type);
128 PROCEDURE delete_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_btn_pr_rec IN btn_pr_rec_type);
135 PROCEDURE delete_row(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_btn_pr_tbl IN btn_pr_tbl_type,
142 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
143 PROCEDURE delete_row(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_btn_pr_tbl IN btn_pr_tbl_type);
150 PROCEDURE validate_row(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_btn_pr_rec IN btn_pr_rec_type);
157 PROCEDURE validate_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_btn_pr_tbl IN btn_pr_tbl_type,
164 px_error_tbl IN OUT NOCOPY ERROR_TBL_TYPE);
165 PROCEDURE validate_row(
166 p_api_version IN NUMBER,
167 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
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;