DBA Data[Home] [Help]

PACKAGE: APPS.CN_ROLE_PAY_GROUPS_PVT_W

Source


1 package cn_role_pay_groups_pvt_w AUTHID CURRENT_USER as
2   /* $Header: cnwrpgps.pls 120.3 2005/09/14 03:42 vensrini noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy cn_role_pay_groups_pvt.role_pay_groups_rec_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_VARCHAR2_TABLE_200
9     , a6 JTF_VARCHAR2_TABLE_200
10     , a7 JTF_VARCHAR2_TABLE_200
11     , a8 JTF_VARCHAR2_TABLE_200
12     , a9 JTF_VARCHAR2_TABLE_200
13     , a10 JTF_VARCHAR2_TABLE_200
14     , a11 JTF_VARCHAR2_TABLE_200
15     , a12 JTF_VARCHAR2_TABLE_200
16     , a13 JTF_VARCHAR2_TABLE_200
17     , a14 JTF_VARCHAR2_TABLE_200
18     , a15 JTF_VARCHAR2_TABLE_200
19     , a16 JTF_VARCHAR2_TABLE_200
20     , a17 JTF_VARCHAR2_TABLE_200
21     , a18 JTF_VARCHAR2_TABLE_200
22     , a19 JTF_VARCHAR2_TABLE_200
23     , a20 JTF_VARCHAR2_TABLE_200
24     , a21 JTF_NUMBER_TABLE
25     , a22 JTF_NUMBER_TABLE
26     );
27   procedure rosetta_table_copy_out_p1(t cn_role_pay_groups_pvt.role_pay_groups_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28     , a1 out nocopy JTF_VARCHAR2_TABLE_100
29     , a2 out nocopy JTF_VARCHAR2_TABLE_100
30     , a3 out nocopy JTF_DATE_TABLE
31     , a4 out nocopy JTF_DATE_TABLE
32     , a5 out nocopy JTF_VARCHAR2_TABLE_200
33     , a6 out nocopy JTF_VARCHAR2_TABLE_200
34     , a7 out nocopy JTF_VARCHAR2_TABLE_200
35     , a8 out nocopy JTF_VARCHAR2_TABLE_200
36     , a9 out nocopy JTF_VARCHAR2_TABLE_200
37     , a10 out nocopy JTF_VARCHAR2_TABLE_200
38     , a11 out nocopy JTF_VARCHAR2_TABLE_200
39     , a12 out nocopy JTF_VARCHAR2_TABLE_200
40     , a13 out nocopy JTF_VARCHAR2_TABLE_200
41     , a14 out nocopy JTF_VARCHAR2_TABLE_200
42     , a15 out nocopy JTF_VARCHAR2_TABLE_200
43     , a16 out nocopy JTF_VARCHAR2_TABLE_200
44     , a17 out nocopy JTF_VARCHAR2_TABLE_200
45     , a18 out nocopy JTF_VARCHAR2_TABLE_200
46     , a19 out nocopy JTF_VARCHAR2_TABLE_200
47     , a20 out nocopy JTF_VARCHAR2_TABLE_200
48     , a21 out nocopy JTF_NUMBER_TABLE
49     , a22 out nocopy JTF_NUMBER_TABLE
50     );
51 
52   procedure create_role_pay_groups(p_api_version  NUMBER
53     , p_init_msg_list  VARCHAR2
54     , p_commit  VARCHAR2
55     , p_validation_level  NUMBER
56     , x_return_status out nocopy  VARCHAR2
57     , x_loading_status out nocopy  VARCHAR2
58     , x_msg_count out nocopy  NUMBER
59     , x_msg_data out nocopy  VARCHAR2
60     , p8_a0 in out nocopy  NUMBER
61     , p8_a1 in out nocopy  VARCHAR2
62     , p8_a2 in out nocopy  VARCHAR2
63     , p8_a3 in out nocopy  DATE
64     , p8_a4 in out nocopy  DATE
65     , p8_a5 in out nocopy  VARCHAR2
66     , p8_a6 in out nocopy  VARCHAR2
67     , p8_a7 in out nocopy  VARCHAR2
68     , p8_a8 in out nocopy  VARCHAR2
69     , p8_a9 in out nocopy  VARCHAR2
70     , p8_a10 in out nocopy  VARCHAR2
71     , p8_a11 in out nocopy  VARCHAR2
72     , p8_a12 in out nocopy  VARCHAR2
73     , p8_a13 in out nocopy  VARCHAR2
74     , p8_a14 in out nocopy  VARCHAR2
75     , p8_a15 in out nocopy  VARCHAR2
76     , p8_a16 in out nocopy  VARCHAR2
77     , p8_a17 in out nocopy  VARCHAR2
78     , p8_a18 in out nocopy  VARCHAR2
79     , p8_a19 in out nocopy  VARCHAR2
80     , p8_a20 in out nocopy  VARCHAR2
81     , p8_a21 in out nocopy  NUMBER
82     , p8_a22 in out nocopy  NUMBER
83   );
84   procedure delete_role_pay_groups(p_api_version  NUMBER
85     , p_init_msg_list  VARCHAR2
86     , p_commit  VARCHAR2
87     , p_validation_level  NUMBER
88     , x_return_status out nocopy  VARCHAR2
89     , x_loading_status out nocopy  VARCHAR2
90     , x_msg_count out nocopy  NUMBER
91     , x_msg_data out nocopy  VARCHAR2
92     , p8_a0 in out nocopy  NUMBER
93     , p8_a1 in out nocopy  VARCHAR2
94     , p8_a2 in out nocopy  VARCHAR2
95     , p8_a3 in out nocopy  DATE
96     , p8_a4 in out nocopy  DATE
97     , p8_a5 in out nocopy  VARCHAR2
98     , p8_a6 in out nocopy  VARCHAR2
99     , p8_a7 in out nocopy  VARCHAR2
100     , p8_a8 in out nocopy  VARCHAR2
101     , p8_a9 in out nocopy  VARCHAR2
102     , p8_a10 in out nocopy  VARCHAR2
103     , p8_a11 in out nocopy  VARCHAR2
104     , p8_a12 in out nocopy  VARCHAR2
105     , p8_a13 in out nocopy  VARCHAR2
106     , p8_a14 in out nocopy  VARCHAR2
107     , p8_a15 in out nocopy  VARCHAR2
108     , p8_a16 in out nocopy  VARCHAR2
109     , p8_a17 in out nocopy  VARCHAR2
110     , p8_a18 in out nocopy  VARCHAR2
111     , p8_a19 in out nocopy  VARCHAR2
112     , p8_a20 in out nocopy  VARCHAR2
113     , p8_a21 in out nocopy  NUMBER
114     , p8_a22 in out nocopy  NUMBER
115   );
116 end cn_role_pay_groups_pvt_w;