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.QA_SSQR_JRAD_PKG dependencies on QA_SS_CONST

Line 372: IF p_char_id = qa_ss_const.item THEN

368: -- OUT table structure.
369:
370: x_parents.delete();
371:
372: IF p_char_id = qa_ss_const.item THEN
373: x_parents(1) := qa_ss_const.production_line;
374:
375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;

Line 373: x_parents(1) := qa_ss_const.production_line;

369:
370: x_parents.delete();
371:
372: IF p_char_id = qa_ss_const.item THEN
373: x_parents(1) := qa_ss_const.production_line;
374:
375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;

Line 375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN

371:
372: IF p_char_id = qa_ss_const.item THEN
373: x_parents(1) := qa_ss_const.production_line;
374:
375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

Line 376: x_parents(1) := qa_ss_const.job_name;

372: IF p_char_id = qa_ss_const.item THEN
373: x_parents(1) := qa_ss_const.production_line;
374:
375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;

Line 377: x_parents(2) := qa_ss_const.production_line;

373: x_parents(1) := qa_ss_const.production_line;
374:
375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;

Line 379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

375: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;
382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

Line 380: x_parents(1) := qa_ss_const.job_name;

376: x_parents(1) := qa_ss_const.job_name;
377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;
382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;

Line 381: x_parents(2) := qa_ss_const.production_line;

377: x_parents(2) := qa_ss_const.production_line;
378:
379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;
382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;
385:

Line 383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

379: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;
382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;
385:
386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
387: x_parents(1) := qa_ss_const.from_op_seq_num;

Line 384: x_parents(1) := qa_ss_const.to_op_seq_num;

380: x_parents(1) := qa_ss_const.job_name;
381: x_parents(2) := qa_ss_const.production_line;
382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;
385:
386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
387: x_parents(1) := qa_ss_const.from_op_seq_num;
388:

Line 386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN

382:
383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;
385:
386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
387: x_parents(1) := qa_ss_const.from_op_seq_num;
388:
389: ELSIF p_char_id = qa_ss_const.uom THEN
390:

Line 387: x_parents(1) := qa_ss_const.from_op_seq_num;

383: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
384: x_parents(1) := qa_ss_const.to_op_seq_num;
385:
386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
387: x_parents(1) := qa_ss_const.from_op_seq_num;
388:
389: ELSIF p_char_id = qa_ss_const.uom THEN
390:
391: x_parents(1) := qa_ss_const.item;

Line 389: ELSIF p_char_id = qa_ss_const.uom THEN

385:
386: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
387: x_parents(1) := qa_ss_const.from_op_seq_num;
388:
389: ELSIF p_char_id = qa_ss_const.uom THEN
390:
391: x_parents(1) := qa_ss_const.item;
392: x_parents(2) := qa_ss_const.production_line;
393:

Line 391: x_parents(1) := qa_ss_const.item;

387: x_parents(1) := qa_ss_const.from_op_seq_num;
388:
389: ELSIF p_char_id = qa_ss_const.uom THEN
390:
391: x_parents(1) := qa_ss_const.item;
392: x_parents(2) := qa_ss_const.production_line;
393:
394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;

Line 392: x_parents(2) := qa_ss_const.production_line;

388:
389: ELSIF p_char_id = qa_ss_const.uom THEN
390:
391: x_parents(1) := qa_ss_const.item;
392: x_parents(2) := qa_ss_const.production_line;
393:
394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;

Line 394: ELSIF p_char_id = qa_ss_const.revision THEN

390:
391: x_parents(1) := qa_ss_const.item;
392: x_parents(2) := qa_ss_const.production_line;
393:
394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN

Line 395: x_parents(1) := qa_ss_const.item;

391: x_parents(1) := qa_ss_const.item;
392: x_parents(2) := qa_ss_const.production_line;
393:
394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;

Line 396: x_parents(2) := qa_ss_const.production_line;

392: x_parents(2) := qa_ss_const.production_line;
393:
394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;

Line 398: ELSIF p_char_id = qa_ss_const.subinventory THEN

394: ELSIF p_char_id = qa_ss_const.revision THEN
395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN

Line 399: x_parents(1) := qa_ss_const.item;

395: x_parents(1) := qa_ss_const.item;
396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;

Line 400: x_parents(2) := qa_ss_const.production_line;

396: x_parents(2) := qa_ss_const.production_line;
397:
398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;
404: x_parents(2) := qa_ss_const.item;

Line 402: ELSIF p_char_id = qa_ss_const.locator THEN

398: ELSIF p_char_id = qa_ss_const.subinventory THEN
399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;
404: x_parents(2) := qa_ss_const.item;
405: x_parents(3) := qa_ss_const.production_line;
406:

Line 403: x_parents(1) := qa_ss_const.subinventory;

399: x_parents(1) := qa_ss_const.item;
400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;
404: x_parents(2) := qa_ss_const.item;
405: x_parents(3) := qa_ss_const.production_line;
406:
407: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

Line 404: x_parents(2) := qa_ss_const.item;

400: x_parents(2) := qa_ss_const.production_line;
401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;
404: x_parents(2) := qa_ss_const.item;
405: x_parents(3) := qa_ss_const.production_line;
406:
407: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
408: -- bug 3830258 incorrect LOVs in QWB

Line 405: x_parents(3) := qa_ss_const.production_line;

401:
402: ELSIF p_char_id = qa_ss_const.locator THEN
403: x_parents(1) := qa_ss_const.subinventory;
404: x_parents(2) := qa_ss_const.item;
405: x_parents(3) := qa_ss_const.production_line;
406:
407: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
408: -- bug 3830258 incorrect LOVs in QWB
409: -- synced up the lot number lov with forms

Line 410: ELSIF p_char_id = qa_ss_const.lot_number THEN

406:
407: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
408: -- bug 3830258 incorrect LOVs in QWB
409: -- synced up the lot number lov with forms
410: ELSIF p_char_id = qa_ss_const.lot_number THEN
411: x_parents(1) := qa_ss_const.item;
412: --x_parents(2) := qa_ss_const.production_line;
413:
414: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

Line 411: x_parents(1) := qa_ss_const.item;

407: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
408: -- bug 3830258 incorrect LOVs in QWB
409: -- synced up the lot number lov with forms
410: ELSIF p_char_id = qa_ss_const.lot_number THEN
411: x_parents(1) := qa_ss_const.item;
412: --x_parents(2) := qa_ss_const.production_line;
413:
414: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
415: -- bug 3830258 incorrect LOVs in QWB

Line 412: --x_parents(2) := qa_ss_const.production_line;

408: -- bug 3830258 incorrect LOVs in QWB
409: -- synced up the lot number lov with forms
410: ELSIF p_char_id = qa_ss_const.lot_number THEN
411: x_parents(1) := qa_ss_const.item;
412: --x_parents(2) := qa_ss_const.production_line;
413:
414: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
415: -- bug 3830258 incorrect LOVs in QWB
416: -- synced up the serial number lov with forms

Line 417: ELSIF p_char_id = qa_ss_const.serial_number THEN

413:
414: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
415: -- bug 3830258 incorrect LOVs in QWB
416: -- synced up the serial number lov with forms
417: ELSIF p_char_id = qa_ss_const.serial_number THEN
418: x_parents(1) := qa_ss_const.lot_number;
419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;

Line 418: x_parents(1) := qa_ss_const.lot_number;

414: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
415: -- bug 3830258 incorrect LOVs in QWB
416: -- synced up the serial number lov with forms
417: ELSIF p_char_id = qa_ss_const.serial_number THEN
418: x_parents(1) := qa_ss_const.lot_number;
419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:

Line 419: x_parents(2) := qa_ss_const.item;

415: -- bug 3830258 incorrect LOVs in QWB
416: -- synced up the serial number lov with forms
417: ELSIF p_char_id = qa_ss_const.serial_number THEN
418: x_parents(1) := qa_ss_const.lot_number;
419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN

Line 420: --x_parents(3) := qa_ss_const.production_line;

416: -- synced up the serial number lov with forms
417: ELSIF p_char_id = qa_ss_const.serial_number THEN
418: x_parents(1) := qa_ss_const.lot_number;
419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;

Line 421: x_parents(3) := qa_ss_const.revision;

417: ELSIF p_char_id = qa_ss_const.serial_number THEN
418: x_parents(1) := qa_ss_const.lot_number;
419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;
425:

Line 423: ELSIF p_char_id = qa_ss_const.comp_uom THEN

419: x_parents(2) := qa_ss_const.item;
420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;
425:
426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;

Line 424: x_parents(1) := qa_ss_const.comp_item;

420: --x_parents(3) := qa_ss_const.production_line;
421: x_parents(3) := qa_ss_const.revision;
422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;
425:
426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;
428:

Line 426: ELSIF p_char_id = qa_ss_const.comp_revision THEN

422:
423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;
425:
426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;
428:
429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;

Line 427: x_parents(1) := qa_ss_const.comp_item;

423: ELSIF p_char_id = qa_ss_const.comp_uom THEN
424: x_parents(1) := qa_ss_const.comp_item;
425:
426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;
428:
429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;
431:

Line 429: ELSIF p_char_id = qa_ss_const.po_line_num THEN

425:
426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;
428:
429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;
431:
432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
433: x_parents(1) := qa_ss_const.po_line_num;

Line 430: x_parents(1) := qa_ss_const.po_number;

426: ELSIF p_char_id = qa_ss_const.comp_revision THEN
427: x_parents(1) := qa_ss_const.comp_item;
428:
429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;
431:
432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;

Line 432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN

428:
429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;
431:
432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;
435: -- Bug 9817478. Added PO Release Num as parent
436: -- for PO Shipment(for Blanket POs). skolluku.

Line 433: x_parents(1) := qa_ss_const.po_line_num;

429: ELSIF p_char_id = qa_ss_const.po_line_num THEN
430: x_parents(1) := qa_ss_const.po_number;
431:
432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;
435: -- Bug 9817478. Added PO Release Num as parent
436: -- for PO Shipment(for Blanket POs). skolluku.
437: x_parents(3) := qa_ss_const.po_release_num;

Line 434: x_parents(2) := qa_ss_const.po_number;

430: x_parents(1) := qa_ss_const.po_number;
431:
432: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;
435: -- Bug 9817478. Added PO Release Num as parent
436: -- for PO Shipment(for Blanket POs). skolluku.
437: x_parents(3) := qa_ss_const.po_release_num;
438:

Line 437: x_parents(3) := qa_ss_const.po_release_num;

433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;
435: -- Bug 9817478. Added PO Release Num as parent
436: -- for PO Shipment(for Blanket POs). skolluku.
437: x_parents(3) := qa_ss_const.po_release_num;
438:
439: ELSIF p_char_id = qa_ss_const.po_release_num THEN
440: x_parents(1) := qa_ss_const.po_number;
441: -- Bug 9817478. Added po_line as a parent.

Line 439: ELSIF p_char_id = qa_ss_const.po_release_num THEN

435: -- Bug 9817478. Added PO Release Num as parent
436: -- for PO Shipment(for Blanket POs). skolluku.
437: x_parents(3) := qa_ss_const.po_release_num;
438:
439: ELSIF p_char_id = qa_ss_const.po_release_num THEN
440: x_parents(1) := qa_ss_const.po_number;
441: -- Bug 9817478. Added po_line as a parent.
442: -- skolluku.
443: x_parents(2) := qa_ss_const.po_line_num;

Line 440: x_parents(1) := qa_ss_const.po_number;

436: -- for PO Shipment(for Blanket POs). skolluku.
437: x_parents(3) := qa_ss_const.po_release_num;
438:
439: ELSIF p_char_id = qa_ss_const.po_release_num THEN
440: x_parents(1) := qa_ss_const.po_number;
441: -- Bug 9817478. Added po_line as a parent.
442: -- skolluku.
443: x_parents(2) := qa_ss_const.po_line_num;
444:

Line 443: x_parents(2) := qa_ss_const.po_line_num;

439: ELSIF p_char_id = qa_ss_const.po_release_num THEN
440: x_parents(1) := qa_ss_const.po_number;
441: -- Bug 9817478. Added po_line as a parent.
442: -- skolluku.
443: x_parents(2) := qa_ss_const.po_line_num;
444:
445: ELSIF p_char_id = qa_ss_const.order_line THEN
446: x_parents(1) := qa_ss_const.sales_order;
447:

Line 445: ELSIF p_char_id = qa_ss_const.order_line THEN

441: -- Bug 9817478. Added po_line as a parent.
442: -- skolluku.
443: x_parents(2) := qa_ss_const.po_line_num;
444:
445: ELSIF p_char_id = qa_ss_const.order_line THEN
446: x_parents(1) := qa_ss_const.sales_order;
447:
448: ELSIF p_char_id = qa_ss_const.task_number THEN
449: x_parents(1) := qa_ss_const.project_number;

Line 446: x_parents(1) := qa_ss_const.sales_order;

442: -- skolluku.
443: x_parents(2) := qa_ss_const.po_line_num;
444:
445: ELSIF p_char_id = qa_ss_const.order_line THEN
446: x_parents(1) := qa_ss_const.sales_order;
447:
448: ELSIF p_char_id = qa_ss_const.task_number THEN
449: x_parents(1) := qa_ss_const.project_number;
450:

Line 448: ELSIF p_char_id = qa_ss_const.task_number THEN

444:
445: ELSIF p_char_id = qa_ss_const.order_line THEN
446: x_parents(1) := qa_ss_const.sales_order;
447:
448: ELSIF p_char_id = qa_ss_const.task_number THEN
449: x_parents(1) := qa_ss_const.project_number;
450:
451: --dgupta: Start R12 EAM Integration. Bug 4345492
452: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

Line 449: x_parents(1) := qa_ss_const.project_number;

445: ELSIF p_char_id = qa_ss_const.order_line THEN
446: x_parents(1) := qa_ss_const.sales_order;
447:
448: ELSIF p_char_id = qa_ss_const.task_number THEN
449: x_parents(1) := qa_ss_const.project_number;
450:
451: --dgupta: Start R12 EAM Integration. Bug 4345492
452: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
453: x_parents(1) := qa_ss_const.asset_group;

Line 452: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

448: ELSIF p_char_id = qa_ss_const.task_number THEN
449: x_parents(1) := qa_ss_const.project_number;
450:
451: --dgupta: Start R12 EAM Integration. Bug 4345492
452: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
453: x_parents(1) := qa_ss_const.asset_group;
454: -- bug 13841504
455: -- The asset instance number lov would no longer depend on
456: -- the Asset serial number

Line 453: x_parents(1) := qa_ss_const.asset_group;

449: x_parents(1) := qa_ss_const.project_number;
450:
451: --dgupta: Start R12 EAM Integration. Bug 4345492
452: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
453: x_parents(1) := qa_ss_const.asset_group;
454: -- bug 13841504
455: -- The asset instance number lov would no longer depend on
456: -- the Asset serial number
457: --x_parents(2) := qa_ss_const.asset_number;

Line 457: --x_parents(2) := qa_ss_const.asset_number;

453: x_parents(1) := qa_ss_const.asset_group;
454: -- bug 13841504
455: -- The asset instance number lov would no longer depend on
456: -- the Asset serial number
457: --x_parents(2) := qa_ss_const.asset_number;
458:
459: ELSIF p_char_id = qa_ss_const.asset_number THEN
460: x_parents(1) := qa_ss_const.asset_group;
461: x_parents(2) := qa_ss_const.asset_instance_number;

Line 459: ELSIF p_char_id = qa_ss_const.asset_number THEN

455: -- The asset instance number lov would no longer depend on
456: -- the Asset serial number
457: --x_parents(2) := qa_ss_const.asset_number;
458:
459: ELSIF p_char_id = qa_ss_const.asset_number THEN
460: x_parents(1) := qa_ss_const.asset_group;
461: x_parents(2) := qa_ss_const.asset_instance_number;
462:
463: -- rkaza. 12/02/2003. bug 3215372.

Line 460: x_parents(1) := qa_ss_const.asset_group;

456: -- the Asset serial number
457: --x_parents(2) := qa_ss_const.asset_number;
458:
459: ELSIF p_char_id = qa_ss_const.asset_number THEN
460: x_parents(1) := qa_ss_const.asset_group;
461: x_parents(2) := qa_ss_const.asset_instance_number;
462:
463: -- rkaza. 12/02/2003. bug 3215372.
464: -- Both asset group and asset number were being assigned to x_parents(1)

Line 461: x_parents(2) := qa_ss_const.asset_instance_number;

457: --x_parents(2) := qa_ss_const.asset_number;
458:
459: ELSIF p_char_id = qa_ss_const.asset_number THEN
460: x_parents(1) := qa_ss_const.asset_group;
461: x_parents(2) := qa_ss_const.asset_instance_number;
462:
463: -- rkaza. 12/02/2003. bug 3215372.
464: -- Both asset group and asset number were being assigned to x_parents(1)
465: ELSIF p_char_id = qa_ss_const.asset_activity THEN

Line 465: ELSIF p_char_id = qa_ss_const.asset_activity THEN

461: x_parents(2) := qa_ss_const.asset_instance_number;
462:
463: -- rkaza. 12/02/2003. bug 3215372.
464: -- Both asset group and asset number were being assigned to x_parents(1)
465: ELSIF p_char_id = qa_ss_const.asset_activity THEN
466: x_parents(1) := qa_ss_const.asset_group;
467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:

Line 466: x_parents(1) := qa_ss_const.asset_group;

462:
463: -- rkaza. 12/02/2003. bug 3215372.
464: -- Both asset group and asset number were being assigned to x_parents(1)
465: ELSIF p_char_id = qa_ss_const.asset_activity THEN
466: x_parents(1) := qa_ss_const.asset_group;
467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN

Line 467: x_parents(2) := qa_ss_const.asset_number;

463: -- rkaza. 12/02/2003. bug 3215372.
464: -- Both asset group and asset number were being assigned to x_parents(1)
465: ELSIF p_char_id = qa_ss_const.asset_activity THEN
466: x_parents(1) := qa_ss_const.asset_group;
467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;

Line 468: x_parents(3) := qa_ss_const.asset_instance_number;

464: -- Both asset group and asset number were being assigned to x_parents(1)
465: ELSIF p_char_id = qa_ss_const.asset_activity THEN
466: x_parents(1) := qa_ss_const.asset_group;
467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;
472: x_parents(2) := qa_ss_const.asset_number;

Line 470: ELSIF p_char_id = qa_ss_const.followup_activity THEN

466: x_parents(1) := qa_ss_const.asset_group;
467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;
472: x_parents(2) := qa_ss_const.asset_number;
473: x_parents(3) := qa_ss_const.asset_instance_number;
474: --dgupta: End R12 EAM Integration. Bug 4345492

Line 471: x_parents(1) := qa_ss_const.asset_group;

467: x_parents(2) := qa_ss_const.asset_number;
468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;
472: x_parents(2) := qa_ss_const.asset_number;
473: x_parents(3) := qa_ss_const.asset_instance_number;
474: --dgupta: End R12 EAM Integration. Bug 4345492
475:

Line 472: x_parents(2) := qa_ss_const.asset_number;

468: x_parents(3) := qa_ss_const.asset_instance_number;
469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;
472: x_parents(2) := qa_ss_const.asset_number;
473: x_parents(3) := qa_ss_const.asset_instance_number;
474: --dgupta: End R12 EAM Integration. Bug 4345492
475:
476: -- rkaza. 12/02/2003. bug 3215404.

Line 473: x_parents(3) := qa_ss_const.asset_instance_number;

469:
470: ELSIF p_char_id = qa_ss_const.followup_activity THEN
471: x_parents(1) := qa_ss_const.asset_group;
472: x_parents(2) := qa_ss_const.asset_number;
473: x_parents(3) := qa_ss_const.asset_instance_number;
474: --dgupta: End R12 EAM Integration. Bug 4345492
475:
476: -- rkaza. 12/02/2003. bug 3215404.
477: -- Added dependency relation for maintenance op seq with maintenance

Line 479: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

475:
476: -- rkaza. 12/02/2003. bug 3215404.
477: -- Added dependency relation for maintenance op seq with maintenance
478: -- work order.
479: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
480: x_parents(1) := qa_ss_const.work_order;
481:
482: -- rkaza. 12/02/2003. bug 3280307.
483: -- Added dependency relation for component item with item

Line 480: x_parents(1) := qa_ss_const.work_order;

476: -- rkaza. 12/02/2003. bug 3215404.
477: -- Added dependency relation for maintenance op seq with maintenance
478: -- work order.
479: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
480: x_parents(1) := qa_ss_const.work_order;
481:
482: -- rkaza. 12/02/2003. bug 3280307.
483: -- Added dependency relation for component item with item
484: ELSIF p_char_id = qa_ss_const.comp_item THEN

Line 484: ELSIF p_char_id = qa_ss_const.comp_item THEN

480: x_parents(1) := qa_ss_const.work_order;
481:
482: -- rkaza. 12/02/2003. bug 3280307.
483: -- Added dependency relation for component item with item
484: ELSIF p_char_id = qa_ss_const.comp_item THEN
485: x_parents(1) := qa_ss_const.item;
486:
487: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
488: -- bug 3830258 incorrect LOVs in QWB

Line 485: x_parents(1) := qa_ss_const.item;

481:
482: -- rkaza. 12/02/2003. bug 3280307.
483: -- Added dependency relation for component item with item
484: ELSIF p_char_id = qa_ss_const.comp_item THEN
485: x_parents(1) := qa_ss_const.item;
486:
487: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
488: -- bug 3830258 incorrect LOVs in QWB
489: -- synced up the component lot number and component serial number

Line 491: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN

487: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
488: -- bug 3830258 incorrect LOVs in QWB
489: -- synced up the component lot number and component serial number
490: -- lov with forms
491: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
492: x_parents(1) := qa_ss_const.comp_item;
493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;

Line 492: x_parents(1) := qa_ss_const.comp_item;

488: -- bug 3830258 incorrect LOVs in QWB
489: -- synced up the component lot number and component serial number
490: -- lov with forms
491: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
492: x_parents(1) := qa_ss_const.comp_item;
493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;
496: x_parents(2) := qa_ss_const.comp_item;

Line 494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN

490: -- lov with forms
491: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
492: x_parents(1) := qa_ss_const.comp_item;
493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;
496: x_parents(2) := qa_ss_const.comp_item;
497: x_parents(3) := qa_ss_const.comp_revision;
498:

Line 495: x_parents(1) := qa_ss_const.comp_lot_number;

491: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
492: x_parents(1) := qa_ss_const.comp_item;
493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;
496: x_parents(2) := qa_ss_const.comp_item;
497: x_parents(3) := qa_ss_const.comp_revision;
498:
499: -- R12 OPM Deviations. Bug 4345503 Start

Line 496: x_parents(2) := qa_ss_const.comp_item;

492: x_parents(1) := qa_ss_const.comp_item;
493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;
496: x_parents(2) := qa_ss_const.comp_item;
497: x_parents(3) := qa_ss_const.comp_revision;
498:
499: -- R12 OPM Deviations. Bug 4345503 Start
500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

Line 497: x_parents(3) := qa_ss_const.comp_revision;

493:
494: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
495: x_parents(1) := qa_ss_const.comp_lot_number;
496: x_parents(2) := qa_ss_const.comp_item;
497: x_parents(3) := qa_ss_const.comp_revision;
498:
499: -- R12 OPM Deviations. Bug 4345503 Start
500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
501: x_parents(1) := qa_ss_const.process_batch_num;

Line 500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

496: x_parents(2) := qa_ss_const.comp_item;
497: x_parents(3) := qa_ss_const.comp_revision;
498:
499: -- R12 OPM Deviations. Bug 4345503 Start
500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
501: x_parents(1) := qa_ss_const.process_batch_num;
502:
503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;

Line 501: x_parents(1) := qa_ss_const.process_batch_num;

497: x_parents(3) := qa_ss_const.comp_revision;
498:
499: -- R12 OPM Deviations. Bug 4345503 Start
500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
501: x_parents(1) := qa_ss_const.process_batch_num;
502:
503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 503: ELSIF p_char_id = qa_ss_const.process_operation THEN

499: -- R12 OPM Deviations. Bug 4345503 Start
500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
501: x_parents(1) := qa_ss_const.process_batch_num;
502:
503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN

Line 504: x_parents(1) := qa_ss_const.process_batch_num;

500: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
501: x_parents(1) := qa_ss_const.process_batch_num;
502:
503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;

Line 505: x_parents(2) := qa_ss_const.process_batchstep_num;

501: x_parents(1) := qa_ss_const.process_batch_num;
502:
503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 507: ELSIF p_char_id = qa_ss_const.process_activity THEN

503: ELSIF p_char_id = qa_ss_const.process_operation THEN
504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN

Line 508: x_parents(1) := qa_ss_const.process_batch_num;

504: x_parents(1) := qa_ss_const.process_batch_num;
505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;

Line 509: x_parents(2) := qa_ss_const.process_batchstep_num;

505: x_parents(2) := qa_ss_const.process_batchstep_num;
506:
507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 511: ELSIF p_char_id = qa_ss_const.process_resource THEN

507: ELSIF p_char_id = qa_ss_const.process_activity THEN
508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:

Line 512: x_parents(1) := qa_ss_const.process_batch_num;

508: x_parents(1) := qa_ss_const.process_batch_num;
509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:
516: ELSIF p_char_id = qa_ss_const.process_parameter THEN

Line 513: x_parents(2) := qa_ss_const.process_batchstep_num;

509: x_parents(2) := qa_ss_const.process_batchstep_num;
510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:
516: ELSIF p_char_id = qa_ss_const.process_parameter THEN
517: x_parents(1) := qa_ss_const.process_resource;

Line 514: x_parents(3) := qa_ss_const.process_activity;

510:
511: ELSIF p_char_id = qa_ss_const.process_resource THEN
512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:
516: ELSIF p_char_id = qa_ss_const.process_parameter THEN
517: x_parents(1) := qa_ss_const.process_resource;
518: -- R12 OPM Deviations. Bug 4345503 End

Line 516: ELSIF p_char_id = qa_ss_const.process_parameter THEN

512: x_parents(1) := qa_ss_const.process_batch_num;
513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:
516: ELSIF p_char_id = qa_ss_const.process_parameter THEN
517: x_parents(1) := qa_ss_const.process_resource;
518: -- R12 OPM Deviations. Bug 4345503 End
519:
520: --

Line 517: x_parents(1) := qa_ss_const.process_resource;

513: x_parents(2) := qa_ss_const.process_batchstep_num;
514: x_parents(3) := qa_ss_const.process_activity;
515:
516: ELSIF p_char_id = qa_ss_const.process_parameter THEN
517: x_parents(1) := qa_ss_const.process_resource;
518: -- R12 OPM Deviations. Bug 4345503 End
519:
520: --
521: -- Bug 6161802

Line 525: ELSIF p_char_id = qa_ss_const.rma_line_num THEN

521: -- Bug 6161802
522: -- Added dependency relation for rma line number with rma number
523: -- skolluku Thu Mon Jul 16 22:08:16 PDT 2007
524: --
525: ELSIF p_char_id = qa_ss_const.rma_line_num THEN
526: x_parents(1) := qa_ss_const.rma_number;
527:
528: --
529: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009

Line 526: x_parents(1) := qa_ss_const.rma_number;

522: -- Added dependency relation for rma line number with rma number
523: -- skolluku Thu Mon Jul 16 22:08:16 PDT 2007
524: --
525: ELSIF p_char_id = qa_ss_const.rma_line_num THEN
526: x_parents(1) := qa_ss_const.rma_number;
527:
528: --
529: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009
530: -- Added dependency relation for SO line number with SO number

Line 532: ELSIF p_char_id = qa_ss_const.order_line THEN

528: --
529: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009
530: -- Added dependency relation for SO line number with SO number
531: --
532: ELSIF p_char_id = qa_ss_const.order_line THEN
533: x_parents(1) := qa_ss_const.sales_order;
534:
535: -- Bug 7588754.pdube Wed Apr 15 07:37:25 PDT 2009
536: -- Added dependency on item and srl number

Line 533: x_parents(1) := qa_ss_const.sales_order;

529: -- Bug 7716875.pdube Mon Apr 13 03:25:19 PDT 2009
530: -- Added dependency relation for SO line number with SO number
531: --
532: ELSIF p_char_id = qa_ss_const.order_line THEN
533: x_parents(1) := qa_ss_const.sales_order;
534:
535: -- Bug 7588754.pdube Wed Apr 15 07:37:25 PDT 2009
536: -- Added dependency on item and srl number
537: ELSIF p_char_id = qa_ss_const.serial_status THEN

Line 537: ELSIF p_char_id = qa_ss_const.serial_status THEN

533: x_parents(1) := qa_ss_const.sales_order;
534:
535: -- Bug 7588754.pdube Wed Apr 15 07:37:25 PDT 2009
536: -- Added dependency on item and srl number
537: ELSIF p_char_id = qa_ss_const.serial_status THEN
538: x_parents(1) := qa_ss_const.item;
539: x_parents(2) := qa_ss_const.serial_number;
540: --
541: -- Bug 9032151

Line 538: x_parents(1) := qa_ss_const.item;

534:
535: -- Bug 7588754.pdube Wed Apr 15 07:37:25 PDT 2009
536: -- Added dependency on item and srl number
537: ELSIF p_char_id = qa_ss_const.serial_status THEN
538: x_parents(1) := qa_ss_const.item;
539: x_parents(2) := qa_ss_const.serial_number;
540: --
541: -- Bug 9032151
542: -- Added dependency relation for item instance with item

Line 539: x_parents(2) := qa_ss_const.serial_number;

535: -- Bug 7588754.pdube Wed Apr 15 07:37:25 PDT 2009
536: -- Added dependency on item and srl number
537: ELSIF p_char_id = qa_ss_const.serial_status THEN
538: x_parents(1) := qa_ss_const.item;
539: x_parents(2) := qa_ss_const.serial_number;
540: --
541: -- Bug 9032151
542: -- Added dependency relation for item instance with item
543: -- skolluku

Line 545: ELSIF p_char_id = qa_ss_const.item_instance THEN

541: -- Bug 9032151
542: -- Added dependency relation for item instance with item
543: -- skolluku
544: --
545: ELSIF p_char_id = qa_ss_const.item_instance THEN
546: x_parents(1) := qa_ss_const.item;
547: --
548: -- Bug 9359442
549: -- Added dependency relation for item instance serial with item

Line 546: x_parents(1) := qa_ss_const.item;

542: -- Added dependency relation for item instance with item
543: -- skolluku
544: --
545: ELSIF p_char_id = qa_ss_const.item_instance THEN
546: x_parents(1) := qa_ss_const.item;
547: --
548: -- Bug 9359442
549: -- Added dependency relation for item instance serial with item
550: -- skolluku

Line 552: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN

548: -- Bug 9359442
549: -- Added dependency relation for item instance serial with item
550: -- skolluku
551: --
552: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN
553: x_parents(1) := qa_ss_const.item;
554:
555: --
556: -- Bug 13638890

Line 553: x_parents(1) := qa_ss_const.item;

549: -- Added dependency relation for item instance serial with item
550: -- skolluku
551: --
552: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN
553: x_parents(1) := qa_ss_const.item;
554:
555: --
556: -- Bug 13638890
557: -- Added dependency relation for to_subinventory with item

Line 561: ELSIF p_char_id = qa_ss_const.to_subinventory THEN

557: -- Added dependency relation for to_subinventory with item
558: -- added dependency relation for to_locator with subinventory and item
559: -- hmakam
560: --
561: ELSIF p_char_id = qa_ss_const.to_subinventory THEN
562: x_parents(1) := qa_ss_const.item;
563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN

Line 562: x_parents(1) := qa_ss_const.item;

558: -- added dependency relation for to_locator with subinventory and item
559: -- hmakam
560: --
561: ELSIF p_char_id = qa_ss_const.to_subinventory THEN
562: x_parents(1) := qa_ss_const.item;
563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;

Line 563: x_parents(2) := qa_ss_const.production_line;

559: -- hmakam
560: --
561: ELSIF p_char_id = qa_ss_const.to_subinventory THEN
562: x_parents(1) := qa_ss_const.item;
563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;
567: x_parents(2) := qa_ss_const.item;

Line 565: ELSIF p_char_id = qa_ss_const.to_locator THEN

561: ELSIF p_char_id = qa_ss_const.to_subinventory THEN
562: x_parents(1) := qa_ss_const.item;
563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;
567: x_parents(2) := qa_ss_const.item;
568: x_parents(3) := qa_ss_const.production_line;
569: END IF;

Line 566: x_parents(1) := qa_ss_const.to_subinventory;

562: x_parents(1) := qa_ss_const.item;
563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;
567: x_parents(2) := qa_ss_const.item;
568: x_parents(3) := qa_ss_const.production_line;
569: END IF;
570:

Line 567: x_parents(2) := qa_ss_const.item;

563: x_parents(2) := qa_ss_const.production_line;
564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;
567: x_parents(2) := qa_ss_const.item;
568: x_parents(3) := qa_ss_const.production_line;
569: END IF;
570:
571: END get_lov_dependencies;

Line 568: x_parents(3) := qa_ss_const.production_line;

564:
565: ELSIF p_char_id = qa_ss_const.to_locator THEN
566: x_parents(1) := qa_ss_const.to_subinventory;
567: x_parents(2) := qa_ss_const.item;
568: x_parents(3) := qa_ss_const.production_line;
569: END IF;
570:
571: END get_lov_dependencies;
572:

Line 723: IF(p_id = qa_ss_const.po_number OR

719: -- bug 5383667
720: -- Added check for Party Name
721: -- ntungare
722: --
723: IF(p_id = qa_ss_const.po_number OR
724: p_id = qa_ss_const.party_name) THEN
725: return qa_chars_api.hardcoded_column(p_id);
726: END IF;
727:

Line 724: p_id = qa_ss_const.party_name) THEN

720: -- Added check for Party Name
721: -- ntungare
722: --
723: IF(p_id = qa_ss_const.po_number OR
724: p_id = qa_ss_const.party_name) THEN
725: return qa_chars_api.hardcoded_column(p_id);
726: END IF;
727:
728: return construct_code(p_element_prefix,p_id);

Line 959: if((p_char_id = qa_ss_const.po_number) OR

955: -- bug 5383667
956: -- added the party name to the list of normalized vals
957: -- ntungare
958: --
959: if((p_char_id = qa_ss_const.po_number) OR
960: (p_char_id = qa_ss_const.party_name))then
961: return 'T';
962: end if;
963:

Line 960: (p_char_id = qa_ss_const.party_name))then

956: -- added the party name to the list of normalized vals
957: -- ntungare
958: --
959: if((p_char_id = qa_ss_const.po_number) OR
960: (p_char_id = qa_ss_const.party_name))then
961: return 'T';
962: end if;
963:
964: return 'F';

Line 981: if(p_char_id = qa_ss_const.po_number) then

977: -- currently we are enabling normalized logic
978: -- only for PO NUMBER. So we are hard coding
979: -- lov region name. In future, this proc must
980: -- be generalized.
981: if(p_char_id = qa_ss_const.po_number) then
982: return 'PONumberLovRN';
983: --
984: -- bug 5383667
985: -- getting the region LOV region name for

Line 991: elsif (p_char_id = qa_ss_const.party_name) then

987: -- region for the Part name, however we should
988: -- later use a common region for all the normalized
989: -- id elements
990: --
991: elsif (p_char_id = qa_ss_const.party_name) then
992: return 'PartyLovRN';
993: end if;
994:
995: return 'QaLovRN';

Line 1025: IF(p_char_id = qa_ss_const.po_number) THEN

1021: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
1022: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
1023: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
1024:
1025: IF(p_char_id = qa_ss_const.po_number) THEN
1026: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
1027: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1028: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1029: lovMap);

Line 1042: ELSIF(p_char_id = qa_ss_const.party_name) THEN

1038: -- bug 5383667
1039: -- Processing for the Party Name element
1040: -- ntungare
1041: --
1042: ELSIF(p_char_id = qa_ss_const.party_name) THEN
1043: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
1044: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
1045: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
1046: lovMap);

Line 1836: IF (r.char_id = qa_ss_const.po_number OR

1832: -- ntungare
1833: --
1834: -- Requires code addition for Adanced Table
1835: -- todo saugupta
1836: IF (r.char_id = qa_ss_const.po_number OR
1837: r.char_id = qa_ss_const.party_name) AND
1838: (p_parent_region_prefix <> g_eqr_mult_dtl_prefix OR
1839: p_parent_region_prefix IS NULL) THEN
1840: -- Bug 9381413

Line 1837: r.char_id = qa_ss_const.party_name) AND

1833: --
1834: -- Requires code addition for Adanced Table
1835: -- todo saugupta
1836: IF (r.char_id = qa_ss_const.po_number OR
1837: r.char_id = qa_ss_const.party_name) AND
1838: (p_parent_region_prefix <> g_eqr_mult_dtl_prefix OR
1839: p_parent_region_prefix IS NULL) THEN
1840: -- Bug 9381413
1841: -- Added IF-ESLIF ladder to set the bool variables appropriately and

Line 1844: IF (r.char_id = qa_ss_const.po_number) THEN

1840: -- Bug 9381413
1841: -- Added IF-ESLIF ladder to set the bool variables appropriately and
1842: -- moved the existing code outside the loop.
1843: -- skolluku
1844: IF (r.char_id = qa_ss_const.po_number) THEN
1845: l_po_num_exists := true;
1846: ELSIF (r.char_id = qa_ss_const.party_name) THEN
1847: l_party_exists := true;
1848: END IF;

Line 1846: ELSIF (r.char_id = qa_ss_const.party_name) THEN

1842: -- moved the existing code outside the loop.
1843: -- skolluku
1844: IF (r.char_id = qa_ss_const.po_number) THEN
1845: l_po_num_exists := true;
1846: ELSIF (r.char_id = qa_ss_const.party_name) THEN
1847: l_party_exists := true;
1848: END IF;
1849: -- l_id_item := create_id_item_for_eqr(p_plan_id,r.char_id);
1850: -- add_child_to_parent(p_content_region, l_id_item, 'contents');

Line 1860: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.po_number);

1856: -- Bug 9381413
1857: -- Add the form values for PO Number and Party Name, if required.
1858: -- skolluku
1859: IF (l_po_num_exists) THEN
1860: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.po_number);
1861: add_child_to_parent(p_content_region, l_id_item, 'contents');
1862: END IF;
1863:
1864: IF (l_party_exists) THEN

Line 1865: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.party_name);

1861: add_child_to_parent(p_content_region, l_id_item, 'contents');
1862: END IF;
1863:
1864: IF (l_party_exists) THEN
1865: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.party_name);
1866: add_child_to_parent(p_content_region, l_id_item, 'contents');
1867: END IF;
1868:
1869: RETURN char_count;

Line 3415: OPEN valueLookups(qa_ss_const.nonconformance_source);

3411: -- admin will create one personalization per each Nonconformance Source (or Request type)
3412: --
3413: -- still map one with normal naming scheme
3414: IF l_template_plan_id in (18, 35) THEN -- Nonconformance master
3415: OPEN valueLookups(qa_ss_const.nonconformance_source);
3416: LOOP
3417: FETCH valueLookups INTO l_short_code, l_hash_code;
3418: EXIT WHEN valueLookups%NOTFOUND;
3419: -- map_plan_eqr_single(p_plan_id, g_ncm || l_short_code || '_');

Line 3429: OPEN valueLookups(2147483607); -- should be qa_ss_const.request_type

3425:
3426: END LOOP;
3427: CLOSE valueLookups;
3428: ELSIF l_template_plan_id = 65 THEN -- Corrective Action Request
3429: OPEN valueLookups(2147483607); -- should be qa_ss_const.request_type
3430: LOOP
3431: FETCH valueLookups INTO l_short_code, l_hash_code;
3432: EXIT WHEN valueLookups%NOTFOUND;
3433: -- map_plan_eqr_single(p_plan_id, g_car || l_short_code || '_');

Line 3529: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;

3525:
3526: SELECT jrad_upgrade_ver
3527: INTO l_seed_ver
3528: FROM qa_plans
3529: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
3530:
3531: fnd_msg_pub.initialize;
3532:
3533: l_eqr_single_doc := g_jrad_region_path || construct_code(

Line 3624: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)

3620: UPDATE qa_plans
3621: SET jrad_upgrade_ver =
3622: (SELECT nvl(jrad_upgrade_ver, 1)
3623: FROM qa_plans
3624: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)
3625: WHERE plan_id = p_plan_id;
3626: END jrad_upgraded;
3627:
3628: