[Home] [Help]
323: 'ERROR_TEXT', SQLERRM, FALSE );
324: END item_org_validations;
325:
326: --API called from PLM HTML UI org assignment.
327: PROCEDURE process_org_assignments(p_item_org_assign_tab IN OUT NOCOPY SYSTEM.EGO_ITEM_ORG_ASSIGN_TABLE
328: ,p_commit IN VARCHAR2
329: ,p_context IN VARCHAR2 DEFAULT NULL
330: ,x_return_status OUT NOCOPY VARCHAR
331: ,x_msg_count OUT NOCOPY NUMBER)
364: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
365: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
366: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
367: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
368: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
369: FROM dual) A
370: ORDER BY INVENTORY_ITEM_ID;
371:
372: l_error_code VARCHAR2(2000);