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 605: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,

601:
602: l_api_name CONSTANT VARCHAR2 (30) := 'validate_dependent_steps';
603:
604: CURSOR Cur_get_dep_steps(v_batch_id NUMBER, v_step_id NUMBER) IS
605: SELECT d.dep_step_id, d.dep_type, d.standard_delay, s.steprelease_type,
606: s.step_status,s.actual_cmplt_date,s.actual_start_date
607: FROM gme_batch_step_dependencies d, gme_batch_steps s
608: WHERE d.batchstep_id = v_step_id
609: AND s.batchstep_id = d.dep_step_id

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

636: ,gme_common_pvt.g_step_closed) THEN
637: RAISE GME_STEP_DEP_COMPLETE;
638: END IF;
639: IF p_step_actual_start_date < l_dep_step_rec.actual_cmplt_date
640: + (l_dep_step_rec.standard_delay/24) THEN
641: RAISE INVALID_START_DATE;
642: END IF;
643: ELSE -- start to start
644: IF l_dep_step_rec.step_status NOT IN (gme_common_pvt.g_step_wip

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

646: ,gme_common_pvt.g_step_closed) THEN
647: RAISE GME_STEP_DEP_WIP;
648: END IF;
649: IF p_step_actual_start_date < l_dep_step_rec.actual_start_date
650: + (l_dep_step_rec.standard_delay/24) THEN
651: RAISE INVALID_START_DATE;
652: END IF;
653: END IF;
654: END LOOP; -- FOR l_dep_step_rec IN Cur_get_dep_steps

Line 910: SELECT dep_step_id, dep_type, standard_delay

906: l_api_name CONSTANT VARCHAR2 (30) := 'validate_step_cmplt_date';
907:
908: -- Bug 13706812 - Use New select to help performance. Renamed original cursor.
909: CURSOR Cur_get_dep_steps_old IS
910: SELECT dep_step_id, dep_type, standard_delay
911: FROM gme_batch_step_dependencies
912: START WITH batchstep_id = p_batch_step_rec.batchstep_id
913: CONNECT BY batchstep_id = PRIOR dep_step_id;
914:

Line 916: SELECT dep_step_id, dep_type, standard_delay

912: START WITH batchstep_id = p_batch_step_rec.batchstep_id
913: CONNECT BY batchstep_id = PRIOR dep_step_id;
914:
915: CURSOR Cur_get_dep_steps IS
916: SELECT dep_step_id, dep_type, standard_delay
917: FROM (SELECT * FROM gme_batch_step_dependencies WHERE batch_id = p_batch_header_rec.batch_id) d,
918: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) s,
919: (SELECT * FROM gme_batch_steps WHERE batch_id = p_batch_header_rec.batch_id) p
920: WHERE s.batchstep_id = d.batchstep_id

Line 969: 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

965:
966: -- Check if the step has a complete date if so validate otherwise assign one to it
967: IF (l_batch_step.actual_cmplt_date IS NOT NULL) THEN
968: IF get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start THEN
969: 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
970: gme_common_pvt.log_message('GME_STEP_START_PREV_STEP_CMPLT',
971: 'PREV_DATE',
972: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
973: 'PREV_STEP', TO_CHAR(X_prev_step),

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

972: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
973: 'PREV_STEP', TO_CHAR(X_prev_step),
974: 'CUR_DATE',
975: TO_CHAR(l_batch_step.actual_cmplt_date +
976: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
977: RAISE INVALID_DATE_ERR;
978: END IF;
979: ELSIF get_rec.dep_type = gme_common_pvt.g_dep_type_start_start THEN
980: 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 980: 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

976: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
977: RAISE INVALID_DATE_ERR;
978: END IF;
979: ELSIF get_rec.dep_type = gme_common_pvt.g_dep_type_start_start THEN
980: 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
981: gme_common_pvt.log_message('GME_STEP_START_PREV_STEP_START',
982: 'PREV_DATE',
983: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
984: 'PREV_STEP', TO_CHAR(X_prev_step),

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

983: TO_CHAR(X_prev_start_date, 'DD-MON-YYYY HH24:MI:SS'),
984: 'PREV_STEP', TO_CHAR(X_prev_step),
985: 'CUR_DATE',
986: TO_CHAR(l_batch_step.actual_start_date +
987: (get_rec.standard_delay/24), 'DD-MON-YYYY HH24:MI:SS'));
988: RAISE INVALID_DATE_ERR;
989: END IF;
990: EXIT;
991: END IF;

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

989: END IF;
990: EXIT;
991: END IF;
992: ELSIF (get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND
993: (get_rec.standard_delay >= 0) THEN
994: l_batch_step.actual_cmplt_date := X_prev_start_date - (get_rec.standard_delay/24);
995: ELSE
996: l_batch_step.actual_cmplt_date := X_prev_start_date;
997: END IF;

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

990: EXIT;
991: END IF;
992: ELSIF (get_rec.dep_type = gme_common_pvt.g_dep_type_finish_start) AND
993: (get_rec.standard_delay >= 0) THEN
994: l_batch_step.actual_cmplt_date := X_prev_start_date - (get_rec.standard_delay/24);
995: ELSE
996: l_batch_step.actual_cmplt_date := X_prev_start_date;
997: END IF;
998: