APPS.CN_RT_QUOTA_ASGN_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package cn_rt_quota_asgn_pvt_w as
2: /* $Header: cnwrtqas.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );

Line 7: , a1 out nocopy JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t cn_rt_quota_asgn_pvt.calc_formulas_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11: , a1 JTF_NUMBER_TABLE

Line 11: , a1 JTF_NUMBER_TABLE

7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_DATE_TABLE

Line 12: , a2 JTF_NUMBER_TABLE

8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_DATE_TABLE
16: , a6 JTF_NUMBER_TABLE

Line 13: , a3 JTF_NUMBER_TABLE

9:
10: procedure rosetta_table_copy_in_p3(t out nocopy cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 JTF_VARCHAR2_TABLE_100
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_DATE_TABLE
16: , a6 JTF_NUMBER_TABLE
17: , a7 JTF_NUMBER_TABLE

Line 16: , a6 JTF_NUMBER_TABLE

12: , a2 JTF_NUMBER_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_DATE_TABLE
16: , a6 JTF_NUMBER_TABLE
17: , a7 JTF_NUMBER_TABLE
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_200

Line 17: , a7 JTF_NUMBER_TABLE

13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_DATE_TABLE
15: , a5 JTF_DATE_TABLE
16: , a6 JTF_NUMBER_TABLE
17: , a7 JTF_NUMBER_TABLE
18: , a8 JTF_VARCHAR2_TABLE_100
19: , a9 JTF_VARCHAR2_TABLE_100
20: , a10 JTF_VARCHAR2_TABLE_200
21: , a11 JTF_VARCHAR2_TABLE_200

Line 35: , a25 JTF_NUMBER_TABLE

31: , a21 JTF_VARCHAR2_TABLE_200
32: , a22 JTF_VARCHAR2_TABLE_200
33: , a23 JTF_VARCHAR2_TABLE_200
34: , a24 JTF_VARCHAR2_TABLE_200
35: , a25 JTF_NUMBER_TABLE
36: , a26 JTF_NUMBER_TABLE
37: , a27 JTF_DATE_TABLE
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_DATE_TABLE

Line 36: , a26 JTF_NUMBER_TABLE

32: , a22 JTF_VARCHAR2_TABLE_200
33: , a23 JTF_VARCHAR2_TABLE_200
34: , a24 JTF_VARCHAR2_TABLE_200
35: , a25 JTF_NUMBER_TABLE
36: , a26 JTF_NUMBER_TABLE
37: , a27 JTF_DATE_TABLE
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_DATE_TABLE
40: , a30 JTF_NUMBER_TABLE

Line 38: , a28 JTF_NUMBER_TABLE

34: , a24 JTF_VARCHAR2_TABLE_200
35: , a25 JTF_NUMBER_TABLE
36: , a26 JTF_NUMBER_TABLE
37: , a27 JTF_DATE_TABLE
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_DATE_TABLE
40: , a30 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a30 JTF_NUMBER_TABLE

36: , a26 JTF_NUMBER_TABLE
37: , a27 JTF_DATE_TABLE
38: , a28 JTF_NUMBER_TABLE
39: , a29 JTF_DATE_TABLE
40: , a30 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE

Line 43: , a1 out nocopy JTF_NUMBER_TABLE

39: , a29 JTF_DATE_TABLE
40: , a30 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE

Line 44: , a2 out nocopy JTF_NUMBER_TABLE

40: , a30 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE

Line 45: , a3 out nocopy JTF_NUMBER_TABLE

41: );
42: procedure rosetta_table_copy_out_p3(t cn_rt_quota_asgn_pvt.rt_quota_asgn_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE

Line 48: , a6 out nocopy JTF_NUMBER_TABLE

44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 49: , a7 out nocopy JTF_NUMBER_TABLE

45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_DATE_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_VARCHAR2_TABLE_100
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_200
53: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 67: , a25 out nocopy JTF_NUMBER_TABLE

63: , a21 out nocopy JTF_VARCHAR2_TABLE_200
64: , a22 out nocopy JTF_VARCHAR2_TABLE_200
65: , a23 out nocopy JTF_VARCHAR2_TABLE_200
66: , a24 out nocopy JTF_VARCHAR2_TABLE_200
67: , a25 out nocopy JTF_NUMBER_TABLE
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_DATE_TABLE
70: , a28 out nocopy JTF_NUMBER_TABLE
71: , a29 out nocopy JTF_DATE_TABLE

Line 68: , a26 out nocopy JTF_NUMBER_TABLE

64: , a22 out nocopy JTF_VARCHAR2_TABLE_200
65: , a23 out nocopy JTF_VARCHAR2_TABLE_200
66: , a24 out nocopy JTF_VARCHAR2_TABLE_200
67: , a25 out nocopy JTF_NUMBER_TABLE
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_DATE_TABLE
70: , a28 out nocopy JTF_NUMBER_TABLE
71: , a29 out nocopy JTF_DATE_TABLE
72: , a30 out nocopy JTF_NUMBER_TABLE

Line 70: , a28 out nocopy JTF_NUMBER_TABLE

66: , a24 out nocopy JTF_VARCHAR2_TABLE_200
67: , a25 out nocopy JTF_NUMBER_TABLE
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_DATE_TABLE
70: , a28 out nocopy JTF_NUMBER_TABLE
71: , a29 out nocopy JTF_DATE_TABLE
72: , a30 out nocopy JTF_NUMBER_TABLE
73: );
74:

Line 72: , a30 out nocopy JTF_NUMBER_TABLE

68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_DATE_TABLE
70: , a28 out nocopy JTF_NUMBER_TABLE
71: , a29 out nocopy JTF_DATE_TABLE
72: , a30 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure create_rate_table_assignment(p_api_version NUMBER
76: , p_init_msg_list VARCHAR2

Line 200: , p7_a1 out nocopy JTF_NUMBER_TABLE

196: , p_type VARCHAR2
197: , p_quota_id NUMBER
198: , p_calc_formula_id NUMBER
199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a1 out nocopy JTF_NUMBER_TABLE
203: , p8_a2 out nocopy JTF_NUMBER_TABLE
204: , p8_a3 out nocopy JTF_NUMBER_TABLE

Line 202: , p8_a1 out nocopy JTF_NUMBER_TABLE

198: , p_calc_formula_id NUMBER
199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a1 out nocopy JTF_NUMBER_TABLE
203: , p8_a2 out nocopy JTF_NUMBER_TABLE
204: , p8_a3 out nocopy JTF_NUMBER_TABLE
205: , p8_a4 out nocopy JTF_DATE_TABLE
206: , p8_a5 out nocopy JTF_DATE_TABLE

Line 203: , p8_a2 out nocopy JTF_NUMBER_TABLE

199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a1 out nocopy JTF_NUMBER_TABLE
203: , p8_a2 out nocopy JTF_NUMBER_TABLE
204: , p8_a3 out nocopy JTF_NUMBER_TABLE
205: , p8_a4 out nocopy JTF_DATE_TABLE
206: , p8_a5 out nocopy JTF_DATE_TABLE
207: , p8_a6 out nocopy JTF_NUMBER_TABLE

Line 204: , p8_a3 out nocopy JTF_NUMBER_TABLE

200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a1 out nocopy JTF_NUMBER_TABLE
203: , p8_a2 out nocopy JTF_NUMBER_TABLE
204: , p8_a3 out nocopy JTF_NUMBER_TABLE
205: , p8_a4 out nocopy JTF_DATE_TABLE
206: , p8_a5 out nocopy JTF_DATE_TABLE
207: , p8_a6 out nocopy JTF_NUMBER_TABLE
208: , p8_a7 out nocopy JTF_NUMBER_TABLE

Line 207: , p8_a6 out nocopy JTF_NUMBER_TABLE

203: , p8_a2 out nocopy JTF_NUMBER_TABLE
204: , p8_a3 out nocopy JTF_NUMBER_TABLE
205: , p8_a4 out nocopy JTF_DATE_TABLE
206: , p8_a5 out nocopy JTF_DATE_TABLE
207: , p8_a6 out nocopy JTF_NUMBER_TABLE
208: , p8_a7 out nocopy JTF_NUMBER_TABLE
209: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
210: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 208: , p8_a7 out nocopy JTF_NUMBER_TABLE

204: , p8_a3 out nocopy JTF_NUMBER_TABLE
205: , p8_a4 out nocopy JTF_DATE_TABLE
206: , p8_a5 out nocopy JTF_DATE_TABLE
207: , p8_a6 out nocopy JTF_NUMBER_TABLE
208: , p8_a7 out nocopy JTF_NUMBER_TABLE
209: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
210: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
211: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_200
212: , p8_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 226: , p8_a25 out nocopy JTF_NUMBER_TABLE

222: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_200
223: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
224: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
225: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
226: , p8_a25 out nocopy JTF_NUMBER_TABLE
227: , p8_a26 out nocopy JTF_NUMBER_TABLE
228: , p8_a27 out nocopy JTF_DATE_TABLE
229: , p8_a28 out nocopy JTF_NUMBER_TABLE
230: , p8_a29 out nocopy JTF_DATE_TABLE

Line 227: , p8_a26 out nocopy JTF_NUMBER_TABLE

223: , p8_a22 out nocopy JTF_VARCHAR2_TABLE_200
224: , p8_a23 out nocopy JTF_VARCHAR2_TABLE_200
225: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
226: , p8_a25 out nocopy JTF_NUMBER_TABLE
227: , p8_a26 out nocopy JTF_NUMBER_TABLE
228: , p8_a27 out nocopy JTF_DATE_TABLE
229: , p8_a28 out nocopy JTF_NUMBER_TABLE
230: , p8_a29 out nocopy JTF_DATE_TABLE
231: , p8_a30 out nocopy JTF_NUMBER_TABLE

Line 229: , p8_a28 out nocopy JTF_NUMBER_TABLE

225: , p8_a24 out nocopy JTF_VARCHAR2_TABLE_200
226: , p8_a25 out nocopy JTF_NUMBER_TABLE
227: , p8_a26 out nocopy JTF_NUMBER_TABLE
228: , p8_a27 out nocopy JTF_DATE_TABLE
229: , p8_a28 out nocopy JTF_NUMBER_TABLE
230: , p8_a29 out nocopy JTF_DATE_TABLE
231: , p8_a30 out nocopy JTF_NUMBER_TABLE
232: , x_return_status out nocopy VARCHAR2
233: , x_msg_count out nocopy NUMBER

Line 231: , p8_a30 out nocopy JTF_NUMBER_TABLE

227: , p8_a26 out nocopy JTF_NUMBER_TABLE
228: , p8_a27 out nocopy JTF_DATE_TABLE
229: , p8_a28 out nocopy JTF_NUMBER_TABLE
230: , p8_a29 out nocopy JTF_DATE_TABLE
231: , p8_a30 out nocopy JTF_NUMBER_TABLE
232: , x_return_status out nocopy VARCHAR2
233: , x_msg_count out nocopy NUMBER
234: , x_msg_data out nocopy VARCHAR2
235: );