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.INV_AUTODETAIL dependencies on INV_DETAIL_UTIL_PVT

Line 627: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,

623: PROCEDURE get_sql_for_rule
624: (
625: p_rule_id IN NUMBER,
626: p_pp_temp_rec IN g_pp_temp_rec_type,
627: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
628: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2

Line 628: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,

624: (
625: p_rule_id IN NUMBER,
626: p_pp_temp_rec IN g_pp_temp_rec_type,
627: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
628: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
629: x_return_status OUT NOCOPY VARCHAR2,
630: x_msg_count OUT NOCOPY NUMBER,
631: x_msg_data OUT NOCOPY VARCHAR2
632: )

Line 735: inv_detail_util_pvt.build_sql

731: ,x_sql_statement => g_stmt
732: );
733: */
734:
735: inv_detail_util_pvt.build_sql
736: (
737: x_return_status => l_return_status
738: ,x_sql_statement => g_stmt);
739: --

Line 886: || 'AND inv_detail_util_pvt.is_sub_loc_lot_trx_allowed('

882: -- Removed for performance reasons. This check will be done in detail_xfer_or_pick
883: -- on each line returned
884: /* IF inv_install.adv_inv_installed(NULL) THEN
885: l_stat_where:= l_stat_where
886: || 'AND inv_detail_util_pvt.is_sub_loc_lot_trx_allowed('
887: || p_request_line_rec.transaction_type_id
888: || ', base.organization_id, base.inventory_item_id, base.subinventory_code'
889: || ', base.locator_id, base.lot_number) = ''Y''';
890: END IF;

Line 1056: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,

1052: --
1053: --
1054: PROCEDURE init_qty_tree
1055: (x_return_status OUT NOCOPY VARCHAR2,
1056: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1057: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1058: x_tree_id OUT NOCOPY NUMBER,
1059: x_msg_count OUT NOCOPY NUMBER,
1060: x_msg_data OUT NOCOPY VARCHAR2

Line 1057: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,

1053: --
1054: PROCEDURE init_qty_tree
1055: (x_return_status OUT NOCOPY VARCHAR2,
1056: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1057: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1058: x_tree_id OUT NOCOPY NUMBER,
1059: x_msg_count OUT NOCOPY NUMBER,
1060: x_msg_data OUT NOCOPY VARCHAR2
1061: )

Line 1153: -- and save outputs by calling inv_detail_util_pvt.add_output

1149: --
1150: -- --------------------------------------------------------------------------
1151: -- What does it do:
1152: -- Detail a transfer or picking only request record using given pick rule,
1153: -- and save outputs by calling inv_detail_util_pvt.add_output
1154: -- --------------------------------------------------------------------------
1155: --
1156: PROCEDURE detail_xfer_or_pick
1157: (p_pp_temp_rec IN g_pp_temp_rec_type,

Line 1158: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,

1154: -- --------------------------------------------------------------------------
1155: --
1156: PROCEDURE detail_xfer_or_pick
1157: (p_pp_temp_rec IN g_pp_temp_rec_type,
1158: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1159: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1160: p_rule_id IN NUMBER,
1161: p_tree_id IN NUMBER,
1162: x_return_status OUT NOCOPY VARCHAR2,

Line 1159: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,

1155: --
1156: PROCEDURE detail_xfer_or_pick
1157: (p_pp_temp_rec IN g_pp_temp_rec_type,
1158: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1159: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1160: p_rule_id IN NUMBER,
1161: p_tree_id IN NUMBER,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: x_msg_count OUT NOCOPY NUMBER,

Line 1210: l_output_serial_rows INV_DETAIL_UTIL_PVT.g_serial_row_table;

1206: --
1207: l_rev_flag BOOLEAN;
1208: l_lot_flag BOOLEAN;
1209: --
1210: l_output_serial_rows INV_DETAIL_UTIL_PVT.g_serial_row_table;
1211: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1212: --
1213: l_serial_number VARCHAR2(30);
1214:

Line 1211: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;

1207: l_rev_flag BOOLEAN;
1208: l_lot_flag BOOLEAN;
1209: --
1210: l_output_serial_rows INV_DETAIL_UTIL_PVT.g_serial_row_table;
1211: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1212: --
1213: l_serial_number VARCHAR2(30);
1214:
1215: l_from_sub_rec MTL_SECONDARY_INVENTORIES%ROWTYPE;

Line 1345: IF inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(p_request_line_rec.transaction_type_id, p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id, l_from_subinventory, l_from_locator_id, l_lot_number) <> 'Y' THEN

1341: --
1342: use_this_row := true;
1343: --
1344: -- Check to determine if this transaction is allowed for lot and locator
1345: IF inv_detail_util_pvt.is_sub_loc_lot_trx_allowed(p_request_line_rec.transaction_type_id, p_request_line_rec.organization_id, p_request_line_rec.inventory_item_id, l_from_subinventory, l_from_locator_id, l_lot_number) <> 'Y' THEN
1346: use_this_row := FALSE;
1347: END IF;
1348:
1349: -- make sure that if this is a non-pick wave move order, that

Line 1466: inv_detail_util_pvt.get_serial_numbers (

1462: -- is in INVVDEUB.pls
1463: l_serial_index := NULL;
1464:
1465: IF p_request_context.detail_serial THEN
1466: inv_detail_util_pvt.get_serial_numbers (
1467: p_inventory_item_id => p_request_line_rec.inventory_item_id
1468: , p_organization_id => p_request_line_rec.organization_id
1469: , p_revision => l_revision
1470: , p_lot_number => l_lot_number

Line 1553: inv_detail_util_pvt.g_output_serial_rows

1549: NULL,
1550: NULL);
1551: FOR l_loop_index IN 1..l_qty_to_update LOOP
1552: l_serial_number :=
1553: inv_detail_util_pvt.g_output_serial_rows
1554: (l_loop_index+l_serial_index-1).serial_number;
1555: l_output_process_rec.serial_number_start := l_serial_number;
1556: l_output_process_rec.serial_number_end := l_serial_number;
1557: -- add it to the output process table for processing later

Line 1558: inv_detail_util_pvt.add_output(l_output_process_rec);

1554: (l_loop_index+l_serial_index-1).serial_number;
1555: l_output_process_rec.serial_number_start := l_serial_number;
1556: l_output_process_rec.serial_number_end := l_serial_number;
1557: -- add it to the output process table for processing later
1558: inv_detail_util_pvt.add_output(l_output_process_rec);
1559: END LOOP;
1560: ELSE
1561: l_output_process_rec.primary_quantity := l_qty_to_update;
1562: l_output_process_rec.transaction_quantity :=

Line 1574: inv_detail_util_pvt.add_output(l_output_process_rec);

1570: NULL,
1571: NULL);
1572: l_output_process_rec.serial_number_start := NULL;
1573: l_output_process_rec.serial_number_end := NULL;
1574: inv_detail_util_pvt.add_output(l_output_process_rec);
1575: END IF;
1576: -- update the quantity remained to detail
1577: l_qty_to_detail := l_qty_to_detail - l_qty_to_update;
1578: --

Line 1611: (p_request_line_rec inv_detail_util_pvt.g_request_line_rec_type,

1607: --
1608: END detail_xfer_or_pick;
1609: --
1610: PROCEDURE detail_putaway_only
1611: (p_request_line_rec inv_detail_util_pvt.g_request_line_rec_type,
1612: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1613: x_return_status OUT NOCOPY VARCHAR2,
1614: x_msg_count OUT NOCOPY NUMBER ,
1615: x_msg_data OUT NOCOPY VARCHAR2

Line 1612: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,

1608: END detail_xfer_or_pick;
1609: --
1610: PROCEDURE detail_putaway_only
1611: (p_request_line_rec inv_detail_util_pvt.g_request_line_rec_type,
1612: p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1613: x_return_status OUT NOCOPY VARCHAR2,
1614: x_msg_count OUT NOCOPY NUMBER ,
1615: x_msg_data OUT NOCOPY VARCHAR2
1616: )

Line 1623: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;

1619: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1620: l_putaway_sub VARCHAR2(30);
1621: l_putaway_loc NUMBER;
1622: l_putaway_cg NUMBER;
1623: l_output_process_rec inv_detail_util_pvt.g_output_process_rec_type;
1624: BEGIN
1625: get_putaway_defaults ( p_request_line_rec.organization_id,
1626: p_request_line_rec.inventory_item_id,
1627: p_request_line_rec.to_subinventory_code,

Line 1666: inv_detail_util_pvt.add_output(l_output_process_rec);

1662: l_output_process_rec.pick_rule_id := NULL;
1663: l_output_process_rec.put_away_rule_id := NULL;
1664: l_output_process_rec.reservation_id := NULL;
1665: -- add it to the output process table for processing later
1666: inv_detail_util_pvt.add_output(l_output_process_rec);
1667: --
1668: x_return_status := l_return_status;
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error THEN

Line 1693: (p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,

1689: -- transactions temporary tables (mtl_material_transactions_temp, etc.)
1690: -- --------------------------------------------------------------------------
1691: --
1692: PROCEDURE detail_request
1693: (p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1694: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1695: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
1696: x_return_status OUT NOCOPY VARCHAR2,
1697: x_msg_count OUT NOCOPY NUMBER ,

Line 1694: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,

1690: -- --------------------------------------------------------------------------
1691: --
1692: PROCEDURE detail_request
1693: (p_request_context IN inv_detail_util_pvt.g_request_context_rec_type,
1694: p_request_line_rec IN inv_detail_util_pvt.g_request_line_rec_type,
1695: p_reservations IN inv_reservation_global.mtl_reservation_tbl_type,
1696: x_return_status OUT NOCOPY VARCHAR2,
1697: x_msg_count OUT NOCOPY NUMBER ,
1698: x_msg_data OUT NOCOPY VARCHAR2

Line 1705: l_detail_level_tbl inv_detail_util_pvt.g_detail_level_tbl_type;

1701: l_rule_id NUMBER;
1702: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1703: l_pp_temp_tbl g_pp_temp_tbl_type;
1704: l_pp_temp_tbl_size NUMBER;
1705: l_detail_level_tbl inv_detail_util_pvt.g_detail_level_tbl_type;
1706: l_detail_level_tbl_size NUMBER;
1707: l_tree_id NUMBER;
1708: l_remaining_quantity NUMBER;
1709: BEGIN

Line 1711: inv_detail_util_pvt.init_output_process_tbl;

1707: l_tree_id NUMBER;
1708: l_remaining_quantity NUMBER;
1709: BEGIN
1710: -- init the output process table
1711: inv_detail_util_pvt.init_output_process_tbl;
1712: IF p_request_context.transfer_flag OR
1713: p_request_context.type_code = 2 THEN -- pick only or transfer
1714: inv_detail_util_pvt.compute_pick_detail_level
1715: (l_return_status ,

Line 1714: inv_detail_util_pvt.compute_pick_detail_level

1710: -- init the output process table
1711: inv_detail_util_pvt.init_output_process_tbl;
1712: IF p_request_context.transfer_flag OR
1713: p_request_context.type_code = 2 THEN -- pick only or transfer
1714: inv_detail_util_pvt.compute_pick_detail_level
1715: (l_return_status ,
1716: p_request_line_rec ,
1717: p_request_context ,
1718: p_reservations ,

Line 1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN

1844: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
1845: raise fnd_api.g_exc_error ;
1846: END IF;
1847: -- if no locations has been found, lets report error
1848: IF inv_detail_util_pvt.g_output_process_tbl.COUNT = 0 THEN
1849: --edited out called to fnd_message by jcearley, 12/2/99
1850: --fnd_message.set_name('INV','INV_SUGGESTION_FAILED');
1851: -- Suggestions not or only partially created through applying strategy
1852: --fnd_msg_pub.add;

Line 1857: inv_detail_util_pvt.process_output(l_return_status,

1853: --RAISE fnd_api.g_exc_error;
1854: RETURN; -- do not raise exeception since it is not an error if can't find qty
1855: END IF;
1856: -- now we can generate records into transactions temp tables
1857: inv_detail_util_pvt.process_output(l_return_status,
1858: p_request_line_rec,
1859: p_request_context
1860: );
1861: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 1949: l_request_context inv_detail_util_pvt.g_request_context_rec_type;

1945: -- constants
1946: l_api_name CONSTANT VARCHAR(30) := 'create_suggestions';
1947: c_api_version_number CONSTANT NUMBER := 1.0;
1948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success ;
1949: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1950: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1951: BEGIN
1952: -- Standard start of API savepoint
1953: SAVEPOINT create_suggestions_sa;

Line 1950: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;

1946: l_api_name CONSTANT VARCHAR(30) := 'create_suggestions';
1947: c_api_version_number CONSTANT NUMBER := 1.0;
1948: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success ;
1949: l_request_context inv_detail_util_pvt.g_request_context_rec_type;
1950: l_request_line_rec inv_detail_util_pvt.g_request_line_rec_type;
1951: BEGIN
1952: -- Standard start of API savepoint
1953: SAVEPOINT create_suggestions_sa;
1954: --

Line 1972: inv_detail_util_pvt.validate_and_init

1968: --
1969: x_return_status := fnd_api.g_ret_sts_success ;
1970: --
1971: -- validate input and initialize
1972: inv_detail_util_pvt.validate_and_init
1973: (l_return_status ,
1974: p_transaction_temp_id ,
1975: p_suggest_serial ,
1976: l_request_line_rec ,