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 GME_BATCH_STEPS

Line 33: p_batch_step_rec IN gme_batch_steps%ROWTYPE

29: U - Unexpected error
30: HISTORY
31: ================================================================================*/
32: PROCEDURE reschedule_step (
33: p_batch_step_rec IN gme_batch_steps%ROWTYPE
34: ,p_source_step_id_tbl IN step_tab
35: ,p_contiguity_override IN VARCHAR2
36: ,p_reschedule_preceding IN VARCHAR2
37: ,p_reschedule_succeeding IN VARCHAR2

Line 39: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

35: ,p_contiguity_override IN VARCHAR2
36: ,p_reschedule_preceding IN VARCHAR2
37: ,p_reschedule_succeeding IN VARCHAR2
38: ,p_use_workday_cal IN VARCHAR2
39: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
40: ,x_return_status OUT NOCOPY VARCHAR2)
41: IS
42: /* Buffers for database reads/writes */
43: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';

Line 46: l_batch_step_rec gme_batch_steps%ROWTYPE;

42: /* Buffers for database reads/writes */
43: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
44: l_batch_header_rec gme_batch_header%ROWTYPE;
45: l_batch_header2_rec gme_batch_header%ROWTYPE;
46: l_batch_step_rec gme_batch_steps%ROWTYPE;
47: l_batch_step_m_rec gme_batch_steps%ROWTYPE;
48: l_material_detail_id_tbl gme_common_pvt.number_tab;
49: l_rel_type NUMBER;
50: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;

Line 47: l_batch_step_m_rec gme_batch_steps%ROWTYPE;

43: l_api_name CONSTANT VARCHAR2 (30) := 'RESCHEDULE_STEP';
44: l_batch_header_rec gme_batch_header%ROWTYPE;
45: l_batch_header2_rec gme_batch_header%ROWTYPE;
46: l_batch_step_rec gme_batch_steps%ROWTYPE;
47: l_batch_step_m_rec gme_batch_steps%ROWTYPE;
48: l_material_detail_id_tbl gme_common_pvt.number_tab;
49: l_rel_type NUMBER;
50: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
51: l_loop_count_get_material NUMBER;

Line 53: l_batch_step2_rec gme_batch_steps%ROWTYPE;

49: l_rel_type NUMBER;
50: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
51: l_loop_count_get_material NUMBER;
52: --Bug#5606089
53: l_batch_step2_rec gme_batch_steps%ROWTYPE;
54: x_batch_step2_rec gme_batch_steps%ROWTYPE;
55: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
56: INDEX BY BINARY_INTEGER;
57:

Line 54: x_batch_step2_rec gme_batch_steps%ROWTYPE;

50: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
51: l_loop_count_get_material NUMBER;
52: --Bug#5606089
53: l_batch_step2_rec gme_batch_steps%ROWTYPE;
54: x_batch_step2_rec gme_batch_steps%ROWTYPE;
55: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
56: INDEX BY BINARY_INTEGER;
57:
58: l_line_type_tbl l_line_type_tbl_typ;

Line 98: FROM gme_batch_steps

94:
95: CURSOR cur_get_max (v_batch_id NUMBER)
96: IS
97: SELECT MAX (plan_cmplt_date)
98: FROM gme_batch_steps
99: WHERE batch_id = v_batch_id;
100:
101: CURSOR cur_get_min (v_batch_id NUMBER)
102: IS

Line 104: FROM gme_batch_steps

100:
101: CURSOR cur_get_min (v_batch_id NUMBER)
102: IS
103: SELECT MIN (plan_start_date)
104: FROM gme_batch_steps
105: WHERE batch_id = v_batch_id;
106:
107: CURSOR cur_get_material (v_batch_id NUMBER)
108: IS

Line 117: FROM gme_batch_step_dependencies d, gme_batch_steps s

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
120: AND s.batch_id = v_batch_id
121: AND d.batch_id = s.batch_id

Line 127: FROM gme_batch_step_dependencies d, gme_batch_steps s

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
131: AND d.batch_id = s.batch_id

Line 137: FROM gme_batch_steps

133:
134: CURSOR cur_get_dep_step_times (v_batchstep_id NUMBER)
135: IS
136: SELECT batchstep_id, plan_start_date, plan_cmplt_date
137: FROM gme_batch_steps
138: WHERE batchstep_id = v_batchstep_id;
139:
140: CURSOR cur_get_max_date_from_prev (
141: v_batch_id NUMBER

Line 148: FROM gme_batch_step_dependencies d, gme_batch_steps s

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
152: AND d.batch_id = s.batch_id;

Line 265: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

261: IF l_return_status <> x_return_status THEN
262: RAISE cal_dates_error;
263: END IF;
264:
265: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
266: ,x_batch_step_rec) ) THEN
267: RAISE batch_step_fetch_error;
268: END IF;
269:

Line 295: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN

291: ,x_batch_step_rec.plan_cmplt_date) >
292: x_batch_step_rec.plan_cmplt_date THEN
293: x_batch_step_rec.plan_cmplt_date := p_batch_step_rec.plan_cmplt_date;
294:
295: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
296: RAISE save_data_error;
297: END IF;
298: END IF;
299: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date

Line 300: UPDATE gme_batch_steps

296: RAISE save_data_error;
297: END IF;
298: END IF;
299: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
300: UPDATE gme_batch_steps
301: SET due_date = p_batch_step_rec.due_date
302: ,last_updated_by = gme_common_pvt.g_user_ident
303: ,last_update_date = gme_common_pvt.g_timestamp
304: ,last_update_login = gme_common_pvt.g_login_id

Line 390: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

386: l_batch_step_rec.batchstep_id :=
387: l_dep_step_rec.batchstep_id;
388: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
389: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
390: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
391: ,l_batch_step_rec) ) THEN
392: RAISE batch_step_fetch_error;
393: END IF;
394: l_max_date :=

Line 489: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

485: l_batch_step_rec.batchstep_id :=
486: l_dep_step_rec.batchstep_id;
487: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
488: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
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 */

Line 759: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

755: END IF; /* recipe_validity_rule_id IS NOT NULL */
756: END IF; /* p_source_step_id_tbl.COUNT = 0 */
757:
758: /* Re-query output batch step row */
759: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
760: ,x_batch_step_rec) ) THEN
761: RAISE batch_step_fetch_error;
762: END IF;
763:

Line 786: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

782: --Bug#5606089 Start. Added the following code.
783: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
784: WHERE material_detail_id = l_material_detail_id_tbl(i);
785:
786: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
787: ,x_batch_step2_rec) ) THEN
788: RAISE batch_step_fetch_error;
789: END IF;*/
790: --Bug#5606089 End.

Line 805: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

801:
802: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
803: WHERE material_detail_id = l_material_detail_id_tbl(i);
804:
805: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
806: ,x_batch_step2_rec) ) THEN
807: RAISE batch_step_fetch_error;
808: END IF;
809: -- pawan kumar end bug 5929323

Line 1064: p_batch_step_rec IN gme_batch_steps%ROWTYPE

1060: A Newbury 05-Aug-2003 B3045672 Modified cursor to include manual and incremental
1061: Pawan Kuamr 01-26-2004 For rework of bug 3010444
1062: ***************************************************************************************/
1063: PROCEDURE save_all_data (
1064: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1065: ,p_use_workday_cal IN VARCHAR2
1066: ,p_contiguity_override IN VARCHAR2
1067: ,p_start_date IN DATE
1068: ,p_end_date IN DATE