[Home] [Help]
PACKAGE: APPS.CN_PAY_GROUP_DTLS_PVT_W
Source
1 package cn_pay_group_dtls_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwpgdts.pls 115.6 2002/11/27 12:20:14 pramadas ship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_DATE_TABLE
12 );
13 procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_VARCHAR2_TABLE_100
15 , a2 out nocopy JTF_VARCHAR2_TABLE_100
16 , a3 out nocopy JTF_VARCHAR2_TABLE_100
17 , a4 out nocopy JTF_VARCHAR2_TABLE_100
18 , a5 out nocopy JTF_NUMBER_TABLE
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_DATE_TABLE
21 , a8 out nocopy JTF_DATE_TABLE
22 );
23
24 procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
25 , a1 JTF_VARCHAR2_TABLE_100
26 , a2 JTF_VARCHAR2_TABLE_100
27 , a3 JTF_VARCHAR2_TABLE_100
28 , a4 JTF_VARCHAR2_TABLE_400
29 , a5 JTF_VARCHAR2_TABLE_100
30 , a6 JTF_DATE_TABLE
31 , a7 JTF_DATE_TABLE
32 );
33 procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_VARCHAR2_TABLE_100
35 , a2 out nocopy JTF_VARCHAR2_TABLE_100
36 , a3 out nocopy JTF_VARCHAR2_TABLE_100
37 , a4 out nocopy JTF_VARCHAR2_TABLE_400
38 , a5 out nocopy JTF_VARCHAR2_TABLE_100
39 , a6 out nocopy JTF_DATE_TABLE
40 , a7 out nocopy JTF_DATE_TABLE
41 );
42
43 procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
44 , a1 JTF_VARCHAR2_TABLE_100
45 , a2 JTF_VARCHAR2_TABLE_100
46 , a3 JTF_VARCHAR2_TABLE_100
47 , a4 JTF_VARCHAR2_TABLE_100
48 , a5 JTF_NUMBER_TABLE
49 , a6 JTF_DATE_TABLE
50 , a7 JTF_DATE_TABLE
51 );
52 procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53 , a1 out nocopy JTF_VARCHAR2_TABLE_100
54 , a2 out nocopy JTF_VARCHAR2_TABLE_100
55 , a3 out nocopy JTF_VARCHAR2_TABLE_100
56 , a4 out nocopy JTF_VARCHAR2_TABLE_100
57 , a5 out nocopy JTF_NUMBER_TABLE
58 , a6 out nocopy JTF_DATE_TABLE
59 , a7 out nocopy JTF_DATE_TABLE
60 );
61
62 procedure get_pay_group_dtls(p_api_version NUMBER
63 , p_init_msg_list VARCHAR2
64 , p_commit VARCHAR2
65 , p_validation_level NUMBER
66 , p_start_record NUMBER
67 , p_fetch_size NUMBER
68 , p_pay_group_id NUMBER
69 , p7_a0 out nocopy JTF_NUMBER_TABLE
70 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
71 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
72 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
73 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
74 , p7_a5 out nocopy JTF_NUMBER_TABLE
75 , p7_a6 out nocopy JTF_NUMBER_TABLE
76 , p7_a7 out nocopy JTF_DATE_TABLE
77 , p7_a8 out nocopy JTF_DATE_TABLE
78 , x_total_record out nocopy NUMBER
79 , x_return_status out nocopy VARCHAR2
80 , x_msg_count out nocopy NUMBER
81 , x_msg_data out nocopy VARCHAR2
82 );
83 procedure get_pay_group_sales(p_api_version NUMBER
84 , p_init_msg_list VARCHAR2
85 , p_commit VARCHAR2
86 , p_validation_level NUMBER
87 , p_start_record NUMBER
88 , p_fetch_size NUMBER
89 , p_pay_group_id NUMBER
90 , p7_a0 out nocopy JTF_NUMBER_TABLE
91 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
92 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
93 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
94 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
95 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
96 , p7_a6 out nocopy JTF_DATE_TABLE
97 , p7_a7 out nocopy JTF_DATE_TABLE
98 , x_total_record out nocopy NUMBER
99 , x_return_status out nocopy VARCHAR2
100 , x_msg_count out nocopy NUMBER
101 , x_msg_data out nocopy VARCHAR2
102 );
103 procedure get_pay_group_roles(p_api_version NUMBER
104 , p_init_msg_list VARCHAR2
105 , p_commit VARCHAR2
106 , p_validation_level NUMBER
107 , p_start_record NUMBER
108 , p_fetch_size NUMBER
109 , p_pay_group_id NUMBER
110 , p7_a0 out nocopy JTF_NUMBER_TABLE
111 , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
112 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
113 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
114 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
115 , p7_a5 out nocopy JTF_NUMBER_TABLE
116 , p7_a6 out nocopy JTF_DATE_TABLE
117 , p7_a7 out nocopy JTF_DATE_TABLE
118 , x_total_record out nocopy NUMBER
119 , x_return_status out nocopy VARCHAR2
120 , x_msg_count out nocopy NUMBER
121 , x_msg_data out nocopy VARCHAR2
122 );
123 end cn_pay_group_dtls_pvt_w;