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

Line 118: SELECT s.batchstep_id, d.dep_type, d.standard_delay

114:
115: -- Bug 11925400 - Add step status check to the where clause.
116: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
117: IS
118: SELECT s.batchstep_id, d.dep_type, d.standard_delay
119: ,s.step_status
120: FROM gme_batch_step_dependencies d, gme_batch_steps s
121: WHERE d.batchstep_id = v_batchstep_id
122: AND s.batchstep_id = d.dep_step_id

Line 131: SELECT d.batchstep_id, d.dep_type, d.standard_delay, s.step_status

127:
128: -- Bug 11925400 - Add step status check to the where clause.
129: CURSOR cur_get_succ_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
130: IS
131: SELECT d.batchstep_id, d.dep_type, d.standard_delay, s.step_status
132: FROM gme_batch_step_dependencies d, gme_batch_steps s
133: WHERE d.batchstep_id = s.batchstep_id
134: AND d.dep_step_id = v_batchstep_id
135: AND s.batch_id = v_batch_id

Line 153: + d.standard_delay / 24) max_date

149: IS
150: SELECT MAX ( DECODE (d.dep_type
151: ,1, s.plan_start_date
152: ,0, s.plan_cmplt_date)
153: + d.standard_delay / 24) max_date
154: FROM gme_batch_step_dependencies d, gme_batch_steps s
155: WHERE d.batchstep_id = v_batchstep_id
156: AND s.batchstep_id = d.dep_step_id
157: AND s.batch_id = v_batch_id

Line 499: /* Standard Delay should always be divided by 24 if used in date calculations */

495: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
496: ,l_batch_step_rec) ) THEN
497: RAISE batch_step_fetch_error;
498: END IF;
499: /* Standard Delay should always be divided by 24 if used in date calculations */
500: IF p_use_workday_cal = fnd_api.g_false THEN
501: IF l_dep_step_rec.dep_type = 0 THEN
502: l_batch_step_rec.plan_cmplt_date :=
503: l_batch_step_m_rec.plan_start_date

Line 504: - l_dep_step_rec.standard_delay / 24;

500: IF p_use_workday_cal = fnd_api.g_false THEN
501: IF l_dep_step_rec.dep_type = 0 THEN
502: l_batch_step_rec.plan_cmplt_date :=
503: l_batch_step_m_rec.plan_start_date
504: - l_dep_step_rec.standard_delay / 24;
505: l_batch_step_rec.plan_start_date := NULL;
506: ELSE
507: l_batch_step_rec.plan_start_date :=
508: l_batch_step_m_rec.plan_start_date

Line 509: - l_dep_step_rec.standard_delay / 24;

505: l_batch_step_rec.plan_start_date := NULL;
506: ELSE
507: l_batch_step_rec.plan_start_date :=
508: l_batch_step_m_rec.plan_start_date
509: - l_dep_step_rec.standard_delay / 24;
510: l_batch_step_rec.plan_cmplt_date := NULL;
511: END IF;
512: ELSE
513: /* Use workday calendar */

Line 517: IF l_dep_step_rec.standard_delay >= 0 THEN

513: /* Use workday calendar */
514: /* Pass in the plan start date
515: of the current step as plan completion date to this procedure as we
516: want to find out the start or completion date of the preceeding step */
517: IF l_dep_step_rec.standard_delay >= 0 THEN
518: gmp_calendar_api.get_contiguous_periods
519: (p_api_version => 1
520: ,p_init_msg_list => TRUE
521: ,p_start_date => NULL

Line 524: ,p_duration => l_dep_step_rec.standard_delay

520: ,p_init_msg_list => TRUE
521: ,p_start_date => NULL
522: ,p_end_date => l_batch_step_m_rec.plan_start_date
523: ,p_calendar_code => l_calendar_code
524: ,p_duration => l_dep_step_rec.standard_delay
525: ,p_output_tbl => l_contig_period_tbl
526: ,x_return_status => l_return_status);
527: l_cal_count := l_contig_period_tbl.COUNT;
528: l_date := l_contig_period_tbl (l_cal_count).start_date;

Line 529: ELSE /* Standard delay is negative */

525: ,p_output_tbl => l_contig_period_tbl
526: ,x_return_status => l_return_status);
527: l_cal_count := l_contig_period_tbl.COUNT;
528: l_date := l_contig_period_tbl (l_cal_count).start_date;
529: ELSE /* Standard delay is negative */
530: gmp_calendar_api.get_contiguous_periods
531: (p_api_version => 1
532: ,p_init_msg_list => TRUE
533: ,p_start_date => l_batch_step_m_rec.plan_start_date

Line 537: (l_dep_step_rec.standard_delay)

533: ,p_start_date => l_batch_step_m_rec.plan_start_date
534: ,p_end_date => NULL
535: ,p_calendar_code => l_calendar_code
536: ,p_duration => ABS
537: (l_dep_step_rec.standard_delay)
538: ,p_output_tbl => l_contig_period_tbl
539: ,x_return_status => l_return_status);
540: l_cal_count := l_contig_period_tbl.COUNT;
541: l_date := l_contig_period_tbl (l_cal_count).end_date;

Line 542: END IF; /* l_dep_step_rec.standard_delay >= 0 */

538: ,p_output_tbl => l_contig_period_tbl
539: ,x_return_status => l_return_status);
540: l_cal_count := l_contig_period_tbl.COUNT;
541: l_date := l_contig_period_tbl (l_cal_count).end_date;
542: END IF; /* l_dep_step_rec.standard_delay >= 0 */
543:
544: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
545: gme_debug.put_line
546: ( 'Called to get the cmplt date for step prior to '

Line 552: || l_dep_step_rec.standard_delay

548: || ' '
549: || TO_CHAR (l_batch_step_m_rec.plan_start_date
550: ,'DD-MON-YYYY HH24:MI:SS')
551: || ' with duration of '
552: || l_dep_step_rec.standard_delay
553: || ' Got back '
554: || TO_CHAR (l_date, 'DD-MON-YYYY HH24:MI:SS') );
555: END IF;
556: