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_RESERVATIONS_PVT dependencies on GME_MATERIAL_DETAILS

Line 154: l_mtl_dtl_rec gme_material_details%ROWTYPE;

150: ,x_return_status OUT NOCOPY VARCHAR2)
151: IS
152: l_api_name CONSTANT VARCHAR2 (30) := 'create_batch_reservations';
153: l_return_status VARCHAR2 (1);
154: l_mtl_dtl_rec gme_material_details%ROWTYPE;
155: l_resv_qty NUMBER DEFAULT NULL;
156: line_resvn_err EXCEPTION;
157: get_open_qty_err EXCEPTION;
158:

Line 162: FROM gme_material_details d, mtl_system_items i

158:
159: CURSOR cur_reservable_ings
160: IS
161: SELECT d.*
162: FROM gme_material_details d, mtl_system_items i
163: WHERE d.batch_id = p_batch_id
164: AND d.line_type = -1
165: AND d.line_type = -1
166: AND ( NVL (p_timefence, 0) = 0

Line 257: p_matl_dtl_rec IN gme_material_details%ROWTYPE

253:
254: -- Bug 6437252
255: -- Added lpn_id parameter.
256: PROCEDURE create_material_reservation (
257: p_matl_dtl_rec IN gme_material_details%ROWTYPE
258: ,p_resv_qty IN NUMBER DEFAULT NULL
259: ,p_sec_resv_qty IN NUMBER DEFAULT NULL
260: ,p_resv_um IN VARCHAR2 DEFAULT NULL
261: ,p_subinventory IN VARCHAR2 DEFAULT NULL

Line 603: PROCEDURE get_MO_allocated_qty (p_mtl_dtl_rec IN gme_material_details%ROWTYPE

599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
600: x_return_status := fnd_api.g_ret_sts_unexp_error;
601: END get_material_res;
602:
603: PROCEDURE get_MO_allocated_qty (p_mtl_dtl_rec IN gme_material_details%ROWTYPE
604: ,p_called_by IN VARCHAR2
605: /* P- picking, R-reservation, S-shortages, Z-from Auto-Detail line */
606: ,x_open_qty OUT NOCOPY NUMBER
607: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 788: ,p_material_dtl_rec IN gme_material_details%ROWTYPE

784: END reservation_fully_specified;
785:
786: PROCEDURE convert_partial_to_dlr (
787: p_reservation_rec IN mtl_reservations%ROWTYPE
788: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
789: ,p_item_rec IN mtl_system_items%ROWTYPE
790: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
791: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
792: ,x_return_status OUT NOCOPY VARCHAR2)

Line 875: FROM gme_material_details d, mtl_system_items_b i

871:
872: CURSOR cur_batch_materials
873: IS
874: SELECT d.material_detail_id, d.batch_id, d.organization_id
875: FROM gme_material_details d, mtl_system_items_b i
876: WHERE d.organization_id = p_organization_id
877: AND d.batch_id = p_batch_id
878: AND d.line_type = gme_common_pvt.g_line_type_ing
879: AND i.organization_id = d.organization_id

Line 1133: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

1129: END get_reservation_dtl_qty;
1130:
1131: -- Bug 12613813 - add p_locator_only parameter so picking can consider locator also.
1132: PROCEDURE get_reserved_qty (
1133: p_mtl_dtl_rec IN gme_material_details%ROWTYPE
1134: ,p_supply_sub_only IN VARCHAR2 DEFAULT 'F'
1135: ,p_locator_only IN VARCHAR2 DEFAULT 'F'
1136: ,x_reserved_qty OUT NOCOPY NUMBER
1137: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1140: l_mtl_dtl_rec gme_material_details%ROWTYPE;

1136: ,x_reserved_qty OUT NOCOPY NUMBER
1137: ,x_return_status OUT NOCOPY VARCHAR2)
1138: IS
1139: l_api_name CONSTANT VARCHAR2 (30) := 'get_reserved_qty';
1140: l_mtl_dtl_rec gme_material_details%ROWTYPE;
1141: l_mtl_dtl_rec_hold gme_material_details%ROWTYPE; -- Bug 12737393
1142: l_resv_tbl gme_common_pvt.reservations_tab;
1143: l_temp_qty NUMBER;
1144: l_return_status VARCHAR2 (1);

Line 1141: l_mtl_dtl_rec_hold gme_material_details%ROWTYPE; -- Bug 12737393

1137: ,x_return_status OUT NOCOPY VARCHAR2)
1138: IS
1139: l_api_name CONSTANT VARCHAR2 (30) := 'get_reserved_qty';
1140: l_mtl_dtl_rec gme_material_details%ROWTYPE;
1141: l_mtl_dtl_rec_hold gme_material_details%ROWTYPE; -- Bug 12737393
1142: l_resv_tbl gme_common_pvt.reservations_tab;
1143: l_temp_qty NUMBER;
1144: l_return_status VARCHAR2 (1);
1145:

Line 1172: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec

1168: x_return_status := fnd_api.g_ret_sts_success;
1169: x_reserved_qty := 0;
1170:
1171: -- Bug 12737393 - Move fetch outside of IF
1172: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec
1173: ,l_mtl_dtl_rec_hold))) THEN
1174: RAISE matl_fetch_error;
1175: END IF;
1176:

Line 1182: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec

1178: OR p_mtl_dtl_rec.dtl_um IS NULL
1179: OR p_mtl_dtl_rec.batch_id IS NULL
1180: OR (p_supply_sub_only = fnd_api.g_true AND p_mtl_dtl_rec.subinventory IS NULL)) THEN
1181: /*
1182: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec
1183: ,l_mtl_dtl_rec) ) ) THEN
1184: RAISE matl_fetch_error;
1185: END IF; */
1186: l_mtl_dtl_rec := l_mtl_dtl_rec_hold;

Line 1587: ,p_material_details_rec IN gme_material_details%ROWTYPE

1583: END pending_reservations_exist;
1584:
1585: PROCEDURE convert_dtl_reservation (
1586: p_reservation_rec IN mtl_reservations%ROWTYPE
1587: ,p_material_details_rec IN gme_material_details%ROWTYPE
1588: ,p_qty_convert IN NUMBER := NULL
1589: ,p_trans_date IN DATE DEFAULT NULL -- Bug 13532998
1590: ,x_message_count OUT NOCOPY NUMBER
1591: ,x_message_list OUT NOCOPY VARCHAR2

Line 1709: /* but this must be expressed in terms of gme_material_details.dtl_um */

1705:
1706: /* Next phase is to create the inventory transaction and relieve the reservation */
1707: l_actual_qty := NVL (p_material_details_rec.actual_qty, 0);
1708: /* If p_qty_convert is null, need to pass in the full reservation_qty */
1709: /* but this must be expressed in terms of gme_material_details.dtl_um */
1710: l_qty_convert := p_qty_convert;
1711:
1712: IF l_qty_convert IS NULL THEN
1713: IF g_debug <= gme_debug.g_log_statement THEN

Line 1772: -- The variable l_qty_convert is expressed in terms of gme_material_details.dtl_um

1768: || l_item_rec.lot_divisible_flag);
1769: END IF;
1770:
1771: -- Bug 6778968 - Add p_called_by parameter to signify the calling routine.
1772: -- The variable l_qty_convert is expressed in terms of gme_material_details.dtl_um
1773:
1774: -- Bug 13532998 - Pass in user transaction date if passed in.
1775: gme_release_batch_pvt.build_and_create_transaction
1776: (p_rsrv_rec => l_reservation_rec

Line 1835: p_material_details_rec IN gme_material_details%ROWTYPE

1831: ,x_data => x_message_list);
1832: END convert_dtl_reservation;
1833:
1834: PROCEDURE auto_detail_line (
1835: p_material_details_rec IN gme_material_details%ROWTYPE
1836: ,x_return_status OUT NOCOPY VARCHAR2)
1837: IS
1838: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1839: l_item_rec mtl_system_items_b%ROWTYPE;

Line 2438: FROM gme_material_details d,mtl_system_items_b i

2434: /* Retrieve Ingredient rows */
2435: CURSOR cur_get_reservable_ings
2436: IS
2437: SELECT d.*
2438: FROM gme_material_details d,mtl_system_items_b i
2439: WHERE d.batch_id = p_batch_rec.batch_id
2440: AND d.line_type = -1
2441: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2442: AND i. inventory_item_id = d.inventory_item_id

Line 2585: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE,

2581: END auto_detail_batch;
2582:
2583: --Bug#4604943 created the following procedure
2584: PROCEDURE validate_mtl_for_reservation(
2585: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE,
2586: x_return_status OUT NOCOPY VARCHAR2) IS
2587:
2588: l_api_name VARCHAR2(30) := 'VALIDATE_MTL_FOR_RESERVATION';
2589: l_batch_header_rec gme_batch_header%ROWTYPE;