APPS.GME_RESCHEDULE_STEP_PVT dependencies on GME_BATCH_HEADER

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

Line 47: l_batch_header2_rec gme_batch_header%ROWTYPE;

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

Line 203: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

199: l_batch_header_rec.batch_id := x_batch_step_rec.batch_id;
200: l_calendar_code := gme_common_pvt.g_calendar_code;
201:
202: /* Initialize local batch header */
203: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
204: ,l_batch_header_rec) ) THEN
205: RAISE batch_header_fetch_error;
206: END IF;
207:

Line 254: (p_gme_batch_header_rec => l_batch_header_rec

250: AND batchstep_id = x_batch_step_rec.batchstep_id);
251: END IF;
252:
253: gme_create_step_pvt.calc_dates
254: (p_gme_batch_header_rec => l_batch_header_rec
255: ,p_use_workday_cal => p_use_workday_cal
256: ,p_contiguity_override => p_contiguity_override
257: ,p_return_status => l_return_status
258: ,p_step_id => p_batch_step_rec.batchstep_id

Line 729: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

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

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

735: l_batch_header_rec.plan_start_date;
736: l_batch_header2_rec.plan_cmplt_date :=
737: l_batch_header_rec.plan_cmplt_date;
738:
739: IF NOT (gme_batch_header_dbl.update_row (l_batch_header2_rec) ) THEN
740: RAISE save_data_error;
741: END IF;
742:
743: --Bug#5365527 added the validity rule check for LCF Batches

Line 1081: l_batch_header_rec gme_batch_header%ROWTYPE;

1077: l_api_name CONSTANT VARCHAR2 (30) := 'SAVE_ALL_DATA';
1078: l_material_detail_id_tbl gme_common_pvt.number_tab;
1079: l_phantom_ids gme_common_pvt.number_tab;
1080: l_return_status VARCHAR2 (1);
1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1083: x_batch_header_rec gme_batch_header%ROWTYPE;
1084:
1085: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE

Line 1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;

1078: l_material_detail_id_tbl gme_common_pvt.number_tab;
1079: l_phantom_ids gme_common_pvt.number_tab;
1080: l_return_status VARCHAR2 (1);
1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1083: x_batch_header_rec gme_batch_header%ROWTYPE;
1084:
1085: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1086: INDEX BY BINARY_INTEGER;

Line 1083: x_batch_header_rec gme_batch_header%ROWTYPE;

1079: l_phantom_ids gme_common_pvt.number_tab;
1080: l_return_status VARCHAR2 (1);
1081: l_batch_header_rec gme_batch_header%ROWTYPE;
1082: l_in_batch_header_rec gme_batch_header%ROWTYPE;
1083: x_batch_header_rec gme_batch_header%ROWTYPE;
1084:
1085: TYPE l_line_type_tbl_typ IS TABLE OF gme_material_details.line_type%TYPE
1086: INDEX BY BINARY_INTEGER;
1087:

Line 1125: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec

1121: /* Initialize return status to success */
1122: x_return_status := fnd_api.g_ret_sts_success;
1123: l_batch_header_rec.batch_id := p_batch_step_rec.batch_id;
1124:
1125: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec
1126: ,x_batch_header_rec) ) THEN
1127: RAISE invalid_batch;
1128: END IF;
1129: