DBA Data[Home] [Help]

APPS.MIGRATE_BATCH dependencies on PM_OPRN_WIP

Line 2352: IF (is_table_migrated (p_table_name => 'PM_OPRN_WIP') = FALSE) THEN

2348: COMMIT;
2349: END IF;
2350: END IF;
2351:
2352: IF (is_table_migrated (p_table_name => 'PM_OPRN_WIP') = FALSE) THEN
2353: l_pos := 18;
2354: insert_batch_step_transfers (x_return_status => l_return_status);
2355: l_pos := 19;
2356:

Line 2362: p_table_name => 'PM_OPRN_WIP',

2358: RAISE error_detail;
2359: END IF;
2360:
2361: set_table_migrated (
2362: p_table_name => 'PM_OPRN_WIP',
2363: x_return_status => l_return_status
2364: );
2365:
2366: IF p_commit THEN

Line 4016: FROM pm_oprn_wip

4012: attribute28,
4013: attribute29,
4014: attribute30,
4015: attribute_category
4016: FROM pm_oprn_wip
4017: WHERE delete_mark < 100;
4018:
4019: insert_message (
4020: p_table_name => 'gme_batch_step_transfers',

Line 4027: UPDATE pm_oprn_wip

4023: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
4024: p_error_type => 'P'
4025: );
4026:
4027: UPDATE pm_oprn_wip
4028: SET delete_mark = delete_mark + 100
4029: WHERE delete_mark < 100;
4030: EXCEPTION
4031: WHEN OTHERS THEN