APPS.MIGRATE_BATCH dependencies on GME_MATERIAL_DETAILS

Line 2675: INSERT INTO gme_material_details

2671: error_detail EXCEPTION;
2672: BEGIN
2673: x_return_status := FND_API.G_RET_STS_SUCCESS;
2674:
2675: INSERT INTO gme_material_details
2676: (material_detail_id,
2677: batch_id,
2678: formulaline_id,
2679: line_no,

Line 2811: p_table_name => 'gme_material_details',

2807: FROM pm_matl_dtl_bak
2808: WHERE in_use < 100;
2809:
2810: insert_message (
2811: p_table_name => 'gme_material_details',
2812: p_procedure_name => 'insert_material_details',
2813: p_parameters => 'none',
2814: p_message => 'number of records inserted = ' || SQL%ROWCOUNT,
2815: p_error_type => 'P'

Line 2832: p_table_name => 'GME_MATERIAL_DETAILS',

2828: x_return_status := l_return_status;
2829: WHEN OTHERS THEN
2830: x_return_status := 'D';
2831: insert_message (
2832: p_table_name => 'GME_MATERIAL_DETAILS',
2833: p_procedure_name => 'INSERT_MATERIAL_DETAILS',
2834: p_parameters => '',
2835: p_message => SQLERRM,
2836: p_error_type => x_return_status

Line 3396: FROM gme_material_details matl

3392: WHERE step.batch_id = pm.batch_id AND
3393: step.batchstep_no = pm.batchstep_no)
3394: AND
3395: EXISTS ( SELECT 1
3396: FROM gme_material_details matl
3397: WHERE matl.batch_id = pm.batch_id AND
3398: matl.material_detail_id = pm.batchline_id)
3399: GROUP BY batchline_id;
3400:

Line 3435: FROM gme_material_details matl

3431: FROM gme_batch_steps step
3432: WHERE step.batch_id = pm.batch_id AND
3433: step.batchstep_no = pm.batchstep_no) OR
3434: NOT EXISTS ( SELECT 1
3435: FROM gme_material_details matl
3436: WHERE matl.batch_id = pm.batch_id AND
3437: matl.material_detail_id = pm.batchline_id)
3438: );
3439:

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

Line 5132: FROM gme_material_details

5128: HAVING max(line_no) <> count(1);
5129:
5130: CURSOR get_matl (v_batch_id NUMBER, v_line_type NUMBER) IS
5131: SELECT material_detail_id
5132: FROM gme_material_details
5133: WHERE batch_id = v_batch_id
5134: AND line_type = v_line_type
5135: ORDER BY line_no asc;
5136:

Line 5155: p_table_name => 'gme_material_details',

5151: l_pos := 3;
5152: WHILE get_blank_line_batches%FOUND LOOP
5153: l_pos := 4;
5154: insert_message (
5155: p_table_name => 'gme_material_details',
5156: p_procedure_name => 'renumber_blank_line_no',
5157: p_parameters => 'batch_id = '||l_get_bl_batches.batch_id||
5158: ' line_type = '||l_get_bl_batches.line_type||
5159: ' max_line_no = '||

Line 5174: UPDATE gme_material_details

5170: FOR rec IN get_matl(l_get_bl_batches.batch_id,
5171: l_get_bl_batches.line_type) LOOP
5172: l_pos := 7;
5173:
5174: UPDATE gme_material_details
5175: SET line_no = l_line_no
5176: WHERE material_detail_id = rec.material_detail_id;
5177:
5178: l_pos := 8;

Line 5190: p_table_name => 'gme_material_details',

5186: END LOOP;
5187:
5188: l_pos := 12;
5189: insert_message (
5190: p_table_name => 'gme_material_details',
5191: p_procedure_name => 'renumber_blank_line_no',
5192: p_parameters => 'none',
5193: p_message => 'Number of batches to renumber for blank line_no = ' || l_dup_no,
5194: p_error_type => 'P'

Line 5200: p_table_name => 'gme_material_details',

5196:
5197: EXCEPTION
5198: WHEN OTHERS THEN
5199: insert_message (
5200: p_table_name => 'gme_material_details',
5201: p_procedure_name => 'renumber_blank_line_no',
5202: p_parameters => 'none',
5203: p_message => SQLERRM || ' with pos = ' || l_pos,
5204: p_error_type => 'D'