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 35: p_batch_step_rec IN gme_batch_steps%ROWTYPE

31: 12-APR-2010 G. Muratore Bug 11925400
32: Add step status check to the where clause for 2 cursors.
33: ================================================================================*/
34: PROCEDURE reschedule_step (
35: p_batch_step_rec IN gme_batch_steps%ROWTYPE
36: ,p_source_step_id_tbl IN step_tab
37: ,p_contiguity_override IN VARCHAR2
38: ,p_reschedule_preceding IN VARCHAR2
39: ,p_reschedule_succeeding IN VARCHAR2

Line 41: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE

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

Line 48: l_batch_step_rec gme_batch_steps%ROWTYPE;

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

Line 49: l_batch_step_m_rec gme_batch_steps%ROWTYPE;

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

Line 55: l_batch_step2_rec gme_batch_steps%ROWTYPE;

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

Line 56: x_batch_step2_rec gme_batch_steps%ROWTYPE;

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

Line 100: FROM gme_batch_steps

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

Line 106: FROM gme_batch_steps

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

Line 120: FROM gme_batch_step_dependencies d, gme_batch_steps s

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

Line 132: FROM gme_batch_step_dependencies d, gme_batch_steps s

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

Line 143: FROM gme_batch_steps

139:
140: CURSOR cur_get_dep_step_times (v_batchstep_id NUMBER)
141: IS
142: SELECT batchstep_id, plan_start_date, plan_cmplt_date
143: FROM gme_batch_steps
144: WHERE batchstep_id = v_batchstep_id;
145:
146: CURSOR cur_get_max_date_from_prev (
147: v_batch_id NUMBER

Line 154: FROM gme_batch_step_dependencies d, gme_batch_steps s

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

Line 271: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

267: IF l_return_status <> x_return_status THEN
268: RAISE cal_dates_error;
269: END IF;
270:
271: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
272: ,x_batch_step_rec) ) THEN
273: RAISE batch_step_fetch_error;
274: END IF;
275:

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

297: ,x_batch_step_rec.plan_cmplt_date) >
298: x_batch_step_rec.plan_cmplt_date THEN
299: x_batch_step_rec.plan_cmplt_date := p_batch_step_rec.plan_cmplt_date;
300:
301: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
302: RAISE save_data_error;
303: END IF;
304: END IF;
305: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date

Line 306: UPDATE gme_batch_steps

302: RAISE save_data_error;
303: END IF;
304: END IF;
305: --Bug#4543875 (port 4416699) Update the changed step due date in the procedure calc_dates with the original due date
306: UPDATE gme_batch_steps
307: SET due_date = p_batch_step_rec.due_date
308: ,last_updated_by = gme_common_pvt.g_user_ident
309: ,last_update_date = gme_common_pvt.g_timestamp
310: ,last_update_login = gme_common_pvt.g_login_id

Line 396: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

392: l_batch_step_rec.batchstep_id :=
393: l_dep_step_rec.batchstep_id;
394: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
395: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
396: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec
397: ,l_batch_step_rec) ) THEN
398: RAISE batch_step_fetch_error;
399: END IF;
400: l_max_date :=

Line 495: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step_rec

491: l_batch_step_rec.batchstep_id :=
492: l_dep_step_rec.batchstep_id;
493: l_batch_step_rec.batch_id := p_batch_step_rec.batch_id;
494: -- Rework 4543875 Pawan Kumar added for fetching the data for succeding step
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 */

Line 765: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec

761: END IF; /* recipe_validity_rule_id IS NOT NULL */
762: END IF; /* p_source_step_id_tbl.COUNT = 0 */
763:
764: /* Re-query output batch step row */
765: IF NOT (gme_batch_steps_dbl.fetch_row (p_batch_step_rec
766: ,x_batch_step_rec) ) THEN
767: RAISE batch_step_fetch_error;
768: END IF;
769:

Line 792: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

788: --Bug#5606089 Start. Added the following code.
789: /* SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
790: WHERE material_detail_id = l_material_detail_id_tbl(i);
791:
792: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
793: ,x_batch_step2_rec) ) THEN
794: RAISE batch_step_fetch_error;
795: END IF;*/
796: --Bug#5606089 End.

Line 811: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec

807:
808: SELECT batchstep_id INTO l_batch_step2_rec.batchstep_id FROM GME_BATCH_STEP_ITEMS
809: WHERE material_detail_id = l_material_detail_id_tbl(i);
810:
811: IF NOT (gme_batch_steps_dbl.fetch_row (l_batch_step2_rec
812: ,x_batch_step2_rec) ) THEN
813: RAISE batch_step_fetch_error;
814: END IF;
815: -- pawan kumar end bug 5929323

Line 1070: p_batch_step_rec IN gme_batch_steps%ROWTYPE

1066: A Newbury 05-Aug-2003 B3045672 Modified cursor to include manual and incremental
1067: Pawan Kuamr 01-26-2004 For rework of bug 3010444
1068: ***************************************************************************************/
1069: PROCEDURE save_all_data (
1070: p_batch_step_rec IN gme_batch_steps%ROWTYPE
1071: ,p_use_workday_cal IN VARCHAR2
1072: ,p_contiguity_override IN VARCHAR2
1073: ,p_start_date IN DATE
1074: ,p_end_date IN DATE