1 PACKAGE OE_Charge_PVT AS
2 /* $Header: OEXVCHRS.pls 120.0 2005/06/01 02:53:55 appldev noship $ */
3
4 -- Procedure to get charge totals at Order Line or Order Header level
5 -- If the header_id is passed and line_id is NULL then total for charges at
6 -- Order Header level is returned
7 -- If header_id and line_id is passed then total for charges at Order line
8 -- level is returned.
9
10 PROCEDURE Get_Charge_Amount
11 ( p_api_version_number IN NUMBER
12 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
13 , p_header_id IN NUMBER
14 , p_line_id IN NUMBER
15 , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
16 , x_return_status OUT NOCOPY VARCHAR2
17
18 , x_msg_count OUT NOCOPY NUMBER
19
20 , x_msg_data OUT NOCOPY VARCHAR2
21
22 , x_charge_amount OUT NOCOPY NUMBER
23
24 );
25
26 -- Function to source the Qualifier Attribute FREIGHT_COST_TYPE
27 -- If the Order line is Shippable and shipping has transferred all costs for
28 -- this line, then this function finds and returns all cost_type_codes from
29 -- OE_PRICE_ADJUSTMENTS table where costs are maintained. It returns a table of
30 -- VARCHAR2 as output.
31
32 FUNCTION Get_Cost_Types
33 RETURN QP_Attr_Mapping_PUB.t_MultiRecord;
34
35 -- Function to source the Pricing Attributes for COST_AMOUNTS.
36 -- If the Order line is Shippable and shipping has transferred all costs for
37 -- this line, then this function takes the cost_type_code as an input and finds
38 -- the cost amount for this cost_type_code from OE_PRICE_ADJUSTMENTS table.
39
40 FUNCTION Get_Cost_Amount
41 ( p_cost_type_code IN VARCHAR2
42 )RETURN VARCHAR2;
43
44 -- This function will be used to source the Qualifier Attribute "SHIPPED_FLAG"
45 -- It will be calling the OE_.Get_Ship_Status to get the line status.
46
47 FUNCTION Get_Shipped_status
48 RETURN VARCHAR2;
49
50 -- This procedure will be used by the Pricing Request before applying the
51 -- charges to the Order. It will check for duplicate charges of same
52 -- charge_type and charge_subtyp. If more that one found then it will select
53 -- the charge with maximum amount.
54
55 PROCEDURE Check_Duplicate_Line_Charges
56 (
57 p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
58 , p_x_line_adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
59 , p_x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type
60 );
61
62 -- This procedure will be used by the Pricing Request before applying the
63 -- charges to the Order. It will check for duplicate charges of same
64 -- charge_type and charge_subtype. If more that one found then it will select
65 -- the charge with maximum amount.
66
67 PROCEDURE Check_Duplicate_Header_Charges
68 (
69 p_header_rec IN OE_Order_PUB.Header_Rec_Type
70 , p_x_Header_adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
71 , p_x_Header_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type
72 );
73
74 -- This procedure will be used in Process Order API to check if any duplicate
75 -- charges exists on a Order Header or a Line before applying any charge.
76
77 PROCEDURE Check_Duplicate_Charges
78 (
79 p_Header_id IN NUMBER
80 , p_line_id IN NUMBER
81 , p_charge_type_code IN VARCHAR2
82 , p_charge_subtype_code IN VARCHAR2
83 , x_duplicate_flag OUT NOCOPY VARCHAR2
84
85 );
86
87 -- This function will be used to source the qualifier attributes LINE_WEIGHT
88 -- and LINE_VOLUME. It will lookup at the following profile options to get the
89 -- target UOM for weight and volume. QP: Line Volume UOM Code and
90 -- QP: Line Weight UOM Code. Then the procedure will call the conversion
91 -- routine to get the values.
92
93 FUNCTION Get_Line_Weight_Or_Volume
94 ( p_uom_class IN VARCHAR2
95 )RETURN VARCHAR2;
96
97
98 --This procedure is to debug charges.
99 --incomplete...
100 Procedure Freight_Debug(p_header_name In Varchar2 default null,
101 p_list_line_id In Number default null,
102 p_line_id In Number,
103 p_org_id In Number);
104
105 --Recurring Charges
106 PROCEDURE Get_Rec_Charge_Amount
107 ( p_api_version_number IN NUMBER
108 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
109 , p_header_id IN NUMBER
110 , p_line_id IN NUMBER
111 , p_all_charges IN VARCHAR2 := FND_API.G_FALSE
112 , p_charge_periodicity_code IN VARCHAR2
113 , x_return_status OUT NOCOPY VARCHAR2
114 , x_msg_count OUT NOCOPY NUMBER
115 , x_msg_data OUT NOCOPY VARCHAR2
116 , x_charge_amount OUT NOCOPY NUMBER
117 );
118 --Recurring Charges
119
120 END OE_Charge_PVT;