APPS.GME_CANCEL_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 81: l_material_details_rec gme_material_details%ROWTYPE;

77:
78: /* Miscellaneous */
79: l_batch_step_rec gme_batch_steps%ROWTYPE;
80: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
81: l_material_details_rec gme_material_details%ROWTYPE;
82: l_material_details_tab gme_common_pvt.material_details_tab;
83: l_batch_step_tab gme_common_pvt.steps_tab;
84: l_batch_header_rec gme_batch_header%ROWTYPE;
85: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

Line 120: IF NOT (gme_material_details_dbl.fetch_tab

116: || ':'
117: || 'Call fetch material tab');
118: END IF;
119:
120: IF NOT (gme_material_details_dbl.fetch_tab
121: (p_material_detail => l_material_details_rec
122: ,x_material_detail => l_material_details_tab) ) THEN
123: RAISE material_details_fetch_err;
124: END IF;

Line 479: l_material_details_rec gme_material_details%ROWTYPE;

475: ,p_recursive IN VARCHAR2 := 'N'
476: ,x_return_status OUT NOCOPY VARCHAR2)
477: IS
478:
479: l_material_details_rec gme_material_details%ROWTYPE;
480: l_material_details_tab gme_common_pvt.material_details_tab;
481: l_batch_header_rec gme_batch_header%ROWTYPE;
482: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
483: l_api_name CONSTANT VARCHAR2 (30) := 'purge_batch_exceptions';

Line 539: IF NOT (gme_material_details_dbl.fetch_tab

535: || ':'
536: || 'Call fetch material tab');
537: END IF;
538:
539: IF NOT (gme_material_details_dbl.fetch_tab
540: (p_material_detail => l_material_details_rec
541: ,x_material_detail => l_material_details_tab) ) THEN
542: RAISE material_details_fetch_err;
543: END IF;