1 PACKAGE OE_Upgrade_Misc_New AUTHID CURRENT_USER AS
2 /* $Header: OEXNUMSS.pls 120.0 2005/06/01 00:42:22 appldev noship $ */
3
4 -- Procedure to convert the passed in Freight Amount to the specified
5 -- currency.
6
7 PROCEDURE CONVERT_CURRENCY
8 ( p_freight_amount IN NUMBER
9 , p_from_currency IN VARCHAR2
10 , p_to_currency IN VARCHAR2
11 , p_conversion_date IN DATE
12 , p_conversion_rate IN NUMBER
13 , p_conversion_type IN VARCHAR2
14 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
15 , x_freight_amount OUT NOCOPY /* file.sql.39 change */ NUMBER
16 );
17
18
19 PROCEDURE CREATE_FREIGHT_RECORD
20 (
21 p_header_id IN NUMBER
22 , p_line_id IN NUMBER
23 , p_freight_charge_id IN NUMBER
24 , p_currency_code IN VARCHAR2
25 , p_charge_type_code IN VARCHAR2
26 , p_adjusted_amount IN VARCHAR2
27 , p_creation_date IN DATE
28 , p_created_by IN NUMBER
29 , p_last_update_date IN DATE
30 , p_last_updated_by IN NUMBER
31 , p_last_update_login IN NUMBER
32 , p_context IN VARCHAR2
33 , p_attribute1 IN VARCHAR2
34 , p_attribute2 IN VARCHAR2
35 , p_attribute3 IN VARCHAR2
36 , p_attribute4 IN VARCHAR2
37 , p_attribute5 IN VARCHAR2
38 , p_attribute6 IN VARCHAR2
39 , p_attribute7 IN VARCHAR2
40 , p_attribute8 IN VARCHAR2
41 , p_attribute9 IN VARCHAR2
42 , p_attribute10 IN VARCHAR2
43 , p_attribute11 IN VARCHAR2
44 , p_attribute12 IN VARCHAR2
45 , p_attribute13 IN VARCHAR2
46 , p_attribute14 IN VARCHAR2
47 , p_attribute15 IN VARCHAR2
48 , p_ac_context IN VARCHAR2
49 , p_ac_attribute1 IN VARCHAR2
50 , p_ac_attribute2 IN VARCHAR2
51 , p_ac_attribute3 IN VARCHAR2
52 , p_ac_attribute4 IN VARCHAR2
53 , p_ac_attribute5 IN VARCHAR2
54 , p_ac_attribute6 IN VARCHAR2
55 , p_ac_attribute7 IN VARCHAR2
56 , p_ac_attribute8 IN VARCHAR2
57 , p_ac_attribute9 IN VARCHAR2
58 , p_ac_attribute10 IN VARCHAR2
59 , p_ac_attribute11 IN VARCHAR2
60 , p_ac_attribute12 IN VARCHAR2
61 , p_ac_attribute13 IN VARCHAR2
62 , p_ac_attribute14 IN VARCHAR2
63 , p_ac_attribute15 IN VARCHAR2
64 , p_invoice_status IN VARCHAR2
65 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
66 );
67
68 PROCEDURE Round_Amount(
69 p_Amount IN NUMBER
70 , p_Currency_Code IN VARCHAR2
71 , x_Round_Amount OUT NOCOPY /* file.sql.39 change */ NUMBER
72 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
73 );
74
75 FUNCTION GET_SOB_CURRENCY(p_org_id IN NUMBER) RETURN VARCHAR2;
76
77 END OE_Upgrade_Misc_New;