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.

[Home] [Help]

APPS.BOM_BOM_ISETUP_IMP dependencies on DBMS_XMLSAVE

Line 747: insCtx DBMS_XMLSave.ctxType;

743: l_bom_ref_desig_rec bom_ref_desig_CUR%ROWTYPE;
744: l_bom_sub_comp_rec bom_sub_comp_CUR%ROWTYPE;
745: l_bom_comp_oper_rec bom_comp_oper_CUR%ROWTYPE;
746:
747: insCtx DBMS_XMLSave.ctxType;
748: rows NUMBER;
749: i NUMBER;
750:
751: -- Following variables are used for logging messages

Line 773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');

769: -- Bom Header Record
770:
771: IF (P_bom_header_XML IS NOT NULL) THEN
772: -- get the context handle
773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document

Line 774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

770:
771: IF (P_bom_header_XML IS NOT NULL) THEN
772: -- get the context handle
773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document
778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);

Line 775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

771: IF (P_bom_header_XML IS NOT NULL) THEN
772: -- get the context handle
773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document
778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);
779: -- this closes the handle

Line 776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');

772: -- get the context handle
773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document
778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);
779: -- this closes the handle
780: DBMS_XMLSave.closeContext(insCtx);

Line 778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);

774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document
778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);
779: -- this closes the handle
780: DBMS_XMLSave.closeContext(insCtx);
781: END IF;
782: -- Bom Revisions Table

Line 780: DBMS_XMLSave.closeContext(insCtx);

776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document
778: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_header_XML);
779: -- this closes the handle
780: DBMS_XMLSave.closeContext(insCtx);
781: END IF;
782: -- Bom Revisions Table
783: /* Bug 3349138 IF (P_bom_revisions_XML IS NOT NULL) THEN
784: -- get the context handle

Line 785: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');

781: END IF;
782: -- Bom Revisions Table
783: /* Bug 3349138 IF (P_bom_revisions_XML IS NOT NULL) THEN
784: -- get the context handle
785: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document

Line 786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

782: -- Bom Revisions Table
783: /* Bug 3349138 IF (P_bom_revisions_XML IS NOT NULL) THEN
784: -- get the context handle
785: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document
790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);

Line 787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

783: /* Bug 3349138 IF (P_bom_revisions_XML IS NOT NULL) THEN
784: -- get the context handle
785: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document
790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
791: -- this closes the handle

Line 788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');

784: -- get the context handle
785: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document
790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
791: -- this closes the handle
792: DBMS_XMLSave.closeContext(insCtx);

Line 790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);

786: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
787: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document
790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
791: -- this closes the handle
792: DBMS_XMLSave.closeContext(insCtx);
793: END IF;
794: */

Line 792: DBMS_XMLSave.closeContext(insCtx);

788: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
789: -- this inserts the document
790: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
791: -- this closes the handle
792: DBMS_XMLSave.closeContext(insCtx);
793: END IF;
794: */
795: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
796: -- Bom Inventory Components

Line 798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');

794: */
795: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
796: -- Bom Inventory Components
797: -- get the context handle
798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document

Line 799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

795: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
796: -- Bom Inventory Components
797: -- get the context handle
798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document
803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);

Line 800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

796: -- Bom Inventory Components
797: -- get the context handle
798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document
803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
804: -- this closes the handle

Line 801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');

797: -- get the context handle
798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document
803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
804: -- this closes the handle
805: DBMS_XMLSave.closeContext(insCtx);

Line 803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);

799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document
803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
804: -- this closes the handle
805: DBMS_XMLSave.closeContext(insCtx);
806: END IF;
807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN

Line 805: DBMS_XMLSave.closeContext(insCtx);

801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document
803: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
804: -- this closes the handle
805: DBMS_XMLSave.closeContext(insCtx);
806: END IF;
807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
808: -- Bom Substitute Components Table
809: -- get the context handle

Line 810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

806: END IF;
807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
808: -- Bom Substitute Components Table
809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document

Line 811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

807: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
808: -- Bom Substitute Components Table
809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document
815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);

Line 812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

808: -- Bom Substitute Components Table
809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document
815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
816: -- this closes the handle

Line 813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');

809: -- get the context handle
810: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document
815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
816: -- this closes the handle
817: DBMS_XMLSave.closeContext(insCtx);

Line 815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);

811: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
812: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document
815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
816: -- this closes the handle
817: DBMS_XMLSave.closeContext(insCtx);
818: END IF;
819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN

Line 817: DBMS_XMLSave.closeContext(insCtx);

813: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
814: -- this inserts the document
815: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
816: -- this closes the handle
817: DBMS_XMLSave.closeContext(insCtx);
818: END IF;
819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
820: -- Bom Reference Designators Table
821: -- get the context handle

Line 822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');

818: END IF;
819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
820: -- Bom Reference Designators Table
821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document

Line 823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
820: -- Bom Reference Designators Table
821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document
827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);

Line 824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

820: -- Bom Reference Designators Table
821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document
827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
828: -- this closes the handle

Line 825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');

821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document
827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
828: -- this closes the handle
829: DBMS_XMLSave.closeContext(insCtx);

Line 827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);

823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document
827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
828: -- this closes the handle
829: DBMS_XMLSave.closeContext(insCtx);
830: END IF;
831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN

Line 829: DBMS_XMLSave.closeContext(insCtx);

825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document
827: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
828: -- this closes the handle
829: DBMS_XMLSave.closeContext(insCtx);
830: END IF;
831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
832: -- Bom Component Operations Table
833: -- get the context handle

Line 834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');

830: END IF;
831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
832: -- Bom Component Operations Table
833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document

Line 835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

831: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
832: -- Bom Component Operations Table
833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document
839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);

Line 836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

832: -- Bom Component Operations Table
833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document
839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
840: -- this closes the handle

Line 837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');

833: -- get the context handle
834: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document
839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
840: -- this closes the handle
841: DBMS_XMLSave.closeContext(insCtx);

Line 839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);

835: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
836: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document
839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
840: -- this closes the handle
841: DBMS_XMLSave.closeContext(insCtx);
842: END IF;
843: /* 090403

Line 841: DBMS_XMLSave.closeContext(insCtx);

837: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
838: -- this inserts the document
839: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
840: -- this closes the handle
841: DBMS_XMLSave.closeContext(insCtx);
842: END IF;
843: /* 090403
844: -- update the temp tables for the DATE and floating point NUMBER columns
845: OPEN bom_updates_CUR;

Line 949: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');

945: /* Bug 3349138 IF (P_bom_revisions_XML IS NOT NULL) THEN
946: * Moved this code above. -TMANDA 26/03/03
947: -- Bom Revisions Table
948: -- get the context handle
949: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document

Line 950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

946: * Moved this code above. -TMANDA 26/03/03
947: -- Bom Revisions Table
948: -- get the context handle
949: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document
954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);

Line 951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

947: -- Bom Revisions Table
948: -- get the context handle
949: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document
954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
955: -- this closes the handle

Line 952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');

948: -- get the context handle
949: insCtx := DBMS_XMLSave.newContext('BOM_REVISIONS_TEMP');
950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document
954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
955: -- this closes the handle
956: DBMS_XMLSave.closeContext(insCtx);

Line 954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);

950: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
951: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document
954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
955: -- this closes the handle
956: DBMS_XMLSave.closeContext(insCtx);
957: *
958: i := 1;

Line 956: DBMS_XMLSave.closeContext(insCtx);

952: DBMS_XMLSave.setRowTag(insCtx , 'BomRevisionsVO');
953: -- this inserts the document
954: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_revisions_XML);
955: -- this closes the handle
956: DBMS_XMLSave.closeContext(insCtx);
957: *
958: i := 1;
959: FOR bom_revisions_rec IN bom_revisions_CUR LOOP
960: l_bom_revisions_tbl(i).assembly_item_name := bom_revisions_rec.AssemblyItemName;

Line 1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');

1000: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
1001: /*Moved this code above - TMANDA 26/03/03
1002: -- Bom Inventory Components
1003: -- get the context handle
1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document

Line 1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

1001: /*Moved this code above - TMANDA 26/03/03
1002: -- Bom Inventory Components
1003: -- get the context handle
1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document
1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);

Line 1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

1002: -- Bom Inventory Components
1003: -- get the context handle
1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document
1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
1010: -- this closes the handle

Line 1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');

1003: -- get the context handle
1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document
1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
1010: -- this closes the handle
1011: DBMS_XMLSave.closeContext(insCtx);

Line 1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);

1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document
1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
1010: -- this closes the handle
1011: DBMS_XMLSave.closeContext(insCtx);
1012: */
1013: i := 1;

Line 1011: DBMS_XMLSave.closeContext(insCtx);

1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document
1009: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_inv_comps_XML);
1010: -- this closes the handle
1011: DBMS_XMLSave.closeContext(insCtx);
1012: */
1013: i := 1;
1014: /*
1015: OPEN bom_comp_CUR;

Line 1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

1091: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
1092: /*
1093: -- Bom Substitute Components Table
1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document

Line 1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

1092: /*
1093: -- Bom Substitute Components Table
1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document
1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);

Line 1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

1093: -- Bom Substitute Components Table
1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document
1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
1101: -- this closes the handle

Line 1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');

1094: -- get the context handle
1095: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document
1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
1101: -- this closes the handle
1102: DBMS_XMLSave.closeContext(insCtx);

Line 1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);

1096: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1097: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document
1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
1101: -- this closes the handle
1102: DBMS_XMLSave.closeContext(insCtx);
1103: */
1104: i := 1;

Line 1102: DBMS_XMLSave.closeContext(insCtx);

1098: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1099: -- this inserts the document
1100: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_sub_comps_XML);
1101: -- this closes the handle
1102: DBMS_XMLSave.closeContext(insCtx);
1103: */
1104: i := 1;
1105: /*
1106: OPEN bom_sub_comp_CUR;

Line 1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');

1151: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
1152: /*
1153: -- Bom Reference Designators Table
1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document

Line 1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

1152: /*
1153: -- Bom Reference Designators Table
1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document
1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);

Line 1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

1153: -- Bom Reference Designators Table
1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document
1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
1161: -- this closes the handle

Line 1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');

1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document
1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
1161: -- this closes the handle
1162: DBMS_XMLSave.closeContext(insCtx);

Line 1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);

1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document
1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
1161: -- this closes the handle
1162: DBMS_XMLSave.closeContext(insCtx);
1163: */
1164:

Line 1162: DBMS_XMLSave.closeContext(insCtx);

1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document
1160: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_ref_desgs_XML);
1161: -- this closes the handle
1162: DBMS_XMLSave.closeContext(insCtx);
1163: */
1164:
1165: i := 1;
1166: /*

Line 1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');

1210: IF (P_bom_comp_oper_XML IS NOT NULL) THEN
1211: /*
1212: -- Bom Component Operations Table
1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document

Line 1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);

1211: /*
1212: -- Bom Component Operations Table
1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document
1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);

Line 1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

1212: -- Bom Component Operations Table
1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document
1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
1220: -- this closes the handle

Line 1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');

1213: -- get the context handle
1214: insCtx := DBMS_XMLSave.newContext('BOM_COMPONENT_OPERATIONS_TEMP');
1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document
1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
1220: -- this closes the handle
1221: DBMS_XMLSave.closeContext(insCtx);

Line 1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);

1215: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1216: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document
1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
1220: -- this closes the handle
1221: DBMS_XMLSave.closeContext(insCtx);
1222: */
1223: i := 1;

Line 1221: DBMS_XMLSave.closeContext(insCtx);

1217: DBMS_XMLSave.setRowTag(insCtx , 'ComponentOperationsVO');
1218: -- this inserts the document
1219: rows := DBMS_XMLSave.insertXML(insCtx, P_bom_comp_oper_XML);
1220: -- this closes the handle
1221: DBMS_XMLSave.closeContext(insCtx);
1222: */
1223: i := 1;
1224: /*
1225: OPEN bom_comp_oper_CUR;