APPS.MIGRATE_BATCH dependencies on PM_ROUT_DEP

Line 2314: IF (is_table_migrated (p_table_name => 'PM_ROUT_DEP') = FALSE) THEN

2310: COMMIT;
2311: END IF;
2312: END IF;
2313:
2314: IF (is_table_migrated (p_table_name => 'PM_ROUT_DEP') = FALSE) THEN
2315: l_pos := 14;
2316: insert_batch_step_dependencies (x_return_status => l_return_status);
2317: l_pos := 15;
2318:

Line 2324: p_table_name => 'PM_ROUT_DEP',

2320: RAISE error_detail;
2321: END IF;
2322:
2323: set_table_migrated (
2324: p_table_name => 'PM_ROUT_DEP',
2325: x_return_status => l_return_status
2326: );
2327:
2328: IF p_commit THEN

Line 3609: FROM pm_rout_dep dep

3605: ,
3606: NULL --attribute30
3607: ,
3608: NULL --attribute_category
3609: FROM pm_rout_dep dep
3610: WHERE dep_type <
3611: 100 -- Only bring over dependencies for which both steps are still defined...
3612: -- If there is a record in dep table and not the 2 corresponding rows in step table, that means
3613: -- the record was marked for delete in the steps table, and, the old code

Line 3633: UPDATE pm_rout_dep

3629: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3630: p_error_type => 'P'
3631: );
3632:
3633: UPDATE pm_rout_dep
3634: SET dep_type = dep_type + 100
3635: WHERE dep_type < 100;
3636: EXCEPTION
3637: WHEN OTHERS THEN

Line 3652: FROM pm_rout_dep dep

3648: PROCEDURE report_step_dep_orphans IS
3649:
3650: CURSOR cur_get_orphans IS
3651: SELECT batch_id, batchstep_no, dep_step_no
3652: FROM pm_rout_dep dep
3653: WHERE dep_type < 100 AND
3654: (NOT EXISTS ( SELECT 1
3655: FROM gme_batch_steps step
3656: WHERE step.batch_id = dep.batch_id AND