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.OE_RESERVE_CONC dependencies on OE_RESERVE_CONC

Line 1: PACKAGE BODY OE_RESERVE_CONC AS

1: PACKAGE BODY OE_RESERVE_CONC AS
2: /* $Header: OEXCRSVB.pls 120.17.12010000.3 2008/11/11 08:17:20 rmoharan ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_RESERVE_CONC';

2: /* $Header: OEXCRSVB.pls 120.17.12010000.3 2008/11/11 08:17:20 rmoharan ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_RESERVE_CONC';
7: G_SET_ID NUMBER;
8: G_PROGRAM_APPLICATION_ID NUMBER;
9: G_PROGRAM_ID NUMBER;
10: G_RESERVATION_MODE VARCHAR2(30);

Line 194: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,

190: and will call create_reservation with the
191: lines having corrected quantity > 0
192: --------------------------------------------------------------------- */
193: Procedure Validate_and_Reserve_for_Set
194: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
195: p_reservation_set_id IN NUMBER,
196: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
197: IS
198:

Line 222: l_rsv_tbl OE_RESERVE_CONC.rsv_tbl_type;

218: ,corrected_qty2 NUMBER -- INVCONV
219: );
220:
221: l_rsv_set_rec Rsv_set_rec_type;
222: l_rsv_tbl OE_RESERVE_CONC.rsv_tbl_type;
223: l_return_status VARCHAR2(1);
224: l_line_reserve_qty NUMBER :=0;
225: l_line_reserve_qty2 NUMBER :=0; -- INVCONV
226: l_sales_order_id NUMBER;

Line 395: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,

391: Procedure Name : Create_Reservation_Set
392: Description : Inserts simulated or reserved records
393: into oe_reservation_sets and oe_rsv_set_details table.
394: --------------------------------------------------------------------- */
395: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
396: p_reserve_set_name IN VARCHAR2,
397: p_rsv_request_id IN NUMBER DEFAULT NULL,
398: p_simulation_request_id IN NUMBER DEFAULT NULL,
399: x_return_status OUT NOCOPY VARCHAR2)

Line 978: p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,

974: Procedure Calculate_Percentage
975: ( p_inventory_item_id IN NUMBER,
976: p_ship_from_org_id IN NUMBER,
977: p_subinventory IN VARCHAR2,
978: p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,
979: x_percentage OUT NOCOPY /* file.sql.39 change */ NUMBER,
980: x_primary_uom OUT NOCOPY VARCHAR2
981: )
982: IS

Line 1294: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,

1290: DESCRIPTION: This Procedure send each line in rsv_tbl to the Inventory for
1291: Reservation
1292: -----------------------------------------------------------------*/
1293: Procedure Create_Reservation
1294: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1295: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1296: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1297: IS
1298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1545: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);

1541: l_return_status := FND_API.G_RET_STS_SUCCESS;
1542: END IF;
1543: x_return_status := l_return_status;
1544: IF l_debug_level > 0 THEN
1545: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);
1546: END IF;
1547:
1548: EXCEPTION
1549: WHEN FND_API.G_EXC_ERROR THEN

Line 1575: Procedure Prepare_And_Reserve(p_rsv_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_RESERVE_CONC.Rsv_Tbl_Type,

1571: DESCRIPTION: This Procedure will call procedures calculate_percentage,
1572: Derive_reservation_qty and create_reservation based on
1573: reservation mode and reservation run type.
1574: -----------------------------------------------------------------*/
1575: Procedure Prepare_And_Reserve(p_rsv_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_RESERVE_CONC.Rsv_Tbl_Type,
1576: p_percent IN NUMBER DEFAULT NULL,
1577: p_reservation_mode IN VARCHAR2,
1578: p_reserve_run_type IN VARCHAR2,
1579: p_reserve_set_name IN VARCHAR2 DEFAULT NULL)

Line 1624: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);

1620:
1621: END IF;
1622:
1623: IF l_debug_level > 0 THEN
1624: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1625: END IF;
1626:
1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1628:

Line 1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);

1623: IF l_debug_level > 0 THEN
1624: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1625: END IF;
1626:
1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1628:
1629: IF l_debug_level > 0 THEN
1630: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1631: END IF;

Line 1630: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);

1626:
1627: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1628:
1629: IF l_debug_level > 0 THEN
1630: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1631: END IF;
1632:
1633: IF p_reserve_run_type = 'RESERVE'
1634: OR p_reserve_run_type IS NULL THEN

Line 1636: --OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);

1632:
1633: IF p_reserve_run_type = 'RESERVE'
1634: OR p_reserve_run_type IS NULL THEN
1635:
1636: --OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1637:
1638:
1639: create_reservation(p_x_rsv_tbl => p_rsv_tbl
1640: ,x_return_status => l_return_status);

Line 1663: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);

1659: END IF;
1660:
1661: ELSIF p_reserve_run_type = 'SIMULATE TO EXTERNAL TABLE' THEN
1662: IF l_debug_level > 0 THEN
1663: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1664: END IF;
1665:
1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1667:

Line 1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);

1662: IF l_debug_level > 0 THEN
1663: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1664: END IF;
1665:
1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1667:
1668: IF l_debug_level > 0 THEN
1669: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1670: END IF;

Line 1669: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);

1665:
1666: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1667:
1668: IF l_debug_level > 0 THEN
1669: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1670: END IF;
1671:
1672: ELSIF p_reserve_run_type = 'SIMULATE' THEN -- Pack J
1673: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);

Line 1885: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||

1881: END IF; -- Check for Reservation Exists Clause
1882: x_return_status := l_return_status;
1883:
1884: IF l_debug_level > 0 THEN
1885: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||
1886: l_return_status ,1);
1887: END IF;
1888: EXCEPTION
1889: WHEN FND_API.G_EXC_ERROR THEN

Line 2023: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||

2019: RAISE FND_API.G_EXC_ERROR;
2020:
2021: END IF;
2022: IF l_debug_level > 0 THEN
2023: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||
2024: l_return_status ,1);
2025: END IF;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:

Line 2968: END OE_RESERVE_CONC;

2964: END IF;
2965: END Reserve;
2966:
2967:
2968: END OE_RESERVE_CONC;