eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_BATCH_STEP_ITEMS

Line 17: l_batchstep_items gme_batch_step_items%ROWTYPE;

13: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
14: IS
15: l_api_name CONSTANT VARCHAR2 (30) := 'insert_material_line';
16: l_material_detail_rec gme_material_details%ROWTYPE;
17: l_batchstep_items gme_batch_step_items%ROWTYPE;
18: l_batch_step_rec gme_batch_steps%ROWTYPE;
19: l_out_material_detail_tbl gme_common_pvt.material_details_tab;
20: l_material_detail_tbl gme_common_pvt.material_details_tab;
21: l_recipe_id NUMBER;

Line 100: IF NOT gme_batch_step_items_dbl.insert_row

96: l_batchstep_items.material_detail_id := x_material_detail_rec.material_detail_id;
97: l_batchstep_items.batch_id := x_material_detail_rec.batch_id;
98: l_batchstep_items.batchstep_id := p_batch_step_rec.batchstep_id;
99:
100: IF NOT gme_batch_step_items_dbl.insert_row
101: (p_batch_step_items => l_batchstep_items
102: ,x_batch_step_items => l_batchstep_items) THEN
103: l_proc := 'gme_batch_step_items_dbl.insert_row';
104: RAISE error_dbl;

Line 103: l_proc := 'gme_batch_step_items_dbl.insert_row';

99:
100: IF NOT gme_batch_step_items_dbl.insert_row
101: (p_batch_step_items => l_batchstep_items
102: ,x_batch_step_items => l_batchstep_items) THEN
103: l_proc := 'gme_batch_step_items_dbl.insert_row';
104: RAISE error_dbl;
105: END IF;
106: END IF;
107:

Line 2761: FROM gme_batch_step_items si, gme_batch_steps s

2757: IS
2758: --FPBug#4524232 Begin
2759: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS
2760: SELECT steprelease_type,step_status
2761: FROM gme_batch_step_items si, gme_batch_steps s
2762: WHERE si.batchstep_id = s.batchstep_id
2763: AND si.material_detail_id = v_material_detail_id;
2764: CURSOR Cur_get_batch_status(v_batch_id NUMBER) IS
2765: SELECT batch_status

Line 3417: FROM gme_batch_step_items

3413:
3414: l_ph_batch_step_rec.batch_id:=l_db_mtl_dtl_rec.phantom_id;
3415:
3416: SELECT batchstep_id INTO l_ph_batch_step_rec.batchstep_id
3417: FROM gme_batch_step_items
3418: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3419: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3420: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3421: l_proc := 'gme_batch_steps_dbl.fetch_row';

Line 3460: FROM gme_batch_step_items

3456: FROM gme_batch_steps
3457: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3458: AND batchstep_id =
3459: (SELECT batchstep_id
3460: FROM gme_batch_step_items
3461: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3462: AND material_detail_id =
3463: l_ph_mtl_dtl_rec.material_detail_id );
3464: ELSE

Line 4536: DELETE FROM gme_batch_step_items

4532: AND line_type = p_material_detail_rec.line_type
4533: AND line_no >= p_material_detail_rec.line_no;
4534:
4535: IF p_batch_step_rec.batchstep_id IS NOT NULL THEN
4536: DELETE FROM gme_batch_step_items
4537: WHERE material_detail_id =
4538: p_material_detail_rec.material_detail_id
4539: AND batchstep_id = p_batch_step_rec.batchstep_id;
4540: