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.21.12020000.2 2012/07/03 09:49:44 amallik 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.21.12020000.2 2012/07/03 09:49:44 amallik 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 41: PROCEDURE Validate_Derived_Quantities(p_x_rsv_rec IN OUT NOCOPY OE_RESERVE_CONC.Res_Rec_Type)

37: 13657322
38: PARAMETERS :
39: p_x_rsv_rec Reservation record to be processed.
40: */
41: PROCEDURE Validate_Derived_Quantities(p_x_rsv_rec IN OUT NOCOPY OE_RESERVE_CONC.Res_Rec_Type)
42: IS
43: l_validated_quantity NUMBER;
44: l_primary_quantity NUMBER;
45: l_qty_return_status VARCHAR2(1);

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

266: and will call create_reservation with the
267: lines having corrected quantity > 0
268: --------------------------------------------------------------------- */
269: Procedure Validate_and_Reserve_for_Set
270: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
271: p_reservation_set_id IN NUMBER,
272: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
273: IS
274:

Line 298: l_rsv_tbl OE_RESERVE_CONC.rsv_tbl_type;

294: ,corrected_qty2 NUMBER -- INVCONV
295: );
296:
297: l_rsv_set_rec Rsv_set_rec_type;
298: l_rsv_tbl OE_RESERVE_CONC.rsv_tbl_type;
299: l_return_status VARCHAR2(1);
300: l_line_reserve_qty NUMBER :=0;
301: l_line_reserve_qty2 NUMBER :=0; -- INVCONV
302: l_sales_order_id NUMBER;

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

467: Procedure Name : Create_Reservation_Set
468: Description : Inserts simulated or reserved records
469: into oe_reservation_sets and oe_rsv_set_details table.
470: --------------------------------------------------------------------- */
471: Procedure Create_Reservation_Set(p_rsv_tbl IN OE_RESERVE_CONC.Rsv_Tbl_Type,
472: p_reserve_set_name IN VARCHAR2,
473: p_rsv_request_id IN NUMBER DEFAULT NULL,
474: p_simulation_request_id IN NUMBER DEFAULT NULL,
475: x_return_status OUT NOCOPY VARCHAR2)

Line 1023: p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,

1019: Procedure Calculate_Percentage
1020: ( p_inventory_item_id IN NUMBER,
1021: p_ship_from_org_id IN NUMBER,
1022: p_subinventory IN VARCHAR2,
1023: p_rsv_tbl IN OE_RESERVE_CONC.rsv_tbl_type,
1024: x_percentage OUT NOCOPY /* file.sql.39 change */ NUMBER,
1025: x_primary_uom OUT NOCOPY VARCHAR2
1026: )
1027: IS

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

1332: DESCRIPTION: This Procedure send each line in rsv_tbl to the Inventory for
1333: Reservation
1334: -----------------------------------------------------------------*/
1335: Procedure Create_Reservation
1336: (p_x_rsv_tbl IN OUT NOCOPY OE_RESERVE_CONC.rsv_tbl_type,
1337: p_partial_reservation IN VARCHAR2 DEFAULT FND_API.G_TRUE,
1338: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1339: IS
1340: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

1593: l_return_status := FND_API.G_RET_STS_SUCCESS;
1594: END IF;
1595: x_return_status := l_return_status;
1596: IF l_debug_level > 0 THEN
1597: OE_DEBUG_PUB.Add('Exiting OE_RESERVE_CONC.Create_reservation for rsv_tbl',1);
1598: END IF;
1599:
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN

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

1623: DESCRIPTION: This Procedure will call procedures calculate_percentage,
1624: Derive_reservation_qty and create_reservation based on
1625: reservation mode and reservation run type.
1626: -----------------------------------------------------------------*/
1627: Procedure Prepare_And_Reserve(p_rsv_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_RESERVE_CONC.Rsv_Tbl_Type,
1628: p_percent IN NUMBER DEFAULT NULL,
1629: p_reservation_mode IN VARCHAR2,
1630: p_reserve_run_type IN VARCHAR2,
1631: p_reserve_set_name IN VARCHAR2 DEFAULT NULL)

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

1672:
1673: END IF;
1674:
1675: IF l_debug_level > 0 THEN
1676: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1677: END IF;
1678:
1679: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1680:

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

1675: IF l_debug_level > 0 THEN
1676: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1677: END IF;
1678:
1679: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1680:
1681: IF l_debug_level > 0 THEN
1682: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1683: END IF;

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

1678:
1679: OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1680:
1681: IF l_debug_level > 0 THEN
1682: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule ',1);
1683: END IF;
1684:
1685: IF p_reserve_run_type = 'RESERVE'
1686: OR p_reserve_run_type IS NULL THEN

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

1684:
1685: IF p_reserve_run_type = 'RESERVE'
1686: OR p_reserve_run_type IS NULL THEN
1687:
1688: --OE_RESERVE_CONC_HOOK.Qty_Per_Business_Rule(p_x_rsv_tbl => p_rsv_tbl);
1689:
1690:
1691: create_reservation(p_x_rsv_tbl => p_rsv_tbl
1692: ,x_return_status => l_return_status);

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

1711: END IF;
1712:
1713: ELSIF p_reserve_run_type = 'SIMULATE TO EXTERNAL TABLE' THEN
1714: IF l_debug_level > 0 THEN
1715: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1716: END IF;
1717:
1718: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1719:

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

1714: IF l_debug_level > 0 THEN
1715: OE_DEBUG_PUB.Add('Going to call OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1716: END IF;
1717:
1718: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1719:
1720: IF l_debug_level > 0 THEN
1721: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1722: END IF;

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

1717:
1718: OE_RESERVE_CONC_HOOK.Simulated_Results(p_x_rsv_tbl => p_rsv_tbl);
1719:
1720: IF l_debug_level > 0 THEN
1721: OE_DEBUG_PUB.Add('After calling OE_RESERVE_CONC_HOOK.Simulated_Results ',1);
1722: END IF;
1723:
1724: ELSIF p_reserve_run_type = 'SIMULATE' THEN -- Pack J
1725: FND_PROFILE.Get('CONC_REQUEST_ID', l_request_id);

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

1933: END IF; -- Check for Reservation Exists Clause
1934: x_return_status := l_return_status;
1935:
1936: IF l_debug_level > 0 THEN
1937: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Need_Reservation' ||
1938: l_return_status ,1);
1939: END IF;
1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN

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

2071: RAISE FND_API.G_EXC_ERROR;
2072:
2073: END IF;
2074: IF l_debug_level > 0 THEN
2075: OE_DEBUG_PUB.Add('..Exiting OE_RESERVE_CONC.Create_reservation' ||
2076: l_return_status ,1);
2077: END IF;
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;
2079:

Line 3044: END OE_RESERVE_CONC;

3040: END IF;
3041: END Reserve;
3042:
3043:
3044: END OE_RESERVE_CONC;