DBA Data[Home] [Help]

APPS.GR_ITEM_EXPLOSION_PROP_PKG dependencies on GR_ITEM_EXPLOSION_PROPERTIES

Line 78: INSERT INTO gr_item_explosion_properties

74: IF FND_API.To_Boolean(l_key_exists) THEN
75: RAISE Item_Exists_Error;
76: END IF;
77:
78: INSERT INTO gr_item_explosion_properties
79: (organization_id,
80: inventory_item_id,
81: ingredient_flag,
82: explode_ingredient_flag,

Line 243: UPDATE gr_item_explosion_properties

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_item_explosion_properties
244: SET organization_id = p_organization_id,
245: inventory_item_id = p_inventory_item_id,
246: ingredient_flag = p_ingredient_flag,
247: explode_ingredient_flag = p_explode_ingredient_flag,

Line 355: FROM gr_item_explosion_properties

351:
352: CURSOR c_lock_item
353: IS
354: SELECT *
355: FROM gr_item_explosion_properties
356: WHERE rowid = p_rowid
357: FOR UPDATE NOWAIT;
358: LockItemRcd c_lock_item%ROWTYPE;
359: BEGIN

Line 715: FROM gr_item_explosion_properties ig

711:
712: CURSOR c_get_item_rowid
713: IS
714: SELECT ig.rowid
715: FROM gr_item_explosion_properties ig
716: WHERE ig.organization_id = p_organization_id
717: AND ig.inventory_item_id = p_inventory_item_id;
718: ItemRecord c_get_item_rowid%ROWTYPE;
719: