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

Line 547: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,

543:
544: l_api_name CONSTANT VARCHAR2 (30) := 'validate_dependent_steps';
545:
546: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
547: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
548: s.step_status,s.actual_cmplt_date,s.actual_start_date
549: FROM gme_batch_step_dependencies d, gme_batch_steps s
550: WHERE d.batchstep_id = v_step_id
551: AND s.batchstep_id = d.dep_step_id

Line 582: + (l_dep_step_rec.standard_delay/24) THEN

578: ,gme_common_pvt.g_step_closed) THEN
579: RAISE GME_STEP_DEP_COMPLETE;
580: END IF;
581: IF p_step_actual_start_date < l_dep_step_rec.actual_cmplt_date
582: + (l_dep_step_rec.standard_delay/24) THEN
583: RAISE INVALID_START_DATE;
584: END IF;
585: ELSE -- start to start
586: IF l_dep_step_rec.step_status NOT IN (gme_common_pvt.g_step_wip

Line 592: + (l_dep_step_rec.standard_delay/24) THEN

588: ,gme_common_pvt.g_step_closed) THEN
589: RAISE GME_STEP_DEP_WIP;
590: END IF;
591: IF p_step_actual_start_date < l_dep_step_rec.actual_start_date
592: + (l_dep_step_rec.standard_delay/24) THEN
593: RAISE INVALID_START_DATE;
594: END IF;
595: END IF;
596: END LOOP; -- FOR l_dep_step_rec IN Cur_get_dep_steps

Line 832: SELECT dep_step_id, dep_type, standard_delay

828:
829: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_cmplt_date';
830:
831: CURSOR Cur_get_dep_steps IS
832: SELECT dep_step_id, dep_type, standard_delay
833: FROM gme_batch_step_dependencies
834: START WITH batchstep_id = p_batch_step_rec.batchstep_id
835: CONNECT BY batchstep_id = PRIOR dep_step_id;
836:

Line 880: IF (p_batch_header_rec.enforce_step_dependency = 1) AND (l_batch_step.actual_cmplt_date + (get_rec.standard_delay/24) > X_prev_start_date) THEN

876:
877: -- Check if the step has a complete date if so validate otherwise assign one to it
878: IF (l_batch_step.actual_cmplt_date IS NOT NULL) THEN
879: IF get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start THEN
880: IF (p_batch_header_rec.enforce_step_dependency = 1) AND (l_batch_step.actual_cmplt_date + (get_rec.standard_delay/24) > X_prev_start_date) THEN
881: gme_common_pvt.log_message('GME_STEP_START_PREV_STEP_CMPLT',
882: 'PREV_DATE',
883: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
884: 'PREV_STEP', TO_CHAR(X_prev_step),

Line 887: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));

883: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
884: 'PREV_STEP', TO_CHAR(X_prev_step),
885: 'CUR_DATE',
886: TO_CHAR(l_batch_step.actual_cmplt_date +
887: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
888: RAISE INVALID_DATE_ERR;
889: END IF;
890: ELSIF get_rec.dep_type = gme_common_pvt.g_dep_type_start_start THEN
891: IF (p_batch_header_rec.enforce_step_dependency = 1) AND (l_batch_step.actual_start_date + (get_rec.standard_delay/24) > X_prev_start_date) THEN

Line 891: IF (p_batch_header_rec.enforce_step_dependency = 1) AND (l_batch_step.actual_start_date + (get_rec.standard_delay/24) > X_prev_start_date) THEN

887: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
888: RAISE INVALID_DATE_ERR;
889: END IF;
890: ELSIF get_rec.dep_type = gme_common_pvt.g_dep_type_start_start THEN
891: IF (p_batch_header_rec.enforce_step_dependency = 1) AND (l_batch_step.actual_start_date + (get_rec.standard_delay/24) > X_prev_start_date) THEN
892: gme_common_pvt.log_message('GME_STEP_START_PREV_STEP_START',
893: 'PREV_DATE',
894: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
895: 'PREV_STEP', TO_CHAR(X_prev_step),

Line 898: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));

894: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
895: 'PREV_STEP', TO_CHAR(X_prev_step),
896: 'CUR_DATE',
897: TO_CHAR(l_batch_step.actual_start_date +
898: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
899: RAISE INVALID_DATE_ERR;
900: END IF;
901: EXIT;
902: END IF;

Line 904: (get_rec.standard_delay >= 0) THEN

900: END IF;
901: EXIT;
902: END IF;
903: ELSIF (get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND
904: (get_rec.standard_delay >= 0) THEN
905: l_batch_step.actual_cmplt_date := X_prev_start_date - (get_rec.standard_delay/24);
906: ELSE
907: l_batch_step.actual_cmplt_date := X_prev_start_date;
908: END IF;

Line 905: l_batch_step.actual_cmplt_date := X_prev_start_date - (get_rec.standard_delay/24);

901: EXIT;
902: END IF;
903: ELSIF (get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND
904: (get_rec.standard_delay >= 0) THEN
905: l_batch_step.actual_cmplt_date := X_prev_start_date - (get_rec.standard_delay/24);
906: ELSE
907: l_batch_step.actual_cmplt_date := X_prev_start_date;
908: END IF;
909: