APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_HEADER

Line 44: l_batch_header_rec gme_batch_header%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';
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;

Line 45: l_batch_header2_rec gme_batch_header%ROWTYPE;

41: IS
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;

Line 197: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

193: l_batch_header_rec.batch_id := x_batch_step_rec.batch_id;
194: l_calendar_code := gme_common_pvt.g_calendar_code;
195:
196: /* Initialize local batch header */
197: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
198: ,l_batch_header_rec) ) THEN
199: RAISE batch_header_fetch_error;
200: END IF;
201:

Line 248: (p_gme_batch_header_rec => l_batch_header_rec

244: AND batchstep_id = x_batch_step_rec.batchstep_id);
245: END IF;
246:
247: gme_create_step_pvt.calc_dates
248: (p_gme_batch_header_rec => l_batch_header_rec
249: ,p_use_workday_cal => p_use_workday_cal
250: ,p_contiguity_override => p_contiguity_override
251: ,p_return_status => l_return_status
252: ,p_step_id => p_batch_step_rec.batchstep_id

Line 723: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

719: we want to fetch the row, so that the timestamps are most
720: current, which is what is used to make sure that someone
721: else has not updated this batch during processing of this
722: program execution. That is why l_batch_header_rec is introduced.*/
723: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
724: ,l_batch_header2_rec) ) THEN
725: RAISE batch_header_fetch_error;
726: END IF;
727:

Line 733: IF NOT (gme_batch_header_dbl.update_row (l_batch_header2_rec) ) THEN

729: l_batch_header_rec.plan_start_date;
730: l_batch_header2_rec.plan_cmplt_date :=
731: l_batch_header_rec.plan_cmplt_date;
732:
733: IF NOT (gme_batch_header_dbl.update_row (l_batch_header2_rec) ) THEN
734: RAISE save_data_error;
735: END IF;
736:
737: --Bug#5365527 added the validity rule check for LCF Batches

Line 1075: l_batch_header_rec gme_batch_header%ROWTYPE;

1071: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1072: l_material_detail_id_tbl gme_common_pvt.number_tab;
1073: l_phantom_ids gme_common_pvt.number_tab;
1074: l_return_status VARCHAR2 (1);
1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1077: x_batch_header_rec gme_batch_header%ROWTYPE;
1078:
1079: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE

Line 1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;

1072: l_material_detail_id_tbl gme_common_pvt.number_tab;
1073: l_phantom_ids gme_common_pvt.number_tab;
1074: l_return_status VARCHAR2 (1);
1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1077: x_batch_header_rec gme_batch_header%ROWTYPE;
1078:
1079: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1080: INDEX BY BINARY_INTEGER;

Line 1077: x_batch_header_rec gme_batch_header%ROWTYPE;

1073: l_phantom_ids gme_common_pvt.number_tab;
1074: l_return_status VARCHAR2 (1);
1075: l_batch_header_rec gme_batch_header%ROWTYPE;
1076: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1077: x_batch_header_rec gme_batch_header%ROWTYPE;
1078:
1079: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1080: INDEX BY BINARY_INTEGER;
1081:

Line 1119: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

1115: /* Initialize return status to success */
1116: x_return_status := fnd_api.g_ret_sts_success;
1117: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
1118:
1119: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
1120: ,x_batch_header_rec) ) THEN
1121: RAISE invalid_batch;
1122: END IF;
1123: