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_RELEASE_BATCH_STEP_PVT dependencies on STANDARD

Line 315: SELECT d.dep_step_id, d.dep_type, d.standard_delay

311: l_api_name CONSTANT VARCHAR2 (30) := 'process_dependent_steps';
312:
313: CURSOR cur_get_dep_steps (v_batchstep_id NUMBER, v_batch_id NUMBER)
314: IS
315: SELECT d.dep_step_id, d.dep_type, d.standard_delay
316: ,s.steprelease_type, s.step_status
317: FROM gme_batch_step_dependencies d, gme_batch_steps s
318: WHERE d.batchstep_id = v_batchstep_id
319: AND s.batchstep_id = d.dep_step_id

Line 386: || 'standard_delay = '

382: || l_dep_step_rec.dep_type);
383: gme_debug.put_line ( g_pkg_name
384: || '.'
385: || l_api_name
386: || 'standard_delay = '
387: || l_dep_step_rec.standard_delay);
388: gme_debug.put_line ( g_pkg_name
389: || '.'
390: || l_api_name

Line 387: || l_dep_step_rec.standard_delay);

383: gme_debug.put_line ( g_pkg_name
384: || '.'
385: || l_api_name
386: || 'standard_delay = '
387: || l_dep_step_rec.standard_delay);
388: gme_debug.put_line ( g_pkg_name
389: || '.'
390: || l_api_name
391: || 'step_status = '

Line 410: AND (l_dep_step_rec.standard_delay >= 0) THEN

406: /* then complete the dependent step otherwise call the release API if the step */
407: /* status is pending. */
408: IF (l_dep_step_rec.dep_type =
409: gme_common_pvt.g_dep_type_finish_start)
410: AND (l_dep_step_rec.standard_delay >= 0) THEN
411: l_complete_dep_step := TRUE;
412: ELSE
413: l_complete_dep_step := FALSE;
414: END IF; /* IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND */

Line 419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */

415:
416: /* If the step status is pending */
417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
421: l_dep_step_rec.standard_delay < 0) OR
422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN
423: l_batch_step_rec.actual_start_date :=

Line 421: l_dep_step_rec.standard_delay < 0) OR

417: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
418: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
419: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
420: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
421: l_dep_step_rec.standard_delay < 0) OR
422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN
423: l_batch_step_rec.actual_start_date :=
424: p_batch_step_rec.actual_start_date
425: - (l_dep_step_rec.standard_delay / 24);

Line 425: - (l_dep_step_rec.standard_delay / 24);

421: l_dep_step_rec.standard_delay < 0) OR
422: (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_start_start) THEN
423: l_batch_step_rec.actual_start_date :=
424: p_batch_step_rec.actual_start_date
425: - (l_dep_step_rec.standard_delay / 24);
426: /*ELSIF (l_dep_step_rec.dep_type =
427: gme_common_pvt.g_dep_type_start_start) THEN
428: l_batch_step_rec.actual_start_date :=
429: p_batch_step_rec.actual_start_date

Line 430: + (l_dep_step_rec.standard_delay / 24); */

426: /*ELSIF (l_dep_step_rec.dep_type =
427: gme_common_pvt.g_dep_type_start_start) THEN
428: l_batch_step_rec.actual_start_date :=
429: p_batch_step_rec.actual_start_date
430: + (l_dep_step_rec.standard_delay / 24); */
431: END IF;
432: /* dep_type = gme_common_pvt.g_dep_type_finish_start */
433:
434: l_in_batch_step_rec := l_batch_step_rec;

Line 460: - (l_dep_step_rec.standard_delay / 24);

456:
457: IF l_complete_dep_step THEN
458: l_batch_step_rec.actual_cmplt_date :=
459: p_batch_step_rec.actual_start_date
460: - (l_dep_step_rec.standard_delay / 24);
461:
462: --Sunitha Ch. bug#5488991 assigning the completion date to the start only when it is null
463: IF l_batch_step_rec.actual_start_date IS NULL THEN
464: l_batch_step_rec.actual_start_date :=