DBA Data[Home] [Help]

PACKAGE: APPS.CN_ACC_PERIODS_PVT_W

Source


1 package cn_acc_periods_pvt_w AUTHID CURRENT_USER as
2   /* $Header: cnwsyprs.pls 120.1 2005/09/14 03:43 vensrini noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_acc_periods_pvt.acc_period_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_DATE_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_VARCHAR2_TABLE_100
10     , a7 JTF_NUMBER_TABLE
11     );
12   procedure rosetta_table_copy_out_p1(t cn_acc_periods_pvt.acc_period_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
13     , a1 out nocopy JTF_NUMBER_TABLE
14     , a2 out nocopy JTF_DATE_TABLE
15     , a3 out nocopy JTF_DATE_TABLE
16     , a4 out nocopy JTF_VARCHAR2_TABLE_100
17     , a5 out nocopy JTF_VARCHAR2_TABLE_100
18     , a6 out nocopy JTF_VARCHAR2_TABLE_100
19     , a7 out nocopy JTF_NUMBER_TABLE
20     );
21 
22   procedure update_acc_periods(p_api_version  NUMBER
23     , p_init_msg_list  VARCHAR2
24     , p_commit  VARCHAR2
25     , p_validation_level  NUMBER
26     , p4_a0 JTF_VARCHAR2_TABLE_100
27     , p4_a1 JTF_NUMBER_TABLE
28     , p4_a2 JTF_DATE_TABLE
29     , p4_a3 JTF_DATE_TABLE
30     , p4_a4 JTF_VARCHAR2_TABLE_100
31     , p4_a5 JTF_VARCHAR2_TABLE_100
32     , p4_a6 JTF_VARCHAR2_TABLE_100
33     , p4_a7 JTF_NUMBER_TABLE
34     , p_org_id  NUMBER
35     , x_return_status out nocopy  VARCHAR2
36     , x_msg_count out nocopy  NUMBER
37     , x_msg_data out nocopy  VARCHAR2
38   );
39   procedure get_acc_periods(p_year  NUMBER
40     , x_system_status out nocopy  VARCHAR2
41     , x_calendar out nocopy  VARCHAR2
42     , x_period_type out nocopy  VARCHAR2
43     , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
44     , p4_a1 out nocopy JTF_NUMBER_TABLE
45     , p4_a2 out nocopy JTF_DATE_TABLE
46     , p4_a3 out nocopy JTF_DATE_TABLE
47     , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
48     , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
49     , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
50     , p4_a7 out nocopy JTF_NUMBER_TABLE
51   );
52 end cn_acc_periods_pvt_w;