APPS.GME_CREATE_BATCH_PVT dependencies on GME_MATERIAL_DETAILS_DBL

Line 83: Changed call to gme_material_details_dbl.update_row which now accepts a p_called_by parameter. This allows

79: Changed select from inline calculation to using variables and making sure that
80: denominator cannot be zero. Procedure: update_step_mtq
81:
82: G. Muratore 26-FEB-2009 Bug 7710435
83: Changed call to gme_material_details_dbl.update_row which now accepts a p_called_by parameter. This allows
84: us to disregard the timestamp used for record locking. It is not required to lock records, during batch create,
85: which are not committed to the database yet. Sometimes, the timestamp in the database record did not match
86: the one in the memory table and therefore updates were failing. Also refetch the material records after the
87: last call to update_row to update the memory tables. PROCEDURE: create_batch.

Line 1831: gme_material_details_dbl.insert_row

1827: gme_debug.put_line ('MATERTIAL lines to be INSERTED ' || l_row_count);
1828: END IF;
1829:
1830: l_return :=
1831: gme_material_details_dbl.insert_row
1832: (l_material_details (l_row_count)
1833: ,l_material_details (l_row_count) );
1834:
1835: IF (g_debug = gme_debug.g_log_statement) THEN

Line 2362: gme_material_details_dbl.update_row (p_material_detail => l_material_details (l_row_count),

2358: --FPBug#4351032 End
2359:
2360: -- Bug 7710435 - Added p_called_by parameter.
2361: l_return :=
2362: gme_material_details_dbl.update_row (p_material_detail => l_material_details (l_row_count),
2363: p_called_by =>'C' );
2364:
2365: /* FPBug#4351032 Updating original primary qty field manually
2366: as this update is not allowed in above dbl procedure */

Line 2437: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN

2433: /* nsinghi bug#5674398 Added the FETCH condition. Reschedule_batch will update the
2434: material_requirement_date, hence requery material detail records */
2435:
2436: l_in_material_detail.batch_id := x_batch_header_rec.batch_id;
2437: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN
2438: RAISE material_dtl_fetch_failure;
2439: END IF;
2440: UPDATE gme_batch_header
2441: SET due_date =

Line 2712: gme_material_details_dbl.update_row (p_material_detail => l_material_details (i),

2708: /* Update material details table we have computed material requirement date and move_order_line_id */
2709: FOR i IN 1 .. l_material_details.COUNT LOOP
2710: -- Bug 7710435 - Added p_called_by parameter.
2711: l_return :=
2712: gme_material_details_dbl.update_row (p_material_detail => l_material_details (i),
2713: p_called_by =>'C' );
2714: END LOOP;
2715:
2716: -- Bug 7710435 - Let's refetch the detail row since the data has been updated.

Line 2718: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN

2714: END LOOP;
2715:
2716: -- Bug 7710435 - Let's refetch the detail row since the data has been updated.
2717: l_in_material_detail.batch_id := x_batch_header_rec.batch_id;
2718: IF NOT gme_material_details_dbl.fetch_tab(l_in_material_detail, l_material_details) THEN
2719: RAISE material_dtl_fetch_failure;
2720: END IF;
2721:
2722: /* Create High Level Reservations */