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.HZ_CLASSIFICATION_V2PUB dependencies on FND_API

Line 111: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

107: *
108: * ARGUMENTS
109: * IN:
110: * p_init_msg_list Initialize message stack if it is set to
111: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
112: * p_class_category_rec Class category record.
113: * IN/OUT:
114: * OUT:
115: * x_return_status Return status after the call. The status can

Line 116: * be FND_API.G_RET_STS_SUCCESS (success),

112: * p_class_category_rec Class category record.
113: * IN/OUT:
114: * OUT:
115: * x_return_status Return status after the call. The status can
116: * be FND_API.G_RET_STS_SUCCESS (success),
117: * FND_API.G_RET_STS_ERROR (error),
118: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
119: * x_msg_count Number of messages in message stack.
120: * x_msg_data Message text if x_msg_count is 1.

Line 117: * FND_API.G_RET_STS_ERROR (error),

113: * IN/OUT:
114: * OUT:
115: * x_return_status Return status after the call. The status can
116: * be FND_API.G_RET_STS_SUCCESS (success),
117: * FND_API.G_RET_STS_ERROR (error),
118: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
119: * x_msg_count Number of messages in message stack.
120: * x_msg_data Message text if x_msg_count is 1.
121: *

Line 118: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

114: * OUT:
115: * x_return_status Return status after the call. The status can
116: * be FND_API.G_RET_STS_SUCCESS (success),
117: * FND_API.G_RET_STS_ERROR (error),
118: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
119: * x_msg_count Number of messages in message stack.
120: * x_msg_data Message text if x_msg_count is 1.
121: *
122: * NOTES

Line 144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

140: * @rep:businessevent oracle.apps.ar.hz.ClassCategory.create
141: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
142: */
143: PROCEDURE create_class_category(
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_class_category_rec IN CLASS_CATEGORY_REC_TYPE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2

Line 162: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

158: *
159: * ARGUMENTS
160: * IN:
161: * p_init_msg_list Initialize message stack if it is set to
162: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
163: * p_class_category_rec Class category record.
164: * IN/OUT:
165: * p_object_version_number Used for locking the being updated record.
166: * OUT:

Line 168: * be FND_API.G_RET_STS_SUCCESS (success),

164: * IN/OUT:
165: * p_object_version_number Used for locking the being updated record.
166: * OUT:
167: * x_return_status Return status after the call. The status can
168: * be FND_API.G_RET_STS_SUCCESS (success),
169: * FND_API.G_RET_STS_ERROR (error),
170: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
171: * x_msg_count Number of messages in message stack.
172: * x_msg_data Message text if x_msg_count is 1.

Line 169: * FND_API.G_RET_STS_ERROR (error),

165: * p_object_version_number Used for locking the being updated record.
166: * OUT:
167: * x_return_status Return status after the call. The status can
168: * be FND_API.G_RET_STS_SUCCESS (success),
169: * FND_API.G_RET_STS_ERROR (error),
170: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
171: * x_msg_count Number of messages in message stack.
172: * x_msg_data Message text if x_msg_count is 1.
173: *

Line 170: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

166: * OUT:
167: * x_return_status Return status after the call. The status can
168: * be FND_API.G_RET_STS_SUCCESS (success),
169: * FND_API.G_RET_STS_ERROR (error),
170: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
171: * x_msg_count Number of messages in message stack.
172: * x_msg_data Message text if x_msg_count is 1.
173: *
174: * NOTES

Line 192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

188: * @rep:businessevent oracle.apps.ar.hz.ClassCategory.update
189: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
190: */
191: PROCEDURE update_class_category(
192: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
193: p_class_category_rec IN CLASS_CATEGORY_REC_TYPE,
194: p_object_version_number IN OUT NOCOPY NUMBER,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,

Line 211: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

207: *
208: * ARGUMENTS
209: * IN:
210: * p_init_msg_list Initialize message stack if it is set to
211: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
212: * p_class_category Class category name.
213: * IN/OUT:
214: * OUT:
215: * x_class_category_rec Returned class category record.

Line 217: * be FND_API.G_RET_STS_SUCCESS (success),

213: * IN/OUT:
214: * OUT:
215: * x_class_category_rec Returned class category record.
216: * x_return_status Return status after the call. The status can
217: * be FND_API.G_RET_STS_SUCCESS (success),
218: * FND_API.G_RET_STS_ERROR (error),
219: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: * x_msg_count Number of messages in message stack.
221: * x_msg_data Message text if x_msg_count is 1.

Line 218: * FND_API.G_RET_STS_ERROR (error),

214: * OUT:
215: * x_class_category_rec Returned class category record.
216: * x_return_status Return status after the call. The status can
217: * be FND_API.G_RET_STS_SUCCESS (success),
218: * FND_API.G_RET_STS_ERROR (error),
219: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: * x_msg_count Number of messages in message stack.
221: * x_msg_data Message text if x_msg_count is 1.
222: *

Line 219: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

215: * x_class_category_rec Returned class category record.
216: * x_return_status Return status after the call. The status can
217: * be FND_API.G_RET_STS_SUCCESS (success),
218: * FND_API.G_RET_STS_ERROR (error),
219: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
220: * x_msg_count Number of messages in message stack.
221: * x_msg_data Message text if x_msg_count is 1.
222: *
223: * NOTES

Line 232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

228: *
229: */
230:
231: PROCEDURE get_class_category_rec (
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
233: p_class_category IN VARCHAR2,
234: x_class_category_rec OUT NOCOPY CLASS_CATEGORY_REC_TYPE,
235: x_return_status OUT NOCOPY VARCHAR2,
236: x_msg_count OUT NOCOPY NUMBER,

Line 251: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

247: *
248: * ARGUMENTS
249: * IN:
250: * p_init_msg_list Initialize message stack if it is set to
251: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
252: * p_class_code_relation_rec Class code relation record.
253: * IN/OUT:
254: * OUT:
255: * x_return_status Return status after the call. The status can

Line 256: * be FND_API.G_RET_STS_SUCCESS (success),

252: * p_class_code_relation_rec Class code relation record.
253: * IN/OUT:
254: * OUT:
255: * x_return_status Return status after the call. The status can
256: * be FND_API.G_RET_STS_SUCCESS (success),
257: * FND_API.G_RET_STS_ERROR (error),
258: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
259: * x_msg_count Number of messages in message stack.
260: * x_msg_data Message text if x_msg_count is 1.

Line 257: * FND_API.G_RET_STS_ERROR (error),

253: * IN/OUT:
254: * OUT:
255: * x_return_status Return status after the call. The status can
256: * be FND_API.G_RET_STS_SUCCESS (success),
257: * FND_API.G_RET_STS_ERROR (error),
258: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
259: * x_msg_count Number of messages in message stack.
260: * x_msg_data Message text if x_msg_count is 1.
261: *

Line 258: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

254: * OUT:
255: * x_return_status Return status after the call. The status can
256: * be FND_API.G_RET_STS_SUCCESS (success),
257: * FND_API.G_RET_STS_ERROR (error),
258: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
259: * x_msg_count Number of messages in message stack.
260: * x_msg_data Message text if x_msg_count is 1.
261: *
262: * NOTES

Line 280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

276: * @rep:businessevent oracle.apps.ar.hz.ClassCodeRelation.create
277: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
278: */
279: PROCEDURE create_class_code_relation(
280: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
281: p_class_code_relation_rec IN CLASS_CODE_RELATION_REC_TYPE,
282: x_return_status OUT NOCOPY VARCHAR2,
283: x_msg_count OUT NOCOPY NUMBER,
284: x_msg_data OUT NOCOPY VARCHAR2

Line 298: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

294: *
295: * ARGUMENTS
296: * IN:
297: * p_init_msg_list Initialize message stack if it is set to
298: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
299: * p_class_code_relation_rec Class code relation record.
300: * IN/OUT:
301: * p_object_version_number Used for locking the being updated record.
302: * OUT:

Line 304: * be FND_API.G_RET_STS_SUCCESS (success),

300: * IN/OUT:
301: * p_object_version_number Used for locking the being updated record.
302: * OUT:
303: * x_return_status Return status after the call. The status can
304: * be FND_API.G_RET_STS_SUCCESS (success),
305: * FND_API.G_RET_STS_ERROR (error),
306: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
307: * x_msg_count Number of messages in message stack.
308: * x_msg_data Message text if x_msg_count is 1.

Line 305: * FND_API.G_RET_STS_ERROR (error),

301: * p_object_version_number Used for locking the being updated record.
302: * OUT:
303: * x_return_status Return status after the call. The status can
304: * be FND_API.G_RET_STS_SUCCESS (success),
305: * FND_API.G_RET_STS_ERROR (error),
306: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
307: * x_msg_count Number of messages in message stack.
308: * x_msg_data Message text if x_msg_count is 1.
309: *

Line 306: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

302: * OUT:
303: * x_return_status Return status after the call. The status can
304: * be FND_API.G_RET_STS_SUCCESS (success),
305: * FND_API.G_RET_STS_ERROR (error),
306: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
307: * x_msg_count Number of messages in message stack.
308: * x_msg_data Message text if x_msg_count is 1.
309: *
310: * NOTES

Line 328: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

324: * @rep:businessevent oracle.apps.ar.hz.ClassCodeRelation.update
325: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
326: */
327: PROCEDURE update_class_code_relation(
328: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
329: p_class_code_relation_rec IN CLASS_CODE_RELATION_REC_TYPE,
330: p_object_version_number IN OUT NOCOPY NUMBER,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,

Line 347: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

343: *
344: * ARGUMENTS
345: * IN:
346: * p_init_msg_list Initialize message stack if it is set to
347: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
348: * p_class_category Class category name.
349: * p_class_code Class code.
350: * p_sub_class_code Sub class code.
351: * p_start_date_active Start date active.

Line 356: * be FND_API.G_RET_STS_SUCCESS (success),

352: * IN/OUT:
353: * OUT:
354: * x_class_code_relation_rec Returned class code relation record.
355: * x_return_status Return status after the call. The status can
356: * be FND_API.G_RET_STS_SUCCESS (success),
357: * FND_API.G_RET_STS_ERROR (error),
358: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
359: * x_msg_count Number of messages in message stack.
360: * x_msg_data Message text if x_msg_count is 1.

Line 357: * FND_API.G_RET_STS_ERROR (error),

353: * OUT:
354: * x_class_code_relation_rec Returned class code relation record.
355: * x_return_status Return status after the call. The status can
356: * be FND_API.G_RET_STS_SUCCESS (success),
357: * FND_API.G_RET_STS_ERROR (error),
358: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
359: * x_msg_count Number of messages in message stack.
360: * x_msg_data Message text if x_msg_count is 1.
361: *

Line 358: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

354: * x_class_code_relation_rec Returned class code relation record.
355: * x_return_status Return status after the call. The status can
356: * be FND_API.G_RET_STS_SUCCESS (success),
357: * FND_API.G_RET_STS_ERROR (error),
358: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
359: * x_msg_count Number of messages in message stack.
360: * x_msg_data Message text if x_msg_count is 1.
361: *
362: * NOTES

Line 371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

367: *
368: */
369:
370: PROCEDURE get_class_code_relation_rec(
371: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
372: p_class_category IN VARCHAR2,
373: p_class_code IN VARCHAR2,
374: p_sub_class_code IN VARCHAR2,
375: p_start_date_active IN DATE,

Line 393: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

389: *
390: * ARGUMENTS
391: * IN:
392: * p_init_msg_list Initialize message stack if it is set to
393: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
394: * p_code_assignement_rec Code assignment record.
395: * IN/OUT:
396: * OUT:
397: * x_return_status Return status after the call. The status can

Line 398: * be FND_API.G_RET_STS_SUCCESS (success),

394: * p_code_assignement_rec Code assignment record.
395: * IN/OUT:
396: * OUT:
397: * x_return_status Return status after the call. The status can
398: * be FND_API.G_RET_STS_SUCCESS (success),
399: * FND_API.G_RET_STS_ERROR (error),
400: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
401: * x_msg_count Number of messages in message stack.
402: * x_msg_data Message text if x_msg_count is 1.

Line 399: * FND_API.G_RET_STS_ERROR (error),

395: * IN/OUT:
396: * OUT:
397: * x_return_status Return status after the call. The status can
398: * be FND_API.G_RET_STS_SUCCESS (success),
399: * FND_API.G_RET_STS_ERROR (error),
400: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
401: * x_msg_count Number of messages in message stack.
402: * x_msg_data Message text if x_msg_count is 1.
403: * x_code_assignment_id Code assignment ID.

Line 400: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

396: * OUT:
397: * x_return_status Return status after the call. The status can
398: * be FND_API.G_RET_STS_SUCCESS (success),
399: * FND_API.G_RET_STS_ERROR (error),
400: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
401: * x_msg_count Number of messages in message stack.
402: * x_msg_data Message text if x_msg_count is 1.
403: * x_code_assignment_id Code assignment ID.
404: *

Line 428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

424: * @rep:businessevent oracle.apps.ar.hz.CodeAssignment.create
425: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
426: */
427: PROCEDURE create_code_assignment(
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_code_assignment_rec IN CODE_ASSIGNMENT_REC_TYPE,
430: x_return_status OUT NOCOPY VARCHAR2,
431: x_msg_count OUT NOCOPY NUMBER,
432: x_msg_data OUT NOCOPY VARCHAR2,

Line 447: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

443: *
444: * ARGUMENTS
445: * IN:
446: * p_init_msg_list Initialize message stack if it is set to
447: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
448: * p_code_assignment_rec Code assignment record.
449: * IN/OUT:
450: * p_object_version_number Used for locking the being updated record.
451: * OUT:

Line 453: * be FND_API.G_RET_STS_SUCCESS (success),

449: * IN/OUT:
450: * p_object_version_number Used for locking the being updated record.
451: * OUT:
452: * x_return_status Return status after the call. The status can
453: * be FND_API.G_RET_STS_SUCCESS (success),
454: * FND_API.G_RET_STS_ERROR (error),
455: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
456: * x_msg_count Number of messages in message stack.
457: * x_msg_data Message text if x_msg_count is 1.

Line 454: * FND_API.G_RET_STS_ERROR (error),

450: * p_object_version_number Used for locking the being updated record.
451: * OUT:
452: * x_return_status Return status after the call. The status can
453: * be FND_API.G_RET_STS_SUCCESS (success),
454: * FND_API.G_RET_STS_ERROR (error),
455: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
456: * x_msg_count Number of messages in message stack.
457: * x_msg_data Message text if x_msg_count is 1.
458: *

Line 455: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

451: * OUT:
452: * x_return_status Return status after the call. The status can
453: * be FND_API.G_RET_STS_SUCCESS (success),
454: * FND_API.G_RET_STS_ERROR (error),
455: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
456: * x_msg_count Number of messages in message stack.
457: * x_msg_data Message text if x_msg_count is 1.
458: *
459: * NOTES

Line 477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

473: * @rep:businessevent oracle.apps.ar.hz.CodeAssignment.update
474: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
475: */
476: PROCEDURE update_code_assignment(
477: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
478: p_code_assignment_rec IN CODE_ASSIGNMENT_REC_TYPE,
479: p_object_version_number IN OUT NOCOPY NUMBER,
480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,

Line 496: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

492: *
493: * ARGUMENTS
494: * IN:
495: * p_init_msg_list Initialize message stack if it is set to
496: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
497: * p_owner_table_name Owner table name.
498: * p_owner_table_id Owner table ID.
499: * p_class_category Class category.
500: * p_class_code Class code.

Line 506: * be FND_API.G_RET_STS_SUCCESS (success),

502: * IN/OUT:
503: * OUT:
504: * x_code_assignment_id Code assignment ID.
505: * x_return_status Return status after the call. The status can
506: * be FND_API.G_RET_STS_SUCCESS (success),
507: * FND_API.G_RET_STS_ERROR (error),
508: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
509: * x_msg_count Number of messages in message stack.
510: * x_msg_data Message text if x_msg_count is 1.

Line 507: * FND_API.G_RET_STS_ERROR (error),

503: * OUT:
504: * x_code_assignment_id Code assignment ID.
505: * x_return_status Return status after the call. The status can
506: * be FND_API.G_RET_STS_SUCCESS (success),
507: * FND_API.G_RET_STS_ERROR (error),
508: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
509: * x_msg_count Number of messages in message stack.
510: * x_msg_data Message text if x_msg_count is 1.
511: *

Line 508: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

504: * x_code_assignment_id Code assignment ID.
505: * x_return_status Return status after the call. The status can
506: * be FND_API.G_RET_STS_SUCCESS (success),
507: * FND_API.G_RET_STS_ERROR (error),
508: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
509: * x_msg_count Number of messages in message stack.
510: * x_msg_data Message text if x_msg_count is 1.
511: *
512: * NOTES

Line 521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

517: *
518: */
519:
520: procedure set_primary_code_assignment(
521: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
522: p_owner_table_name IN VARCHAR2,
523: p_owner_table_id IN NUMBER,
524: p_class_category IN VARCHAR2,
525: p_class_code IN VARCHAR2,

Line 545: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

541: *
542: * ARGUMENTS
543: * IN:
544: * p_init_msg_list Initialize message stack if it is set to
545: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
546: * p_code_assignment_id Code assignment ID.
547: * IN/OUT:
548: * OUT:
549: * x_code_assignment_rec Returned code assignment record.

Line 551: * be FND_API.G_RET_STS_SUCCESS (success),

547: * IN/OUT:
548: * OUT:
549: * x_code_assignment_rec Returned code assignment record.
550: * x_return_status Return status after the call. The status can
551: * be FND_API.G_RET_STS_SUCCESS (success),
552: * FND_API.G_RET_STS_ERROR (error),
553: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
554: * x_msg_count Number of messages in message stack.
555: * x_msg_data Message text if x_msg_count is 1.

Line 552: * FND_API.G_RET_STS_ERROR (error),

548: * OUT:
549: * x_code_assignment_rec Returned code assignment record.
550: * x_return_status Return status after the call. The status can
551: * be FND_API.G_RET_STS_SUCCESS (success),
552: * FND_API.G_RET_STS_ERROR (error),
553: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
554: * x_msg_count Number of messages in message stack.
555: * x_msg_data Message text if x_msg_count is 1.
556: *

Line 553: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

549: * x_code_assignment_rec Returned code assignment record.
550: * x_return_status Return status after the call. The status can
551: * be FND_API.G_RET_STS_SUCCESS (success),
552: * FND_API.G_RET_STS_ERROR (error),
553: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
554: * x_msg_count Number of messages in message stack.
555: * x_msg_data Message text if x_msg_count is 1.
556: *
557: * NOTES

Line 566: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

562: *
563: */
564:
565: PROCEDURE get_code_assignment_rec(
566: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
567: p_code_assignment_id IN NUMBER,
568: x_code_assignment_rec OUT NOCOPY CODE_ASSIGNMENT_REC_TYPE,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,

Line 585: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

581: *
582: * ARGUMENTS
583: * IN:
584: * p_init_msg_list Initialize message stack if it is set to
585: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
586: * p_class_category_use_rec Class category use record.
587: * IN/OUT:
588: * OUT:
589: * x_return_status Return status after the call. The status can

Line 590: * be FND_API.G_RET_STS_SUCCESS (success),

586: * p_class_category_use_rec Class category use record.
587: * IN/OUT:
588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.

Line 591: * FND_API.G_RET_STS_ERROR (error),

587: * IN/OUT:
588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.
595: *

Line 592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

588: * OUT:
589: * x_return_status Return status after the call. The status can
590: * be FND_API.G_RET_STS_SUCCESS (success),
591: * FND_API.G_RET_STS_ERROR (error),
592: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
593: * x_msg_count Number of messages in message stack.
594: * x_msg_data Message text if x_msg_count is 1.
595: *
596: * NOTES

Line 621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

617: * @rep:businessevent oracle.apps.ar.hz.ClassCategoryUse.create
618: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
619: */
620: PROCEDURE create_class_category_use (
621: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
622: p_class_category_use_rec IN CLASS_CATEGORY_USE_REC_TYPE,
623: x_return_status OUT NOCOPY VARCHAR2,
624: x_msg_count OUT NOCOPY NUMBER,
625: x_msg_data OUT NOCOPY VARCHAR2

Line 639: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

635: *
636: * ARGUMENTS
637: * IN:
638: * p_init_msg_list Initialize message stack if it is set to
639: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
640: * p_class_category_use_rec Class category use record.
641: * IN/OUT:
642: * p_object_version_number Used for locking the being updated record.
643: * OUT:

Line 645: * be FND_API.G_RET_STS_SUCCESS (success),

641: * IN/OUT:
642: * p_object_version_number Used for locking the being updated record.
643: * OUT:
644: * x_return_status Return status after the call. The status can
645: * be FND_API.G_RET_STS_SUCCESS (success),
646: * FND_API.G_RET_STS_ERROR (error),
647: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
648: * x_msg_count Number of messages in message stack.
649: * x_msg_data Message text if x_msg_count is 1.

Line 646: * FND_API.G_RET_STS_ERROR (error),

642: * p_object_version_number Used for locking the being updated record.
643: * OUT:
644: * x_return_status Return status after the call. The status can
645: * be FND_API.G_RET_STS_SUCCESS (success),
646: * FND_API.G_RET_STS_ERROR (error),
647: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
648: * x_msg_count Number of messages in message stack.
649: * x_msg_data Message text if x_msg_count is 1.
650: *

Line 647: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

643: * OUT:
644: * x_return_status Return status after the call. The status can
645: * be FND_API.G_RET_STS_SUCCESS (success),
646: * FND_API.G_RET_STS_ERROR (error),
647: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
648: * x_msg_count Number of messages in message stack.
649: * x_msg_data Message text if x_msg_count is 1.
650: *
651: * NOTES

Line 669: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,

665: * @rep:businessevent oracle.apps.ar.hz.ClassCategoryUse.update
666: * @rep:doccd 120hztig.pdf Classification API Use, Oracle Trading Community Architecture Technical Implementation Guide
667: */
668: PROCEDURE update_class_category_use (
669: p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
670: p_class_category_use_rec IN CLASS_CATEGORY_USE_REC_TYPE,
671: p_object_version_number IN OUT NOCOPY NUMBER,
672: x_return_status OUT NOCOPY VARCHAR2,
673: x_msg_count OUT NOCOPY NUMBER,

Line 688: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

684: *
685: * ARGUMENTS
686: * IN:
687: * p_init_msg_list Initialize message stack if it is set to
688: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
689: * p_class_category Class category name.
690: * p_owner_table Owner table name.
691: * IN/OUT:
692: * OUT:

Line 695: * be FND_API.G_RET_STS_SUCCESS (success),

691: * IN/OUT:
692: * OUT:
693: * x_class_category_use_rec Returned class category use record.
694: * x_return_status Return status after the call. The status can
695: * be FND_API.G_RET_STS_SUCCESS (success),
696: * FND_API.G_RET_STS_ERROR (error),
697: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
698: * x_msg_count Number of messages in message stack.
699: * x_msg_data Message text if x_msg_count is 1.

Line 696: * FND_API.G_RET_STS_ERROR (error),

692: * OUT:
693: * x_class_category_use_rec Returned class category use record.
694: * x_return_status Return status after the call. The status can
695: * be FND_API.G_RET_STS_SUCCESS (success),
696: * FND_API.G_RET_STS_ERROR (error),
697: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
698: * x_msg_count Number of messages in message stack.
699: * x_msg_data Message text if x_msg_count is 1.
700: *

Line 697: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

693: * x_class_category_use_rec Returned class category use record.
694: * x_return_status Return status after the call. The status can
695: * be FND_API.G_RET_STS_SUCCESS (success),
696: * FND_API.G_RET_STS_ERROR (error),
697: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
698: * x_msg_count Number of messages in message stack.
699: * x_msg_data Message text if x_msg_count is 1.
700: *
701: * NOTES

Line 710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

706: *
707: */
708:
709: PROCEDURE get_class_category_use_rec(
710: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
711: p_class_category IN VARCHAR2,
712: p_owner_table IN VARCHAR2,
713: x_class_category_use_rec OUT NOCOPY CLASS_CATEGORY_USE_REC_TYPE,
714: x_return_status OUT NOCOPY VARCHAR2,

Line 761: p_id NUMBER := FND_API.G_MISS_NUM,

757: */
758: FUNCTION IS_VALID_CATEGORY(
759: p_owner_table VARCHAR2,
760: p_class_category VARCHAR2,
761: p_id NUMBER := FND_API.G_MISS_NUM,
762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,

Line 762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,

758: FUNCTION IS_VALID_CATEGORY(
759: p_owner_table VARCHAR2,
760: p_class_category VARCHAR2,
761: p_id NUMBER := FND_API.G_MISS_NUM,
762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR

Line 763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,

759: p_owner_table VARCHAR2,
760: p_class_category VARCHAR2,
761: p_id NUMBER := FND_API.G_MISS_NUM,
762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
767: ) RETURN VARCHAR2;

Line 764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,

760: p_class_category VARCHAR2,
761: p_id NUMBER := FND_API.G_MISS_NUM,
762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
767: ) RETURN VARCHAR2;
768:

Line 765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,

761: p_id NUMBER := FND_API.G_MISS_NUM,
762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
767: ) RETURN VARCHAR2;
768:
769:

Line 766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR

762: p_key_1 VARCHAR2 := FND_API.G_MISS_CHAR,
763: p_key_2 VARCHAR2 := FND_API.G_MISS_CHAR,
764: p_key_3 VARCHAR2 := FND_API.G_MISS_CHAR,
765: p_key_4 VARCHAR2 := FND_API.G_MISS_CHAR,
766: p_key_5 VARCHAR2 := FND_API.G_MISS_CHAR
767: ) RETURN VARCHAR2;
768:
769:
770: /**

Line 782: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

778: *
779: * ARGUMENTS
780: * IN:
781: * p_init_msg_list Initialize message stack if it is set to
782: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
783: * p_class_code_rec Lookup value related columns
784: * IN/OUT:
785: * OUT:
786: * x_return_status Return status after the call. The status can

Line 787: * be FND_API.G_RET_STS_SUCCESS (success),

783: * p_class_code_rec Lookup value related columns
784: * IN/OUT:
785: * OUT:
786: * x_return_status Return status after the call. The status can
787: * be FND_API.G_RET_STS_SUCCESS (success),
788: * FND_API.G_RET_STS_ERROR (error),
789: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
790: * x_msg_count Number of messages in message stack.
791: * x_msg_data Message text if x_msg_count is 1.

Line 788: * FND_API.G_RET_STS_ERROR (error),

784: * IN/OUT:
785: * OUT:
786: * x_return_status Return status after the call. The status can
787: * be FND_API.G_RET_STS_SUCCESS (success),
788: * FND_API.G_RET_STS_ERROR (error),
789: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
790: * x_msg_count Number of messages in message stack.
791: * x_msg_data Message text if x_msg_count is 1.
792: *

Line 789: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

785: * OUT:
786: * x_return_status Return status after the call. The status can
787: * be FND_API.G_RET_STS_SUCCESS (success),
788: * FND_API.G_RET_STS_ERROR (error),
789: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
790: * x_msg_count Number of messages in message stack.
791: * x_msg_data Message text if x_msg_count is 1.
792: *
793: * NOTES

Line 802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

798: *
799: */
800:
801: PROCEDURE create_class_code(
802: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
803: p_class_code_rec IN CLASS_CODE_REC_TYPE,
804: x_return_status OUT NOCOPY VARCHAR2,
805: x_msg_count OUT NOCOPY NUMBER,
806: x_msg_data OUT NOCOPY VARCHAR2

Line 823: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

819: *
820: * ARGUMENTS
821: * IN:
822: * p_init_msg_list Initialize message stack if it is set to
823: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
824: * p_class_code_rec Lookup value related columns
825: * IN/OUT:
826: * p_object_version_number Used for locking the being updated record.
827: * OUT:

Line 829: * be FND_API.G_RET_STS_SUCCESS (success),

825: * IN/OUT:
826: * p_object_version_number Used for locking the being updated record.
827: * OUT:
828: * x_return_status Return status after the call. The status can
829: * be FND_API.G_RET_STS_SUCCESS (success),
830: * FND_API.G_RET_STS_ERROR (error),
831: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
832: * x_msg_count Number of messages in message stack.
833: * x_msg_data Message text if x_msg_count is 1.

Line 830: * FND_API.G_RET_STS_ERROR (error),

826: * p_object_version_number Used for locking the being updated record.
827: * OUT:
828: * x_return_status Return status after the call. The status can
829: * be FND_API.G_RET_STS_SUCCESS (success),
830: * FND_API.G_RET_STS_ERROR (error),
831: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
832: * x_msg_count Number of messages in message stack.
833: * x_msg_data Message text if x_msg_count is 1.
834: *

Line 831: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

827: * OUT:
828: * x_return_status Return status after the call. The status can
829: * be FND_API.G_RET_STS_SUCCESS (success),
830: * FND_API.G_RET_STS_ERROR (error),
831: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
832: * x_msg_count Number of messages in message stack.
833: * x_msg_data Message text if x_msg_count is 1.
834: *
835: * NOTES

Line 844: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

840: *
841: */
842:
843: PROCEDURE update_class_code(
844: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
845: p_class_code_rec IN CLASS_CODE_REC_TYPE,
846: p_object_version_number IN OUT NOCOPY NUMBER,
847: x_return_status OUT NOCOPY VARCHAR2,
848: x_msg_count OUT NOCOPY NUMBER,