APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_STEPS

Line 83: FROM gme_batch_steps

79:
80: CURSOR cur_get_batchstep_dtl (v_batch_id NUMBER, v_batchstep_no NUMBER)
81: IS
82: SELECT batchstep_id, step_status
83: FROM gme_batch_steps
84: WHERE batch_id = v_batch_id AND batchstep_no = v_batchstep_no;
85:
86: CURSOR cur_get_activity_id (
87: v_step_id NUMBER

Line 347: FROM gme_batch_steps a, gme_batch_step_activities b

343:
344: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
345: IS
346: SELECT a.step_status, a.batch_id, a.step_qty_um
347: FROM gme_batch_steps a, gme_batch_step_activities b
348: WHERE b.batchstep_activity_id = v_act_id
349: AND a.batch_id = b.batch_id
350: AND a.batchstep_id = b.batchstep_id;
351:

Line 1642: FROM gme_batch_steps

1638: -- Define CURSORS
1639: CURSOR cur_get_step_dtls (v_batchstep_id NUMBER)
1640: IS
1641: SELECT max_step_capacity
1642: FROM gme_batch_steps
1643: WHERE batchstep_id = v_batchstep_id;
1644:
1645: CURSOR cur_get_rsrc_hdr (v_resources VARCHAR2)
1646: IS

Line 1737: UPDATE gme_batch_steps

1733:
1734: IF ( l_capacity_constraint = 1
1735: AND l_batchstep_resource_rec.max_capacity < l_max_step_capacity) THEN
1736: -- CALL DBL with updated max_capacity
1737: UPDATE gme_batch_steps
1738: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1739: ,last_update_date = gme_common_pvt.g_timestamp
1740: ,last_updated_by = gme_common_pvt.g_user_ident
1741: ,last_update_login = gme_common_pvt.g_login_id

Line 1816: FROM gme_batch_steps a, gme_batch_step_resources b

1812: CURSOR cur_get_step_dtl (v_resource_id NUMBER)
1813: IS
1814: SELECT a.batchstep_id, a.step_status, b.batchstep_activity_id
1815: ,a.batch_id, b.resources
1816: FROM gme_batch_steps a, gme_batch_step_resources b
1817: WHERE b.batchstep_resource_id = v_resource_id
1818: AND a.batch_id = b.batch_id
1819: AND a.batchstep_id = b.batchstep_id;
1820:

Line 1824: FROM gme_batch_steps;

1820:
1821: CURSOR cur_get_step_capacity (v_batchstep_id NUMBER)
1822: IS
1823: SELECT max_step_capacity
1824: FROM gme_batch_steps;
1825:
1826: CURSOR cur_get_rsrc_dtl (v_resources VARCHAR2, v_orgn_code VARCHAR2)
1827: IS
1828: SELECT capacity_constraint

Line 1986: UPDATE gme_batch_steps

1982: l_update_capacity := 1;
1983: END IF;
1984:
1985: -- CALL DBL with updated max_capacity
1986: UPDATE gme_batch_steps
1987: SET max_step_capacity = DECODE(l_update_capacity, 1, l_batchstep_resource_out_rec.max_capacity, max_step_capacity),
1988: last_update_date = l_batchstep_resource_out_rec.last_update_date
1989: WHERE batchstep_id = l_batchstep_id AND batch_id = l_batch_id;
1990: END IF;