eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OKL_ACCOUNTING_UTIL_W

Source


1 package okl_accounting_util_w AUTHID CURRENT_USER as
2   /* $Header: OKLEAUTS.pls 120.3 2007/01/25 11:20:28 nikshah ship $ */
3   procedure rosetta_table_copy_in_p0(t out nocopy okl_accounting_util.seg_num_array_type, a0 JTF_NUMBER_TABLE);
4   procedure rosetta_table_copy_out_p0(t okl_accounting_util.seg_num_array_type, a0 out nocopy JTF_NUMBER_TABLE);
5 
6   procedure rosetta_table_copy_in_p1(t out nocopy okl_accounting_util.seg_array_type, a0 JTF_VARCHAR2_TABLE_100);
7   procedure rosetta_table_copy_out_p1(t okl_accounting_util.seg_array_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
8 
9   procedure rosetta_table_copy_in_p2(t out nocopy okl_accounting_util.seg_desc_array_type, a0 JTF_VARCHAR2_TABLE_100);
10   procedure rosetta_table_copy_out_p2(t okl_accounting_util.seg_desc_array_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11 
12   procedure rosetta_table_copy_in_p3(t out nocopy okl_accounting_util.error_message_type, a0 JTF_VARCHAR2_TABLE_2000);
13   procedure rosetta_table_copy_out_p3(t okl_accounting_util.error_message_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000);
14 
15   procedure rosetta_table_copy_in_p26(t out nocopy okl_accounting_util.overlap_attrib_tbl_type, a0 JTF_VARCHAR2_TABLE_100
16     , a1 JTF_VARCHAR2_TABLE_100
17     , a2 JTF_VARCHAR2_TABLE_200
18     );
19   procedure rosetta_table_copy_out_p26(t okl_accounting_util.overlap_attrib_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
20     , a1 out nocopy JTF_VARCHAR2_TABLE_100
21     , a2 out nocopy JTF_VARCHAR2_TABLE_200
22     );
23 
24   procedure get_segment_array(p_concate_segments  VARCHAR2
25     , p_delimiter  VARCHAR2
26     , p_seg_array_type out nocopy JTF_VARCHAR2_TABLE_100
27   );
28   procedure get_error_message(p_all_message out nocopy JTF_VARCHAR2_TABLE_2000
29   );
30   procedure get_error_msg(p_all_message out nocopy JTF_VARCHAR2_TABLE_2000
31   );
32   function get_curr_con_rate(p_from_curr_code  VARCHAR2
33     , p_to_curr_code  VARCHAR2
34     , p_con_date  date
35     , p_con_type  VARCHAR2
36   ) return number;
37   procedure get_curr_con_rate(p_api_version  NUMBER
38     , p_init_msg_list  VARCHAR2
39     , x_return_status out nocopy  VARCHAR2
40     , x_msg_count out nocopy  NUMBER
41     , x_msg_data out nocopy  VARCHAR2
42     , p_from_curr_code  VARCHAR2
43     , p_to_curr_code  VARCHAR2
44     , p_con_date  date
45     , p_con_type  VARCHAR2
46     , x_conv_rate out nocopy  NUMBER
47   );
48   procedure get_accounting_segment(p0_a0 out nocopy  JTF_NUMBER_TABLE
49     , p0_a1 out nocopy  JTF_VARCHAR2_TABLE_100
50     , p0_a2 out nocopy  JTF_VARCHAR2_TABLE_100
51   );
52   procedure get_period_info(p_date  date
53     , p_period_name out nocopy  VARCHAR2
54     , p_start_date out nocopy  DATE
55     , p_end_date out nocopy  DATE
56     , p_ledger_id  NUMBER
57   );
58   procedure check_overlaps(p_id  NUMBER
59     , p1_a0 JTF_VARCHAR2_TABLE_100
60     , p1_a1 JTF_VARCHAR2_TABLE_100
61     , p1_a2 JTF_VARCHAR2_TABLE_200
62     , p_start_date_attribute_name  VARCHAR2
63     , p_start_date  date
64     , p_end_date_attribute_name  VARCHAR2
65     , p_end_date  date
66     , p_view  VARCHAR2
67     , x_return_status out nocopy  VARCHAR2
68     , x_valid out nocopy  number
69   );
70   procedure get_version(p0_a0 JTF_VARCHAR2_TABLE_100
71     , p0_a1 JTF_VARCHAR2_TABLE_100
72     , p0_a2 JTF_VARCHAR2_TABLE_200
73     , p_cur_version  VARCHAR2
74     , p_end_date_attribute_name  VARCHAR2
75     , p_end_date  date
76     , p_view  VARCHAR2
77     , x_return_status out nocopy  VARCHAR2
78     , x_new_version out nocopy  VARCHAR2
79   );
80   procedure convert_to_functional_currency(p_khr_id  NUMBER
81     , p_to_currency  VARCHAR2
82     , p_transaction_date  date
83     , p_amount  NUMBER
84     , x_contract_currency out nocopy  VARCHAR2
85     , x_currency_conversion_type out nocopy  VARCHAR2
86     , x_currency_conversion_rate out nocopy  NUMBER
87     , x_currency_conversion_date out nocopy  DATE
88     , x_converted_amount out nocopy  NUMBER
89   );
90   procedure convert_to_functional_currency(p_khr_id  NUMBER
91     , p_to_currency  VARCHAR2
92     , p_transaction_date  date
93     , p_amount  NUMBER
94     , x_return_status out nocopy  VARCHAR2
95     , x_contract_currency out nocopy  VARCHAR2
96     , x_currency_conversion_type out nocopy  VARCHAR2
97     , x_currency_conversion_rate out nocopy  NUMBER
98     , x_currency_conversion_date out nocopy  DATE
99     , x_converted_amount out nocopy  NUMBER
100   );
101   procedure convert_to_contract_currency(p_khr_id  NUMBER
102     , p_from_currency  VARCHAR2
103     , p_transaction_date  date
104     , p_amount  NUMBER
105     , x_contract_currency out nocopy  VARCHAR2
106     , x_currency_conversion_type out nocopy  VARCHAR2
107     , x_currency_conversion_rate out nocopy  NUMBER
108     , x_currency_conversion_date out nocopy  DATE
109     , x_converted_amount out nocopy  NUMBER
110   );
111   procedure convert_to_contract_currency(p_khr_id  NUMBER
112     , p_from_currency  VARCHAR2
113     , p_transaction_date  date
114     , p_amount  NUMBER
115     , x_return_status out nocopy  VARCHAR2
116     , x_contract_currency out nocopy  VARCHAR2
117     , x_currency_conversion_type out nocopy  VARCHAR2
118     , x_currency_conversion_rate out nocopy  NUMBER
119     , x_currency_conversion_date out nocopy  DATE
120     , x_converted_amount out nocopy  NUMBER
121   );
122   function get_valid_gl_date(p_gl_date  date
123     , p_ledger_id  NUMBER
124   ) return date;
125 end okl_accounting_util_w;