PACKAGE: APPS.AMS_UTILITY_PVT_W

Source

1 package ams_utility_pvt_w AUTHID CURRENT_USER as
2   /* $Header: amswutls.pls 115.5 2003/01/20 19:24:17 yzhao ship $ */
3   procedure rosetta_table_copy_in_p45(t out nocopy ams_utility_pvt.dependent_objects_tbl_type, a0 JTF_VARCHAR2_TABLE_300
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_VARCHAR2_TABLE_300
7     , a4 JTF_VARCHAR2_TABLE_100
8     );
9   procedure rosetta_table_copy_out_p45(t ams_utility_pvt.dependent_objects_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
10     , a1 out nocopy JTF_VARCHAR2_TABLE_100
11     , a2 out nocopy JTF_VARCHAR2_TABLE_100
12     , a3 out nocopy JTF_VARCHAR2_TABLE_300
13     , a4 out nocopy JTF_VARCHAR2_TABLE_100
14     );
15 
16   procedure create_log(x_return_status out nocopy  VARCHAR2
17     , p_arc_log_used_by  VARCHAR2
18     , p_log_used_by_id  VARCHAR2
19     , p_msg_data  VARCHAR2
20     , p_msg_level  NUMBER
21     , p_msg_type  VARCHAR2
22     , p_desc  VARCHAR2
23     , p_budget_id  NUMBER
24     , p_threshold_id  NUMBER
25     , p_transaction_id  NUMBER
26     , p_notification_creat_date  date
27     , p_activity_log_id  NUMBER
28   );
29   procedure convert_currency(x_return_status out nocopy  VARCHAR2
30     , p_from_currency  VARCHAR2
31     , p_to_currency  VARCHAR2
32     , p_conv_date  date
33     , p_from_amount  NUMBER
34     , x_to_amount out nocopy  NUMBER
35   );
36   procedure convert_timezone(p_init_msg_list  VARCHAR2
37     , x_return_status out nocopy  VARCHAR2
38     , x_msg_count out nocopy  NUMBER
39     , x_msg_data out nocopy  VARCHAR2
40     , p_user_tz_id  NUMBER
41     , p_in_time  date
42     , p_convert_type  VARCHAR2
43     , x_out_time out nocopy  DATE
44   );
45   procedure convert_currency(p_set_of_books_id  NUMBER
46     , p_from_currency  VARCHAR2
47     , p_conversion_date  date
48     , p_conversion_type  VARCHAR2
49     , p_conversion_rate  NUMBER
50     , p_amount  NUMBER
51     , x_return_status out nocopy  VARCHAR2
52     , x_acc_amount out nocopy  NUMBER
53     , x_rate out nocopy  NUMBER
54   );
55   procedure calculate_functional_curr(p_from_amount  NUMBER
56     , p_conv_date  date
57     , p_tc_currency_code  VARCHAR2
58     , p_org_id  NUMBER
59     , x_to_amount out nocopy  NUMBER
60     , x_set_of_books_id out nocopy  NUMBER
61     , x_mrc_sob_type_code out nocopy  VARCHAR2
62     , x_fc_currency_code out nocopy  VARCHAR2
63     , x_exchange_rate_type in out nocopy  VARCHAR2
64     , x_exchange_rate in out nocopy  NUMBER
65     , x_return_status out nocopy  VARCHAR2
66   );
67   procedure convert_currency(p_from_currency  VARCHAR2
68     , p_to_currency  VARCHAR2
69     , p_conv_type  VARCHAR2
70     , p_conv_rate  NUMBER
71     , p_conv_date  date
72     , p_from_amount  NUMBER
73     , x_return_status out nocopy  VARCHAR2
74     , x_to_amount out nocopy  NUMBER
75     , x_rate out nocopy  NUMBER
76   );
77 end ams_utility_pvt_w;