[Home] [Help]
109: , NULL Delete_Group_Name
110: , NULL DG_Description
111: , NULL ser_start_op_seq
112: , NULL row_identifier
113: FROM bom_routing_header_temp tmp,
114: mtl_parameters org,
115: mtl_system_items_kfv item
116: WHERE org.organization_code = tmp.OrganizationCode
117: AND item.organization_id = org.organization_id
158: , NULL Delete_Group_Name
159: , NULL DG_Description
160: , NULL ser_start_op_seq
161: , NULL row_identifier
162: FROM bom_routing_header_temp tmp,
163: mtl_parameters org,
164: mtl_system_items_kfv item
165: WHERE org.organization_code = tmp.OrganizationCode
166: AND item.organization_id = org.organization_id
834: FND_MESSAGE.SET_NAME('BOM', 'BOM_SETUP_NO_ROWS');
835: FND_MESSAGE.RETRIEVE(X_G_msg_data);
836: ELSE
837: -- get the context handle
838: insCtx := DBMS_XMLSave.newContext('BOM_ROUTING_HEADER_TEMP');
839: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
840: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
841: DBMS_XMLSave.setRowTag(insCtx , 'OperationalRoutingsVO');
842: -- this inserts the document