DBA Data[Home] [Help]

APPS.OKL_CNTR_GRP_BILLING_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p14(t out nocopy okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_cntr_grp_billing_pvt_w as
2: /* $Header: OKLICLBS.pls 120.3 2008/02/21 13:24:51 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_200

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_cntr_grp_billing_pvt_w as
2: /* $Header: OKLICLBS.pls 120.3 2008/02/21 13:24:51 udhenuko noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_VARCHAR2_TABLE_200
20: , a2 out nocopy JTF_NUMBER_TABLE

Line 18: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_VARCHAR2_TABLE_200
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_VARCHAR2_TABLE_100
22: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 20: , a2 out nocopy JTF_NUMBER_TABLE

16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p14(t okl_cntr_grp_billing_pvt.cntr_bill_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_VARCHAR2_TABLE_200
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_VARCHAR2_TABLE_100
22: , a4 out nocopy JTF_VARCHAR2_TABLE_200
23: , a5 out nocopy JTF_VARCHAR2_TABLE_200
24: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: , a10 out nocopy JTF_NUMBER_TABLE

24: , a6 out nocopy JTF_VARCHAR2_TABLE_100
25: , a7 out nocopy JTF_VARCHAR2_TABLE_100
26: , a8 out nocopy JTF_DATE_TABLE
27: , a9 out nocopy JTF_DATE_TABLE
28: , a10 out nocopy JTF_NUMBER_TABLE
29: , a11 out nocopy JTF_DATE_TABLE
30: , a12 out nocopy JTF_NUMBER_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );

Line 30: , a12 out nocopy JTF_NUMBER_TABLE

26: , a8 out nocopy JTF_DATE_TABLE
27: , a9 out nocopy JTF_DATE_TABLE
28: , a10 out nocopy JTF_NUMBER_TABLE
29: , a11 out nocopy JTF_DATE_TABLE
30: , a12 out nocopy JTF_NUMBER_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure counter_grp_billing_calc(p_api_version NUMBER

Line 31: , a13 out nocopy JTF_NUMBER_TABLE

27: , a9 out nocopy JTF_DATE_TABLE
28: , a10 out nocopy JTF_NUMBER_TABLE
29: , a11 out nocopy JTF_DATE_TABLE
30: , a12 out nocopy JTF_NUMBER_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure counter_grp_billing_calc(p_api_version NUMBER
35: , p_init_msg_list VARCHAR2

Line 73: , p5_a0 JTF_NUMBER_TABLE

69: , p_init_msg_list VARCHAR2
70: , x_return_status out nocopy VARCHAR2
71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p5_a0 JTF_NUMBER_TABLE
74: , p5_a1 JTF_VARCHAR2_TABLE_200
75: , p5_a2 JTF_NUMBER_TABLE
76: , p5_a3 JTF_VARCHAR2_TABLE_100
77: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 75: , p5_a2 JTF_NUMBER_TABLE

71: , x_msg_count out nocopy NUMBER
72: , x_msg_data out nocopy VARCHAR2
73: , p5_a0 JTF_NUMBER_TABLE
74: , p5_a1 JTF_VARCHAR2_TABLE_200
75: , p5_a2 JTF_NUMBER_TABLE
76: , p5_a3 JTF_VARCHAR2_TABLE_100
77: , p5_a4 JTF_VARCHAR2_TABLE_200
78: , p5_a5 JTF_VARCHAR2_TABLE_200
79: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 83: , p5_a10 JTF_NUMBER_TABLE

79: , p5_a6 JTF_VARCHAR2_TABLE_100
80: , p5_a7 JTF_VARCHAR2_TABLE_100
81: , p5_a8 JTF_DATE_TABLE
82: , p5_a9 JTF_DATE_TABLE
83: , p5_a10 JTF_NUMBER_TABLE
84: , p5_a11 JTF_DATE_TABLE
85: , p5_a12 JTF_NUMBER_TABLE
86: , p5_a13 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 85: , p5_a12 JTF_NUMBER_TABLE

81: , p5_a8 JTF_DATE_TABLE
82: , p5_a9 JTF_DATE_TABLE
83: , p5_a10 JTF_NUMBER_TABLE
84: , p5_a11 JTF_DATE_TABLE
85: , p5_a12 JTF_NUMBER_TABLE
86: , p5_a13 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_NUMBER_TABLE
88: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
89: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 86: , p5_a13 JTF_NUMBER_TABLE

82: , p5_a9 JTF_DATE_TABLE
83: , p5_a10 JTF_NUMBER_TABLE
84: , p5_a11 JTF_DATE_TABLE
85: , p5_a12 JTF_NUMBER_TABLE
86: , p5_a13 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_NUMBER_TABLE
88: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
89: , p6_a2 out nocopy JTF_NUMBER_TABLE
90: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 87: , p6_a0 out nocopy JTF_NUMBER_TABLE

83: , p5_a10 JTF_NUMBER_TABLE
84: , p5_a11 JTF_DATE_TABLE
85: , p5_a12 JTF_NUMBER_TABLE
86: , p5_a13 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_NUMBER_TABLE
88: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
89: , p6_a2 out nocopy JTF_NUMBER_TABLE
90: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
91: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 89: , p6_a2 out nocopy JTF_NUMBER_TABLE

85: , p5_a12 JTF_NUMBER_TABLE
86: , p5_a13 JTF_NUMBER_TABLE
87: , p6_a0 out nocopy JTF_NUMBER_TABLE
88: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
89: , p6_a2 out nocopy JTF_NUMBER_TABLE
90: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
91: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
92: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
93: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , p6_a10 out nocopy JTF_NUMBER_TABLE

93: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
94: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
95: , p6_a8 out nocopy JTF_DATE_TABLE
96: , p6_a9 out nocopy JTF_DATE_TABLE
97: , p6_a10 out nocopy JTF_NUMBER_TABLE
98: , p6_a11 out nocopy JTF_DATE_TABLE
99: , p6_a12 out nocopy JTF_NUMBER_TABLE
100: , p6_a13 out nocopy JTF_NUMBER_TABLE
101: );

Line 99: , p6_a12 out nocopy JTF_NUMBER_TABLE

95: , p6_a8 out nocopy JTF_DATE_TABLE
96: , p6_a9 out nocopy JTF_DATE_TABLE
97: , p6_a10 out nocopy JTF_NUMBER_TABLE
98: , p6_a11 out nocopy JTF_DATE_TABLE
99: , p6_a12 out nocopy JTF_NUMBER_TABLE
100: , p6_a13 out nocopy JTF_NUMBER_TABLE
101: );
102: procedure counter_grp_billing_insert(p_api_version NUMBER
103: , p_init_msg_list VARCHAR2

Line 100: , p6_a13 out nocopy JTF_NUMBER_TABLE

96: , p6_a9 out nocopy JTF_DATE_TABLE
97: , p6_a10 out nocopy JTF_NUMBER_TABLE
98: , p6_a11 out nocopy JTF_DATE_TABLE
99: , p6_a12 out nocopy JTF_NUMBER_TABLE
100: , p6_a13 out nocopy JTF_NUMBER_TABLE
101: );
102: procedure counter_grp_billing_insert(p_api_version NUMBER
103: , p_init_msg_list VARCHAR2
104: , x_return_status out nocopy VARCHAR2

Line 141: , p5_a0 JTF_NUMBER_TABLE

137: , p_init_msg_list VARCHAR2
138: , x_return_status out nocopy VARCHAR2
139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_200
143: , p5_a2 JTF_NUMBER_TABLE
144: , p5_a3 JTF_VARCHAR2_TABLE_100
145: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 143: , p5_a2 JTF_NUMBER_TABLE

139: , x_msg_count out nocopy NUMBER
140: , x_msg_data out nocopy VARCHAR2
141: , p5_a0 JTF_NUMBER_TABLE
142: , p5_a1 JTF_VARCHAR2_TABLE_200
143: , p5_a2 JTF_NUMBER_TABLE
144: , p5_a3 JTF_VARCHAR2_TABLE_100
145: , p5_a4 JTF_VARCHAR2_TABLE_200
146: , p5_a5 JTF_VARCHAR2_TABLE_200
147: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 151: , p5_a10 JTF_NUMBER_TABLE

147: , p5_a6 JTF_VARCHAR2_TABLE_100
148: , p5_a7 JTF_VARCHAR2_TABLE_100
149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p5_a11 JTF_DATE_TABLE
153: , p5_a12 JTF_NUMBER_TABLE
154: , p5_a13 JTF_NUMBER_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 153: , p5_a12 JTF_NUMBER_TABLE

149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p5_a11 JTF_DATE_TABLE
153: , p5_a12 JTF_NUMBER_TABLE
154: , p5_a13 JTF_NUMBER_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
157: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 154: , p5_a13 JTF_NUMBER_TABLE

150: , p5_a9 JTF_DATE_TABLE
151: , p5_a10 JTF_NUMBER_TABLE
152: , p5_a11 JTF_DATE_TABLE
153: , p5_a12 JTF_NUMBER_TABLE
154: , p5_a13 JTF_NUMBER_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
157: , p6_a2 out nocopy JTF_NUMBER_TABLE
158: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 155: , p6_a0 out nocopy JTF_NUMBER_TABLE

151: , p5_a10 JTF_NUMBER_TABLE
152: , p5_a11 JTF_DATE_TABLE
153: , p5_a12 JTF_NUMBER_TABLE
154: , p5_a13 JTF_NUMBER_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
157: , p6_a2 out nocopy JTF_NUMBER_TABLE
158: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 157: , p6_a2 out nocopy JTF_NUMBER_TABLE

153: , p5_a12 JTF_NUMBER_TABLE
154: , p5_a13 JTF_NUMBER_TABLE
155: , p6_a0 out nocopy JTF_NUMBER_TABLE
156: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
157: , p6_a2 out nocopy JTF_NUMBER_TABLE
158: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
159: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
160: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
161: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 165: , p6_a10 out nocopy JTF_NUMBER_TABLE

161: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_NUMBER_TABLE
166: , p6_a11 out nocopy JTF_DATE_TABLE
167: , p6_a12 out nocopy JTF_NUMBER_TABLE
168: , p6_a13 out nocopy JTF_NUMBER_TABLE
169: );

Line 167: , p6_a12 out nocopy JTF_NUMBER_TABLE

163: , p6_a8 out nocopy JTF_DATE_TABLE
164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_NUMBER_TABLE
166: , p6_a11 out nocopy JTF_DATE_TABLE
167: , p6_a12 out nocopy JTF_NUMBER_TABLE
168: , p6_a13 out nocopy JTF_NUMBER_TABLE
169: );
170: end okl_cntr_grp_billing_pvt_w;

Line 168: , p6_a13 out nocopy JTF_NUMBER_TABLE

164: , p6_a9 out nocopy JTF_DATE_TABLE
165: , p6_a10 out nocopy JTF_NUMBER_TABLE
166: , p6_a11 out nocopy JTF_DATE_TABLE
167: , p6_a12 out nocopy JTF_NUMBER_TABLE
168: , p6_a13 out nocopy JTF_NUMBER_TABLE
169: );
170: end okl_cntr_grp_billing_pvt_w;