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 115: SELECT s.batchstep_id, d.dep_type, d.standard_delay

111: WHERE batch_id = v_batch_id;
112:
113: CURSOR cur_get_prec_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
114: IS
115: SELECT s.batchstep_id, d.dep_type, d.standard_delay
116: ,s.step_status
117: FROM gme_batch_step_dependencies d, gme_batch_steps s
118: WHERE d.batchstep_id = v_batchstep_id
119: AND s.batchstep_id = d.dep_step_id

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

122: ORDER BY s.plan_start_date;
123:
124: CURSOR cur_get_succ_steps (v_batch_id NUMBER, v_batchstep_id NUMBER)
125: IS
126: SELECT d.batchstep_id, d.dep_type, d.standard_delay, s.step_status
127: FROM gme_batch_step_dependencies d, gme_batch_steps s
128: WHERE d.batchstep_id = s.batchstep_id
129: AND d.dep_step_id = v_batchstep_id
130: AND s.batch_id = v_batch_id

Line 147: + d.standard_delay / 24) max_date

143: IS
144: SELECT MAX ( DECODE (d.dep_type
145: ,1, s.plan_start_date
146: ,0, s.plan_cmplt_date)
147: + d.standard_delay / 24) max_date
148: FROM gme_batch_step_dependencies d, gme_batch_steps s
149: WHERE d.batchstep_id = v_batchstep_id
150: AND s.batchstep_id = d.dep_step_id
151: AND s.batch_id = v_batch_id

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

489: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
490: ,l_batch_step_rec) ) THEN
491: RAISE batch_step_fetch_error;
492: END IF;
493: /* Standard Delay should always be divided by 24 if used in date calculations */
494: IF p_use_workday_cal = fnd_api.g_false THEN
495: IF l_dep_step_rec.dep_type = 0 THEN
496: l_batch_step_rec.plan_cmplt_date :=
497: l_batch_step_m_rec.plan_start_date

Line 498: - l_dep_step_rec.standard_delay / 24;

494: IF p_use_workday_cal = fnd_api.g_false THEN
495: IF l_dep_step_rec.dep_type = 0 THEN
496: l_batch_step_rec.plan_cmplt_date :=
497: l_batch_step_m_rec.plan_start_date
498: - l_dep_step_rec.standard_delay / 24;
499: l_batch_step_rec.plan_start_date := NULL;
500: ELSE
501: l_batch_step_rec.plan_start_date :=
502: l_batch_step_m_rec.plan_start_date

Line 503: - l_dep_step_rec.standard_delay / 24;

499: l_batch_step_rec.plan_start_date := NULL;
500: ELSE
501: l_batch_step_rec.plan_start_date :=
502: l_batch_step_m_rec.plan_start_date
503: - l_dep_step_rec.standard_delay / 24;
504: l_batch_step_rec.plan_cmplt_date := NULL;
505: END IF;
506: ELSE
507: /* Use workday calendar */

Line 511: IF l_dep_step_rec.standard_delay >= 0 THEN

507: /* Use workday calendar */
508: /* Pass in the plan start date
509: of the current step as plan completion date to this procedure as we
510: want to find out the start or completion date of the preceeding step */
511: IF l_dep_step_rec.standard_delay >= 0 THEN
512: gmp_calendar_api.get_contiguous_periods
513: (p_api_version => 1
514: ,p_init_msg_list => TRUE
515: ,p_start_date => NULL

Line 518: ,p_duration => l_dep_step_rec.standard_delay

514: ,p_init_msg_list => TRUE
515: ,p_start_date => NULL
516: ,p_end_date => l_batch_step_m_rec.plan_start_date
517: ,p_calendar_code => l_calendar_code
518: ,p_duration => l_dep_step_rec.standard_delay
519: ,p_output_tbl => l_contig_period_tbl
520: ,x_return_status => l_return_status);
521: l_cal_count := l_contig_period_tbl.COUNT;
522: l_date := l_contig_period_tbl (l_cal_count).start_date;

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

519: ,p_output_tbl => l_contig_period_tbl
520: ,x_return_status => l_return_status);
521: l_cal_count := l_contig_period_tbl.COUNT;
522: l_date := l_contig_period_tbl (l_cal_count).start_date;
523: ELSE /* Standard delay is negative */
524: gmp_calendar_api.get_contiguous_periods
525: (p_api_version => 1
526: ,p_init_msg_list => TRUE
527: ,p_start_date => l_batch_step_m_rec.plan_start_date

Line 531: (l_dep_step_rec.standard_delay)

527: ,p_start_date => l_batch_step_m_rec.plan_start_date
528: ,p_end_date => NULL
529: ,p_calendar_code => l_calendar_code
530: ,p_duration => ABS
531: (l_dep_step_rec.standard_delay)
532: ,p_output_tbl => l_contig_period_tbl
533: ,x_return_status => l_return_status);
534: l_cal_count := l_contig_period_tbl.COUNT;
535: l_date := l_contig_period_tbl (l_cal_count).end_date;

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

532: ,p_output_tbl => l_contig_period_tbl
533: ,x_return_status => l_return_status);
534: l_cal_count := l_contig_period_tbl.COUNT;
535: l_date := l_contig_period_tbl (l_cal_count).end_date;
536: END IF; /* l_dep_step_rec.standard_delay >= 0 */
537:
538: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
539: gme_debug.put_line
540: ( 'Called to get the cmplt date for step prior to '

Line 546: || l_dep_step_rec.standard_delay

542: || ' '
543: || TO_CHAR (l_batch_step_m_rec.plan_start_date
544: ,'DD-MON-YYYY HH24:MI:SS')
545: || ' with duration of '
546: || l_dep_step_rec.standard_delay
547: || ' Got back '
548: || TO_CHAR (l_date, 'DD-MON-YYYY HH24:MI:SS') );
549: END IF;
550: