APPS.GME_BATCHSTEP_RSRC_PVT dependencies on GME_BATCH_STEPS

Line 75: FROM gme_batch_steps

71:
72: CURSOR cur_get_batchstep_dtl (v_batch_id NUMBER, v_batchstep_no NUMBER)
73: IS
74: SELECT batchstep_id, step_status
75: FROM gme_batch_steps
76: WHERE batch_id = v_batch_id AND batchstep_no = v_batchstep_no;
77:
78: CURSOR cur_get_activity_id (
79: v_step_id NUMBER

Line 335: FROM gme_batch_steps a, gme_batch_step_activities b

331:
332: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
333: IS
334: SELECT a.step_status, a.batch_id, a.step_qty_um
335: FROM gme_batch_steps a, gme_batch_step_activities b
336: WHERE b.batchstep_activity_id = v_act_id
337: AND a.batch_id = b.batch_id
338: AND a.batchstep_id = b.batchstep_id;
339:

Line 1617: FROM gme_batch_steps

1613: -- Define CURSORS
1614: CURSOR cur_get_step_dtls (v_batchstep_id NUMBER)
1615: IS
1616: SELECT max_step_capacity
1617: FROM gme_batch_steps
1618: WHERE batchstep_id = v_batchstep_id;
1619:
1620: CURSOR cur_get_rsrc_hdr (v_resources VARCHAR2)
1621: IS

Line 1712: UPDATE gme_batch_steps

1708:
1709: IF ( l_capacity_constraint = 1
1710: AND l_batchstep_resource_rec.max_capacity < l_max_step_capacity) THEN
1711: -- CALL DBL with updated max_capacity
1712: UPDATE gme_batch_steps
1713: SET max_step_capacity = l_batchstep_resource_rec.max_capacity
1714: ,last_update_date = gme_common_pvt.g_timestamp
1715: ,last_updated_by = gme_common_pvt.g_user_ident
1716: ,last_update_login = gme_common_pvt.g_login_id

Line 1785: FROM gme_batch_steps a, gme_batch_step_resources b

1781: CURSOR cur_get_step_dtl (v_resource_id NUMBER)
1782: IS
1783: SELECT a.batchstep_id, a.step_status, b.batchstep_activity_id
1784: ,a.batch_id, b.resources
1785: FROM gme_batch_steps a, gme_batch_step_resources b
1786: WHERE b.batchstep_resource_id = v_resource_id
1787: AND a.batch_id = b.batch_id
1788: AND a.batchstep_id = b.batchstep_id;
1789:

Line 1793: FROM gme_batch_steps;

1789:
1790: CURSOR cur_get_step_capacity (v_batchstep_id NUMBER)
1791: IS
1792: SELECT max_step_capacity
1793: FROM gme_batch_steps;
1794:
1795: CURSOR cur_get_rsrc_dtl (v_resources VARCHAR2, v_orgn_code VARCHAR2)
1796: IS
1797: SELECT capacity_constraint

Line 1950: UPDATE gme_batch_steps

1946: IF ( l_capacity_constraint = 1
1947: AND l_batchstep_resource_out_rec.max_capacity <
1948: l_max_step_capacity) THEN
1949: -- CALL DBL with updated max_capacity
1950: UPDATE gme_batch_steps
1951: SET max_step_capacity =
1952: l_batchstep_resource_out_rec.max_capacity
1953: WHERE batchstep_id = l_batchstep_id AND batch_id = l_batch_id;
1954: END IF;