eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_CREATE_STEP_PVT dependencies on GME_BATCH_STEP_DEPENDENCIES

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

898: END LOOP; /* WHILE i IS NOT NULL ; STEP ITEM ASSOCIATIONS*/
899:
900: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:
905: -- Create data for GME_BATCH_STEP_DEPENDENCIES
906: i := p_routing_depd_tbl.FIRST;

Line 905: -- Create data for GME_BATCH_STEP_DEPENDENCIES

901: gme_debug.put_line ('Completed GME_BATCH_STEP_ITEMS');
902: gme_debug.put_line ('GME_BATCH_STEP_DEPENDENCIES');
903: END IF;
904:
905: -- Create data for GME_BATCH_STEP_DEPENDENCIES
906: i := p_routing_depd_tbl.FIRST;
907: j := 0;
908:
909: WHILE i IS NOT NULL LOOP

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

957: i := p_routing_depd_tbl.NEXT (i);
958: END LOOP; /* WHILE i IS NOT NULL ; STEP DEPENDENCIES*/
959:
960: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
961: gme_debug.put_line ('Completed GME_BATCH_STEP_DEPENDENCIES');
962: END IF;
963:
964: -- Now calculate the step quantities...
965: IF ( p_recipe_rout_step_tbl.COUNT = 1

Line 1755: FROM gme_batch_step_dependencies d, gme_batch_steps r

1751: CURSOR cur_get_step_date_4_cal (v_step_id NUMBER, v_batch_id NUMBER)
1752: IS
1753: SELECT dep_type, r.plan_start_date, r.plan_cmplt_date
1754: ,standard_delay
1755: FROM gme_batch_step_dependencies d, gme_batch_steps r
1756: WHERE d.batch_id = r.batch_id
1757: AND d.batch_id = v_batch_id
1758: AND r.batchstep_id = d.dep_step_id
1759: AND d.batchstep_id = v_step_id;

Line 1766: FROM gme_batch_step_dependencies d, gme_batch_steps r

1762: IS
1763: SELECT MAX (DECODE (dep_type
1764: ,1, r.plan_start_date + standard_delay / 24
1765: ,0, r.plan_cmplt_date + standard_delay / 24) )
1766: FROM gme_batch_step_dependencies d, gme_batch_steps r
1767: WHERE d.batch_id = r.batch_id
1768: AND d.batch_id = v_batch_id
1769: AND r.batchstep_id = d.dep_step_id
1770: AND d.batchstep_id = v_step_id;

Line 2890: FROM gme_batch_step_dependencies

2886: SELECT batchstep_id, batchstep_no
2887: FROM gme_batch_steps
2888: WHERE batch_id = v_batch_id
2889: AND batchstep_id NOT IN (SELECT dep_step_id
2890: FROM gme_batch_step_dependencies
2891: WHERE batch_id = v_batch_id);
2892: TYPE leaf_node_fields IS RECORD(leaf_batchstep_id NUMBER,
2893: leaf_batchstep_no NUMBER);
2894: TYPE leaf_nodes_tab IS TABLE OF leaf_node_fields INDEX BY BINARY_INTEGER;

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

2902: If there are multiple branches then we will get multiple records like the above */
2903: CURSOR Cur_get_branches(v_batch_id NUMBER, v_batchstep_id NUMBER) IS
2904: SELECT branch, LENGTH(branch) sz
2905: 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
2906: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = v_batch_id) d,
2907: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) s,
2908: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) p
2909: WHERE s.batchstep_id = d.batchstep_id
2910: AND p.batchstep_id(+) = d.dep_step_id

Line 3059: FROM gme_batch_step_dependencies

3055: SELECT batchstep_id
3056: FROM gme_batch_steps
3057: WHERE batch_id = v_batch_id AND
3058: batchstep_id NOT IN (SELECT dep_step_id
3059: FROM gme_batch_step_dependencies
3060: WHERE batch_id = v_batch_id);
3061: CURSOR cur_get_step_no (v_step_id gme_batch_steps.batchstep_id%TYPE) IS
3062: SELECT batchstep_no
3063: FROM gme_batch_steps

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

3168:
3169: -- Bug 9862326 - This cursor will fetch all delays related to a given step including dependent steps.
3170: CURSOR cur_get_step_delay (v_batch_id NUMBER, v_batchstep_id NUMBER) IS
3171: SELECT REPLACE(sys_connect_by_path(dep_type||';'||d.dep_step_id||';'||standard_delay||';',' '), ' ', NULL) branch
3172: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = v_batch_id) d,
3173: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) s,
3174: (SELECT * FROM gme_batch_steps WHERE batch_id = v_batch_id) p
3175: WHERE s.batchstep_id = d.batchstep_id
3176: AND p.batchstep_id(+) = d.dep_step_id

Line 3193: from gme_batch_step_dependencies d, gme_batch_steps s

3189: gme_debug.put_line ('entering get_longest_in_branch with batchstep_id '||node);
3190: END IF;
3191:
3192: for curnode in (select d.dep_step_id, dep_type, standard_delay, s.batchstep_no, s.batch_id
3193: from gme_batch_step_dependencies d, gme_batch_steps s
3194: where s.batchstep_id = d.batchstep_id and d.batchstep_id = node)
3195: loop
3196: /* initialize step duration */
3197: subnodes_found := 1;