[Home] [Help]
PACKAGE: APPS.OE_MARGIN_PVT
Source
1 PACKAGE OE_MARGIN_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEXVMRGS.pls 120.3 2011/05/03 12:16:27 slagiset ship $ */
3
4 G_SEEDED_MARGIN_HOLD_ID CONSTANT NUMBER:='40';
5
6 FUNCTION Get_Cost (p_line_rec IN OE_ORDER_PUB.LINE_REC_TYPE DEFAULT OE_Order_Pub.G_MISS_LINE_REC
7 ,p_request_rec IN Oe_Order_Pub.Request_Rec_Type DEFAULT Oe_Order_Pub.G_MISS_REQUEST_REC
8 ,p_order_currency IN VARCHAR2 Default NULL
9 ,p_sob_currency IN VARCHAR2 Default NULL
10 ,p_inventory_item_id IN NUMBER Default NULL
11 ,p_ship_from_org_id IN NUMBER Default NULL
12 ,p_conversion_Type_code IN VARCHAR2 Default NULL
13 ,p_conversion_rate IN NUMBER Default NULL
14 ,p_item_type_code IN VARCHAR2 Default 'STANDARD'
15 ,p_header_flag IN Boolean Default FALSE
16 ,p_ordered_uom IN VARCHAR2 Default NULL --Bug 11880399
17 ) RETURN NUMBER;
18
19 PROCEDURE Get_Order_Margin
20 (p_header_id IN NUMBER,
21 p_org_id IN NUMBER default NULL,
22 x_order_margin_percent OUT NOCOPY NUMBER,
23
24 x_order_margin_amount OUT NOCOPY NUMBER);
25
26
27 PROCEDURE Margin_Hold
28 (p_header_id IN NUMBER);
29
30 procedure cost_action
31 (
32 p_selected_records Oe_Globals.Selected_Record_Tbl
33 ,P_cost_level varchar2
34 );
35
36 --------------------------------------------------------------------
37 --Margin should only avail for pack I
38 --This is wrapper to a call to OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL
39 --------------------------------------------------------------------
40 Function Is_Margin_Avail return Boolean;
41
42
43 --Input line Record
44 --Output unit cost, margin amount and percent
45 Procedure Get_Line_Margin(p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE,
46 x_unit_cost Out NOCOPY Number,
47 x_unit_margin_amount Out NOCOPY Number,
48 x_margin_percent Out NOCOPY Number);
49
50
51 End OE_MARGIN_PVT;