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.

[Home] [Help]

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 140: IF NOT gme_batch_step_items_dbl.insert_row

136: l_batchstep_items.material_detail_id := x_material_detail_rec.material_detail_id;
137: l_batchstep_items.batch_id := x_material_detail_rec.batch_id;
138: l_batchstep_items.batchstep_id := p_batch_step_rec.batchstep_id;
139:
140: IF NOT gme_batch_step_items_dbl.insert_row
141: (p_batch_step_items => l_batchstep_items
142: ,x_batch_step_items => l_batchstep_items) THEN
143: l_proc := 'gme_batch_step_items_dbl.insert_row';
144: RAISE error_dbl;

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

139:
140: IF NOT gme_batch_step_items_dbl.insert_row
141: (p_batch_step_items => l_batchstep_items
142: ,x_batch_step_items => l_batchstep_items) THEN
143: l_proc := 'gme_batch_step_items_dbl.insert_row';
144: RAISE error_dbl;
145: END IF;
146: END IF;
147:

Line 2905: FROM gme_batch_step_items si, gme_batch_steps s

2901: IS
2902: --FPBug#4524232 Begin
2903: CURSOR Cur_get_step_status(v_material_detail_id NUMBER) IS
2904: SELECT steprelease_type,step_status
2905: FROM gme_batch_step_items si, gme_batch_steps s
2906: WHERE si.batchstep_id = s.batchstep_id
2907: AND si.material_detail_id = v_material_detail_id;
2908: CURSOR Cur_get_batch_status(v_batch_id NUMBER) IS
2909: SELECT batch_status

Line 3563: FROM gme_batch_step_items

3559:
3560: l_ph_batch_step_rec.batch_id:=l_db_mtl_dtl_rec.phantom_id;
3561:
3562: SELECT batchstep_id INTO l_ph_batch_step_rec.batchstep_id
3563: FROM gme_batch_step_items
3564: WHERE batch_id = l_mtl_dtl_rec.phantom_id
3565: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3566: IF NOT gme_batch_steps_dbl.fetch_row(l_ph_batch_step_rec, l_ph_batch_step_rec) THEN
3567: l_proc := 'gme_batch_steps_dbl.fetch_row';

Line 3606: FROM gme_batch_step_items

3602: FROM gme_batch_steps
3603: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3604: AND batchstep_id =
3605: (SELECT batchstep_id
3606: FROM gme_batch_step_items
3607: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3608: AND material_detail_id =
3609: l_ph_mtl_dtl_rec.material_detail_id );
3610: ELSE

Line 4729: DELETE FROM gme_batch_step_items

4725: AND line_type = p_material_detail_rec.line_type
4726: AND line_no >= p_material_detail_rec.line_no;
4727:
4728: IF p_batch_step_rec.batchstep_id IS NOT NULL THEN
4729: DELETE FROM gme_batch_step_items
4730: WHERE material_detail_id =
4731: p_material_detail_rec.material_detail_id
4732: AND batchstep_id = p_batch_step_rec.batchstep_id;
4733: