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 391: || 'standard_delay = '

387: || l_dep_step_rec.dep_type);
388: gme_debug.put_line ( g_pkg_name
389: || '.'
390: || l_api_name
391: || 'standard_delay = '
392: || l_dep_step_rec.standard_delay);
393: gme_debug.put_line ( g_pkg_name
394: || '.'
395: || l_api_name

Line 392: || l_dep_step_rec.standard_delay);

388: gme_debug.put_line ( g_pkg_name
389: || '.'
390: || l_api_name
391: || 'standard_delay = '
392: || l_dep_step_rec.standard_delay);
393: gme_debug.put_line ( g_pkg_name
394: || '.'
395: || l_api_name
396: || 'step_status = '

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

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

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

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

Line 426: l_dep_step_rec.standard_delay < 0) OR

422: IF (l_dep_step_rec.step_status = gme_common_pvt.g_step_pending) THEN
423: /*Bug#5183521 when step dependency is start to start, the dependent should start before the current step
424: considering the standard delay defined in dependencies.commented the ELSE and added OR condition */
425: IF (l_dep_step_rec.dep_type = gme_common_pvt.g_dep_type_finish_start AND
426: l_dep_step_rec.standard_delay < 0) OR
427: (l_dep_step_rec.dep_type = 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);

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

426: l_dep_step_rec.standard_delay < 0) OR
427: (l_dep_step_rec.dep_type = 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: /*ELSIF (l_dep_step_rec.dep_type =
432: gme_common_pvt.g_dep_type_start_start) THEN
433: l_batch_step_rec.actual_start_date :=
434: p_batch_step_rec.actual_start_date

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

431: /*ELSIF (l_dep_step_rec.dep_type =
432: gme_common_pvt.g_dep_type_start_start) THEN
433: l_batch_step_rec.actual_start_date :=
434: p_batch_step_rec.actual_start_date
435: + (l_dep_step_rec.standard_delay / 24); */
436: END IF;
437: /* dep_type = gme_common_pvt.g_dep_type_finish_start */
438:
439: l_in_batch_step_rec := l_batch_step_rec;

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

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