1 PACKAGE OE_Upgrade_Misc AUTHID CURRENT_USER AS
2 /* $Header: OEXIUMSS.pls 115.5 2003/10/20 06:58:30 appldev ship $ */
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 VARCHAR2
15
16 , x_freight_amount OUT NOCOPY NUMBER
17
18 );
19
20
21 PROCEDURE CREATE_FREIGHT_RECORD
22 (
23 p_header_id IN NUMBER
24 , p_line_id IN NUMBER
25 , p_freight_charge_id IN NUMBER
26 , p_currency_code IN VARCHAR2
27 , p_charge_type_code IN VARCHAR2
28 , p_adjusted_amount IN VARCHAR2
29 , p_creation_date IN DATE
30 , p_created_by IN NUMBER
31 , p_last_update_date IN DATE
32 , p_last_updated_by IN NUMBER
33 , p_last_update_login IN NUMBER
34 , p_context IN VARCHAR2
35 , p_attribute1 IN VARCHAR2
36 , p_attribute2 IN VARCHAR2
37 , p_attribute3 IN VARCHAR2
38 , p_attribute4 IN VARCHAR2
39 , p_attribute5 IN VARCHAR2
40 , p_attribute6 IN VARCHAR2
41 , p_attribute7 IN VARCHAR2
42 , p_attribute8 IN VARCHAR2
43 , p_attribute9 IN VARCHAR2
44 , p_attribute10 IN VARCHAR2
45 , p_attribute11 IN VARCHAR2
46 , p_attribute12 IN VARCHAR2
47 , p_attribute13 IN VARCHAR2
48 , p_attribute14 IN VARCHAR2
49 , p_attribute15 IN VARCHAR2
50 , p_ac_context IN VARCHAR2
51 , p_ac_attribute1 IN VARCHAR2
52 , p_ac_attribute2 IN VARCHAR2
53 , p_ac_attribute3 IN VARCHAR2
54 , p_ac_attribute4 IN VARCHAR2
55 , p_ac_attribute5 IN VARCHAR2
56 , p_ac_attribute6 IN VARCHAR2
57 , p_ac_attribute7 IN VARCHAR2
58 , p_ac_attribute8 IN VARCHAR2
59 , p_ac_attribute9 IN VARCHAR2
60 , p_ac_attribute10 IN VARCHAR2
61 , p_ac_attribute11 IN VARCHAR2
62 , p_ac_attribute12 IN VARCHAR2
63 , p_ac_attribute13 IN VARCHAR2
64 , p_ac_attribute14 IN VARCHAR2
65 , p_ac_attribute15 IN VARCHAR2
66 , x_return_status OUT NOCOPY VARCHAR2
67
68 );
69
70 PROCEDURE Round_Amount(
71 p_Amount IN NUMBER
72 , p_Currency_Code IN VARCHAR2
73 , x_Round_Amount OUT NOCOPY NUMBER
74
75 , x_return_status OUT NOCOPY VARCHAR2
76
77 );
78
79 FUNCTION GET_SOB_CURRENCY(p_org_id IN NUMBER) RETURN VARCHAR2;
80
81 END OE_Upgrade_Misc;