DBA Data[Home] [Help]

PACKAGE: APPS.OE_MARGIN_PVT

Source


1 PACKAGE OE_MARGIN_PVT AS
2 /* $Header: OEXVMRGS.pls 120.2.12010000.1 2008/07/25 08:04:52 appldev 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) RETURN NUMBER;
16 
17 PROCEDURE Get_Order_Margin
18 (p_header_id              IN  NUMBER,
19 p_org_id  IN NUMBER default NULL,
20 x_order_margin_percent OUT NOCOPY NUMBER,
21 
22 x_order_margin_amount OUT NOCOPY NUMBER);
23 
24 
25 PROCEDURE Margin_Hold
26 (p_header_id IN NUMBER);
27 
28 procedure cost_action
29                 (
30                  p_selected_records            Oe_Globals.Selected_Record_Tbl
31                 ,P_cost_level                  varchar2
32 );
33 
34 --------------------------------------------------------------------
35 --Margin should only avail for pack I
36 --This is wrapper to a call to OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL
37 --------------------------------------------------------------------
38 Function Is_Margin_Avail return Boolean;
39 
40 
41 --Input line Record
42 --Output unit cost, margin amount and percent
43 Procedure Get_Line_Margin(p_line_rec In OE_ORDER_PUB.LINE_REC_TYPE,
44                           x_unit_cost Out NOCOPY Number,
45                           x_unit_margin_amount Out NOCOPY Number,
46                           x_margin_percent Out NOCOPY Number);
47 
48 
49 End  OE_MARGIN_PVT;