APPS.GME_CREATE_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 827: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');

823: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
824:
825: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
826: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
827: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
828: END IF;
829:
830: -- Create data for GME_BATCH_STEP_DEPENDENCIES
831: i := p_routing_depd_tbl.FIRST;

Line 830: -- Create data for GME_BATCH_STEP_DEPENDENCIES

826: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
827: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
828: END IF;
829:
830: -- Create data for GME_BATCH_STEP_DEPENDENCIES
831: i := p_routing_depd_tbl.FIRST;
832: j := 0;
833:
834: WHILE i IS NOT NULL LOOP

Line 886: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');

882: i := p_routing_depd_tbl.NEXT (i);
883: END LOOP; /* WHILE i IS NOT NULL ; STEP DEPENDENCIES*/
884:
885: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
886: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');
887: END IF;
888:
889: -- Now calculate the step quantities...
890: IF ( p_recipe_rout_step_tbl.COUNT = 1

Line 1670: FROM gme_batch_step_dependencies d, gme_batch_steps r

1666: CURSOR cur_get_step_date_4_cal (v_step_id NUMBER, v_batch_id NUMBER)
1667: IS
1668: SELECT dep_type, r.plan_start_date, r.plan_cmplt_date
1669: ,standard_delay
1670: FROM gme_batch_step_dependencies d, gme_batch_steps r
1671: WHERE d.batch_id = r.batch_id
1672: AND d.batch_id = v_batch_id
1673: AND r.batchstep_id = d.dep_step_id
1674: AND d.batchstep_id = v_step_id;

Line 1681: FROM gme_batch_step_dependencies d, gme_batch_steps r

1677: IS
1678: SELECT MAX (DECODE (dep_type
1679: ,1, r.plan_start_date + standard_delay / 24
1680: ,0, r.plan_cmplt_date + standard_delay / 24) )
1681: FROM gme_batch_step_dependencies d, gme_batch_steps r
1682: WHERE d.batch_id = r.batch_id
1683: AND d.batch_id = v_batch_id
1684: AND r.batchstep_id = d.dep_step_id
1685: AND d.batchstep_id = v_step_id;

Line 2700: FROM gme_batch_step_dependencies

2696: SELECT batchstep_id, batchstep_no
2697: FROM gme_batch_steps
2698: WHERE batch_id = v_batch_id
2699: AND batchstep_id NOT IN (SELECT dep_step_id
2700: FROM gme_batch_step_dependencies
2701: WHERE batch_id = v_batch_id);
2702: TYPE leaf_node_fields IS RECORD(leaf_batchstep_id NUMBER,
2703: leaf_batchstep_no NUMBER);
2704: TYPE leaf_nodes_tab IS TABLE OF leaf_node_fields INDEX BY BINARY_INTEGER;

Line 2716: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = v_batch_id) d,

2712: If there are multiple branches then we will get multiple records like the above */
2713: CURSOR Cur_get_branches(v_batch_id NUMBER, v_batchstep_id NUMBER) IS
2714: SELECT branch, LENGTH(branch) sz
2715: FROM (SELECT REPLACE(sys_connect_by_path(LPAD(s.batchstep_no, 5, 0)||LPAD(p.batchstep_no, 5, 0 )||dep_type||LPAD(standard_delay, 3,0),' '), ' ', NULL) branch
2716: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = v_batch_id) d,
2717: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) s,
2718: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) p
2719: WHERE s.batchstep_id = d.batchstep_id
2720: AND p.batchstep_id = d.dep_step_id