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 464: l_txn_number := qa_ss_const.ss_outside_processing_txn;

460: -- of them it should be text input. This distiction is made here.
461:
462:
463: IF (p_prefix = g_txn_osp_prefix) THEN
464: l_txn_number := qa_ss_const.ss_outside_processing_txn;
465:
466: ELSIF (p_prefix = g_txn_ship_prefix) THEN
467: l_txn_number := qa_ss_const.ss_shipments_txn;
468:

Line 467: l_txn_number := qa_ss_const.ss_shipments_txn;

463: IF (p_prefix = g_txn_osp_prefix) THEN
464: l_txn_number := qa_ss_const.ss_outside_processing_txn;
465:
466: ELSIF (p_prefix = g_txn_ship_prefix) THEN
467: l_txn_number := qa_ss_const.ss_shipments_txn;
468:
469: ELSIF (p_prefix = g_txn_work_prefix) THEN
470: l_txn_number := qa_ss_const.eam_work_order_txn;
471:

Line 470: l_txn_number := qa_ss_const.eam_work_order_txn;

466: ELSIF (p_prefix = g_txn_ship_prefix) THEN
467: l_txn_number := qa_ss_const.ss_shipments_txn;
468:
469: ELSIF (p_prefix = g_txn_work_prefix) THEN
470: l_txn_number := qa_ss_const.eam_work_order_txn;
471:
472: ELSIF (p_prefix = g_txn_asset_prefix) THEN
473: l_txn_number := qa_ss_const.eam_asset_txn;
474:

Line 473: l_txn_number := qa_ss_const.eam_asset_txn;

469: ELSIF (p_prefix = g_txn_work_prefix) THEN
470: l_txn_number := qa_ss_const.eam_work_order_txn;
471:
472: ELSIF (p_prefix = g_txn_asset_prefix) THEN
473: l_txn_number := qa_ss_const.eam_asset_txn;
474:
475: ELSIF (p_prefix = g_txn_op_prefix) THEN
476: l_txn_number := qa_ss_const.eam_operation_txn;
477:

Line 476: l_txn_number := qa_ss_const.eam_operation_txn;

472: ELSIF (p_prefix = g_txn_asset_prefix) THEN
473: l_txn_number := qa_ss_const.eam_asset_txn;
474:
475: ELSIF (p_prefix = g_txn_op_prefix) THEN
476: l_txn_number := qa_ss_const.eam_operation_txn;
477:
478: --dgupta: Start R12 EAM Integration. Bug 4345492
479: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
480: l_txn_number := qa_ss_const.eam_checkin_txn;

Line 480: l_txn_number := qa_ss_const.eam_checkin_txn;

476: l_txn_number := qa_ss_const.eam_operation_txn;
477:
478: --dgupta: Start R12 EAM Integration. Bug 4345492
479: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
480: l_txn_number := qa_ss_const.eam_checkin_txn;
481:
482: ELSIF (p_prefix = g_checkout_eqr_prefix) THEN
483: l_txn_number := qa_ss_const.eam_checkout_txn;
484: --dgupta: End R12 EAM Integration. Bug 4345492

Line 483: l_txn_number := qa_ss_const.eam_checkout_txn;

479: ELSIF (p_prefix = g_checkin_eqr_prefix) THEN
480: l_txn_number := qa_ss_const.eam_checkin_txn;
481:
482: ELSIF (p_prefix = g_checkout_eqr_prefix) THEN
483: l_txn_number := qa_ss_const.eam_checkout_txn;
484: --dgupta: End R12 EAM Integration. Bug 4345492
485:
486:
487: END IF;

Line 547: l_txn_number := qa_ss_const.ss_outside_processing_txn;

543: END IF;
544:
545: IF ( instr(p_prefix, g_osp_vqr_prefix) <> 0 ) THEN
546: -- prefix passed has 'QAVQROSP' in it
547: l_txn_number := qa_ss_const.ss_outside_processing_txn;
548:
549: ELSIF ( instr(p_prefix, g_ship_vqr_prefix) <> 0 ) THEN
550: -- prefix passed has 'QAVQRSHP' in it
551: l_txn_number := qa_ss_const.ss_shipments_txn;

Line 551: l_txn_number := qa_ss_const.ss_shipments_txn;

547: l_txn_number := qa_ss_const.ss_outside_processing_txn;
548:
549: ELSIF ( instr(p_prefix, g_ship_vqr_prefix) <> 0 ) THEN
550: -- prefix passed has 'QAVQRSHP' in it
551: l_txn_number := qa_ss_const.ss_shipments_txn;
552:
553: ELSIF ( instr(p_prefix, g_work_vqr_prefix) <> 0 ) THEN
554: -- prefix passed has 'QAVQRWORK' in it
555: l_txn_number := qa_ss_const.eam_work_order_txn;

Line 555: l_txn_number := qa_ss_const.eam_work_order_txn;

551: l_txn_number := qa_ss_const.ss_shipments_txn;
552:
553: ELSIF ( instr(p_prefix, g_work_vqr_prefix) <> 0 ) THEN
554: -- prefix passed has 'QAVQRWORK' in it
555: l_txn_number := qa_ss_const.eam_work_order_txn;
556:
557: ELSIF ( instr(p_prefix, g_asset_vqr_prefix) <> 0 ) THEN
558: -- prefix passed has 'QAVQRASSET' in it
559: l_txn_number := qa_ss_const.eam_asset_txn;

Line 559: l_txn_number := qa_ss_const.eam_asset_txn;

555: l_txn_number := qa_ss_const.eam_work_order_txn;
556:
557: ELSIF ( instr(p_prefix, g_asset_vqr_prefix) <> 0 ) THEN
558: -- prefix passed has 'QAVQRASSET' in it
559: l_txn_number := qa_ss_const.eam_asset_txn;
560:
561: ELSIF ( instr(p_prefix, g_op_vqr_prefix) <> 0 ) THEN
562: -- prefix passed has 'QAVQROP' in it
563: l_txn_number := qa_ss_const.eam_operation_txn;

Line 563: l_txn_number := qa_ss_const.eam_operation_txn;

559: l_txn_number := qa_ss_const.eam_asset_txn;
560:
561: ELSIF ( instr(p_prefix, g_op_vqr_prefix) <> 0 ) THEN
562: -- prefix passed has 'QAVQROP' in it
563: l_txn_number := qa_ss_const.eam_operation_txn;
564:
565: --dgupta: Start R12 EAM Integration. Bug 4345492
566: ELSIF ( instr(p_prefix, g_checkin_vqr_prefix) <> 0 ) THEN
567: -- prefix passed has 'QAVQRCHECKIN' in it

Line 568: l_txn_number := qa_ss_const.eam_checkin_txn;

564:
565: --dgupta: Start R12 EAM Integration. Bug 4345492
566: ELSIF ( instr(p_prefix, g_checkin_vqr_prefix) <> 0 ) THEN
567: -- prefix passed has 'QAVQRCHECKIN' in it
568: l_txn_number := qa_ss_const.eam_checkin_txn;
569:
570: ELSIF ( instr(p_prefix, g_checkout_vqr_prefix) <> 0 ) THEN
571: -- prefix passed has 'QAVQRCHECKOUT' in it
572: l_txn_number := qa_ss_const.eam_checkout_txn;

Line 572: l_txn_number := qa_ss_const.eam_checkout_txn;

568: l_txn_number := qa_ss_const.eam_checkin_txn;
569:
570: ELSIF ( instr(p_prefix, g_checkout_vqr_prefix) <> 0 ) THEN
571: -- prefix passed has 'QAVQRCHECKOUT' in it
572: l_txn_number := qa_ss_const.eam_checkout_txn;
573: --dgupta: End R12 EAM Integration. Bug 4345492
574:
575: END IF;
576:

Line 598: IF p_char_id = qa_ss_const.item THEN

594: -- OUT table structure.
595:
596: x_parents.delete();
597:
598: IF p_char_id = qa_ss_const.item THEN
599: x_parents(1) := qa_ss_const.production_line;
600:
601: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
602: x_parents(1) := qa_ss_const.job_name;

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

595:
596: x_parents.delete();
597:
598: IF p_char_id = qa_ss_const.item THEN
599: x_parents(1) := qa_ss_const.production_line;
600:
601: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
602: x_parents(1) := qa_ss_const.job_name;
603: x_parents(2) := qa_ss_const.production_line;

Line 601: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN

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

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

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

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

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

Line 605: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

601: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
602: x_parents(1) := qa_ss_const.job_name;
603: x_parents(2) := qa_ss_const.production_line;
604:
605: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
606: x_parents(1) := qa_ss_const.job_name;
607: x_parents(2) := qa_ss_const.production_line;
608:
609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

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

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

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

603: x_parents(2) := qa_ss_const.production_line;
604:
605: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
606: x_parents(1) := qa_ss_const.job_name;
607: x_parents(2) := qa_ss_const.production_line;
608:
609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
610: x_parents(1) := qa_ss_const.to_op_seq_num;
611:

Line 609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

605: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
606: x_parents(1) := qa_ss_const.job_name;
607: x_parents(2) := qa_ss_const.production_line;
608:
609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
610: x_parents(1) := qa_ss_const.to_op_seq_num;
611:
612: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
613: x_parents(1) := qa_ss_const.from_op_seq_num;

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

606: x_parents(1) := qa_ss_const.job_name;
607: x_parents(2) := qa_ss_const.production_line;
608:
609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
610: x_parents(1) := qa_ss_const.to_op_seq_num;
611:
612: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
613: x_parents(1) := qa_ss_const.from_op_seq_num;
614:

Line 612: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN

608:
609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
610: x_parents(1) := qa_ss_const.to_op_seq_num;
611:
612: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
613: x_parents(1) := qa_ss_const.from_op_seq_num;
614:
615: ELSIF p_char_id = qa_ss_const.uom THEN
616:

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

609: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
610: x_parents(1) := qa_ss_const.to_op_seq_num;
611:
612: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
613: x_parents(1) := qa_ss_const.from_op_seq_num;
614:
615: ELSIF p_char_id = qa_ss_const.uom THEN
616:
617: x_parents(1) := qa_ss_const.item;

Line 615: ELSIF p_char_id = qa_ss_const.uom THEN

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

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

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

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

614:
615: ELSIF p_char_id = qa_ss_const.uom THEN
616:
617: x_parents(1) := qa_ss_const.item;
618: x_parents(2) := qa_ss_const.production_line;
619:
620: ELSIF p_char_id = qa_ss_const.revision THEN
621: x_parents(1) := qa_ss_const.item;
622: x_parents(2) := qa_ss_const.production_line;

Line 620: ELSIF p_char_id = qa_ss_const.revision THEN

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

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

617: x_parents(1) := qa_ss_const.item;
618: x_parents(2) := qa_ss_const.production_line;
619:
620: ELSIF p_char_id = qa_ss_const.revision THEN
621: x_parents(1) := qa_ss_const.item;
622: x_parents(2) := qa_ss_const.production_line;
623:
624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;

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

618: x_parents(2) := qa_ss_const.production_line;
619:
620: ELSIF p_char_id = qa_ss_const.revision THEN
621: x_parents(1) := qa_ss_const.item;
622: x_parents(2) := qa_ss_const.production_line;
623:
624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;

Line 624: ELSIF p_char_id = qa_ss_const.subinventory THEN

620: ELSIF p_char_id = qa_ss_const.revision THEN
621: x_parents(1) := qa_ss_const.item;
622: x_parents(2) := qa_ss_const.production_line;
623:
624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN

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

621: x_parents(1) := qa_ss_const.item;
622: x_parents(2) := qa_ss_const.production_line;
623:
624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN
629: x_parents(1) := qa_ss_const.subinventory;

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

622: x_parents(2) := qa_ss_const.production_line;
623:
624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN
629: x_parents(1) := qa_ss_const.subinventory;
630: x_parents(2) := qa_ss_const.item;

Line 628: ELSIF p_char_id = qa_ss_const.locator THEN

624: ELSIF p_char_id = qa_ss_const.subinventory THEN
625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN
629: x_parents(1) := qa_ss_const.subinventory;
630: x_parents(2) := qa_ss_const.item;
631: x_parents(3) := qa_ss_const.production_line;
632:

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

625: x_parents(1) := qa_ss_const.item;
626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN
629: x_parents(1) := qa_ss_const.subinventory;
630: x_parents(2) := qa_ss_const.item;
631: x_parents(3) := qa_ss_const.production_line;
632:
633: -- anagarwa Thu Aug 12 15:49:51 PDT 2004

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

626: x_parents(2) := qa_ss_const.production_line;
627:
628: ELSIF p_char_id = qa_ss_const.locator THEN
629: x_parents(1) := qa_ss_const.subinventory;
630: x_parents(2) := qa_ss_const.item;
631: x_parents(3) := qa_ss_const.production_line;
632:
633: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
634: -- bug 3830258 incorrect LOVs in QWB

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

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

Line 636: ELSIF p_char_id = qa_ss_const.lot_number THEN

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

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

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

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

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

Line 643: ELSIF p_char_id = qa_ss_const.serial_number THEN

639:
640: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
641: -- bug 3830258 incorrect LOVs in QWB
642: -- synced up the serial number lov with forms
643: ELSIF p_char_id = qa_ss_const.serial_number THEN
644: x_parents(1) := qa_ss_const.lot_number;
645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;

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

640: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
641: -- bug 3830258 incorrect LOVs in QWB
642: -- synced up the serial number lov with forms
643: ELSIF p_char_id = qa_ss_const.serial_number THEN
644: x_parents(1) := qa_ss_const.lot_number;
645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:

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

641: -- bug 3830258 incorrect LOVs in QWB
642: -- synced up the serial number lov with forms
643: ELSIF p_char_id = qa_ss_const.serial_number THEN
644: x_parents(1) := qa_ss_const.lot_number;
645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN

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

642: -- synced up the serial number lov with forms
643: ELSIF p_char_id = qa_ss_const.serial_number THEN
644: x_parents(1) := qa_ss_const.lot_number;
645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;

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

643: ELSIF p_char_id = qa_ss_const.serial_number THEN
644: x_parents(1) := qa_ss_const.lot_number;
645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;
651:

Line 649: ELSIF p_char_id = qa_ss_const.comp_uom THEN

645: x_parents(2) := qa_ss_const.item;
646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;
651:
652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;

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

646: --x_parents(3) := qa_ss_const.production_line;
647: x_parents(3) := qa_ss_const.revision;
648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;
651:
652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;
654:

Line 652: ELSIF p_char_id = qa_ss_const.comp_revision THEN

648:
649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;
651:
652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;
654:
655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;

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

649: ELSIF p_char_id = qa_ss_const.comp_uom THEN
650: x_parents(1) := qa_ss_const.comp_item;
651:
652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;
654:
655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;
657:

Line 655: ELSIF p_char_id = qa_ss_const.po_line_num THEN

651:
652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;
654:
655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;
657:
658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
659: x_parents(1) := qa_ss_const.po_line_num;

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

652: ELSIF p_char_id = qa_ss_const.comp_revision THEN
653: x_parents(1) := qa_ss_const.comp_item;
654:
655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;
657:
658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
659: x_parents(1) := qa_ss_const.po_line_num;
660: x_parents(2) := qa_ss_const.po_number;

Line 658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN

654:
655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;
657:
658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
659: x_parents(1) := qa_ss_const.po_line_num;
660: x_parents(2) := qa_ss_const.po_number;
661: -- Bug 9817478. Added PO Release Num as parent
662: -- for PO Shipment(for Blanket POs). skolluku.

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

655: ELSIF p_char_id = qa_ss_const.po_line_num THEN
656: x_parents(1) := qa_ss_const.po_number;
657:
658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
659: x_parents(1) := qa_ss_const.po_line_num;
660: x_parents(2) := qa_ss_const.po_number;
661: -- Bug 9817478. Added PO Release Num as parent
662: -- for PO Shipment(for Blanket POs). skolluku.
663: x_parents(3) := qa_ss_const.po_release_num;

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

656: x_parents(1) := qa_ss_const.po_number;
657:
658: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
659: x_parents(1) := qa_ss_const.po_line_num;
660: x_parents(2) := qa_ss_const.po_number;
661: -- Bug 9817478. Added PO Release Num as parent
662: -- for PO Shipment(for Blanket POs). skolluku.
663: x_parents(3) := qa_ss_const.po_release_num;
664:

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

659: x_parents(1) := qa_ss_const.po_line_num;
660: x_parents(2) := qa_ss_const.po_number;
661: -- Bug 9817478. Added PO Release Num as parent
662: -- for PO Shipment(for Blanket POs). skolluku.
663: x_parents(3) := qa_ss_const.po_release_num;
664:
665: ELSIF p_char_id = qa_ss_const.po_release_num THEN
666: x_parents(1) := qa_ss_const.po_number;
667: -- Bug 9817478. Added PO Line Num as a parent.

Line 665: ELSIF p_char_id = qa_ss_const.po_release_num THEN

661: -- Bug 9817478. Added PO Release Num as parent
662: -- for PO Shipment(for Blanket POs). skolluku.
663: x_parents(3) := qa_ss_const.po_release_num;
664:
665: ELSIF p_char_id = qa_ss_const.po_release_num THEN
666: x_parents(1) := qa_ss_const.po_number;
667: -- Bug 9817478. Added PO Line Num as a parent.
668: -- skolluku.
669: x_parents(2) := qa_ss_const.po_line_num;

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

662: -- for PO Shipment(for Blanket POs). skolluku.
663: x_parents(3) := qa_ss_const.po_release_num;
664:
665: ELSIF p_char_id = qa_ss_const.po_release_num THEN
666: x_parents(1) := qa_ss_const.po_number;
667: -- Bug 9817478. Added PO Line Num as a parent.
668: -- skolluku.
669: x_parents(2) := qa_ss_const.po_line_num;
670:

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

665: ELSIF p_char_id = qa_ss_const.po_release_num THEN
666: x_parents(1) := qa_ss_const.po_number;
667: -- Bug 9817478. Added PO Line Num as a parent.
668: -- skolluku.
669: x_parents(2) := qa_ss_const.po_line_num;
670:
671: ELSIF p_char_id = qa_ss_const.order_line THEN
672: x_parents(1) := qa_ss_const.sales_order;
673:

Line 671: ELSIF p_char_id = qa_ss_const.order_line THEN

667: -- Bug 9817478. Added PO Line Num as a parent.
668: -- skolluku.
669: x_parents(2) := qa_ss_const.po_line_num;
670:
671: ELSIF p_char_id = qa_ss_const.order_line THEN
672: x_parents(1) := qa_ss_const.sales_order;
673:
674: ELSIF p_char_id = qa_ss_const.task_number THEN
675: x_parents(1) := qa_ss_const.project_number;

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

668: -- skolluku.
669: x_parents(2) := qa_ss_const.po_line_num;
670:
671: ELSIF p_char_id = qa_ss_const.order_line THEN
672: x_parents(1) := qa_ss_const.sales_order;
673:
674: ELSIF p_char_id = qa_ss_const.task_number THEN
675: x_parents(1) := qa_ss_const.project_number;
676:

Line 674: ELSIF p_char_id = qa_ss_const.task_number THEN

670:
671: ELSIF p_char_id = qa_ss_const.order_line THEN
672: x_parents(1) := qa_ss_const.sales_order;
673:
674: ELSIF p_char_id = qa_ss_const.task_number THEN
675: x_parents(1) := qa_ss_const.project_number;
676:
677: --dgupta: Start R12 EAM Integration. Bug 4345492
678: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

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

671: ELSIF p_char_id = qa_ss_const.order_line THEN
672: x_parents(1) := qa_ss_const.sales_order;
673:
674: ELSIF p_char_id = qa_ss_const.task_number THEN
675: x_parents(1) := qa_ss_const.project_number;
676:
677: --dgupta: Start R12 EAM Integration. Bug 4345492
678: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
679: x_parents(1) := qa_ss_const.asset_group;

Line 678: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

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

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

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

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

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

Line 682: ELSIF p_char_id = qa_ss_const.asset_number THEN

678: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681:
682: ELSIF p_char_id = qa_ss_const.asset_number THEN
683: x_parents(1) := qa_ss_const.asset_group;
684: x_parents(2) := qa_ss_const.asset_instance_number;
685:
686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project

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

679: x_parents(1) := qa_ss_const.asset_group;
680: x_parents(2) := qa_ss_const.asset_number;
681:
682: ELSIF p_char_id = qa_ss_const.asset_number THEN
683: x_parents(1) := qa_ss_const.asset_group;
684: x_parents(2) := qa_ss_const.asset_instance_number;
685:
686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
687: -- added the following dependencies

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

680: x_parents(2) := qa_ss_const.asset_number;
681:
682: ELSIF p_char_id = qa_ss_const.asset_number THEN
683: x_parents(1) := qa_ss_const.asset_group;
684: x_parents(2) := qa_ss_const.asset_instance_number;
685:
686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
687: -- added the following dependencies
688: ELSIF p_char_id = qa_ss_const.asset_activity THEN

Line 688: ELSIF p_char_id = qa_ss_const.asset_activity THEN

684: x_parents(2) := qa_ss_const.asset_instance_number;
685:
686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
687: -- added the following dependencies
688: ELSIF p_char_id = qa_ss_const.asset_activity THEN
689: x_parents(1) := qa_ss_const.asset_group;
690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:

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

685:
686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
687: -- added the following dependencies
688: ELSIF p_char_id = qa_ss_const.asset_activity THEN
689: x_parents(1) := qa_ss_const.asset_group;
690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN

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

686: -- rkaza. 10/22/2003. 3209804. As part of EAM rebuild project
687: -- added the following dependencies
688: ELSIF p_char_id = qa_ss_const.asset_activity THEN
689: x_parents(1) := qa_ss_const.asset_group;
690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;

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

687: -- added the following dependencies
688: ELSIF p_char_id = qa_ss_const.asset_activity THEN
689: x_parents(1) := qa_ss_const.asset_group;
690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;
695: x_parents(2) := qa_ss_const.asset_number;

Line 693: ELSIF p_char_id = qa_ss_const.followup_activity THEN

689: x_parents(1) := qa_ss_const.asset_group;
690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;
695: x_parents(2) := qa_ss_const.asset_number;
696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492

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

690: x_parents(2) := qa_ss_const.asset_number;
691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;
695: x_parents(2) := qa_ss_const.asset_number;
696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492
698:

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

691: x_parents(3) := qa_ss_const.asset_instance_number;
692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;
695: x_parents(2) := qa_ss_const.asset_number;
696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492
698:
699: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

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

692:
693: ELSIF p_char_id = qa_ss_const.followup_activity THEN
694: x_parents(1) := qa_ss_const.asset_group;
695: x_parents(2) := qa_ss_const.asset_number;
696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492
698:
699: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
700: x_parents(1) := qa_ss_const.work_order;

Line 699: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN

695: x_parents(2) := qa_ss_const.asset_number;
696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492
698:
699: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
700: x_parents(1) := qa_ss_const.work_order;
701:
702: -- rkaza. 12/02/2003. bug 3280307.
703: -- Added dependency relation for component item with item

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

696: x_parents(3) := qa_ss_const.asset_instance_number;
697: --dgupta: End R12 EAM Integration. Bug 4345492
698:
699: ELSIF p_char_id = qa_ss_const.maintenance_op_seq THEN
700: x_parents(1) := qa_ss_const.work_order;
701:
702: -- rkaza. 12/02/2003. bug 3280307.
703: -- Added dependency relation for component item with item
704: ELSIF p_char_id = qa_ss_const.comp_item THEN

Line 704: ELSIF p_char_id = qa_ss_const.comp_item THEN

700: x_parents(1) := qa_ss_const.work_order;
701:
702: -- rkaza. 12/02/2003. bug 3280307.
703: -- Added dependency relation for component item with item
704: ELSIF p_char_id = qa_ss_const.comp_item THEN
705: x_parents(1) := qa_ss_const.item;
706:
707: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
708: -- bug 3830258 incorrect LOVs in QWB

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

701:
702: -- rkaza. 12/02/2003. bug 3280307.
703: -- Added dependency relation for component item with item
704: ELSIF p_char_id = qa_ss_const.comp_item THEN
705: x_parents(1) := qa_ss_const.item;
706:
707: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
708: -- bug 3830258 incorrect LOVs in QWB
709: -- synced up the component lot number and component serial number

Line 711: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN

707: -- anagarwa Thu Aug 12 15:49:51 PDT 2004
708: -- bug 3830258 incorrect LOVs in QWB
709: -- synced up the component lot number and component serial number
710: -- lov with forms
711: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
712: x_parents(1) := qa_ss_const.comp_item;
713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;

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

708: -- bug 3830258 incorrect LOVs in QWB
709: -- synced up the component lot number and component serial number
710: -- lov with forms
711: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
712: x_parents(1) := qa_ss_const.comp_item;
713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;
716: x_parents(2) := qa_ss_const.comp_item;

Line 714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN

710: -- lov with forms
711: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
712: x_parents(1) := qa_ss_const.comp_item;
713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;
716: x_parents(2) := qa_ss_const.comp_item;
717: x_parents(3) := qa_ss_const.comp_revision;
718:

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

711: ELSIF p_char_id = qa_ss_const.comp_lot_number THEN
712: x_parents(1) := qa_ss_const.comp_item;
713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;
716: x_parents(2) := qa_ss_const.comp_item;
717: x_parents(3) := qa_ss_const.comp_revision;
718:
719: -- R12 OPM Deviations. Bug 4345503 Start

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

712: x_parents(1) := qa_ss_const.comp_item;
713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;
716: x_parents(2) := qa_ss_const.comp_item;
717: x_parents(3) := qa_ss_const.comp_revision;
718:
719: -- R12 OPM Deviations. Bug 4345503 Start
720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

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

713:
714: ELSIF p_char_id = qa_ss_const.comp_serial_number THEN
715: x_parents(1) := qa_ss_const.comp_lot_number;
716: x_parents(2) := qa_ss_const.comp_item;
717: x_parents(3) := qa_ss_const.comp_revision;
718:
719: -- R12 OPM Deviations. Bug 4345503 Start
720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
721: x_parents(1) := qa_ss_const.process_batch_num;

Line 720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN

716: x_parents(2) := qa_ss_const.comp_item;
717: x_parents(3) := qa_ss_const.comp_revision;
718:
719: -- R12 OPM Deviations. Bug 4345503 Start
720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
721: x_parents(1) := qa_ss_const.process_batch_num;
722:
723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;

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

717: x_parents(3) := qa_ss_const.comp_revision;
718:
719: -- R12 OPM Deviations. Bug 4345503 Start
720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
721: x_parents(1) := qa_ss_const.process_batch_num;
722:
723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 723: ELSIF p_char_id = qa_ss_const.process_operation THEN

719: -- R12 OPM Deviations. Bug 4345503 Start
720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
721: x_parents(1) := qa_ss_const.process_batch_num;
722:
723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN

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

720: ELSIF p_char_id = qa_ss_const.process_batchstep_num THEN
721: x_parents(1) := qa_ss_const.process_batch_num;
722:
723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;

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

721: x_parents(1) := qa_ss_const.process_batch_num;
722:
723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 727: ELSIF p_char_id = qa_ss_const.process_activity THEN

723: ELSIF p_char_id = qa_ss_const.process_operation THEN
724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN

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

724: x_parents(1) := qa_ss_const.process_batch_num;
725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;

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

725: x_parents(2) := qa_ss_const.process_batchstep_num;
726:
727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;

Line 731: ELSIF p_char_id = qa_ss_const.process_resource THEN

727: ELSIF p_char_id = qa_ss_const.process_activity THEN
728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:

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

728: x_parents(1) := qa_ss_const.process_batch_num;
729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:
736: ELSIF p_char_id = qa_ss_const.process_parameter THEN

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

729: x_parents(2) := qa_ss_const.process_batchstep_num;
730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:
736: ELSIF p_char_id = qa_ss_const.process_parameter THEN
737: x_parents(1) := qa_ss_const.process_resource;

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

730:
731: ELSIF p_char_id = qa_ss_const.process_resource THEN
732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:
736: ELSIF p_char_id = qa_ss_const.process_parameter THEN
737: x_parents(1) := qa_ss_const.process_resource;
738:

Line 736: ELSIF p_char_id = qa_ss_const.process_parameter THEN

732: x_parents(1) := qa_ss_const.process_batch_num;
733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:
736: ELSIF p_char_id = qa_ss_const.process_parameter THEN
737: x_parents(1) := qa_ss_const.process_resource;
738:
739: -- R12 OPM Deviations. Bug 4345503 End
740: --

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

733: x_parents(2) := qa_ss_const.process_batchstep_num;
734: x_parents(2) := qa_ss_const.process_activity;
735:
736: ELSIF p_char_id = qa_ss_const.process_parameter THEN
737: x_parents(1) := qa_ss_const.process_resource;
738:
739: -- R12 OPM Deviations. Bug 4345503 End
740: --
741: -- Bug 9032151

Line 745: ELSIF p_char_id = qa_ss_const.item_instance THEN

741: -- Bug 9032151
742: -- Added dependency relation for item instance with item
743: -- skolluku
744: --
745: ELSIF p_char_id = qa_ss_const.item_instance THEN
746: x_parents(1) := qa_ss_const.item;
747:
748: --
749: -- Bug 9359442

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

742: -- Added dependency relation for item instance with item
743: -- skolluku
744: --
745: ELSIF p_char_id = qa_ss_const.item_instance THEN
746: x_parents(1) := qa_ss_const.item;
747:
748: --
749: -- Bug 9359442
750: -- Added dependency relation for item instance serial with item

Line 753: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN

749: -- Bug 9359442
750: -- Added dependency relation for item instance serial with item
751: -- skolluku
752: --
753: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN
754: x_parents(1) := qa_ss_const.item;
755: END IF;
756:
757: END get_dependencies;

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

750: -- Added dependency relation for item instance serial with item
751: -- skolluku
752: --
753: ELSIF p_char_id = qa_ss_const.item_instance_serial THEN
754: x_parents(1) := qa_ss_const.item;
755: END IF;
756:
757: END get_dependencies;
758:

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

921: p_id IN VARCHAR2)
922: RETURN VARCHAR2 IS
923:
924: BEGIN
925: IF(p_id = qa_ss_const.po_number) THEN
926: return qa_chars_api.hardcoded_column(p_id);
927: END IF;
928:
929: return construct_jrad_code(p_element_prefix,p_id);

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

1077:
1078: BEGIN
1079: -- currently we are enabling normalized logic
1080: -- only for PO NUMBER
1081: if(p_char_id = qa_ss_const.po_number) then
1082: return 'T';
1083: end if;
1084:
1085: return 'F';

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

1098: -- currently we are enabling normalized logic
1099: -- only for PO NUMBER. So we are hard coding
1100: -- lov region name. In future, this proc must
1101: -- be generalized.
1102: if(p_char_id = qa_ss_const.po_number) then
1103: return 'PONumberLovRN';
1104: end if;
1105:
1106: return 'QaLovRN';

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

1124: l_lov_region VARCHAR2(100);
1125:
1126: BEGIN
1127:
1128: IF(p_char_id = qa_ss_const.po_number) THEN
1129: l_lov_region := qa_ssqr_jrad_pkg.g_jrad_lov_dir_path || get_lov_region_name(p_plan_id,p_char_id);
1130: jdr_docbuilder.setAttribute(p_char_item,
1131: 'externalListOfValues',
1132: l_lov_region);

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

1679: END IF;
1680:
1681: IF (p_attribute_code = g_last_update_date_attribute) THEN
1682: -- Assign a datatype of DATETIME to last_update_date.
1683: l_data_type := convert_data_type(qa_ss_const.datetime_datatype);
1684: END IF;
1685:
1686: special_elem := jdr_docbuilder.createElement(jdr_docbuilder.OA_NS,
1687: l_item_style);

Line 1835: IF l_element_id = qa_ss_const.po_number THEN

1831: 'contents', child1);
1832: --contents is the grouping name
1833:
1834: -- For MOAC : add normalized column.
1835: IF l_element_id = qa_ss_const.po_number THEN
1836: -- Bug 9954346
1837: -- Moved existing code to outside loop and assigned true to l_po_num_exists flag.
1838: -- skolluku
1839: l_po_num_exists := true;

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

1849: -- Bug 9954346
1850: -- Add the form value for PO Number, if required.
1851: -- skolluku
1852: IF (l_po_num_exists) THEN
1853: l_id_item := create_id_item_for_eqr(p_plan_id,qa_ss_const.po_number);
1854: JDR_DOCBUILDER.addChild(topLevel, JDR_DOCBUILDER.UI_NS,'contents',l_id_item);
1855: END IF;
1856:
1857: child1 := add_special_region_item (

Line 2385: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;

2381:
2382: SELECT jrad_upgrade_ver
2383: INTO l_seed_ver
2384: FROM qa_plans
2385: WHERE plan_id = qa_ss_const.JRAD_UPGRADE_PLAN;
2386:
2387: IF l_jrad_upgrade_ver IS NULL OR
2388: l_jrad_upgrade_ver < l_seed_ver THEN
2389: qa_ssqr_jrad_pkg.map_plan(p_plan_id);