[Home] [Help]
PACKAGE: APPS.OKL_BGH_PVT
Source
1 Package Okl_Bgh_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLSBGHS.pls 115.2 2002/03/29 17:43:55 pkm ship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE bgh_rec_type IS RECORD (
7 id NUMBER := Okc_Api.G_MISS_NUM,
8 sequence_number NUMBER := Okc_Api.G_MISS_NUM,
9 date_transmission OKL_BLLNG_CHRG_HDRS_B.DATE_TRANSMISSION%TYPE := Okc_Api.G_MISS_DATE,
10 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
11 request_id NUMBER := Okc_Api.G_MISS_NUM,
12 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
13 program_id NUMBER := Okc_Api.G_MISS_NUM,
14 program_update_date OKL_BLLNG_CHRG_HDRS_B.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
15 org_id NUMBER := Okc_Api.G_MISS_NUM,
16 trx_status_code OKL_BLLNG_CHRG_HDRS_B.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
17 attribute_category OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
18 attribute1 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
19 attribute2 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
20 attribute3 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
21 attribute4 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
22 attribute5 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
23 attribute6 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
24 attribute7 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
25 attribute8 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
26 attribute9 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
27 attribute10 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
28 attribute11 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
29 attribute12 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
30 attribute13 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
31 attribute14 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
32 attribute15 OKL_BLLNG_CHRG_HDRS_B.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
33 created_by NUMBER := Okc_Api.G_MISS_NUM,
34 creation_date OKL_BLLNG_CHRG_HDRS_B.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
35 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
36 last_update_date OKL_BLLNG_CHRG_HDRS_B.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
37 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
38 g_miss_bgh_rec bgh_rec_type;
39 TYPE bgh_tbl_type IS TABLE OF bgh_rec_type
40 INDEX BY BINARY_INTEGER;
41 TYPE OklBllngChrgHdrsTlRecType IS RECORD (
42 id NUMBER := Okc_Api.G_MISS_NUM,
43 LANGUAGE OKL_BLLNG_CHRG_HDRS_TL.LANGUAGE%TYPE := Okc_Api.G_MISS_CHAR,
44 source_lang OKL_BLLNG_CHRG_HDRS_TL.SOURCE_LANG%TYPE := Okc_Api.G_MISS_CHAR,
45 sfwt_flag OKL_BLLNG_CHRG_HDRS_TL.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
46 name OKL_BLLNG_CHRG_HDRS_TL.NAME%TYPE := Okc_Api.G_MISS_CHAR,
47 origin OKL_BLLNG_CHRG_HDRS_TL.ORIGIN%TYPE := Okc_Api.G_MISS_CHAR,
48 destination OKL_BLLNG_CHRG_HDRS_TL.DESTINATION%TYPE := Okc_Api.G_MISS_CHAR,
49 created_by NUMBER := Okc_Api.G_MISS_NUM,
50 creation_date OKL_BLLNG_CHRG_HDRS_TL.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
51 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
52 last_update_date OKL_BLLNG_CHRG_HDRS_TL.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
53 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
54 GMissOklBllngChrgHdrsTlRec OklBllngChrgHdrsTlRecType;
55 TYPE OklBllngChrgHdrsTlTblType IS TABLE OF OklBllngChrgHdrsTlRecType
56 INDEX BY BINARY_INTEGER;
57 TYPE bghv_rec_type IS RECORD (
58 id NUMBER := Okc_Api.G_MISS_NUM,
59 object_version_number NUMBER := Okc_Api.G_MISS_NUM,
60 sfwt_flag OKL_BLLNG_CHRG_HDRS_V.SFWT_FLAG%TYPE := Okc_Api.G_MISS_CHAR,
61 name OKL_BLLNG_CHRG_HDRS_V.NAME%TYPE := Okc_Api.G_MISS_CHAR,
62 sequence_number NUMBER := Okc_Api.G_MISS_NUM,
63 date_transmission OKL_BLLNG_CHRG_HDRS_V.DATE_TRANSMISSION%TYPE := Okc_Api.G_MISS_DATE,
64 origin OKL_BLLNG_CHRG_HDRS_V.ORIGIN%TYPE := Okc_Api.G_MISS_CHAR,
65 destination OKL_BLLNG_CHRG_HDRS_V.DESTINATION%TYPE := Okc_Api.G_MISS_CHAR,
66 trx_status_code OKL_BLLNG_CHRG_HDRS_V.TRX_STATUS_CODE%TYPE := Okc_Api.G_MISS_CHAR,
67 attribute_category OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE_CATEGORY%TYPE := Okc_Api.G_MISS_CHAR,
68 attribute1 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE1%TYPE := Okc_Api.G_MISS_CHAR,
69 attribute2 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE2%TYPE := Okc_Api.G_MISS_CHAR,
70 attribute3 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE3%TYPE := Okc_Api.G_MISS_CHAR,
71 attribute4 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE4%TYPE := Okc_Api.G_MISS_CHAR,
72 attribute5 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE5%TYPE := Okc_Api.G_MISS_CHAR,
73 attribute6 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE6%TYPE := Okc_Api.G_MISS_CHAR,
74 attribute7 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE7%TYPE := Okc_Api.G_MISS_CHAR,
75 attribute8 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE8%TYPE := Okc_Api.G_MISS_CHAR,
76 attribute9 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE9%TYPE := Okc_Api.G_MISS_CHAR,
77 attribute10 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE10%TYPE := Okc_Api.G_MISS_CHAR,
78 attribute11 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE11%TYPE := Okc_Api.G_MISS_CHAR,
79 attribute12 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE12%TYPE := Okc_Api.G_MISS_CHAR,
80 attribute13 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE13%TYPE := Okc_Api.G_MISS_CHAR,
81 attribute14 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE14%TYPE := Okc_Api.G_MISS_CHAR,
82 attribute15 OKL_BLLNG_CHRG_HDRS_V.ATTRIBUTE15%TYPE := Okc_Api.G_MISS_CHAR,
83 request_id NUMBER := Okc_Api.G_MISS_NUM,
84 program_application_id NUMBER := Okc_Api.G_MISS_NUM,
85 program_id NUMBER := Okc_Api.G_MISS_NUM,
86 program_update_date OKL_BLLNG_CHRG_HDRS_V.PROGRAM_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
87 org_id NUMBER := Okc_Api.G_MISS_NUM,
88 created_by NUMBER := Okc_Api.G_MISS_NUM,
89 creation_date OKL_BLLNG_CHRG_HDRS_V.CREATION_DATE%TYPE := Okc_Api.G_MISS_DATE,
90 last_updated_by NUMBER := Okc_Api.G_MISS_NUM,
91 last_update_date OKL_BLLNG_CHRG_HDRS_V.LAST_UPDATE_DATE%TYPE := Okc_Api.G_MISS_DATE,
92 last_update_login NUMBER := Okc_Api.G_MISS_NUM);
93 g_miss_bghv_rec bghv_rec_type;
94 TYPE bghv_tbl_type IS TABLE OF bghv_rec_type
95 INDEX BY BINARY_INTEGER;
96 ---------------------------------------------------------------------------
97 -- GLOBAL MESSAGE CONSTANTS
98 ---------------------------------------------------------------------------
99 G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
100 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_UNABLE_TO_RESERVE_REC;
101 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_DELETED;
102 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okc_Api.G_FORM_RECORD_CHANGED;
103 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okc_Api.G_RECORD_LOGICALLY_DELETED;
104 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_REQUIRED_VALUE;
105 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
106 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_COL_NAME_TOKEN;
107 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_PARENT_TABLE_TOKEN;
108 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okc_Api.G_CHILD_TABLE_TOKEN;
109 ---------------------------------------------------------------------------
110 -- GLOBAL VARIABLES
111 ---------------------------------------------------------------------------
112 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_BGH_PVT';
113 G_APP_NAME CONSTANT VARCHAR2(3) := Okc_Api.G_APP_NAME;
114 ---------------------------------------------------------------------------
115 -- Procedures and Functions
116 ---------------------------------------------------------------------------
117
118 PROCEDURE qc;
119 PROCEDURE change_version;
120 PROCEDURE api_copy;
121 PROCEDURE add_language;
122 PROCEDURE insert_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
125 x_return_status OUT NOCOPY VARCHAR2,
126 x_msg_count OUT NOCOPY NUMBER,
127 x_msg_data OUT NOCOPY VARCHAR2,
128 p_bghv_rec IN bghv_rec_type,
129 x_bghv_rec OUT NOCOPY bghv_rec_type);
130
131 PROCEDURE insert_row(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_bghv_tbl IN bghv_tbl_type,
138 x_bghv_tbl OUT NOCOPY bghv_tbl_type);
139
140 PROCEDURE lock_row(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_bghv_rec IN bghv_rec_type);
147
148 PROCEDURE lock_row(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_bghv_tbl IN bghv_tbl_type);
155
156 PROCEDURE update_row(
157 p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
159 x_return_status OUT NOCOPY VARCHAR2,
160 x_msg_count OUT NOCOPY NUMBER,
161 x_msg_data OUT NOCOPY VARCHAR2,
162 p_bghv_rec IN bghv_rec_type,
163 x_bghv_rec OUT NOCOPY bghv_rec_type);
164
165 PROCEDURE update_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_bghv_tbl IN bghv_tbl_type,
172 x_bghv_tbl OUT NOCOPY bghv_tbl_type);
173
174 PROCEDURE delete_row(
175 p_api_version IN NUMBER,
176 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_msg_count OUT NOCOPY NUMBER,
179 x_msg_data OUT NOCOPY VARCHAR2,
180 p_bghv_rec IN bghv_rec_type);
181
182 PROCEDURE delete_row(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_bghv_tbl IN bghv_tbl_type);
189
190 PROCEDURE validate_row(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_bghv_rec IN bghv_rec_type);
197
198 PROCEDURE validate_row(
199 p_api_version IN NUMBER,
200 p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_msg_count OUT NOCOPY NUMBER,
203 x_msg_data OUT NOCOPY VARCHAR2,
204 p_bghv_tbl IN bghv_tbl_type);
205
206 END Okl_Bgh_Pvt;