[Home] [Help]
PACKAGE: APPS.OZF_UTILITY_PVT_W
Source
1 package ozf_utility_pvt_w AUTHID CURRENT_USER as
2 /* $Header: ozfwutls.pls 120.1 2006/04/04 08:30:25 sshivali noship $ */
3 procedure rosetta_table_copy_in_p12(t out nocopy ozf_utility_pvt.operating_units_tbl, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p12(t ozf_utility_pvt.operating_units_tbl, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p59(t out nocopy ozf_utility_pvt.dependent_objects_tbl_type, a0 JTF_VARCHAR2_TABLE_300
7 , a1 JTF_VARCHAR2_TABLE_100
8 , a2 JTF_VARCHAR2_TABLE_100
9 , a3 JTF_VARCHAR2_TABLE_300
10 , a4 JTF_VARCHAR2_TABLE_100
11 );
12 procedure rosetta_table_copy_out_p59(t ozf_utility_pvt.dependent_objects_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
13 , a1 out nocopy JTF_VARCHAR2_TABLE_100
14 , a2 out nocopy JTF_VARCHAR2_TABLE_100
15 , a3 out nocopy JTF_VARCHAR2_TABLE_300
16 , a4 out nocopy JTF_VARCHAR2_TABLE_100
17 );
18
19 procedure log_message(p_log_level NUMBER
20 , p_module_name VARCHAR2
21 , p_rcs_id VARCHAR2
22 , p_pop_message number
23 );
24 procedure logging_enabled(p_log_level NUMBER
25 , ddrosetta_retval_bool OUT NOCOPY NUMBER
26 );
27 procedure create_log(x_return_status out nocopy VARCHAR2
28 , p_arc_log_used_by VARCHAR2
29 , p_log_used_by_id VARCHAR2
30 , p_msg_data VARCHAR2
31 , p_msg_level NUMBER
32 , p_msg_type VARCHAR2
33 , p_desc VARCHAR2
34 , p_budget_id NUMBER
35 , p_threshold_id NUMBER
36 , p_transaction_id NUMBER
37 , p_notification_creat_date date
38 , p_activity_log_id NUMBER
39 );
40 procedure convert_currency(x_return_status out nocopy VARCHAR2
41 , p_from_currency VARCHAR2
42 , p_to_currency VARCHAR2
43 , p_conv_date date
44 , p_from_amount NUMBER
45 , x_to_amount out nocopy NUMBER
46 );
47 procedure convert_timezone(p_init_msg_list VARCHAR2
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_count out nocopy NUMBER
50 , x_msg_data out nocopy VARCHAR2
51 , p_user_tz_id NUMBER
52 , p_in_time date
53 , p_convert_type VARCHAR2
54 , x_out_time out nocopy DATE
55 );
56 procedure convert_currency(p_set_of_books_id NUMBER
57 , p_from_currency VARCHAR2
58 , p_conversion_date date
59 , p_conversion_type VARCHAR2
60 , p_conversion_rate NUMBER
61 , p_amount NUMBER
62 , x_return_status out nocopy VARCHAR2
63 , x_acc_amount out nocopy NUMBER
64 , x_rate out nocopy NUMBER
65 );
66 procedure calculate_functional_curr(p_from_amount NUMBER
67 , p_conv_date date
68 , p_tc_currency_code VARCHAR2
69 , p_org_id NUMBER
70 , x_to_amount out nocopy NUMBER
71 , x_set_of_books_id out nocopy NUMBER
72 , x_mrc_sob_type_code out nocopy VARCHAR2
73 , x_fc_currency_code out nocopy VARCHAR2
74 , x_exchange_rate_type in out nocopy VARCHAR2
75 , x_exchange_rate in out nocopy NUMBER
76 , x_return_status out nocopy VARCHAR2
77 );
78 procedure calculate_functional_currency(p_from_amount NUMBER
79 , p_conv_date date
80 , p_tc_currency_code VARCHAR2
81 , p_ledger_id NUMBER
82 , x_to_amount out nocopy NUMBER
83 , x_mrc_sob_type_code out nocopy VARCHAR2
84 , x_fc_currency_code out nocopy VARCHAR2
85 , x_exchange_rate_type in out nocopy VARCHAR2
86 , x_exchange_rate in out nocopy NUMBER
87 , x_return_status out nocopy VARCHAR2
88 );
89 procedure convert_currency(p_from_currency VARCHAR2
90 , p_to_currency VARCHAR2
91 , p_conv_type VARCHAR2
92 , p_conv_rate NUMBER
93 , p_conv_date date
94 , p_from_amount NUMBER
95 , x_return_status out nocopy VARCHAR2
96 , x_to_amount out nocopy NUMBER
97 , x_rate out nocopy NUMBER
98 );
99 end ozf_utility_pvt_w;