DBA Data[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;