APPS.GME_CANCEL_BATCH_PVT dependencies on GME_MATERIAL_DETAILS

Line 51: l_material_details_rec gme_material_details%ROWTYPE;

47:
48: /* Miscellaneous */
49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
51: l_material_details_rec gme_material_details%ROWTYPE;
52: l_material_details_tab gme_common_pvt.material_details_tab;
53: l_batch_step_tab gme_common_pvt.steps_tab;
54: l_batch_header_rec gme_batch_header%ROWTYPE;
55: l_ph_batch_header_rec gme_batch_header%ROWTYPE;

Line 90: IF NOT (gme_material_details_dbl.fetch_tab

86: || ':'
87: || 'Call fetch material tab');
88: END IF;
89:
90: IF NOT (gme_material_details_dbl.fetch_tab
91: (p_material_detail => l_material_details_rec
92: ,x_material_detail => l_material_details_tab) ) THEN
93: RAISE material_details_fetch_err;
94: END IF;

Line 408: l_material_details_rec gme_material_details%ROWTYPE;

404: ,p_delete_trans_pairs IN VARCHAR2 := 'F'
405: ,x_return_status OUT NOCOPY VARCHAR2)
406: IS
407:
408: l_material_details_rec gme_material_details%ROWTYPE;
409: l_material_details_tab gme_common_pvt.material_details_tab;
410: l_batch_header_rec gme_batch_header%ROWTYPE;
411: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
412: l_api_name CONSTANT VARCHAR2 (30) := 'purge_batch_exceptions';

Line 456: IF NOT (gme_material_details_dbl.fetch_tab

452: || ':'
453: || 'Call fetch material tab');
454: END IF;
455:
456: IF NOT (gme_material_details_dbl.fetch_tab
457: (p_material_detail => l_material_details_rec
458: ,x_material_detail => l_material_details_tab) ) THEN
459: RAISE material_details_fetch_err;
460: END IF;