[Home] [Help]
PACKAGE: APPS.INL_LANDEDCOST_PVT
Source
1 PACKAGE INL_LANDEDCOST_PVT AUTHID CURRENT_USER AS
2 /* $Header: INLVLCOS.pls 120.14 2011/12/20 17:27:21 ebarbosa ship $ */
3
4 G_MODULE_NAME CONSTANT VARCHAR2(200) := 'INL.PLSQL.INL_LANDEDCOST_PVT.';
5 G_PKG_NAME CONSTANT VARCHAR2(30) := 'INL_LANDEDCOST_PVT';
6
7 L_FND_FALSE CONSTANT VARCHAR2(1) := fnd_api.g_false; --Bug#9660084
8 L_FND_VALID_LEVEL_FULL CONSTANT NUMBER := fnd_api.g_valid_level_full; --Bug#9660084
9
10 PROCEDURE Run_Calculation (
11 p_api_version IN NUMBER,
12 p_init_msg_list IN VARCHAR2 := L_FND_FALSE,
13 p_commit IN VARCHAR2 := L_FND_FALSE,
14 p_validation_level IN NUMBER := L_FND_VALID_LEVEL_FULL,
15 p_ship_header_id IN NUMBER,
16 p_calc_scope_code IN NUMBER := 0,
17 x_return_status OUT NOCOPY VARCHAR2,
18 x_msg_count OUT NOCOPY NUMBER,
19 x_msg_data OUT NOCOPY VARCHAR2
20 );
21
22 FUNCTION Converted_Qty (
23 p_organization_id IN NUMBER,
24 p_inventory_item_id IN NUMBER,
25 p_qty IN NUMBER,
26 p_from_uom_code IN VARCHAR2,
27 p_to_uom_code IN VARCHAR2
28 ) RETURN NUMBER;
29
30
31 FUNCTION Converted_Amt (
32 p_amt IN NUMBER,
33 p_from_currency_code IN VARCHAR2,
34 p_to_currency_code IN VARCHAR2,
35 p_currency_conversion_type IN VARCHAR2,
36 p_currency_conversion_date IN DATE
37 ) RETURN NUMBER;
38
39 FUNCTION Converted_Amt (
40 p_amt IN NUMBER,
41 p_from_currency_code IN VARCHAR2,
42 p_to_currency_code IN VARCHAR2,
43 p_currency_conversion_type IN VARCHAR2,
44 p_currency_conversion_date IN DATE,
45 x_currency_conversion_rate OUT NOCOPY NUMBER
46 ) RETURN NUMBER;
47
48 FUNCTION Converted_Price(
49 p_unit_price IN NUMBER,
50 p_organization_id IN NUMBER,
51 p_inventory_item_id IN NUMBER,
52 p_from_uom_code IN VARCHAR2,
53 p_to_uom_code IN VARCHAR2
54 ) RETURN NUMBER;
55
56 END INL_LANDEDCOST_PVT;