131: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');
133: END IF;
134:
135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)
136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(
137: x_rowid =>v_rowid
138: ,x_WORK_ITEM_ID => v_WORK_ITEM_ID
139: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
132: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Before Calling iex_strategies_pkg.insert_row');
133: END IF;
134:
135: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row)
136: IEX_STRATEGY_WORK_ITEMS_PKG.Insert_Row(
137: x_rowid =>v_rowid
138: ,x_WORK_ITEM_ID => v_WORK_ITEM_ID
139: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
140: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID
359: -- Api body
360: --
361:
362: -- call locking table handler
363: IEX_STRATEGY_WORK_ITEMS_PKG.lock_row (
364: p_strategy_work_item_rec.WORK_ITEM_ID,
365: l_object_version_number
366: );
367:
364: p_strategy_work_item_rec.WORK_ITEM_ID,
365: l_object_version_number
366: );
367:
368: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row)
369: IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row(
370: x_WORK_ITEM_ID => p_strategy_work_item_rec.WORK_ITEM_ID
371: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
372: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID
365: l_object_version_number
366: );
367:
368: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row)
369: IEX_STRATEGY_WORK_ITEMS_PKG.Update_Row(
370: x_WORK_ITEM_ID => p_strategy_work_item_rec.WORK_ITEM_ID
371: ,x_STRATEGY_ID => p_strategy_work_item_rec.STRATEGY_ID
372: ,x_RESOURCE_ID => p_strategy_work_item_rec.RESOURCE_ID
373: ,x_STATUS_CODE => p_strategy_work_item_rec.STATUS_CODE
572: --
573: -- Api body
574: --
575:
576: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row)
577: IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row(p_WORK_ITEM_ID);
578:
579: --
580: -- End of API body
573: -- Api body
574: --
575:
576: -- Invoke table handler(IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row)
577: IEX_STRATEGY_WORK_ITEMS_PKG.Delete_Row(p_WORK_ITEM_ID);
578:
579: --
580: -- End of API body
581: --