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 72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec

68: gme_debug.put_line (g_pkg_name||'.'|| l_api_name||': '||SQL%ROWCOUNT||' records renumbered');
69: END IF;
70:
71: -- insert new material line
72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
73: ,x_material_detail_rec) THEN
74: l_proc := 'gme_material_details_dbl.insert_row';
75: RAISE error_dbl;
76: END IF;

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

70:
71: -- insert new material line
72: IF NOT gme_material_details_dbl.insert_row (p_material_detail_rec
73: ,x_material_detail_rec) THEN
74: l_proc := 'gme_material_details_dbl.insert_row';
75: RAISE error_dbl;
76: END IF;
77:
78: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

243: END IF;
244: END IF; -- IF recipe_id null
245: END IF;
246:
247: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
248: l_proc := 'gme_material_details_dbl.update_row';
249: RAISE error_dbl;
250: END IF;
251:

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

244: END IF; -- IF recipe_id null
245: END IF;
246:
247: IF NOT gme_material_details_dbl.update_row (x_material_detail_rec) THEN
248: l_proc := 'gme_material_details_dbl.update_row';
249: RAISE error_dbl;
250: END IF;
251:
252: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

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

3477: -- 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.
3478:
3479: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3480: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3481: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3482: l_proc := 'gme_material_details_dbl.fetch_row';
3483: RAISE error_dbl;
3484: END IF;
3485: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;

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

3478:
3479: IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN
3480: l_ph_mtl_dtl_rec.material_detail_id := l_mtl_dtl_rec.phantom_line_id;
3481: IF NOT gme_material_details_dbl.fetch_row(l_ph_mtl_dtl_rec, l_ph_mtl_dtl_rec) THEN
3482: l_proc := 'gme_material_details_dbl.fetch_row';
3483: RAISE error_dbl;
3484: END IF;
3485: l_ph_mtl_dtl_rec.material_requirement_date := l_mtl_dtl_rec.material_requirement_date;
3486: l_ph_mtl_dtl_rec.release_type := l_mtl_dtl_rec.release_type;

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

3651: WHERE batch_id = l_ph_mtl_dtl_rec.batch_id
3652: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3653:
3654:
3655: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3656: l_proc := 'gme_material_details_dbl.update_row';
3657: RAISE error_dbl;
3658: END IF;
3659:

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

3652: AND material_detail_id = l_ph_mtl_dtl_rec.material_detail_id;
3653:
3654:
3655: IF NOT gme_material_details_dbl.update_row (l_ph_mtl_dtl_rec) THEN
3656: l_proc := 'gme_material_details_dbl.update_row';
3657: RAISE error_dbl;
3658: END IF;
3659:
3660: END IF; -- IF l_mtl_dtl_rec.phantom_line_id IS NOT NULL THEN

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

3782: SELECT last_update_date INTO l_mtl_dtl_rec.last_update_date
3783: FROM gme_material_details
3784: WHERE batch_id = l_mtl_dtl_rec.batch_id
3785: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3787: l_proc := 'gme_material_details_dbl.update_row';
3788: RAISE error_dbl;
3789: -- nsinghi bug#5208923. added the else part.
3790: ELSE

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

3783: FROM gme_material_details
3784: WHERE batch_id = l_mtl_dtl_rec.batch_id
3785: AND material_detail_id = l_mtl_dtl_rec.material_detail_id;
3786: IF NOT gme_material_details_dbl.update_row (l_mtl_dtl_rec) THEN
3787: l_proc := 'gme_material_details_dbl.update_row';
3788: RAISE error_dbl;
3789: -- nsinghi bug#5208923. added the else part.
3790: ELSE
3791: gme_common_pvt.get_who(x_user_ident => x_material_detail_rec.last_updated_by,

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

3802: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3803: gme_debug.put_line ( g_pkg_name
3804: || '.'
3805: || l_api_name
3806: || ' after gme_material_details_dbl.update_row');
3807: gme_debug.put_line ( g_pkg_name
3808: || '.'
3809: || l_api_name
3810: || ' successfully updated material_detail_id= '

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

4709: END IF;
4710: END IF;
4711: -- 4944024 END
4712:
4713: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4714: l_proc := 'gme_material_details_dbl.delete_row';
4715: RAISE error_dbl;
4716: END IF;
4717:

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

4710: END IF;
4711: -- 4944024 END
4712:
4713: IF NOT gme_material_details_dbl.delete_row (p_material_detail_rec) THEN
4714: l_proc := 'gme_material_details_dbl.delete_row';
4715: RAISE error_dbl;
4716: END IF;
4717:
4718: -- renumber subsequent lines