1 PACKAGE OE_Totals_GRP AUTHID CURRENT_USER AS
2 /* $Header: OEXGTOTS.pls 120.0 2005/05/31 23:49:14 appldev noship $ */
3
4
5 -- Start of Comments
6 -- API name Get_Order_Total
7 -- Type Group
8 -- Function: The API to return Order/Line totals for (Line amount/Tax /Charges)
9 -- For Order level total, the Header_id should be passed in and Line_id
10 -- should be null. For line level totals, both should be passed in with values.
11 --
12 -- Pre-reqs
13 --
14 -- Parameters
15 -- p_header_id IN NUMBER
16 -- p_line_id IN NUMBER
17 -- p_total_type IN NUMBER possible values are
18 -- ('ALL','LINES','CHARGES','TAXES')
19 --
20 -- Version Current version = 1.0
21 -- Initial version = 1.0
22 --
23 -- Notes
24 --
25 -- End of Comments
26 FUNCTION Get_Order_Total
27 ( p_header_id IN NUMBER
28 , p_line_id IN NUMBER
29 , p_total_type IN VARCHAR2 := 'ALL'
30 ) RETURN NUMBER;
31
32 FUNCTION Get_Rec_Order_Total
33 ( p_header_id IN NUMBER
34 , p_line_id IN NUMBER
35 , p_charge_periodicity_code IN VARCHAR2
36 , p_total_type IN VARCHAR2 := 'ALL'
37 ) RETURN NUMBER;
38
39 PROCEDURE GET_RECURRING_TOTALS
40 (
41 p_header_id IN NUMBER,
42 x_rec_charges_tbl IN OUT NOCOPY OE_OE_TOTALS_SUMMARY.Rec_Charges_Tbl_Type);
43
44 --Pay Now Pay Later project
45 --group API which returns the pay now portion of an order or an order line. The pay now portion is broken up into subtotal, tax, charges and pay now total.
46 FUNCTION Get_PayNow_Total
47 ( p_header_id IN NUMBER
48 , p_line_id IN NUMBER
49 , p_total_type IN VARCHAR2 := NULL
50 ) RETURN NUMBER;
51
52
53 END OE_Totals_GRP;
[Home] [Help]