DBA Data[Home] [Help]

APPS.OE_UPG_PC dependencies on OE_UPGRADE_PC_SCOPE

Line 438: FROM oe_upgrade_pc_scope

434:
435: PROCEDURE Upgrade_insert_scope IS
436: CURSOR old_scope IS
437: SELECT distinct SCOPE_CODE, old_object_id
438: FROM oe_upgrade_pc_scope
439: ORDER BY SCOPE_CODE;
440: l_scope_table scope_table;
441: --
442: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 453: UPDATE oe_upgrade_pc_scope

449: ,s.old_object_id
450: ,l_scope_table);
451:
452: IF l_scope_table.COUNT > 0 THEN
453: UPDATE oe_upgrade_pc_scope
454: SET scope_op = l_scope_table(1).scope_op
455: , record_set_id = l_scope_table(1).record_set_id
456: , new_entity_id = l_scope_table(1).validation_entity_id
457: WHERE scope_code = s.scope_code