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:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN

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:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;

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:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;
438:

Line 436: ELSIF p_char_id = qa_ss_const.po_release_num THEN

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:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;
438:
439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;

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

433: x_parents(1) := qa_ss_const.po_line_num;
434: x_parents(2) := qa_ss_const.po_number;
435:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;
438:
439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;
441:

Line 439: ELSIF p_char_id = qa_ss_const.order_line THEN

435:
436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;
438:
439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;
441:
442: ELSIF p_char_id = qa_ss_const.task_number THEN
443: x_parents(1) := qa_ss_const.project_number;

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

436: ELSIF p_char_id = qa_ss_const.po_release_num THEN
437: x_parents(1) := qa_ss_const.po_number;
438:
439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;
441:
442: ELSIF p_char_id = qa_ss_const.task_number THEN
443: x_parents(1) := qa_ss_const.project_number;
444:

Line 442: ELSIF p_char_id = qa_ss_const.task_number THEN

438:
439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;
441:
442: ELSIF p_char_id = qa_ss_const.task_number THEN
443: x_parents(1) := qa_ss_const.project_number;
444:
445: --dgupta: Start R12 EAM Integration. Bug 4345492
446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

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

439: ELSIF p_char_id = qa_ss_const.order_line THEN
440: x_parents(1) := qa_ss_const.sales_order;
441:
442: ELSIF p_char_id = qa_ss_const.task_number THEN
443: x_parents(1) := qa_ss_const.project_number;
444:
445: --dgupta: Start R12 EAM Integration. Bug 4345492
446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
447: x_parents(1) := qa_ss_const.asset_group;

Line 446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

442: ELSIF p_char_id = qa_ss_const.task_number THEN
443: x_parents(1) := qa_ss_const.project_number;
444:
445: --dgupta: Start R12 EAM Integration. Bug 4345492
446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
447: x_parents(1) := qa_ss_const.asset_group;
448: x_parents(2) := qa_ss_const.asset_number;
449:
450: ELSIF p_char_id = qa_ss_const.asset_number THEN

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

443: x_parents(1) := qa_ss_const.project_number;
444:
445: --dgupta: Start R12 EAM Integration. Bug 4345492
446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
447: x_parents(1) := qa_ss_const.asset_group;
448: x_parents(2) := qa_ss_const.asset_number;
449:
450: ELSIF p_char_id = qa_ss_const.asset_number THEN
451: x_parents(1) := qa_ss_const.asset_group;

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

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

Line 450: ELSIF p_char_id = qa_ss_const.asset_number THEN

446: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
447: x_parents(1) := qa_ss_const.asset_group;
448: x_parents(2) := qa_ss_const.asset_number;
449:
450: ELSIF p_char_id = qa_ss_const.asset_number THEN
451: x_parents(1) := qa_ss_const.asset_group;
452: x_parents(2) := qa_ss_const.asset_instance_number;
453:
454: -- rkaza. 12/02/2003. bug 3215372.

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

447: x_parents(1) := qa_ss_const.asset_group;
448: x_parents(2) := qa_ss_const.asset_number;
449:
450: ELSIF p_char_id = qa_ss_const.asset_number THEN
451: x_parents(1) := qa_ss_const.asset_group;
452: x_parents(2) := qa_ss_const.asset_instance_number;
453:
454: -- rkaza. 12/02/2003. bug 3215372.
455: -- Both asset group and asset number were being assigned to x_parents(1)

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

448: x_parents(2) := qa_ss_const.asset_number;
449:
450: ELSIF p_char_id = qa_ss_const.asset_number THEN
451: x_parents(1) := qa_ss_const.asset_group;
452: x_parents(2) := qa_ss_const.asset_instance_number;
453:
454: -- rkaza. 12/02/2003. bug 3215372.
455: -- Both asset group and asset number were being assigned to x_parents(1)
456: ELSIF p_char_id = qa_ss_const.asset_activity THEN

Line 456: ELSIF p_char_id = qa_ss_const.asset_activity THEN

452: x_parents(2) := qa_ss_const.asset_instance_number;
453:
454: -- rkaza. 12/02/2003. bug 3215372.
455: -- Both asset group and asset number were being assigned to x_parents(1)
456: ELSIF p_char_id = qa_ss_const.asset_activity THEN
457: x_parents(1) := qa_ss_const.asset_group;
458: x_parents(2) := qa_ss_const.asset_number;
459: x_parents(3) := qa_ss_const.asset_instance_number;
460:

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

453:
454: -- rkaza. 12/02/2003. bug 3215372.
455: -- Both asset group and asset number were being assigned to x_parents(1)
456: ELSIF p_char_id = qa_ss_const.asset_activity THEN
457: x_parents(1) := qa_ss_const.asset_group;
458: x_parents(2) := qa_ss_const.asset_number;
459: x_parents(3) := qa_ss_const.asset_instance_number;
460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN

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

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

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

455: -- Both asset group and asset number were being assigned to x_parents(1)
456: ELSIF p_char_id = qa_ss_const.asset_activity THEN
457: x_parents(1) := qa_ss_const.asset_group;
458: x_parents(2) := qa_ss_const.asset_number;
459: x_parents(3) := qa_ss_const.asset_instance_number;
460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN
462: x_parents(1) := qa_ss_const.asset_group;
463: x_parents(2) := qa_ss_const.asset_number;

Line 461: ELSIF p_char_id = qa_ss_const.followup_activity THEN

457: x_parents(1) := qa_ss_const.asset_group;
458: x_parents(2) := qa_ss_const.asset_number;
459: x_parents(3) := qa_ss_const.asset_instance_number;
460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN
462: x_parents(1) := qa_ss_const.asset_group;
463: x_parents(2) := qa_ss_const.asset_number;
464: x_parents(3) := qa_ss_const.asset_instance_number;
465: --dgupta: End R12 EAM Integration. Bug 4345492

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

458: x_parents(2) := qa_ss_const.asset_number;
459: x_parents(3) := qa_ss_const.asset_instance_number;
460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN
462: x_parents(1) := qa_ss_const.asset_group;
463: x_parents(2) := qa_ss_const.asset_number;
464: x_parents(3) := qa_ss_const.asset_instance_number;
465: --dgupta: End R12 EAM Integration. Bug 4345492
466:

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

459: x_parents(3) := qa_ss_const.asset_instance_number;
460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN
462: x_parents(1) := qa_ss_const.asset_group;
463: x_parents(2) := qa_ss_const.asset_number;
464: x_parents(3) := qa_ss_const.asset_instance_number;
465: --dgupta: End R12 EAM Integration. Bug 4345492
466:
467: -- rkaza. 12/02/2003. bug 3215404.

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

460:
461: ELSIF p_char_id = qa_ss_const.followup_activity THEN
462: x_parents(1) := qa_ss_const.asset_group;
463: x_parents(2) := qa_ss_const.asset_number;
464: x_parents(3) := qa_ss_const.asset_instance_number;
465: --dgupta: End R12 EAM Integration. Bug 4345492
466:
467: -- rkaza. 12/02/2003. bug 3215404.
468: -- Added dependency relation for maintenance op seq with maintenance

Line 470: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

466:
467: -- rkaza. 12/02/2003. bug 3215404.
468: -- Added dependency relation for maintenance op seq with maintenance
469: -- work order.
470: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
471: x_parents(1) := qa_ss_const.work_order;
472:
473: -- rkaza. 12/02/2003. bug 3280307.
474: -- Added dependency relation for component item with item

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

467: -- rkaza. 12/02/2003. bug 3215404.
468: -- Added dependency relation for maintenance op seq with maintenance
469: -- work order.
470: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
471: x_parents(1) := qa_ss_const.work_order;
472:
473: -- rkaza. 12/02/2003. bug 3280307.
474: -- Added dependency relation for component item with item
475: ELSIF p_char_id = qa_ss_const.comp_item THEN

Line 475: ELSIF p_char_id = qa_ss_const.comp_item THEN

471: x_parents(1) := qa_ss_const.work_order;
472:
473: -- rkaza. 12/02/2003. bug 3280307.
474: -- Added dependency relation for component item with item
475: ELSIF p_char_id = qa_ss_const.comp_item THEN
476: x_parents(1) := qa_ss_const.item;
477:
478: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
479: -- bug 3830258 incorrect LOVs in QWB

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

472:
473: -- rkaza. 12/02/2003. bug 3280307.
474: -- Added dependency relation for component item with item
475: ELSIF p_char_id = qa_ss_const.comp_item THEN
476: x_parents(1) := qa_ss_const.item;
477:
478: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
479: -- bug 3830258 incorrect LOVs in QWB
480: -- synced up the component lot number and component serial number

Line 482: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN

478: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
479: -- bug 3830258 incorrect LOVs in QWB
480: -- synced up the component lot number and component serial number
481: -- lov with forms
482: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
483: x_parents(1) := qa_ss_const.comp_item;
484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;

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

479: -- bug 3830258 incorrect LOVs in QWB
480: -- synced up the component lot number and component serial number
481: -- lov with forms
482: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
483: x_parents(1) := qa_ss_const.comp_item;
484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;
487: x_parents(2) := qa_ss_const.comp_item;

Line 485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN

481: -- lov with forms
482: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
483: x_parents(1) := qa_ss_const.comp_item;
484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;
487: x_parents(2) := qa_ss_const.comp_item;
488: x_parents(3) := qa_ss_const.comp_revision;
489:

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

482: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
483: x_parents(1) := qa_ss_const.comp_item;
484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;
487: x_parents(2) := qa_ss_const.comp_item;
488: x_parents(3) := qa_ss_const.comp_revision;
489:
490: -- R12 OPM Deviations. Bug 4345503 Start

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

483: x_parents(1) := qa_ss_const.comp_item;
484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;
487: x_parents(2) := qa_ss_const.comp_item;
488: x_parents(3) := qa_ss_const.comp_revision;
489:
490: -- R12 OPM Deviations. Bug 4345503 Start
491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

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

484:
485: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
486: x_parents(1) := qa_ss_const.comp_lot_number;
487: x_parents(2) := qa_ss_const.comp_item;
488: x_parents(3) := qa_ss_const.comp_revision;
489:
490: -- R12 OPM Deviations. Bug 4345503 Start
491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
492: x_parents(1) := qa_ss_const.process_batch_num;

Line 491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

487: x_parents(2) := qa_ss_const.comp_item;
488: x_parents(3) := qa_ss_const.comp_revision;
489:
490: -- R12 OPM Deviations. Bug 4345503 Start
491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
492: x_parents(1) := qa_ss_const.process_batch_num;
493:
494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;

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

488: x_parents(3) := qa_ss_const.comp_revision;
489:
490: -- R12 OPM Deviations. Bug 4345503 Start
491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
492: x_parents(1) := qa_ss_const.process_batch_num;
493:
494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 494: ELSIF p_char_id = qa_ss_const.process_operation THEN

490: -- R12 OPM Deviations. Bug 4345503 Start
491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
492: x_parents(1) := qa_ss_const.process_batch_num;
493:
494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN

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

491: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
492: x_parents(1) := qa_ss_const.process_batch_num;
493:
494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;

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

492: x_parents(1) := qa_ss_const.process_batch_num;
493:
494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;
500: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 498: ELSIF p_char_id = qa_ss_const.process_activity THEN

494: ELSIF p_char_id = qa_ss_const.process_operation THEN
495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;
500: x_parents(2) := qa_ss_const.process_batchstep_num;
501:
502: ELSIF p_char_id = qa_ss_const.process_resource THEN

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

495: x_parents(1) := qa_ss_const.process_batch_num;
496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;
500: x_parents(2) := qa_ss_const.process_batchstep_num;
501:
502: ELSIF p_char_id = qa_ss_const.process_resource THEN
503: x_parents(1) := qa_ss_const.process_batch_num;

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

496: x_parents(2) := qa_ss_const.process_batchstep_num;
497:
498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;
500: x_parents(2) := qa_ss_const.process_batchstep_num;
501:
502: ELSIF p_char_id = qa_ss_const.process_resource THEN
503: x_parents(1) := qa_ss_const.process_batch_num;
504: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 502: ELSIF p_char_id = qa_ss_const.process_resource THEN

498: ELSIF p_char_id = qa_ss_const.process_activity THEN
499: x_parents(1) := qa_ss_const.process_batch_num;
500: x_parents(2) := qa_ss_const.process_batchstep_num;
501:
502: ELSIF p_char_id = qa_ss_const.process_resource THEN
503: x_parents(1) := qa_ss_const.process_batch_num;
504: x_parents(2) := qa_ss_const.process_batchstep_num;
505: x_parents(3) := qa_ss_const.process_activity;
506:

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

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

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

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

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

501:
502: ELSIF p_char_id = qa_ss_const.process_resource THEN
503: x_parents(1) := qa_ss_const.process_batch_num;
504: x_parents(2) := qa_ss_const.process_batchstep_num;
505: x_parents(3) := qa_ss_const.process_activity;
506:
507: ELSIF p_char_id = qa_ss_const.process_parameter THEN
508: x_parents(1) := qa_ss_const.process_resource;
509: -- R12 OPM Deviations. Bug 4345503 End

Line 507: ELSIF p_char_id = qa_ss_const.process_parameter THEN

503: x_parents(1) := qa_ss_const.process_batch_num;
504: x_parents(2) := qa_ss_const.process_batchstep_num;
505: x_parents(3) := qa_ss_const.process_activity;
506:
507: ELSIF p_char_id = qa_ss_const.process_parameter THEN
508: x_parents(1) := qa_ss_const.process_resource;
509: -- R12 OPM Deviations. Bug 4345503 End
510:
511: --

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

504: x_parents(2) := qa_ss_const.process_batchstep_num;
505: x_parents(3) := qa_ss_const.process_activity;
506:
507: ELSIF p_char_id = qa_ss_const.process_parameter THEN
508: x_parents(1) := qa_ss_const.process_resource;
509: -- R12 OPM Deviations. Bug 4345503 End
510:
511: --
512: -- Bug 6161802

Line 516: ELSIF p_char_id = qa_ss_const.rma_line_num THEN

512: -- Bug 6161802
513: -- Added dependency relation for rma line number with rma number
514: -- skolluku Thu Mon Jul 16 22:08:16 PDT 2007
515: --
516: ELSIF p_char_id = qa_ss_const.rma_line_num THEN
517: x_parents(1) := qa_ss_const.rma_number;
518:
519: END IF;
520:

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

513: -- Added dependency relation for rma line number with rma number
514: -- skolluku Thu Mon Jul 16 22:08:16 PDT 2007
515: --
516: ELSIF p_char_id = qa_ss_const.rma_line_num THEN
517: x_parents(1) := qa_ss_const.rma_number;
518:
519: END IF;
520:
521: END get_lov_dependencies;

Line 673: IF(p_id = qa_ss_const.po_number OR

669: -- bug 5383667
670: -- Added check for Party Name
671: -- ntungare
672: --
673: IF(p_id = qa_ss_const.po_number OR
674: p_id = qa_ss_const.party_name) THEN
675: return qa_chars_api.hardcoded_column(p_id);
676: END IF;
677:

Line 674: p_id = qa_ss_const.party_name) THEN

670: -- Added check for Party Name
671: -- ntungare
672: --
673: IF(p_id = qa_ss_const.po_number OR
674: p_id = qa_ss_const.party_name) THEN
675: return qa_chars_api.hardcoded_column(p_id);
676: END IF;
677:
678: return construct_code(p_element_prefix,p_id);

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

905: -- bug 5383667
906: -- added the party name to the list of normalized vals
907: -- ntungare
908: --
909: if((p_char_id = qa_ss_const.po_number) OR
910: (p_char_id = qa_ss_const.party_name))then
911: return 'T';
912: end if;
913:

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

906: -- added the party name to the list of normalized vals
907: -- ntungare
908: --
909: if((p_char_id = qa_ss_const.po_number) OR
910: (p_char_id = qa_ss_const.party_name))then
911: return 'T';
912: end if;
913:
914: return 'F';

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

927: -- currently we are enabling normalized logic
928: -- only for PO NUMBER. So we are hard coding
929: -- lov region name. In future, this proc must
930: -- be generalized.
931: if(p_char_id = qa_ss_const.po_number) then
932: return 'PONumberLovRN';
933: --
934: -- bug 5383667
935: -- getting the region LOV region name for

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

937: -- region for the Part name, however we should
938: -- later use a common region for all the normalized
939: -- id elements
940: --
941: elsif (p_char_id = qa_ss_const.party_name) then
942: return 'PartyLovRN';
943: end if;
944:
945: return 'QaLovRN';

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

971: lovMap := jdr_docbuilder.createElement(jdr_docbuilder.JRAD_NS, 'lovMap');
972: jdr_docbuilder.setAttribute(lovMap, 'criteriaFrom', p_attribute_code);
973: jdr_docbuilder.setAttribute(lovMap, 'resultTo', p_attribute_code);
974:
975: IF(p_char_id = qa_ss_const.po_number) THEN
976: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'Segment1');
977: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
978: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
979: lovMap);

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

988: -- bug 5383667
989: -- Processing for the Party Name element
990: -- ntungare
991: --
992: ELSIF(p_char_id = qa_ss_const.party_name) THEN
993: jdr_docbuilder.setAttribute(lovMap, 'lovItem', 'PartyName');
994: jdr_docbuilder.setAttribute(lovMap, 'requiredForLOV', 'true');
995: jdr_docbuilder.addChild(p_char_item, jdr_docbuilder.JRAD_NS, 'lovMappings',
996: lovMap);

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

1764: -- ntungare
1765: --
1766: -- Requires code addition for Adanced Table
1767: -- todo saugupta
1768: IF (r.char_id = qa_ss_const.po_number OR
1769: r.char_id = qa_ss_const.party_name) AND
1770: (p_parent_region_prefix <> g_eqr_mult_dtl_prefix OR
1771: p_parent_region_prefix IS NULL) THEN
1772: l_id_item := create_id_item_for_eqr(p_plan_id,r.char_id);

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

1765: --
1766: -- Requires code addition for Adanced Table
1767: -- todo saugupta
1768: IF (r.char_id = qa_ss_const.po_number OR
1769: r.char_id = qa_ss_const.party_name) AND
1770: (p_parent_region_prefix <> g_eqr_mult_dtl_prefix OR
1771: p_parent_region_prefix IS NULL) THEN
1772: l_id_item := create_id_item_for_eqr(p_plan_id,r.char_id);
1773: add_child_to_parent(p_content_region, l_id_item, 'contents');

Line 3319: OPEN valueLookups(qa_ss_const.nonconformance_source);

3315: -- admin will create one personalization per each Nonconformance Source (or Request type)
3316: --
3317: -- still map one with normal naming scheme
3318: IF l_template_plan_id in (18, 35) THEN -- Nonconformance master
3319: OPEN valueLookups(qa_ss_const.nonconformance_source);
3320: LOOP
3321: FETCH valueLookups INTO l_short_code;
3322: EXIT WHEN valueLookups%NOTFOUND;
3323: map_plan_eqr_single(p_plan_id, g_ncm || l_short_code || '_');

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

3325: map_plan_eqr_multiple(p_plan_id, g_ncm || l_short_code || '_');
3326: END LOOP;
3327: CLOSE valueLookups;
3328: ELSIF l_template_plan_id = 65 THEN -- Corrective Action Request
3329: OPEN valueLookups(2147483607); -- should be qa_ss_const.request_type
3330: LOOP
3331: FETCH valueLookups INTO l_short_code;
3332: EXIT WHEN valueLookups%NOTFOUND;
3333: map_plan_eqr_single(p_plan_id, g_car || l_short_code || '_');

Line 3425: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;

3421:
3422: SELECT jrad_upgrade_ver
3423: INTO l_seed_ver
3424: FROM qa_plans
3425: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
3426:
3427: fnd_msg_pub.initialize;
3428:
3429: l_eqr_single_doc := g_jrad_region_path || construct_code(

Line 3520: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)

3516: UPDATE qa_plans
3517: SET jrad_upgrade_ver =
3518: (SELECT nvl(jrad_upgrade_ver, 1)
3519: FROM qa_plans
3520: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN)
3521: WHERE plan_id = p_plan_id;
3522: END jrad_upgraded;
3523:
3524: