APPS.MIGRATE_BATCH dependencies on GME_BATCH_HEADER

Line 966: FROM gme_batch_header

962: BEGIN
963: l_pos := 1;
964: SELECT batch_status, batch_type
965: INTO v_batch_status, v_batch_type
966: FROM gme_batch_header
967: WHERE batch_id = p_batch_id;
968: l_pos := 2;
969:
970: IF v_batch_status <> 2 OR v_batch_type = 10 THEN

Line 1055: FROM gme_batch_header

1051: BEGIN
1052: l_pos := 1;
1053: SELECT batch_status, plant_code, batch_no, batch_type
1054: INTO v_batch_status, v_plant_code, v_batch_no, v_batch_type
1055: FROM gme_batch_header
1056: WHERE batch_id = p_batch_id;
1057: l_pos := 2;
1058:
1059: IF v_batch_status <> 1 OR v_batch_type = 10 THEN

Line 1165: FROM gme_batch_header

1161: BEGIN
1162: l_pos := 1;
1163: SELECT batch_status
1164: INTO v_batch_status
1165: FROM gme_batch_header
1166: WHERE batch_id = p_batch_id;
1167: l_pos := 2;
1168:
1169: IF v_batch_status = -1 /* Cancelled */ OR

Line 2500: INSERT INTO gme_batch_header

2496: PROCEDURE insert_batch_header (x_return_status OUT NOCOPY VARCHAR2) IS
2497: BEGIN
2498: x_return_status := FND_API.G_RET_STS_SUCCESS;
2499:
2500: INSERT INTO gme_batch_header
2501: (batch_id,
2502: plant_code,
2503: batch_no,
2504: batch_type,

Line 2644: p_table_name => 'gme_batch_header',

2640: FROM pm_btch_hdr_bak
2641: WHERE in_use < 100;
2642:
2643: insert_message (
2644: p_table_name => 'gme_batch_header',
2645: p_procedure_name => 'insert_batch_header',
2646: p_parameters => 'none',
2647: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
2648: p_error_type => 'P'

Line 2660: p_table_name => 'pm_btch_hdr_bak/gme_batch_header',

2656: EXCEPTION
2657: WHEN OTHERS THEN
2658: x_return_status := 'D';
2659: insert_message (
2660: p_table_name => 'pm_btch_hdr_bak/gme_batch_header',
2661: p_procedure_name => 'insert_batch_header',
2662: p_parameters => 'none',
2663: p_message => SQLERRM,
2664: p_error_type => x_return_status

Line 5123: FROM gme_material_details d, gme_batch_header b

5119:
5120: CURSOR get_blank_line_batches IS
5121: SELECT d.batch_id, line_type, max(line_no) max_line_no,
5122: count(1) line_count
5123: FROM gme_material_details d, gme_batch_header b
5124: WHERE d.batch_id=b.batch_id
5125: AND batch_status in (1,2,3)
5126: AND batch_type = 0
5127: GROUP BY d.batch_id, line_type