473: tmp.NewReferenceDesignator ,
474: NULL ReturnStatus ,
475: 'CREATE' TransactionType ,
476: NULL RowIdentifier
477: FROM bom_reference_designators_temp tmp
478: WHERE NOT EXISTS (SELECT 1
479: FROM bom_reference_designators ref,
480: bom_inventory_components comp,
481: bom_bill_of_materials bom,
526: tmp.NewReferenceDesignator ,
527: NULL ReturnStatus ,
528: 'UPDATE' TransactionType ,
529: NULL RowIdentifier
530: FROM bom_reference_designators_temp tmp
531: WHERE EXISTS (SELECT 1
532: FROM bom_reference_designators ref,
533: bom_inventory_components comp,
534: bom_bill_of_materials bom,
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
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