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_MATERIAL_DETAIL_PVT dependencies on GME_MATERIAL_DETAILS_DBL

Line 67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec

63: gme_debug.put_line (g_pkg_name||'.'|| l_api_name||': '||SQL%ROWCOUNT||' records renumbered');
64: END IF;
65:
66: -- insert new material line
67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
68: ,x_material_detail_rec) THEN
69: l_proc := 'gme_material_details_dbl.insert_row';
70: RAISE error_dbl;
71: END IF;

Line 69: l_proc := 'gme_material_details_dbl.insert_row';

65:
66: -- insert new material line
67: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
68: ,x_material_detail_rec) THEN
69: l_proc := 'gme_material_details_dbl.insert_row';
70: RAISE error_dbl;
71: END IF;
72:
73: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 207: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN

203: END IF;
204: END IF; -- IF recipe_id null
205: END IF;
206:
207: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
208: l_proc := 'gme_material_details_dbl.update_row';
209: RAISE error_dbl;
210: END IF;
211:

Line 208: l_proc := 'gme_material_details_dbl.update_row';

204: END IF; -- IF recipe_id null
205: END IF;
206:
207: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
208: l_proc := 'gme_material_details_dbl.update_row';
209: RAISE error_dbl;
210: END IF;
211:
212: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 3335: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN

3331: -- ToDo Put an IF condition to check if material_requirement_date has changed or release_type has changed. Only if either has changed, then we need to do the re-schedule stuff.
3332:
3333: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3334: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3335: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3336: l_proc := 'gme_material_details_dbl.fetch_row';
3337: RAISE error_dbl;
3338: END IF;
3339: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

Line 3336: l_proc := 'gme_material_details_dbl.fetch_row';

3332:
3333: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3334: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3335: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3336: l_proc := 'gme_material_details_dbl.fetch_row';
3337: RAISE error_dbl;
3338: END IF;
3339: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;
3340: l_ph_mtl_dtl_rec.release_type := l_mtl_dtl_rec.release_type;

Line 3509: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN

3505: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3506: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3507:
3508:
3509: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3510: l_proc := 'gme_material_details_dbl.update_row';
3511: RAISE error_dbl;
3512: END IF;
3513:

Line 3510: l_proc := 'gme_material_details_dbl.update_row';

3506: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3507:
3508:
3509: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3510: l_proc := 'gme_material_details_dbl.update_row';
3511: RAISE error_dbl;
3512: END IF;
3513:
3514: END IF; -- IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN

Line 3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN

3591: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3592: FROM gme_material_details
3593: WHERE batch_id = l_mtl_dtl_rec.batch_id
3594: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3596: l_proc := 'gme_material_details_dbl.update_row';
3597: RAISE error_dbl;
3598: -- nsinghi bug#5208923. added the else part.
3599: ELSE

Line 3596: l_proc := 'gme_material_details_dbl.update_row';

3592: FROM gme_material_details
3593: WHERE batch_id = l_mtl_dtl_rec.batch_id
3594: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3595: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3596: l_proc := 'gme_material_details_dbl.update_row';
3597: RAISE error_dbl;
3598: -- nsinghi bug#5208923. added the else part.
3599: ELSE
3600: gme_common_pvt.get_who(x_user_ident => x_material_detail_rec.last_updated_by,

Line 3615: || ' after gme_material_details_dbl.update_row');

3611: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3612: gme_debug.put_line ( g_pkg_name
3613: || '.'
3614: || l_api_name
3615: || ' after gme_material_details_dbl.update_row');
3616: gme_debug.put_line ( g_pkg_name
3617: || '.'
3618: || l_api_name
3619: || ' successfully updated material_detail_id= '

Line 4520: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN

4516: END IF;
4517: END IF;
4518: -- 4944024 END
4519:
4520: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4521: l_proc := 'gme_material_details_dbl.delete_row';
4522: RAISE error_dbl;
4523: END IF;
4524:

Line 4521: l_proc := 'gme_material_details_dbl.delete_row';

4517: END IF;
4518: -- 4944024 END
4519:
4520: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4521: l_proc := 'gme_material_details_dbl.delete_row';
4522: RAISE error_dbl;
4523: END IF;
4524:
4525: -- renumber subsequent lines