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 STANDARD

Line 935: l_gme_batch_step_dep (j).standard_delay :=

931:
932: l_gme_batch_step_dep (j).dep_type := p_routing_depd_tbl (i).dep_type;
933: l_gme_batch_step_dep (j).rework_code :=
934: p_routing_depd_tbl (i).rework_code;
935: l_gme_batch_step_dep (j).standard_delay :=
936: p_routing_depd_tbl (i).standard_delay;
937: l_gme_batch_step_dep (j).min_delay :=
938: p_routing_depd_tbl (i).minimum_delay;
939: l_gme_batch_step_dep (j).max_delay :=

Line 936: p_routing_depd_tbl (i).standard_delay;

932: l_gme_batch_step_dep (j).dep_type := p_routing_depd_tbl (i).dep_type;
933: l_gme_batch_step_dep (j).rework_code :=
934: p_routing_depd_tbl (i).rework_code;
935: l_gme_batch_step_dep (j).standard_delay :=
936: p_routing_depd_tbl (i).standard_delay;
937: l_gme_batch_step_dep (j).min_delay :=
938: p_routing_depd_tbl (i).minimum_delay;
939: l_gme_batch_step_dep (j).max_delay :=
940: p_routing_depd_tbl (i).max_delay;

Line 1048: --multiply the step qty with standard factor to get mass qty

1044:
1045: --Bug#5231180 used gme_common_pvt variables rather GMD spec variables
1046: --IF l_uom_class = NVL(gmd_auto_step_calc.g_profile_mass_um_type,gme_common_pvt.g_mass_um_type) THEN
1047: IF l_uom_class = gme_common_pvt.g_mass_um_type THEN
1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
1052: --multiply the step qty with standard factor to get vol qty

Line 1052: --multiply the step qty with standard factor to get vol qty

1048: --multiply the step qty with standard factor to get mass qty
1049: l_mass_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1050: --ELSIF l_uom_class = NVL(gmd_auto_step_calc.g_profile_volume_um_type,gme_common_pvt.g_volume_um_type) THEN
1051: ELSIF l_uom_class = gme_common_pvt.g_volume_um_type THEN
1052: --multiply the step qty with standard factor to get vol qty
1053: l_volume_qty := p_recipe_rout_step_tbl (1).step_qty * l_std_factor;
1054: END IF;
1055:
1056: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN

Line 1754: ,standard_delay

1750: IS
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

Line 1764: ,1, r.plan_start_date + standard_delay / 24

1760:
1761: CURSOR cur_get_step_date (v_step_id NUMBER, v_batch_id NUMBER)
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

Line 1765: ,0, r.plan_cmplt_date + standard_delay / 24) )

1761: CURSOR cur_get_step_date (v_step_id NUMBER, v_batch_id NUMBER)
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

Line 1794: ,p_offset => rec.standard_delay

1790: END IF;
1791:
1792: l_plan_start_date :=
1793: get_working_start_time (p_start_date => l_date
1794: ,p_offset => rec.standard_delay
1795: ,p_calendar_code => p_calendar_code);
1796:
1797: IF l_plan_start_date IS NULL THEN
1798: RETURN NULL;

Line 2900: Characters 12-14 is standard delay 001

2896: /* Each record is built up of 14 character strings like this 00020000100001 by the query below
2897: Characters 1-5 is step_no 00020
2898: Characters 6-10 is dep_step_no 00010
2899: Character 11 is dep_type 0
2900: Characters 12-14 is standard delay 001
2901: If there is a dependency like 30 -> 20 -> 10 then the output would be 0003000020000100020000100001
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

Line 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

2901: If there is a dependency like 30 -> 20 -> 10 then the output would be 0003000020000100020000100001
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

Line 2923: l_standard_delay NUMBER;

2919: l_duration NUMBER := 0;
2920: l_step_no NUMBER;
2921: l_dep_step_no NUMBER;
2922: l_dep_type NUMBER;
2923: l_standard_delay NUMBER;
2924: BEGIN
2925: IF g_debug <= gme_debug.g_log_procedure THEN
2926: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
2927: END IF;

Line 2952: /* Divide by 14 because length of step_no = 5, dep_step_no = 5, dep_type = 1, standard_delay = 3 */

2948: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' current branch: ' || l_branches_tbl(j).branch);
2949: END IF;
2950: m := 1;
2951: n := 5;
2952: /* Divide by 14 because length of step_no = 5, dep_step_no = 5, dep_type = 1, standard_delay = 3 */
2953: FOR k IN 1..l_branches_tbl(j).sz/14 LOOP --Start parsing string now
2954: l_step_no := SUBSTR(l_branches_tbl(j).branch, m, 5);
2955: m := n + 1;
2956: n := m + 4;

Line 2963: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);

2959: n := m + 0;
2960: l_dep_type := SUBSTR(l_branches_tbl(j).branch, m, 1);
2961: m := n + 1;
2962: n := m + 2;
2963: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2964: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2966: END IF;
2967: IF (k = 1) THEN

Line 2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);

2961: m := n + 1;
2962: n := m + 2;
2963: l_standard_delay := SUBSTR(l_branches_tbl(j).branch, m, 3);
2964: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2965: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' Step->Depstep->Deptype->Delay = '||l_step_no||'->'||l_dep_step_no||'->'||l_dep_type||'->'||l_standard_delay);
2966: END IF;
2967: IF (k = 1) THEN
2968: l_duration := l_step_duration_tab(l_step_no);
2969: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 2973: l_duration := l_duration + l_standard_delay;

2969: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2970: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' step->duration: ' || l_step_no||'->'||l_duration);
2971: END IF;
2972: END IF;
2973: l_duration := l_duration + l_standard_delay;
2974: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2975: gme_debug.put_line(g_pkg_name || '.'|| l_api_name||' depstep->duration: ' || l_dep_step_no||'->'||l_duration);
2976: END IF;
2977: IF (l_dep_type = 1) THEN -- Start to Start

Line 3051: l_branch_standard_delay step_tab;

3047: l_branch_dep_step_id step_tab;
3048: l_branch_dep_type step_tab;
3049: l_branch_batchstep_no step_tab;
3050: l_branch_dep_step_no step_tab;
3051: l_branch_standard_delay step_tab;
3052: l_api_name CONSTANT VARCHAR2 (30) := 'Calc longest time';
3053:
3054: CURSOR cur_get_leaf_nodes (v_batch_id NUMBER) IS
3055: SELECT batchstep_id

Line 3160: l_standard_delay NUMBER;

3156:
3157: -- Bug 9862326
3158: l_start_string NUMBER;
3159: l_end_string NUMBER;
3160: l_standard_delay NUMBER;
3161: l_standard_delay_string VARCHAR2(4000);
3162:
3163: -- Bug 10226452
3164: l_standard_delay_hold NUMBER;

Line 3161: l_standard_delay_string VARCHAR2(4000);

3157: -- Bug 9862326
3158: l_start_string NUMBER;
3159: l_end_string NUMBER;
3160: l_standard_delay NUMBER;
3161: l_standard_delay_string VARCHAR2(4000);
3162:
3163: -- Bug 10226452
3164: l_standard_delay_hold NUMBER;
3165: l_dep_type NUMBER;

Line 3164: l_standard_delay_hold NUMBER;

3160: l_standard_delay NUMBER;
3161: l_standard_delay_string VARCHAR2(4000);
3162:
3163: -- Bug 10226452
3164: l_standard_delay_hold NUMBER;
3165: l_dep_type NUMBER;
3166: l_batchstep_no NUMBER;
3167: l_dep_step_id NUMBER;
3168:

Line 3171: SELECT REPLACE(sys_connect_by_path(dep_type||';'||d.dep_step_id||';'||standard_delay||';',' '), ' ', NULL) branch

3167: l_dep_step_id NUMBER;
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

Line 3192: for curnode in (select d.dep_step_id, dep_type, standard_delay, s.batchstep_no, s.batch_id

3188: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
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 */

Line 3203: gme_debug.put_line ('delay is '||curnode.standard_delay);

3199: gme_debug.put_line ('entering the loop');
3200: gme_debug.put_line ('batchstep_no is '||curnode.batchstep_no);
3201: gme_debug.put_line ('batch_id is '||curnode.batch_id);
3202: gme_debug.put_line ('duration is '||l_step_duration_tab (curnode.batchstep_no));
3203: gme_debug.put_line ('delay is '||curnode.standard_delay);
3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;
3206:
3207: -- This calculation account for duration and delay of the current step.

Line 3208: StepDuration := l_step_duration_tab (curnode.batchstep_no) + curnode.standard_delay;

3204: gme_debug.put_line ('dep_type is '||curnode.dep_type);
3205: END IF;
3206:
3207: -- This calculation account for duration and delay of the current step.
3208: StepDuration := l_step_duration_tab (curnode.batchstep_no) + curnode.standard_delay;
3209:
3210: IF (curnode.dep_type = 1) THEN -- Start to Start
3211: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3212: gme_debug.put_line ('start to start...');

Line 3218: FETCH cur_get_step_delay INTO l_standard_delay_string;

3214: END IF;
3215:
3216: -- Bug 9862326 - Must account for delay of dependent steps due to inheritance.
3217: OPEN cur_get_step_delay(curnode.batch_id, curnode.dep_step_id);
3218: FETCH cur_get_step_delay INTO l_standard_delay_string;
3219:
3220: -- Bug 10226452 - Restructure this code to loop thru all branches fetched.
3221: l_standard_delay_hold := 0;
3222:

Line 3221: l_standard_delay_hold := 0;

3217: OPEN cur_get_step_delay(curnode.batch_id, curnode.dep_step_id);
3218: FETCH cur_get_step_delay INTO l_standard_delay_string;
3219:
3220: -- Bug 10226452 - Restructure this code to loop thru all branches fetched.
3221: l_standard_delay_hold := 0;
3222:
3223: WHILE cur_get_step_delay%FOUND LOOP
3224: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);

Line 3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);

3221: l_standard_delay_hold := 0;
3222:
3223: WHILE cur_get_step_delay%FOUND LOOP
3224: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);
3226: END IF;
3227:
3228: -- Sum up all dependent delays for the current step by extrapolating values from string.
3229: l_standard_delay := 0;

Line 3229: l_standard_delay := 0;

3225: gme_debug.put_line ('delay string is '||l_standard_delay_string);
3226: END IF;
3227:
3228: -- Sum up all dependent delays for the current step by extrapolating values from string.
3229: l_standard_delay := 0;
3230: l_start_string := 1;
3231: WHILE l_start_string <= LENGTH(l_standard_delay_string) LOOP
3232: -- Get the dep type
3233: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

Line 3231: WHILE l_start_string <= LENGTH(l_standard_delay_string) LOOP

3227:
3228: -- Sum up all dependent delays for the current step by extrapolating values from string.
3229: l_standard_delay := 0;
3230: l_start_string := 1;
3231: WHILE l_start_string <= LENGTH(l_standard_delay_string) LOOP
3232: -- Get the dep type
3233: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3234: l_dep_type := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3235: l_start_string := l_end_string + 1;

Line 3233: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

3229: l_standard_delay := 0;
3230: l_start_string := 1;
3231: WHILE l_start_string <= LENGTH(l_standard_delay_string) LOOP
3232: -- Get the dep type
3233: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3234: l_dep_type := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3235: l_start_string := l_end_string + 1;
3236:
3237: -- Get the batch step no

Line 3234: l_dep_type := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);

3230: l_start_string := 1;
3231: WHILE l_start_string <= LENGTH(l_standard_delay_string) LOOP
3232: -- Get the dep type
3233: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3234: l_dep_type := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3235: l_start_string := l_end_string + 1;
3236:
3237: -- Get the batch step no
3238: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

Line 3238: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

3234: l_dep_type := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3235: l_start_string := l_end_string + 1;
3236:
3237: -- Get the batch step no
3238: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3239: l_dep_step_id := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3240: l_start_string := l_end_string + 1;
3241:
3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.

Line 3239: l_dep_step_id := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);

3235: l_start_string := l_end_string + 1;
3236:
3237: -- Get the batch step no
3238: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3239: l_dep_step_id := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3240: l_start_string := l_end_string + 1;
3241:
3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.
3243: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

Line 3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.

3238: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3239: l_dep_step_id := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3240: l_start_string := l_end_string + 1;
3241:
3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.
3243: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3244: l_standard_delay := l_standard_delay + SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3245: l_start_string := l_end_string + 1;
3246:

Line 3243: l_end_string := instr(l_standard_delay_string, ';', l_start_string);

3239: l_dep_step_id := SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3240: l_start_string := l_end_string + 1;
3241:
3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.
3243: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3244: l_standard_delay := l_standard_delay + SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3245: l_start_string := l_end_string + 1;
3246:
3247: -- If it's a finish to start we need to add in duration of the dependent step also.

Line 3244: l_standard_delay := l_standard_delay + SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);

3240: l_start_string := l_end_string + 1;
3241:
3242: -- Get the standard delay and add it in. This value is always added regardless of dep type.
3243: l_end_string := instr(l_standard_delay_string, ';', l_start_string);
3244: l_standard_delay := l_standard_delay + SUBSTR(l_standard_delay_string, l_start_string, l_end_string - l_start_string);
3245: l_start_string := l_end_string + 1;
3246:
3247: -- If it's a finish to start we need to add in duration of the dependent step also.
3248: IF (l_dep_type = 0) THEN

Line 3254: l_standard_delay := l_standard_delay + l_step_duration_tab (l_batchstep_no);

3250: OPEN cur_get_step_no(curnode.batch_id, l_dep_step_id);
3251: FETCH cur_get_step_no INTO l_batchstep_no;
3252: CLOSE cur_get_step_no;
3253:
3254: l_standard_delay := l_standard_delay + l_step_duration_tab (l_batchstep_no);
3255: END IF;
3256:
3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:

Line 3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);

3256:
3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:
3259: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN

Line 3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);

3257: END LOOP; /* WHILE l_start_string IS NOT NULL */
3258:
3259: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN
3265: l_standard_delay_hold := l_standard_delay;

Line 3264: IF l_standard_delay > l_standard_delay_hold THEN

3260: gme_debug.put_line ('aggregate dependent delay is '||l_standard_delay);
3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN
3265: l_standard_delay_hold := l_standard_delay;
3266: END IF;
3267:
3268: FETCH cur_get_step_delay INTO l_standard_delay_string;

Line 3265: l_standard_delay_hold := l_standard_delay;

3261: gme_debug.put_line ('HOLD delay is '||l_standard_delay_hold);
3262: END IF;
3263:
3264: IF l_standard_delay > l_standard_delay_hold THEN
3265: l_standard_delay_hold := l_standard_delay;
3266: END IF;
3267:
3268: FETCH cur_get_step_delay INTO l_standard_delay_string;
3269: END LOOP; /* WHILE l_start_string IS NOT NULL */

Line 3268: FETCH cur_get_step_delay INTO l_standard_delay_string;

3264: IF l_standard_delay > l_standard_delay_hold THEN
3265: l_standard_delay_hold := l_standard_delay;
3266: END IF;
3267:
3268: FETCH cur_get_step_delay INTO l_standard_delay_string;
3269: END LOOP; /* WHILE l_start_string IS NOT NULL */
3270:
3271: CLOSE cur_get_step_delay;
3272:

Line 3273: StepDuration := StepDuration + l_standard_delay_hold;

3269: END LOOP; /* WHILE l_start_string IS NOT NULL */
3270:
3271: CLOSE cur_get_step_delay;
3272:
3273: StepDuration := StepDuration + l_standard_delay_hold;
3274:
3275: x := get_longest_in_branch(curnode.dep_step_id,l_step_duration_tab);
3276: IF (x > StepDuration) THEN
3277: longi := x;