8:
9: ----------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_AQERRMSG_PUB';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16:
25:
26: --Object type procedure for insert
27: PROCEDURE create_err_msg(
28: p_api_version IN NUMBER,
29: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
30: x_return_status OUT NOCOPY VARCHAR2,
31: x_msg_count OUT NOCOPY NUMBER,
32: x_msg_data OUT NOCOPY VARCHAR2,
33: p_aqev_rec IN aqev_rec_type,
37:
38: --Object type procedure for update
39: PROCEDURE update_err_msg(
40: p_api_version IN NUMBER,
41: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
42: x_return_status OUT NOCOPY VARCHAR2,
43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2,
45: p_aqev_rec IN aqev_rec_type,
49:
50: --Object type procedure for validate
51: PROCEDURE validate_err_msg(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_aqev_rec IN aqev_rec_type,
59:
60: --Procedures for Errors
61: PROCEDURE create_err(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_aqev_tbl IN aqev_tbl_type,
68: x_aqev_tbl OUT NOCOPY aqev_tbl_type);
69:
70: PROCEDURE create_err(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_aqev_rec IN aqev_rec_type,
77: x_aqev_rec OUT NOCOPY aqev_rec_type);
78:
79: PROCEDURE lock_err(
80: p_api_version IN NUMBER,
81: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2,
85: p_aqev_tbl IN aqev_tbl_type);
85: p_aqev_tbl IN aqev_tbl_type);
86:
87: PROCEDURE lock_err(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
90: x_return_status OUT NOCOPY VARCHAR2,
91: x_msg_count OUT NOCOPY NUMBER,
92: x_msg_data OUT NOCOPY VARCHAR2,
93: p_aqev_rec IN aqev_rec_type);
93: p_aqev_rec IN aqev_rec_type);
94:
95: PROCEDURE update_err(
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_aqev_tbl IN aqev_tbl_type,
102: x_aqev_tbl OUT NOCOPY aqev_tbl_type);
103:
104: PROCEDURE update_err(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_aqev_rec IN aqev_rec_type,
111: x_aqev_rec OUT NOCOPY aqev_rec_type);
112:
113: PROCEDURE delete_err(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_aqev_tbl IN aqev_tbl_type);
119: p_aqev_tbl IN aqev_tbl_type);
120:
121: PROCEDURE delete_err(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_aqev_rec IN aqev_rec_type);
127: p_aqev_rec IN aqev_rec_type);
128:
129: PROCEDURE validate_err(
130: p_api_version IN NUMBER,
131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132: x_return_status OUT NOCOPY VARCHAR2,
133: x_msg_count OUT NOCOPY NUMBER,
134: x_msg_data OUT NOCOPY VARCHAR2,
135: p_aqev_tbl IN aqev_tbl_type);
135: p_aqev_tbl IN aqev_tbl_type);
136:
137: PROCEDURE validate_err(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aqev_rec IN aqev_rec_type);
144:
145: --Procedures for Messages
146: PROCEDURE create_msg(
147: p_api_version IN NUMBER,
148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,
152: p_aqmv_tbl IN aqmv_tbl_type,
153: x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
154:
155: PROCEDURE create_msg(
156: p_api_version IN NUMBER,
157: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
158: x_return_status OUT NOCOPY VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,
160: x_msg_data OUT NOCOPY VARCHAR2,
161: p_aqmv_rec IN aqmv_rec_type,
162: x_aqmv_rec OUT NOCOPY aqmv_rec_type);
163:
164: PROCEDURE lock_msg(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_aqmv_tbl IN aqmv_tbl_type);
170: p_aqmv_tbl IN aqmv_tbl_type);
171:
172: PROCEDURE lock_msg(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175: x_return_status OUT NOCOPY VARCHAR2,
176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_aqmv_rec IN aqmv_rec_type);
178: p_aqmv_rec IN aqmv_rec_type);
179:
180: PROCEDURE update_msg(
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183: x_return_status OUT NOCOPY VARCHAR2,
184: x_msg_count OUT NOCOPY NUMBER,
185: x_msg_data OUT NOCOPY VARCHAR2,
186: p_aqmv_tbl IN aqmv_tbl_type,
187: x_aqmv_tbl OUT NOCOPY aqmv_tbl_type);
188:
189: PROCEDURE update_msg(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_aqmv_rec IN aqmv_rec_type,
196: x_aqmv_rec OUT NOCOPY aqmv_rec_type);
197:
198: PROCEDURE delete_msg(
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_aqmv_rec IN aqmv_rec_type);
204: p_aqmv_rec IN aqmv_rec_type);
205:
206: PROCEDURE delete_msg(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_aqmv_tbl IN aqmv_tbl_type);
212: p_aqmv_tbl IN aqmv_tbl_type);
213:
214: PROCEDURE validate_msg(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_aqmv_tbl IN aqmv_tbl_type);
220: p_aqmv_tbl IN aqmv_tbl_type);
221:
222: PROCEDURE validate_msg(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_aqmv_rec IN aqmv_rec_type);