APPS.GME_API_GRP dependencies on GME_BATCH_STEPS

Line 432: FROM gme_batch_steps s,

428: l_available_quantity NUMBER;
429:
430: CURSOR cur_get_step_status (v_material_detail_id NUMBER) IS
431: SELECT step_status
432: FROM gme_batch_steps s,
433: gme_batch_step_items i
434: WHERE s.batchstep_id = i.batchstep_id
435: AND i.material_detail_id = v_material_detail_id;
436:

Line 605: l_batch_step gme_batch_steps%ROWTYPE;

601: ,p_org_id IN NUMBER
602: ,p_quality_status IN NUMBER
603: ,x_return_status OUT NOCOPY VARCHAR2)
604: IS
605: l_batch_step gme_batch_steps%ROWTYPE;
606: expected_err EXCEPTION;
607: BEGIN
608: IF NOT gme_common_pvt.g_setup_done THEN
609: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_org_id);

Line 620: IF (NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) ) THEN

616:
617: gme_common_pvt.set_timestamp;
618: l_batch_step.batchstep_id := p_batchstep_id;
619:
620: IF (NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) ) THEN
621: RAISE expected_err;
622: END IF;
623:
624: IF ( p_quality_status IS NULL

Line 644: IF (NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) ) THEN

640: END IF;
641:
642: l_batch_step.quality_status := p_quality_status;
643:
644: IF (NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) ) THEN
645: RAISE expected_err;
646: END IF;
647: EXCEPTION
648: WHEN expected_err THEN

Line 1174: FROM gme_batch_step_items a, gme_batch_steps b

1170: ORDER BY m.material_requirement_date, m.batch_id, m.material_detail_id;
1171:
1172: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
1173: SELECT b.*
1174: FROM gme_batch_step_items a, gme_batch_steps b
1175: WHERE a.batchstep_id = b.batchstep_id
1176: AND a.material_detail_id = p_material_detail_id;
1177:
1178: CURSOR get_msg (v_msg_name IN VARCHAR2) IS

Line 1195: l_batchstep_rec gme_batch_steps%ROWTYPE;

1191: x_return_status VARCHAR2 (1);
1192: l_batch_header_rec gme_batch_header%ROWTYPE;
1193: l_old_item_rec item_master_cursor%ROWTYPE;
1194: l_new_item_rec item_master_cursor%ROWTYPE;
1195: l_batchstep_rec gme_batch_steps%ROWTYPE;
1196: x_batchstep_rec gme_batch_steps%ROWTYPE;
1197: l_rsc_trans_count NUMBER;
1198: l_temp_qty NUMBER;
1199: l_trans_loaded BOOLEAN DEFAULT FALSE;

Line 1196: x_batchstep_rec gme_batch_steps%ROWTYPE;

1192: l_batch_header_rec gme_batch_header%ROWTYPE;
1193: l_old_item_rec item_master_cursor%ROWTYPE;
1194: l_new_item_rec item_master_cursor%ROWTYPE;
1195: l_batchstep_rec gme_batch_steps%ROWTYPE;
1196: x_batchstep_rec gme_batch_steps%ROWTYPE;
1197: l_rsc_trans_count NUMBER;
1198: l_temp_qty NUMBER;
1199: l_trans_loaded BOOLEAN DEFAULT FALSE;
1200: l_oneitem_success BOOLEAN DEFAULT FALSE;

Line 2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h

2969: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2970: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2971: CURSOR Cur_get_step(v_line_id NUMBER) IS
2972: SELECT s.step_status, h.automatic_step_calculation
2973: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2974: WHERE r.batchstep_resource_id = v_line_id
2975: AND a.batchstep_activity_id = r.batchstep_activity_id
2976: AND s.batchstep_id = a.batchstep_id
2977: AND h.batch_id = s.batch_id;