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_JRAD_PKG dependencies on QA_SS_CONST

Line 40: OPEN qptxn(p_plan_id,qa_ss_const.ss_outside_processing_txn);

36: -- This subroutine determines if a plan has been associated
37: -- and enabled for osp self service transactions or not.
38: -- If it is then it returns true else it returns false.
39:
40: OPEN qptxn(p_plan_id,qa_ss_const.ss_outside_processing_txn);
41: FETCH qptxn INTO dummy;
42: result := qptxn%FOUND;
43: CLOSE qptxn;
44: RETURN result;

Line 61: OPEN qptxn(p_plan_id,qa_ss_const.ss_shipments_txn);

57: -- This subroutine determines if a plan has been associated
58: -- and enabled for shipment self service transactions or not.
59: -- If it is then it returns true else it returns false.
60:
61: OPEN qptxn(p_plan_id,qa_ss_const.ss_shipments_txn);
62: FETCH qptxn INTO dummy;
63: result := qptxn%FOUND;
64: CLOSE qptxn;
65: RETURN result;

Line 81: qa_ss_const.sales_order)) THEN

77: -- by checking if sales order is a part of the plan
78: -- and enabled.
79:
80: IF (qa_plan_element_api.element_in_plan(p_plan_id,
81: qa_ss_const.sales_order)) THEN
82: RETURN TRUE;
83: ELSE
84: RETURN FALSE;
85: END IF;

Line 102: OPEN qptxn(p_plan_id,qa_ss_const.eam_work_order_txn);

98: -- This subroutine determines if a plan has been associated
99: -- and enabled for EAM work order or not. If it is then it returns true
100: -- else it returns false.
101:
102: OPEN qptxn(p_plan_id,qa_ss_const.eam_work_order_txn);
103: FETCH qptxn INTO dummy;
104: result := qptxn%FOUND;
105: CLOSE qptxn;
106:

Line 124: OPEN qptxn(p_plan_id,qa_ss_const.eam_asset_txn);

120: -- This subroutine determines if a plan has been associated
121: -- and enabled for EAM asset query or not. If it is then it returns true
122: -- else it returns false.
123:
124: OPEN qptxn(p_plan_id,qa_ss_const.eam_asset_txn);
125: FETCH qptxn INTO dummy;
126: result := qptxn%FOUND;
127: CLOSE qptxn;
128:

Line 147: OPEN qptxn(p_plan_id,qa_ss_const.eam_operation_txn);

143: -- This subroutine determines if a plan has been associated
144: -- and enabled for EAM op comp or not. If it is then it returns true
145: -- else it returns false.
146:
147: OPEN qptxn(p_plan_id,qa_ss_const.eam_operation_txn);
148: FETCH qptxn INTO dummy;
149: result := qptxn%FOUND;
150: CLOSE qptxn;
151:

Line 164: OPEN qptxn(p_plan_id,qa_ss_const.eam_checkin_txn);

160: result BOOLEAN;
161: dummy NUMBER;
162:
163: BEGIN
164: OPEN qptxn(p_plan_id,qa_ss_const.eam_checkin_txn);
165: FETCH qptxn INTO dummy;
166: result := qptxn%FOUND;
167: CLOSE qptxn;
168:

Line 179: OPEN qptxn(p_plan_id,qa_ss_const.eam_checkout_txn);

175: result BOOLEAN;
176: dummy NUMBER;
177:
178: BEGIN
179: OPEN qptxn(p_plan_id,qa_ss_const.eam_checkout_txn);
180: FETCH qptxn INTO dummy;
181: result := qptxn%FOUND;
182: CLOSE qptxn;
183:

Line 455: l_txn_number := qa_ss_const.ss_outside_processing_txn;

451: -- of them it should be text input. This distiction is made here.
452:
453:
454: IF (p_prefix = g_txn_osp_prefix) THEN
455: l_txn_number := qa_ss_const.ss_outside_processing_txn;
456:
457: ELSIF (p_prefix = g_txn_ship_prefix) THEN
458: l_txn_number := qa_ss_const.ss_shipments_txn;
459:

Line 458: l_txn_number := qa_ss_const.ss_shipments_txn;

454: IF (p_prefix = g_txn_osp_prefix) THEN
455: l_txn_number := qa_ss_const.ss_outside_processing_txn;
456:
457: ELSIF (p_prefix = g_txn_ship_prefix) THEN
458: l_txn_number := qa_ss_const.ss_shipments_txn;
459:
460: ELSIF (p_prefix = g_txn_work_prefix) THEN
461: l_txn_number := qa_ss_const.eam_work_order_txn;
462:

Line 461: l_txn_number := qa_ss_const.eam_work_order_txn;

457: ELSIF (p_prefix = g_txn_ship_prefix) THEN
458: l_txn_number := qa_ss_const.ss_shipments_txn;
459:
460: ELSIF (p_prefix = g_txn_work_prefix) THEN
461: l_txn_number := qa_ss_const.eam_work_order_txn;
462:
463: ELSIF (p_prefix = g_txn_asset_prefix) THEN
464: l_txn_number := qa_ss_const.eam_asset_txn;
465:

Line 464: l_txn_number := qa_ss_const.eam_asset_txn;

460: ELSIF (p_prefix = g_txn_work_prefix) THEN
461: l_txn_number := qa_ss_const.eam_work_order_txn;
462:
463: ELSIF (p_prefix = g_txn_asset_prefix) THEN
464: l_txn_number := qa_ss_const.eam_asset_txn;
465:
466: ELSIF (p_prefix = g_txn_op_prefix) THEN
467: l_txn_number := qa_ss_const.eam_operation_txn;
468:

Line 467: l_txn_number := qa_ss_const.eam_operation_txn;

463: ELSIF (p_prefix = g_txn_asset_prefix) THEN
464: l_txn_number := qa_ss_const.eam_asset_txn;
465:
466: ELSIF (p_prefix = g_txn_op_prefix) THEN
467: l_txn_number := qa_ss_const.eam_operation_txn;
468:
469: --dgupta: Start R12 EAM Integration. Bug 4345492
470: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
471: l_txn_number := qa_ss_const.eam_checkin_txn;

Line 471: l_txn_number := qa_ss_const.eam_checkin_txn;

467: l_txn_number := qa_ss_const.eam_operation_txn;
468:
469: --dgupta: Start R12 EAM Integration. Bug 4345492
470: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
471: l_txn_number := qa_ss_const.eam_checkin_txn;
472:
473: ELSIF (p_prefix = g_checkout_eqr_prefix) THEN
474: l_txn_number := qa_ss_const.eam_checkout_txn;
475: --dgupta: End R12 EAM Integration. Bug 4345492

Line 474: l_txn_number := qa_ss_const.eam_checkout_txn;

470: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
471: l_txn_number := qa_ss_const.eam_checkin_txn;
472:
473: ELSIF (p_prefix = g_checkout_eqr_prefix) THEN
474: l_txn_number := qa_ss_const.eam_checkout_txn;
475: --dgupta: End R12 EAM Integration. Bug 4345492
476:
477:
478: END IF;

Line 538: l_txn_number := qa_ss_const.ss_outside_processing_txn;

534: END IF;
535:
536: IF ( instr(p_prefix, g_osp_vqr_prefix) <> 0 ) THEN
537: -- prefix passed has 'QAVQROSP' in it
538: l_txn_number := qa_ss_const.ss_outside_processing_txn;
539:
540: ELSIF ( instr(p_prefix, g_ship_vqr_prefix) <> 0 ) THEN
541: -- prefix passed has 'QAVQRSHP' in it
542: l_txn_number := qa_ss_const.ss_shipments_txn;

Line 542: l_txn_number := qa_ss_const.ss_shipments_txn;

538: l_txn_number := qa_ss_const.ss_outside_processing_txn;
539:
540: ELSIF ( instr(p_prefix, g_ship_vqr_prefix) <> 0 ) THEN
541: -- prefix passed has 'QAVQRSHP' in it
542: l_txn_number := qa_ss_const.ss_shipments_txn;
543:
544: ELSIF ( instr(p_prefix, g_work_vqr_prefix) <> 0 ) THEN
545: -- prefix passed has 'QAVQRWORK' in it
546: l_txn_number := qa_ss_const.eam_work_order_txn;

Line 546: l_txn_number := qa_ss_const.eam_work_order_txn;

542: l_txn_number := qa_ss_const.ss_shipments_txn;
543:
544: ELSIF ( instr(p_prefix, g_work_vqr_prefix) <> 0 ) THEN
545: -- prefix passed has 'QAVQRWORK' in it
546: l_txn_number := qa_ss_const.eam_work_order_txn;
547:
548: ELSIF ( instr(p_prefix, g_asset_vqr_prefix) <> 0 ) THEN
549: -- prefix passed has 'QAVQRASSET' in it
550: l_txn_number := qa_ss_const.eam_asset_txn;

Line 550: l_txn_number := qa_ss_const.eam_asset_txn;

546: l_txn_number := qa_ss_const.eam_work_order_txn;
547:
548: ELSIF ( instr(p_prefix, g_asset_vqr_prefix) <> 0 ) THEN
549: -- prefix passed has 'QAVQRASSET' in it
550: l_txn_number := qa_ss_const.eam_asset_txn;
551:
552: ELSIF ( instr(p_prefix, g_op_vqr_prefix) <> 0 ) THEN
553: -- prefix passed has 'QAVQROP' in it
554: l_txn_number := qa_ss_const.eam_operation_txn;

Line 554: l_txn_number := qa_ss_const.eam_operation_txn;

550: l_txn_number := qa_ss_const.eam_asset_txn;
551:
552: ELSIF ( instr(p_prefix, g_op_vqr_prefix) <> 0 ) THEN
553: -- prefix passed has 'QAVQROP' in it
554: l_txn_number := qa_ss_const.eam_operation_txn;
555:
556: --dgupta: Start R12 EAM Integration. Bug 4345492
557: ELSIF ( instr(p_prefix, g_checkin_vqr_prefix) <> 0 ) THEN
558: -- prefix passed has 'QAVQRCHECKIN' in it

Line 559: l_txn_number := qa_ss_const.eam_checkin_txn;

555:
556: --dgupta: Start R12 EAM Integration. Bug 4345492
557: ELSIF ( instr(p_prefix, g_checkin_vqr_prefix) <> 0 ) THEN
558: -- prefix passed has 'QAVQRCHECKIN' in it
559: l_txn_number := qa_ss_const.eam_checkin_txn;
560:
561: ELSIF ( instr(p_prefix, g_checkout_vqr_prefix) <> 0 ) THEN
562: -- prefix passed has 'QAVQRCHECKOUT' in it
563: l_txn_number := qa_ss_const.eam_checkout_txn;

Line 563: l_txn_number := qa_ss_const.eam_checkout_txn;

559: l_txn_number := qa_ss_const.eam_checkin_txn;
560:
561: ELSIF ( instr(p_prefix, g_checkout_vqr_prefix) <> 0 ) THEN
562: -- prefix passed has 'QAVQRCHECKOUT' in it
563: l_txn_number := qa_ss_const.eam_checkout_txn;
564: --dgupta: End R12 EAM Integration. Bug 4345492
565:
566: END IF;
567:

Line 589: IF p_char_id = qa_ss_const.item THEN

585: -- OUT table structure.
586:
587: x_parents.delete();
588:
589: IF p_char_id = qa_ss_const.item THEN
590: x_parents(1) := qa_ss_const.production_line;
591:
592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;

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

586:
587: x_parents.delete();
588:
589: IF p_char_id = qa_ss_const.item THEN
590: x_parents(1) := qa_ss_const.production_line;
591:
592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;

Line 592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN

588:
589: IF p_char_id = qa_ss_const.item THEN
590: x_parents(1) := qa_ss_const.production_line;
591:
592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

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

589: IF p_char_id = qa_ss_const.item THEN
590: x_parents(1) := qa_ss_const.production_line;
591:
592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;

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

590: x_parents(1) := qa_ss_const.production_line;
591:
592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;

Line 596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

592: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;
599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

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

593: x_parents(1) := qa_ss_const.job_name;
594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;
599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;

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

594: x_parents(2) := qa_ss_const.production_line;
595:
596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;
599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;
602:

Line 600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

596: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;
599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;
602:
603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
604: x_parents(1) := qa_ss_const.from_op_seq_num;

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

597: x_parents(1) := qa_ss_const.job_name;
598: x_parents(2) := qa_ss_const.production_line;
599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;
602:
603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
604: x_parents(1) := qa_ss_const.from_op_seq_num;
605:

Line 603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN

599:
600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;
602:
603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
604: x_parents(1) := qa_ss_const.from_op_seq_num;
605:
606: ELSIF p_char_id = qa_ss_const.uom THEN
607:

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

600: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
601: x_parents(1) := qa_ss_const.to_op_seq_num;
602:
603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
604: x_parents(1) := qa_ss_const.from_op_seq_num;
605:
606: ELSIF p_char_id = qa_ss_const.uom THEN
607:
608: x_parents(1) := qa_ss_const.item;

Line 606: ELSIF p_char_id = qa_ss_const.uom THEN

602:
603: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
604: x_parents(1) := qa_ss_const.from_op_seq_num;
605:
606: ELSIF p_char_id = qa_ss_const.uom THEN
607:
608: x_parents(1) := qa_ss_const.item;
609: x_parents(2) := qa_ss_const.production_line;
610:

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

604: x_parents(1) := qa_ss_const.from_op_seq_num;
605:
606: ELSIF p_char_id = qa_ss_const.uom THEN
607:
608: x_parents(1) := qa_ss_const.item;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;

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

605:
606: ELSIF p_char_id = qa_ss_const.uom THEN
607:
608: x_parents(1) := qa_ss_const.item;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;

Line 611: ELSIF p_char_id = qa_ss_const.revision THEN

607:
608: x_parents(1) := qa_ss_const.item;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN

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

608: x_parents(1) := qa_ss_const.item;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;

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

609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;

Line 615: ELSIF p_char_id = qa_ss_const.subinventory THEN

611: ELSIF p_char_id = qa_ss_const.revision THEN
612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN

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

612: x_parents(1) := qa_ss_const.item;
613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;

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

613: x_parents(2) := qa_ss_const.production_line;
614:
615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;
621: x_parents(2) := qa_ss_const.item;

Line 619: ELSIF p_char_id = qa_ss_const.locator THEN

615: ELSIF p_char_id = qa_ss_const.subinventory THEN
616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;
621: x_parents(2) := qa_ss_const.item;
622: x_parents(3) := qa_ss_const.production_line;
623:

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

616: x_parents(1) := qa_ss_const.item;
617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;
621: x_parents(2) := qa_ss_const.item;
622: x_parents(3) := qa_ss_const.production_line;
623:
624: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

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

617: x_parents(2) := qa_ss_const.production_line;
618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;
621: x_parents(2) := qa_ss_const.item;
622: x_parents(3) := qa_ss_const.production_line;
623:
624: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
625: -- bug 3830258 incorrect LOVs in QWB

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

618:
619: ELSIF p_char_id = qa_ss_const.locator THEN
620: x_parents(1) := qa_ss_const.subinventory;
621: x_parents(2) := qa_ss_const.item;
622: x_parents(3) := qa_ss_const.production_line;
623:
624: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
625: -- bug 3830258 incorrect LOVs in QWB
626: -- synced up the lot number lov with forms

Line 627: ELSIF p_char_id = qa_ss_const.lot_number THEN

623:
624: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
625: -- bug 3830258 incorrect LOVs in QWB
626: -- synced up the lot number lov with forms
627: ELSIF p_char_id = qa_ss_const.lot_number THEN
628: x_parents(1) := qa_ss_const.item;
629: --x_parents(2) := qa_ss_const.production_line;
630:
631: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

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

624: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
625: -- bug 3830258 incorrect LOVs in QWB
626: -- synced up the lot number lov with forms
627: ELSIF p_char_id = qa_ss_const.lot_number THEN
628: x_parents(1) := qa_ss_const.item;
629: --x_parents(2) := qa_ss_const.production_line;
630:
631: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
632: -- bug 3830258 incorrect LOVs in QWB

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

625: -- bug 3830258 incorrect LOVs in QWB
626: -- synced up the lot number lov with forms
627: ELSIF p_char_id = qa_ss_const.lot_number THEN
628: x_parents(1) := qa_ss_const.item;
629: --x_parents(2) := qa_ss_const.production_line;
630:
631: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
632: -- bug 3830258 incorrect LOVs in QWB
633: -- synced up the serial number lov with forms

Line 634: ELSIF p_char_id = qa_ss_const.serial_number THEN

630:
631: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
632: -- bug 3830258 incorrect LOVs in QWB
633: -- synced up the serial number lov with forms
634: ELSIF p_char_id = qa_ss_const.serial_number THEN
635: x_parents(1) := qa_ss_const.lot_number;
636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;

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

631: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
632: -- bug 3830258 incorrect LOVs in QWB
633: -- synced up the serial number lov with forms
634: ELSIF p_char_id = qa_ss_const.serial_number THEN
635: x_parents(1) := qa_ss_const.lot_number;
636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:

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

632: -- bug 3830258 incorrect LOVs in QWB
633: -- synced up the serial number lov with forms
634: ELSIF p_char_id = qa_ss_const.serial_number THEN
635: x_parents(1) := qa_ss_const.lot_number;
636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN

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

633: -- synced up the serial number lov with forms
634: ELSIF p_char_id = qa_ss_const.serial_number THEN
635: x_parents(1) := qa_ss_const.lot_number;
636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;

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

634: ELSIF p_char_id = qa_ss_const.serial_number THEN
635: x_parents(1) := qa_ss_const.lot_number;
636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;
642:

Line 640: ELSIF p_char_id = qa_ss_const.comp_uom THEN

636: x_parents(2) := qa_ss_const.item;
637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;
642:
643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;

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

637: --x_parents(3) := qa_ss_const.production_line;
638: x_parents(3) := qa_ss_const.revision;
639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;
642:
643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;
645:

Line 643: ELSIF p_char_id = qa_ss_const.comp_revision THEN

639:
640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;
642:
643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;
645:
646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;

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

640: ELSIF p_char_id = qa_ss_const.comp_uom THEN
641: x_parents(1) := qa_ss_const.comp_item;
642:
643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;
645:
646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;
648:

Line 646: ELSIF p_char_id = qa_ss_const.po_line_num THEN

642:
643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;
645:
646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;
648:
649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;

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

643: ELSIF p_char_id = qa_ss_const.comp_revision THEN
644: x_parents(1) := qa_ss_const.comp_item;
645:
646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;
648:
649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;

Line 649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN

645:
646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;
648:
649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN

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

646: ELSIF p_char_id = qa_ss_const.po_line_num THEN
647: x_parents(1) := qa_ss_const.po_number;
648:
649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;

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

647: x_parents(1) := qa_ss_const.po_number;
648:
649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;
655:

Line 653: ELSIF p_char_id = qa_ss_const.po_release_num THEN

649: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;
655:
656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;

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

650: x_parents(1) := qa_ss_const.po_line_num;
651: x_parents(2) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;
655:
656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;
658:

Line 656: ELSIF p_char_id = qa_ss_const.order_line THEN

652:
653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;
655:
656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;
658:
659: ELSIF p_char_id = qa_ss_const.task_number THEN
660: x_parents(1) := qa_ss_const.project_number;

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

653: ELSIF p_char_id = qa_ss_const.po_release_num THEN
654: x_parents(1) := qa_ss_const.po_number;
655:
656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;
658:
659: ELSIF p_char_id = qa_ss_const.task_number THEN
660: x_parents(1) := qa_ss_const.project_number;
661:

Line 659: ELSIF p_char_id = qa_ss_const.task_number THEN

655:
656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;
658:
659: ELSIF p_char_id = qa_ss_const.task_number THEN
660: x_parents(1) := qa_ss_const.project_number;
661:
662: --dgupta: Start R12 EAM Integration. Bug 4345492
663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

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

656: ELSIF p_char_id = qa_ss_const.order_line THEN
657: x_parents(1) := qa_ss_const.sales_order;
658:
659: ELSIF p_char_id = qa_ss_const.task_number THEN
660: x_parents(1) := qa_ss_const.project_number;
661:
662: --dgupta: Start R12 EAM Integration. Bug 4345492
663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
664: x_parents(1) := qa_ss_const.asset_group;

Line 663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

659: ELSIF p_char_id = qa_ss_const.task_number THEN
660: x_parents(1) := qa_ss_const.project_number;
661:
662: --dgupta: Start R12 EAM Integration. Bug 4345492
663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
664: x_parents(1) := qa_ss_const.asset_group;
665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN

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

660: x_parents(1) := qa_ss_const.project_number;
661:
662: --dgupta: Start R12 EAM Integration. Bug 4345492
663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
664: x_parents(1) := qa_ss_const.asset_group;
665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN
668: x_parents(1) := qa_ss_const.asset_group;

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

661:
662: --dgupta: Start R12 EAM Integration. Bug 4345492
663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
664: x_parents(1) := qa_ss_const.asset_group;
665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_instance_number;

Line 667: ELSIF p_char_id = qa_ss_const.asset_number THEN

663: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
664: x_parents(1) := qa_ss_const.asset_group;
665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_instance_number;
670:
671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project

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

664: x_parents(1) := qa_ss_const.asset_group;
665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_instance_number;
670:
671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
672: -- added the following dependencies

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

665: x_parents(2) := qa_ss_const.asset_number;
666:
667: ELSIF p_char_id = qa_ss_const.asset_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_instance_number;
670:
671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
672: -- added the following dependencies
673: ELSIF p_char_id = qa_ss_const.asset_activity THEN

Line 673: ELSIF p_char_id = qa_ss_const.asset_activity THEN

669: x_parents(2) := qa_ss_const.asset_instance_number;
670:
671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
672: -- added the following dependencies
673: ELSIF p_char_id = qa_ss_const.asset_activity THEN
674: x_parents(1) := qa_ss_const.asset_group;
675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:

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

670:
671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
672: -- added the following dependencies
673: ELSIF p_char_id = qa_ss_const.asset_activity THEN
674: x_parents(1) := qa_ss_const.asset_group;
675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN

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

671: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
672: -- added the following dependencies
673: ELSIF p_char_id = qa_ss_const.asset_activity THEN
674: x_parents(1) := qa_ss_const.asset_group;
675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;

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

672: -- added the following dependencies
673: ELSIF p_char_id = qa_ss_const.asset_activity THEN
674: x_parents(1) := qa_ss_const.asset_group;
675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;

Line 678: ELSIF p_char_id = qa_ss_const.followup_activity THEN

674: x_parents(1) := qa_ss_const.asset_group;
675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492

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

675: x_parents(2) := qa_ss_const.asset_number;
676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492
683:

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

676: x_parents(3) := qa_ss_const.asset_instance_number;
677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492
683:
684: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

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

677:
678: ELSIF p_char_id = qa_ss_const.followup_activity THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492
683:
684: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
685: x_parents(1) := qa_ss_const.work_order;

Line 684: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

680: x_parents(2) := qa_ss_const.asset_number;
681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492
683:
684: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
685: x_parents(1) := qa_ss_const.work_order;
686:
687: -- rkaza. 12/02/2003. bug 3280307.
688: -- Added dependency relation for component item with item

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

681: x_parents(3) := qa_ss_const.asset_instance_number;
682: --dgupta: End R12 EAM Integration. Bug 4345492
683:
684: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
685: x_parents(1) := qa_ss_const.work_order;
686:
687: -- rkaza. 12/02/2003. bug 3280307.
688: -- Added dependency relation for component item with item
689: ELSIF p_char_id = qa_ss_const.comp_item THEN

Line 689: ELSIF p_char_id = qa_ss_const.comp_item THEN

685: x_parents(1) := qa_ss_const.work_order;
686:
687: -- rkaza. 12/02/2003. bug 3280307.
688: -- Added dependency relation for component item with item
689: ELSIF p_char_id = qa_ss_const.comp_item THEN
690: x_parents(1) := qa_ss_const.item;
691:
692: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
693: -- bug 3830258 incorrect LOVs in QWB

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

686:
687: -- rkaza. 12/02/2003. bug 3280307.
688: -- Added dependency relation for component item with item
689: ELSIF p_char_id = qa_ss_const.comp_item THEN
690: x_parents(1) := qa_ss_const.item;
691:
692: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
693: -- bug 3830258 incorrect LOVs in QWB
694: -- synced up the component lot number and component serial number

Line 696: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN

692: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
693: -- bug 3830258 incorrect LOVs in QWB
694: -- synced up the component lot number and component serial number
695: -- lov with forms
696: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
697: x_parents(1) := qa_ss_const.comp_item;
698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;

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

693: -- bug 3830258 incorrect LOVs in QWB
694: -- synced up the component lot number and component serial number
695: -- lov with forms
696: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
697: x_parents(1) := qa_ss_const.comp_item;
698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;
701: x_parents(2) := qa_ss_const.comp_item;

Line 699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN

695: -- lov with forms
696: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
697: x_parents(1) := qa_ss_const.comp_item;
698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;
701: x_parents(2) := qa_ss_const.comp_item;
702: x_parents(3) := qa_ss_const.comp_revision;
703:

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

696: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
697: x_parents(1) := qa_ss_const.comp_item;
698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;
701: x_parents(2) := qa_ss_const.comp_item;
702: x_parents(3) := qa_ss_const.comp_revision;
703:
704: -- R12 OPM Deviations. Bug 4345503 Start

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

697: x_parents(1) := qa_ss_const.comp_item;
698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;
701: x_parents(2) := qa_ss_const.comp_item;
702: x_parents(3) := qa_ss_const.comp_revision;
703:
704: -- R12 OPM Deviations. Bug 4345503 Start
705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

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

698:
699: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
700: x_parents(1) := qa_ss_const.comp_lot_number;
701: x_parents(2) := qa_ss_const.comp_item;
702: x_parents(3) := qa_ss_const.comp_revision;
703:
704: -- R12 OPM Deviations. Bug 4345503 Start
705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
706: x_parents(1) := qa_ss_const.process_batch_num;

Line 705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

701: x_parents(2) := qa_ss_const.comp_item;
702: x_parents(3) := qa_ss_const.comp_revision;
703:
704: -- R12 OPM Deviations. Bug 4345503 Start
705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
706: x_parents(1) := qa_ss_const.process_batch_num;
707:
708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;

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

702: x_parents(3) := qa_ss_const.comp_revision;
703:
704: -- R12 OPM Deviations. Bug 4345503 Start
705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
706: x_parents(1) := qa_ss_const.process_batch_num;
707:
708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 708: ELSIF p_char_id = qa_ss_const.process_operation THEN

704: -- R12 OPM Deviations. Bug 4345503 Start
705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
706: x_parents(1) := qa_ss_const.process_batch_num;
707:
708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN

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

705: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
706: x_parents(1) := qa_ss_const.process_batch_num;
707:
708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;

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

706: x_parents(1) := qa_ss_const.process_batch_num;
707:
708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 712: ELSIF p_char_id = qa_ss_const.process_activity THEN

708: ELSIF p_char_id = qa_ss_const.process_operation THEN
709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN

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

709: x_parents(1) := qa_ss_const.process_batch_num;
710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;

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

710: x_parents(2) := qa_ss_const.process_batchstep_num;
711:
712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 716: ELSIF p_char_id = qa_ss_const.process_resource THEN

712: ELSIF p_char_id = qa_ss_const.process_activity THEN
713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:

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

713: x_parents(1) := qa_ss_const.process_batch_num;
714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:
721: ELSIF p_char_id = qa_ss_const.process_parameter THEN

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

714: x_parents(2) := qa_ss_const.process_batchstep_num;
715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:
721: ELSIF p_char_id = qa_ss_const.process_parameter THEN
722: x_parents(1) := qa_ss_const.process_resource;

Line 719: x_parents(2) := qa_ss_const.process_activity;

715:
716: ELSIF p_char_id = qa_ss_const.process_resource THEN
717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:
721: ELSIF p_char_id = qa_ss_const.process_parameter THEN
722: x_parents(1) := qa_ss_const.process_resource;
723:

Line 721: ELSIF p_char_id = qa_ss_const.process_parameter THEN

717: x_parents(1) := qa_ss_const.process_batch_num;
718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:
721: ELSIF p_char_id = qa_ss_const.process_parameter THEN
722: x_parents(1) := qa_ss_const.process_resource;
723:
724: -- R12 OPM Deviations. Bug 4345503 End
725: END IF;

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

718: x_parents(2) := qa_ss_const.process_batchstep_num;
719: x_parents(2) := qa_ss_const.process_activity;
720:
721: ELSIF p_char_id = qa_ss_const.process_parameter THEN
722: x_parents(1) := qa_ss_const.process_resource;
723:
724: -- R12 OPM Deviations. Bug 4345503 End
725: END IF;
726:

Line 895: IF(p_id = qa_ss_const.po_number) THEN

891: p_id IN VARCHAR2)
892: RETURN VARCHAR2 IS
893:
894: BEGIN
895: IF(p_id = qa_ss_const.po_number) THEN
896: return qa_chars_api.hardcoded_column(p_id);
897: END IF;
898:
899: return construct_jrad_code(p_element_prefix,p_id);

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

1047:
1048: BEGIN
1049: -- currently we are enabling normalized logic
1050: -- only for PO NUMBER
1051: if(p_char_id = qa_ss_const.po_number) then
1052: return 'T';
1053: end if;
1054:
1055: return 'F';

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

1068: -- currently we are enabling normalized logic
1069: -- only for PO NUMBER. So we are hard coding
1070: -- lov region name. In future, this proc must
1071: -- be generalized.
1072: if(p_char_id = qa_ss_const.po_number) then
1073: return 'PONumberLovRN';
1074: end if;
1075:
1076: return 'QaLovRN';

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

1094: l_lov_region VARCHAR2(100);
1095:
1096: BEGIN
1097:
1098: IF(p_char_id = qa_ss_const.po_number) THEN
1099: l_lov_region := qa_ssqr_jrad_pkg.g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1100: jdr_docbuilder.setAttribute(p_char_item,
1101: 'externalListOfValues',
1102: l_lov_region);

Line 1626: l_data_type := convert_data_type(qa_ss_const.datetime_datatype);

1622: END IF;
1623:
1624: IF (p_attribute_code = g_last_update_date_attribute) THEN
1625: -- Assign a datatype of DATETIME to last_update_date.
1626: l_data_type := convert_data_type(qa_ss_const.datetime_datatype);
1627: END IF;
1628:
1629: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1630: l_item_style);

Line 1747: IF l_element_id = qa_ss_const.po_number THEN

1743: 'contents', child1);
1744: --contents is the grouping name
1745:
1746: -- For MOAC : add normalized column.
1747: IF l_element_id = qa_ss_const.po_number THEN
1748: l_id_item := create_id_item_for_eqr(p_plan_id,l_element_id);
1749: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);
1750: END IF;
1751:

Line 2281: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;

2277:
2278: SELECT jrad_upgrade_ver
2279: INTO l_seed_ver
2280: FROM qa_plans
2281: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
2282:
2283: IF l_jrad_upgrade_ver IS NULL OR
2284: l_jrad_upgrade_ver < l_seed_ver THEN
2285: qa_ssqr_jrad_pkg.map_plan(p_plan_id);