eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_TMPT_SET_PVT dependencies on OKC_API

Line 16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

12:
13: ------------------------------------------------------------------------------
14: -- Global Variables
15: G_PKG_NAME CONSTANT VARCHAR2(200) := 'okl_template';
16: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
17: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
19: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
20: ------------------------------------------------------------------------------

Line 29: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

25:
26: --Object type procedure for insert
27: PROCEDURE create_tmpt_set(
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_aesv_rec IN aesv_rec_type

Line 44: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

40:
41: --Object type procedure for update
42: PROCEDURE update_tmpt_set(
43: p_api_version IN NUMBER
44: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
45: ,x_return_status OUT NOCOPY VARCHAR2
46: ,x_msg_count OUT NOCOPY NUMBER
47: ,x_msg_data OUT NOCOPY VARCHAR2
48: ,p_aesv_rec IN aesv_rec_type

Line 59: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

55:
56: --Object type procedure for validate
57: PROCEDURE validate_tmpt_set(
58: p_api_version IN NUMBER
59: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
60: ,x_return_status OUT NOCOPY VARCHAR2
61: ,x_msg_count OUT NOCOPY NUMBER
62: ,x_msg_data OUT NOCOPY VARCHAR2
63: ,p_aesv_rec IN aesv_rec_type

Line 71: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

67:
68:
69: PROCEDURE create_tmpt_set(
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_aesv_tbl IN aesv_tbl_type,

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

76: x_aesv_tbl OUT NOCOPY aesv_tbl_type);
77:
78: PROCEDURE create_tmpt_set(
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_aesv_rec IN aesv_rec_type,

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

85: x_aesv_rec OUT NOCOPY aesv_rec_type);
86:
87: PROCEDURE lock_tmpt_set(
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_aesv_tbl IN aesv_tbl_type);

Line 97: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

93: p_aesv_tbl IN aesv_tbl_type);
94:
95: PROCEDURE lock_tmpt_set(
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_aesv_rec IN aesv_rec_type);

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

101: p_aesv_rec IN aesv_rec_type);
102:
103: PROCEDURE update_tmpt_set(
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_aesv_tbl IN aesv_tbl_type,

Line 114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

110: x_aesv_tbl OUT NOCOPY aesv_tbl_type);
111:
112: PROCEDURE update_tmpt_set(
113: p_api_version IN NUMBER,
114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_aesv_rec IN aesv_rec_type,

Line 123: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

119: x_aesv_rec OUT NOCOPY aesv_rec_type);
120:
121: PROCEDURE delete_tmpt_set(
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_aesv_tbl IN aesv_tbl_type);

Line 131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

127: p_aesv_tbl IN aesv_tbl_type);
128:
129: PROCEDURE delete_tmpt_set(
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_aesv_rec IN aesv_rec_type);

Line 139: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

135: p_aesv_rec IN aesv_rec_type);
136:
137: PROCEDURE validate_tmpt_set(
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_aesv_tbl IN aesv_tbl_type);

Line 147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

143: p_aesv_tbl IN aesv_tbl_type);
144:
145: PROCEDURE validate_tmpt_set(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_aesv_rec IN aesv_rec_type);

Line 156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

152:
153:
154: PROCEDURE create_template(
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_avlv_tbl IN avlv_tbl_type,

Line 165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

161: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
162:
163: PROCEDURE create_template(
164: p_api_version IN NUMBER,
165: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166: x_return_status OUT NOCOPY VARCHAR2,
167: x_msg_count OUT NOCOPY NUMBER,
168: x_msg_data OUT NOCOPY VARCHAR2,
169: p_avlv_rec IN avlv_rec_type,

Line 174: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

170: x_avlv_rec OUT NOCOPY avlv_rec_type);
171:
172: PROCEDURE lock_template(
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_avlv_tbl IN avlv_tbl_type);

Line 182: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

178: p_avlv_tbl IN avlv_tbl_type);
179:
180: PROCEDURE lock_template(
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_avlv_rec IN avlv_rec_type);

Line 190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

186: p_avlv_rec IN avlv_rec_type);
187:
188: PROCEDURE update_template(
189: p_api_version IN NUMBER,
190: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
194: p_avlv_tbl IN avlv_tbl_type,

Line 199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

195: x_avlv_tbl OUT NOCOPY avlv_tbl_type);
196:
197: PROCEDURE update_template(
198: p_api_version IN NUMBER,
199: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
203: p_avlv_rec IN avlv_rec_type,

Line 208: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

204: x_avlv_rec OUT NOCOPY avlv_rec_type);
205:
206: PROCEDURE delete_template(
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_avlv_tbl IN avlv_tbl_type);

Line 216: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

212: p_avlv_tbl IN avlv_tbl_type);
213:
214: PROCEDURE delete_template(
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_avlv_rec IN avlv_rec_type);

Line 224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

220: p_avlv_rec IN avlv_rec_type);
221:
222: PROCEDURE validate_template(
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_avlv_tbl IN avlv_tbl_type);

Line 232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

228: p_avlv_tbl IN avlv_tbl_type);
229:
230: PROCEDURE validate_template(
231: p_api_version IN NUMBER,
232: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_avlv_rec IN avlv_rec_type);

Line 241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

237:
238:
239: PROCEDURE create_tmpt_lines(
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
245: p_atlv_tbl IN atlv_tbl_type,

Line 250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

246: x_atlv_tbl OUT NOCOPY atlv_tbl_type);
247:
248: PROCEDURE create_tmpt_lines(
249: p_api_version IN NUMBER,
250: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_atlv_rec IN atlv_rec_type,

Line 259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

255: x_atlv_rec OUT NOCOPY atlv_rec_type);
256:
257: PROCEDURE lock_tmpt_lines(
258: p_api_version IN NUMBER,
259: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_atlv_tbl IN atlv_tbl_type);

Line 267: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

263: p_atlv_tbl IN atlv_tbl_type);
264:
265: PROCEDURE lock_tmpt_lines(
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
268: x_return_status OUT NOCOPY VARCHAR2,
269: x_msg_count OUT NOCOPY NUMBER,
270: x_msg_data OUT NOCOPY VARCHAR2,
271: p_atlv_rec IN atlv_rec_type);

Line 275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

271: p_atlv_rec IN atlv_rec_type);
272:
273: PROCEDURE update_tmpt_lines(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_atlv_tbl IN atlv_tbl_type,

Line 284: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

280: x_atlv_tbl OUT NOCOPY atlv_tbl_type);
281:
282: PROCEDURE update_tmpt_lines(
283: p_api_version IN NUMBER,
284: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
285: x_return_status OUT NOCOPY VARCHAR2,
286: x_msg_count OUT NOCOPY NUMBER,
287: x_msg_data OUT NOCOPY VARCHAR2,
288: p_atlv_rec IN atlv_rec_type,

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

289: x_atlv_rec OUT NOCOPY atlv_rec_type);
290:
291: PROCEDURE delete_tmpt_lines(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
294: x_return_status OUT NOCOPY VARCHAR2,
295: x_msg_count OUT NOCOPY NUMBER,
296: x_msg_data OUT NOCOPY VARCHAR2,
297: p_atlv_tbl IN atlv_tbl_type);

Line 301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

297: p_atlv_tbl IN atlv_tbl_type);
298:
299: PROCEDURE delete_tmpt_lines(
300: p_api_version IN NUMBER,
301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302: x_return_status OUT NOCOPY VARCHAR2,
303: x_msg_count OUT NOCOPY NUMBER,
304: x_msg_data OUT NOCOPY VARCHAR2,
305: p_atlv_rec IN atlv_rec_type);

Line 309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

305: p_atlv_rec IN atlv_rec_type);
306:
307: PROCEDURE validate_tmpt_lines(
308: p_api_version IN NUMBER,
309: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
310: x_return_status OUT NOCOPY VARCHAR2,
311: x_msg_count OUT NOCOPY NUMBER,
312: x_msg_data OUT NOCOPY VARCHAR2,
313: p_atlv_tbl IN atlv_tbl_type);

Line 317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

313: p_atlv_tbl IN atlv_tbl_type);
314:
315: PROCEDURE validate_tmpt_lines(
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
318: x_return_status OUT NOCOPY VARCHAR2,
319: x_msg_count OUT NOCOPY NUMBER,
320: x_msg_data OUT NOCOPY VARCHAR2,
321: p_atlv_rec IN atlv_rec_type);