DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_HEADER_MIG

Line 57: FROM gme_batch_header_mig

53: item_not_defined EXCEPTION;
54:
55: CURSOR Cur_get_batches IS
56: SELECT *
57: FROM gme_batch_header_mig
58: WHERE NVL(migrated_batch_ind, ' ') <> 'M'
59: AND organization_id IS NOT NULL
60: ORDER BY batch_id;
61:

Line 541: UPDATE gme_batch_header_mig

537:
538: create_batch_mapping(p_batch_header_mig => get_batches,
539: p_batch_header => l_batch_header);
540:
541: UPDATE gme_batch_header_mig
542: SET migrated_batch_ind = 'M'
543: WHERE batch_id = get_batches.batch_id;
544:
545: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 674: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

670: p_db_error => SQLERRM,
671: p_app_short_name => 'GMA');
672: END recreate_open_batches;
673:
674: PROCEDURE build_batch_hdr(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
675: x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE) IS
676: BEGIN
677: x_batch_header.batch_id := p_batch_header_mig.batch_id;
678: x_batch_header.plant_code := p_batch_header_mig.plant_code;

Line 1489: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,

1485: gme_debug.put_line('End procedure '||l_api_name);
1486: END IF;
1487: END create_batch_step_transfers;
1488:
1489: PROCEDURE create_batch_mapping(p_batch_header_mig IN gme_batch_header_mig%ROWTYPE,
1490: p_batch_header IN gme_batch_header%ROWTYPE) IS
1491: BEGIN
1492: INSERT INTO gme_batch_mapping_mig(plant_code,
1493: old_batch_id,

Line 1627: FROM gme_batch_header_mig o, gme_batch_mapping_mig m

1623:
1624: PROCEDURE release_batches IS
1625: CURSOR Cur_wip_batches IS
1626: SELECT m.*, o.actual_start_date
1627: FROM gme_batch_header_mig o, gme_batch_mapping_mig m
1628: WHERE o.batch_status = gme_common_pvt.g_batch_wip
1629: AND m.old_batch_id = o.batch_id
1630: AND o.parentline_id IS NULL
1631: AND m.new_batch_id NOT IN (SELECT batch_id