APPS.GME_API_GRP dependencies on GME_BATCH_STEPS

Line 411: FROM gme_batch_steps s,

407: l_available_quantity NUMBER;
408:
409: CURSOR cur_get_step_status (v_material_detail_id NUMBER) IS
410: SELECT step_status
411: FROM gme_batch_steps s,
412: gme_batch_step_items i
413: WHERE s.batchstep_id = i.batchstep_id
414: AND i.material_detail_id = v_material_detail_id;
415:

Line 581: l_batch_step gme_batch_steps%ROWTYPE;

577: ,p_org_id IN NUMBER
578: ,p_quality_status IN NUMBER
579: ,x_return_status OUT NOCOPY VARCHAR2)
580: IS
581: l_batch_step gme_batch_steps%ROWTYPE;
582: expected_err EXCEPTION;
583: BEGIN
584: IF NOT gme_common_pvt.g_setup_done THEN
585: gme_common_pvt.g_setup_done := gme_common_pvt.setup (p_org_id);

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

592:
593: gme_common_pvt.set_timestamp;
594: l_batch_step.batchstep_id := p_batchstep_id;
595:
596: IF (NOT (gme_batch_steps_dbl.fetch_row (l_batch_step, l_batch_step) ) ) THEN
597: RAISE expected_err;
598: END IF;
599:
600: IF ( p_quality_status IS NULL

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

616: END IF;
617:
618: l_batch_step.quality_status := p_quality_status;
619:
620: IF (NOT (gme_batch_steps_dbl.update_row (l_batch_step) ) ) THEN
621: RAISE expected_err;
622: END IF;
623: EXCEPTION
624: WHEN expected_err THEN

Line 1145: FROM gme_batch_step_items a, gme_batch_steps b

1141: ORDER BY m.material_requirement_date, m.batch_id, m.material_detail_id;
1142:
1143: CURSOR c_batchsteps (p_material_detail_id IN NUMBER) IS
1144: SELECT b.*
1145: FROM gme_batch_step_items a, gme_batch_steps b
1146: WHERE a.batchstep_id = b.batchstep_id
1147: AND a.material_detail_id = p_material_detail_id;
1148:
1149: CURSOR get_msg (v_msg_name IN VARCHAR2) IS

Line 1166: l_batchstep_rec gme_batch_steps%ROWTYPE;

1162: x_return_status VARCHAR2 (1);
1163: l_batch_header_rec gme_batch_header%ROWTYPE;
1164: l_old_item_rec item_master_cursor%ROWTYPE;
1165: l_new_item_rec item_master_cursor%ROWTYPE;
1166: l_batchstep_rec gme_batch_steps%ROWTYPE;
1167: x_batchstep_rec gme_batch_steps%ROWTYPE;
1168: l_rsc_trans_count NUMBER;
1169: l_temp_qty NUMBER;
1170: l_trans_loaded BOOLEAN DEFAULT FALSE;

Line 1167: x_batchstep_rec gme_batch_steps%ROWTYPE;

1163: l_batch_header_rec gme_batch_header%ROWTYPE;
1164: l_old_item_rec item_master_cursor%ROWTYPE;
1165: l_new_item_rec item_master_cursor%ROWTYPE;
1166: l_batchstep_rec gme_batch_steps%ROWTYPE;
1167: x_batchstep_rec gme_batch_steps%ROWTYPE;
1168: l_rsc_trans_count NUMBER;
1169: l_temp_qty NUMBER;
1170: l_trans_loaded BOOLEAN DEFAULT FALSE;
1171: l_oneitem_success BOOLEAN DEFAULT FALSE;

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

2884: l_new_step_resources gme_batch_step_resources%ROWTYPE;
2885: l_rsrc_txn_gtmp_rec gme_resource_txns_gtmp%ROWTYPE;
2886: CURSOR Cur_get_step(v_line_id NUMBER) IS
2887: SELECT s.step_status, h.automatic_step_calculation
2888: FROM gme_batch_steps s, gme_batch_step_activities a, gme_batch_step_resources r, gme_batch_header h
2889: WHERE r.batchstep_resource_id = v_line_id
2890: AND a.batchstep_activity_id = r.batchstep_activity_id
2891: AND s.batchstep_id = a.batchstep_id
2892: AND h.batch_id = s.batch_id;