DBA Data[Home] [Help]

PACKAGE: APPS.PVX_UTILITY_PVT_W

Source


1 package pvx_utility_pvt_w AUTHID CURRENT_USER as
2   /* $Header: pvxwutls.pls 120.1 2008/02/28 22:19:20 hekkiral ship $ */
3   procedure rosetta_table_copy_in_p11(t out nocopy pvx_utility_pvt.log_params_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_2000
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_VARCHAR2_TABLE_100
7     );
8   procedure rosetta_table_copy_out_p11(t pvx_utility_pvt.log_params_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
9     , a1 out nocopy JTF_VARCHAR2_TABLE_2000
10     , a2 out nocopy JTF_VARCHAR2_TABLE_100
11     , a3 out nocopy JTF_VARCHAR2_TABLE_100
12     );
13 
14   procedure convert_timezone(p_init_msg_list  VARCHAR2
15     , x_return_status out nocopy  VARCHAR2
16     , x_msg_count out nocopy  NUMBER
17     , x_msg_data out nocopy  VARCHAR2
18     , p_user_tz_id  NUMBER
19     , p_in_time  date
20     , p_convert_type  VARCHAR2
21     , x_out_time out nocopy  DATE
22   );
23   procedure create_history_log(p_arc_history_for_entity_code  VARCHAR2
24     , p_history_for_entity_id  NUMBER
25     , p_history_category_code  VARCHAR2
26     , p_message_code  VARCHAR2
27     , p_partner_id  NUMBER
28     , p_access_level_flag  VARCHAR2
29     , p_interaction_level  NUMBER
30     , p_comments  VARCHAR2
31     , p8_a0 JTF_VARCHAR2_TABLE_100
32     , p8_a1 JTF_VARCHAR2_TABLE_2000
33     , p8_a2 JTF_VARCHAR2_TABLE_100
34     , p8_a3 JTF_VARCHAR2_TABLE_100
35     , p_init_msg_list  VARCHAR2
36     , p_commit  VARCHAR2
37     , x_return_status out nocopy  VARCHAR2
38     , x_msg_count out nocopy  NUMBER
39     , x_msg_data out nocopy  VARCHAR2
40   );
41   procedure get_business_days(p_from_date  date
42     , p_to_date  date
43     , x_bus_days out nocopy  NUMBER
44   );
45 end pvx_utility_pvt_w;