APPS.MIGRATE_BATCH dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 3478: INSERT INTO gme_batch_step_dependencies

3474: x_return_status := FND_API.G_RET_STS_SUCCESS;
3475:
3476: report_step_dep_orphans;
3477:
3478: INSERT INTO gme_batch_step_dependencies
3479: (batch_id,
3480: batchstep_id,
3481: dep_type,
3482: dep_step_id,

Line 3626: p_table_name => 'gme_batch_step_dependencies',

3622: WHERE step.batch_id = dep.batch_id AND
3623: step.batchstep_no = dep.dep_step_no);
3624:
3625: insert_message (
3626: p_table_name => 'gme_batch_step_dependencies',
3627: p_procedure_name => 'insert_batch_step_dependencies',
3628: p_parameters => 'none',
3629: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
3630: p_error_type => 'P'

Line 3640: p_table_name => 'GME_BATCH_STEP_DEPENDENCIES',

3636: EXCEPTION
3637: WHEN OTHERS THEN
3638: x_return_status := 'D';
3639: insert_message (
3640: p_table_name => 'GME_BATCH_STEP_DEPENDENCIES',
3641: p_procedure_name => 'INSERT_BATCH_STEP_DEPENDENCIES',
3642: p_parameters => '',
3643: p_message => SQLERRM,
3644: p_error_type => x_return_status

Line 3672: p_table_name => 'gme_batch_step_dependencies',

3668: OPEN cur_get_orphans;
3669: FETCH cur_get_orphans INTO l_cur_get_orphans;
3670: WHILE cur_get_orphans%FOUND LOOP
3671: insert_message (
3672: p_table_name => 'gme_batch_step_dependencies',
3673: p_procedure_name => 'report_step_dep_orphans',
3674: p_parameters => 'Batch_id=>'||to_char(l_cur_get_orphans.batch_id)
3675: ||' step_no=>'||l_cur_get_orphans.batchstep_no
3676: ||' dep_step_no=>'||l_cur_get_orphans.dep_step_no,

Line 3688: p_table_name => 'GME_BATCH_STEP_DEPENDENCIES',

3684:
3685: EXCEPTION
3686: WHEN OTHERS THEN
3687: insert_message (
3688: p_table_name => 'GME_BATCH_STEP_DEPENDENCIES',
3689: p_procedure_name => 'REPORT_STEP_DEP_ORPHANS',
3690: p_parameters => '',
3691: p_message => SQLERRM,
3692: p_error_type => 'D'