DBA Data[Home] [Help]

APPS.EGO_ITEM_ORG_ASSIGN_PVT dependencies on EGO_ITEM_ORG_ASSIGN_TABLE

Line 315: PROCEDURE process_org_assignments(p_item_org_assign_tab IN OUT NOCOPY SYSTEM.EGO_ITEM_ORG_ASSIGN_TABLE

311: 'ERROR_TEXT', SQLERRM, FALSE );
312: END item_org_validations;
313:
314: --API called from PLM HTML UI org assignment.
315: PROCEDURE process_org_assignments(p_item_org_assign_tab IN OUT NOCOPY SYSTEM.EGO_ITEM_ORG_ASSIGN_TABLE
316: ,p_commit IN VARCHAR2
317: ,p_context IN VARCHAR2 DEFAULT NULL
318: ,x_return_status OUT NOCOPY VARCHAR
319: ,x_msg_count OUT NOCOPY NUMBER)

Line 356: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)

352: ,A.SECONDARY_DEFAULT_IND SECONDARY_DEFAULT_IND
353: ,A.ONT_PRICING_QTY_SOURCE ONT_PRICING_QTY_SOURCE
354: ,A.DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_HIGH
355: ,A.DUAL_UOM_DEVIATION_LOW DUAL_UOM_DEVIATION_LOW
356: FROM THE (SELECT CAST(p_item_org_assign_tab AS "SYSTEM".EGO_ITEM_ORG_ASSIGN_TABLE)
357: FROM dual) A
358: ORDER BY INVENTORY_ITEM_ID;
359:
360: l_error_code VARCHAR2(2000);