[Home] [Help]
PACKAGE: APPS.OKL_TMG_PVT
Source
1 Package OKL_TMG_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSTMGS.pls 115.4 2003/09/26 01:29:33 rmunjulu noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE tmgv_rec_type IS RECORD (
7 id NUMBER := OKL_API.G_MISS_NUM
8 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
9 ,bch_id NUMBER := OKL_API.G_MISS_NUM
10 ,tmg_message_name OKL_TRX_MSGS_V.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
11 ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
12 ,tmg_language_code OKL_TRX_MSGS_V.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
13 ,message_text OKL_TRX_MSGS_V.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
14 ,trx_id NUMBER := OKL_API.G_MISS_NUM
15 ,trx_source_table OKL_TRX_MSGS_V.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
16 ,sequence_number NUMBER := OKL_API.G_MISS_NUM
17 ,request_id NUMBER := OKL_API.G_MISS_NUM
18 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
19 ,program_id NUMBER := OKL_API.G_MISS_NUM
20 ,program_update_date OKL_TRX_MSGS_V.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
21 ,created_by NUMBER := OKL_API.G_MISS_NUM
22 ,creation_date OKL_TRX_MSGS_V.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
23 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
24 ,last_update_date OKL_TRX_MSGS_V.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
25 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
26 -- RMUNJULU 3018641 Added column
27 ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
28 G_MISS_tmgv_rec tmgv_rec_type;
29 TYPE tmgv_tbl_type IS TABLE OF tmgv_rec_type
30 INDEX BY BINARY_INTEGER;
31 TYPE tmg_rec_type IS RECORD (
32 id NUMBER := OKL_API.G_MISS_NUM
33 ,sequence_number NUMBER := OKL_API.G_MISS_NUM
34 ,trx_id NUMBER := OKL_API.G_MISS_NUM
35 ,trx_source_table OKL_TRX_MSGS.TRX_SOURCE_TABLE%TYPE := OKL_API.G_MISS_CHAR
36 ,bch_id NUMBER := OKL_API.G_MISS_NUM
37 ,tmg_language_code OKL_TRX_MSGS.TMG_LANGUAGE_CODE%TYPE := OKL_API.G_MISS_CHAR
38 ,tmg_message_name OKL_TRX_MSGS.TMG_MESSAGE_NAME%TYPE := OKL_API.G_MISS_CHAR
39 ,tmg_application_id NUMBER := OKL_API.G_MISS_NUM
40 ,message_text OKL_TRX_MSGS.MESSAGE_TEXT%TYPE := OKL_API.G_MISS_CHAR
41 ,object_version_number NUMBER := OKL_API.G_MISS_NUM
42 ,request_id NUMBER := OKL_API.G_MISS_NUM
43 ,program_application_id NUMBER := OKL_API.G_MISS_NUM
44 ,program_id NUMBER := OKL_API.G_MISS_NUM
45 ,program_update_date OKL_TRX_MSGS.PROGRAM_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
46 ,created_by NUMBER := OKL_API.G_MISS_NUM
47 ,creation_date OKL_TRX_MSGS.CREATION_DATE%TYPE := OKL_API.G_MISS_DATE
48 ,last_updated_by NUMBER := OKL_API.G_MISS_NUM
49 ,last_update_date OKL_TRX_MSGS.LAST_UPDATE_DATE%TYPE := OKL_API.G_MISS_DATE
50 ,last_update_login NUMBER := OKL_API.G_MISS_NUM
51 -- RMUNJULU 3018641 Added column
52 ,tmg_run NUMBER := OKL_API.G_MISS_NUM);
53 G_MISS_tmg_rec tmg_rec_type;
54 TYPE tmg_tbl_type IS TABLE OF tmg_rec_type
55 INDEX BY BINARY_INTEGER;
56 ---------------------------------------------------------------------------
57 -- GLOBAL MESSAGE CONSTANTS
58 ---------------------------------------------------------------------------
59 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
60 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
61 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
62 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
63 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
64 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
65 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
66 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
67 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
68 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
69 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
70 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
71 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
72
73 ---------------------------------------------------------------------------
74 -- GLOBAL EXCEPTIONS
75 ---------------------------------------------------------------------------
76 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
77
78 ---------------------------------------------------------------------------
79 -- GLOBAL VARIABLES
80 ---------------------------------------------------------------------------
81 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TMG_PVT';
82 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
83 ---------------------------------------------------------------------------
84 -- Procedures and Functions
85 ---------------------------------------------------------------------------
86
87 PROCEDURE qc;
88 PROCEDURE change_version;
89 PROCEDURE api_copy;
90 PROCEDURE insert_row(
91 p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2,
96 p_tmgv_rec IN tmgv_rec_type,
97 x_tmgv_rec OUT NOCOPY tmgv_rec_type);
98 PROCEDURE insert_row(
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2,
104 p_tmgv_tbl IN tmgv_tbl_type,
105 x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
106 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
107 PROCEDURE insert_row(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_tmgv_tbl IN tmgv_tbl_type,
114 x_tmgv_tbl OUT NOCOPY tmgv_tbl_type);
115 PROCEDURE lock_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_tmgv_rec IN tmgv_rec_type);
122 PROCEDURE lock_row(
123 p_api_version IN NUMBER,
124 p_init_msg_list IN VARCHAR2 DEFAULT OKL_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_tmgv_tbl IN tmgv_tbl_type,
129 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
130 PROCEDURE lock_row(
131 p_api_version IN NUMBER,
132 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
133 x_return_status OUT NOCOPY VARCHAR2,
134 x_msg_count OUT NOCOPY NUMBER,
135 x_msg_data OUT NOCOPY VARCHAR2,
136 p_tmgv_tbl IN tmgv_tbl_type);
137 PROCEDURE update_row(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_tmgv_rec IN tmgv_rec_type,
144 x_tmgv_rec OUT NOCOPY tmgv_rec_type);
145 PROCEDURE update_row(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_tmgv_tbl IN tmgv_tbl_type,
152 x_tmgv_tbl OUT NOCOPY tmgv_tbl_type,
153 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
154 PROCEDURE update_row(
155 p_api_version IN NUMBER,
156 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160 p_tmgv_tbl IN tmgv_tbl_type,
161 x_tmgv_tbl OUT NOCOPY tmgv_tbl_type);
162 PROCEDURE delete_row(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_tmgv_rec IN tmgv_rec_type);
169 PROCEDURE delete_row(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_tmgv_tbl IN tmgv_tbl_type,
176 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
177 PROCEDURE delete_row(
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
180 x_return_status OUT NOCOPY VARCHAR2,
181 x_msg_count OUT NOCOPY NUMBER,
182 x_msg_data OUT NOCOPY VARCHAR2,
183 p_tmgv_tbl IN tmgv_tbl_type);
184 PROCEDURE validate_row(
185 p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_tmgv_rec IN tmgv_rec_type);
191 PROCEDURE validate_row(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_tmgv_tbl IN tmgv_tbl_type,
198 px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE);
199 PROCEDURE validate_row(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_tmgv_tbl IN tmgv_tbl_type);
206 END OKL_TMG_PVT;