APPS.OKL_RGRP_RULES_PROCESS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package okl_rgrp_rules_process_pvt_w as
2: /* $Header: OKLERGRS.pls 120.1 2005/07/11 14:20:19 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLERGRS.pls 120.1 2005/07/11 14:20:19 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_2000
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_500

Line 21: , a18 JTF_VARCHAR2_TABLE_100

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_2000
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_2000
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500

Line 43: , a40 JTF_VARCHAR2_TABLE_100

39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_500
45: , a42 JTF_VARCHAR2_TABLE_500
46: , a43 JTF_VARCHAR2_TABLE_500
47: , a44 JTF_VARCHAR2_TABLE_500

Line 59: , a56 JTF_VARCHAR2_TABLE_100

55: , a52 JTF_VARCHAR2_TABLE_500
56: , a53 JTF_VARCHAR2_TABLE_500
57: , a54 JTF_VARCHAR2_TABLE_500
58: , a55 JTF_VARCHAR2_TABLE_500
59: , a56 JTF_VARCHAR2_TABLE_100
60: , a57 JTF_VARCHAR2_TABLE_100
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_VARCHAR2_TABLE_100
63: , a60 JTF_NUMBER_TABLE

Line 60: , a57 JTF_VARCHAR2_TABLE_100

56: , a53 JTF_VARCHAR2_TABLE_500
57: , a54 JTF_VARCHAR2_TABLE_500
58: , a55 JTF_VARCHAR2_TABLE_500
59: , a56 JTF_VARCHAR2_TABLE_100
60: , a57 JTF_VARCHAR2_TABLE_100
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_VARCHAR2_TABLE_100
63: , a60 JTF_NUMBER_TABLE
64: );

Line 61: , a58 JTF_VARCHAR2_TABLE_100

57: , a54 JTF_VARCHAR2_TABLE_500
58: , a55 JTF_VARCHAR2_TABLE_500
59: , a56 JTF_VARCHAR2_TABLE_100
60: , a57 JTF_VARCHAR2_TABLE_100
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_VARCHAR2_TABLE_100
63: , a60 JTF_NUMBER_TABLE
64: );
65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a59 JTF_VARCHAR2_TABLE_100

58: , a55 JTF_VARCHAR2_TABLE_500
59: , a56 JTF_VARCHAR2_TABLE_100
60: , a57 JTF_VARCHAR2_TABLE_100
61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_VARCHAR2_TABLE_100
63: , a60 JTF_NUMBER_TABLE
64: );
65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
66: , a1 out nocopy JTF_NUMBER_TABLE

Line 65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

61: , a58 JTF_VARCHAR2_TABLE_100
62: , a59 JTF_VARCHAR2_TABLE_100
63: , a60 JTF_NUMBER_TABLE
64: );
65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , a3 out nocopy JTF_VARCHAR2_TABLE_100

64: );
65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_100
72: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a4 out nocopy JTF_VARCHAR2_TABLE_100

65: procedure rosetta_table_copy_out_p2(t okl_rgrp_rules_process_pvt.rgr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_100
72: , a7 out nocopy JTF_VARCHAR2_TABLE_200
73: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 70: , a5 out nocopy JTF_VARCHAR2_TABLE_100

66: , a1 out nocopy JTF_NUMBER_TABLE
67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_100
72: , a7 out nocopy JTF_VARCHAR2_TABLE_200
73: , a8 out nocopy JTF_VARCHAR2_TABLE_200
74: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 71: , a6 out nocopy JTF_VARCHAR2_TABLE_100

67: , a2 out nocopy JTF_NUMBER_TABLE
68: , a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , a4 out nocopy JTF_VARCHAR2_TABLE_100
70: , a5 out nocopy JTF_VARCHAR2_TABLE_100
71: , a6 out nocopy JTF_VARCHAR2_TABLE_100
72: , a7 out nocopy JTF_VARCHAR2_TABLE_200
73: , a8 out nocopy JTF_VARCHAR2_TABLE_200
74: , a9 out nocopy JTF_VARCHAR2_TABLE_200
75: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , a10 out nocopy JTF_VARCHAR2_TABLE_100

71: , a6 out nocopy JTF_VARCHAR2_TABLE_100
72: , a7 out nocopy JTF_VARCHAR2_TABLE_200
73: , a8 out nocopy JTF_VARCHAR2_TABLE_200
74: , a9 out nocopy JTF_VARCHAR2_TABLE_200
75: , a10 out nocopy JTF_VARCHAR2_TABLE_100
76: , a11 out nocopy JTF_VARCHAR2_TABLE_100
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , a13 out nocopy JTF_NUMBER_TABLE
79: , a14 out nocopy JTF_NUMBER_TABLE

Line 76: , a11 out nocopy JTF_VARCHAR2_TABLE_100

72: , a7 out nocopy JTF_VARCHAR2_TABLE_200
73: , a8 out nocopy JTF_VARCHAR2_TABLE_200
74: , a9 out nocopy JTF_VARCHAR2_TABLE_200
75: , a10 out nocopy JTF_VARCHAR2_TABLE_100
76: , a11 out nocopy JTF_VARCHAR2_TABLE_100
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , a13 out nocopy JTF_NUMBER_TABLE
79: , a14 out nocopy JTF_NUMBER_TABLE
80: , a15 out nocopy JTF_NUMBER_TABLE

Line 77: , a12 out nocopy JTF_VARCHAR2_TABLE_100

73: , a8 out nocopy JTF_VARCHAR2_TABLE_200
74: , a9 out nocopy JTF_VARCHAR2_TABLE_200
75: , a10 out nocopy JTF_VARCHAR2_TABLE_100
76: , a11 out nocopy JTF_VARCHAR2_TABLE_100
77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , a13 out nocopy JTF_NUMBER_TABLE
79: , a14 out nocopy JTF_NUMBER_TABLE
80: , a15 out nocopy JTF_NUMBER_TABLE
81: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 81: , a16 out nocopy JTF_VARCHAR2_TABLE_100

77: , a12 out nocopy JTF_VARCHAR2_TABLE_100
78: , a13 out nocopy JTF_NUMBER_TABLE
79: , a14 out nocopy JTF_NUMBER_TABLE
80: , a15 out nocopy JTF_NUMBER_TABLE
81: , a16 out nocopy JTF_VARCHAR2_TABLE_100
82: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a18 out nocopy JTF_VARCHAR2_TABLE_100
84: , a19 out nocopy JTF_VARCHAR2_TABLE_100
85: , a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 83: , a18 out nocopy JTF_VARCHAR2_TABLE_100

79: , a14 out nocopy JTF_NUMBER_TABLE
80: , a15 out nocopy JTF_NUMBER_TABLE
81: , a16 out nocopy JTF_VARCHAR2_TABLE_100
82: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a18 out nocopy JTF_VARCHAR2_TABLE_100
84: , a19 out nocopy JTF_VARCHAR2_TABLE_100
85: , a20 out nocopy JTF_VARCHAR2_TABLE_500
86: , a21 out nocopy JTF_VARCHAR2_TABLE_500
87: , a22 out nocopy JTF_VARCHAR2_TABLE_500

Line 84: , a19 out nocopy JTF_VARCHAR2_TABLE_100

80: , a15 out nocopy JTF_NUMBER_TABLE
81: , a16 out nocopy JTF_VARCHAR2_TABLE_100
82: , a17 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a18 out nocopy JTF_VARCHAR2_TABLE_100
84: , a19 out nocopy JTF_VARCHAR2_TABLE_100
85: , a20 out nocopy JTF_VARCHAR2_TABLE_500
86: , a21 out nocopy JTF_VARCHAR2_TABLE_500
87: , a22 out nocopy JTF_VARCHAR2_TABLE_500
88: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 105: , a40 out nocopy JTF_VARCHAR2_TABLE_100

101: , a36 out nocopy JTF_DATE_TABLE
102: , a37 out nocopy JTF_NUMBER_TABLE
103: , a38 out nocopy JTF_DATE_TABLE
104: , a39 out nocopy JTF_NUMBER_TABLE
105: , a40 out nocopy JTF_VARCHAR2_TABLE_100
106: , a41 out nocopy JTF_VARCHAR2_TABLE_500
107: , a42 out nocopy JTF_VARCHAR2_TABLE_500
108: , a43 out nocopy JTF_VARCHAR2_TABLE_500
109: , a44 out nocopy JTF_VARCHAR2_TABLE_500

Line 121: , a56 out nocopy JTF_VARCHAR2_TABLE_100

117: , a52 out nocopy JTF_VARCHAR2_TABLE_500
118: , a53 out nocopy JTF_VARCHAR2_TABLE_500
119: , a54 out nocopy JTF_VARCHAR2_TABLE_500
120: , a55 out nocopy JTF_VARCHAR2_TABLE_500
121: , a56 out nocopy JTF_VARCHAR2_TABLE_100
122: , a57 out nocopy JTF_VARCHAR2_TABLE_100
123: , a58 out nocopy JTF_VARCHAR2_TABLE_100
124: , a59 out nocopy JTF_VARCHAR2_TABLE_100
125: , a60 out nocopy JTF_NUMBER_TABLE

Line 122: , a57 out nocopy JTF_VARCHAR2_TABLE_100

118: , a53 out nocopy JTF_VARCHAR2_TABLE_500
119: , a54 out nocopy JTF_VARCHAR2_TABLE_500
120: , a55 out nocopy JTF_VARCHAR2_TABLE_500
121: , a56 out nocopy JTF_VARCHAR2_TABLE_100
122: , a57 out nocopy JTF_VARCHAR2_TABLE_100
123: , a58 out nocopy JTF_VARCHAR2_TABLE_100
124: , a59 out nocopy JTF_VARCHAR2_TABLE_100
125: , a60 out nocopy JTF_NUMBER_TABLE
126: );

Line 123: , a58 out nocopy JTF_VARCHAR2_TABLE_100

119: , a54 out nocopy JTF_VARCHAR2_TABLE_500
120: , a55 out nocopy JTF_VARCHAR2_TABLE_500
121: , a56 out nocopy JTF_VARCHAR2_TABLE_100
122: , a57 out nocopy JTF_VARCHAR2_TABLE_100
123: , a58 out nocopy JTF_VARCHAR2_TABLE_100
124: , a59 out nocopy JTF_VARCHAR2_TABLE_100
125: , a60 out nocopy JTF_NUMBER_TABLE
126: );
127:

Line 124: , a59 out nocopy JTF_VARCHAR2_TABLE_100

120: , a55 out nocopy JTF_VARCHAR2_TABLE_500
121: , a56 out nocopy JTF_VARCHAR2_TABLE_100
122: , a57 out nocopy JTF_VARCHAR2_TABLE_100
123: , a58 out nocopy JTF_VARCHAR2_TABLE_100
124: , a59 out nocopy JTF_VARCHAR2_TABLE_100
125: , a60 out nocopy JTF_NUMBER_TABLE
126: );
127:
128: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE

Line 129: , a1 JTF_VARCHAR2_TABLE_100

125: , a60 out nocopy JTF_NUMBER_TABLE
126: );
127:
128: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 130: , a2 JTF_VARCHAR2_TABLE_100

126: );
127:
128: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , a3 JTF_VARCHAR2_TABLE_100

127:
128: procedure rosetta_table_copy_in_p3(t out nocopy okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 134: , a1 out nocopy JTF_VARCHAR2_TABLE_100

130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , a2 out nocopy JTF_VARCHAR2_TABLE_100
136: , a3 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138:

Line 135: , a2 out nocopy JTF_VARCHAR2_TABLE_100

131: , a3 JTF_VARCHAR2_TABLE_100
132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , a2 out nocopy JTF_VARCHAR2_TABLE_100
136: , a3 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138:
139: procedure process_rule_group_rules(p_api_version NUMBER

Line 136: , a3 out nocopy JTF_VARCHAR2_TABLE_100

132: );
133: procedure rosetta_table_copy_out_p3(t okl_rgrp_rules_process_pvt.rgr_out_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: , a2 out nocopy JTF_VARCHAR2_TABLE_100
136: , a3 out nocopy JTF_VARCHAR2_TABLE_100
137: );
138:
139: procedure process_rule_group_rules(p_api_version NUMBER
140: , p_init_msg_list VARCHAR2

Line 148: , p9_a0 JTF_VARCHAR2_TABLE_100

144: , p_chr_id NUMBER
145: , p_line_id NUMBER
146: , p_cpl_id NUMBER
147: , p_rrd_id NUMBER
148: , p9_a0 JTF_VARCHAR2_TABLE_100
149: , p9_a1 JTF_NUMBER_TABLE
150: , p9_a2 JTF_NUMBER_TABLE
151: , p9_a3 JTF_VARCHAR2_TABLE_100
152: , p9_a4 JTF_VARCHAR2_TABLE_100

Line 151: , p9_a3 JTF_VARCHAR2_TABLE_100

147: , p_rrd_id NUMBER
148: , p9_a0 JTF_VARCHAR2_TABLE_100
149: , p9_a1 JTF_NUMBER_TABLE
150: , p9_a2 JTF_NUMBER_TABLE
151: , p9_a3 JTF_VARCHAR2_TABLE_100
152: , p9_a4 JTF_VARCHAR2_TABLE_100
153: , p9_a5 JTF_VARCHAR2_TABLE_100
154: , p9_a6 JTF_VARCHAR2_TABLE_100
155: , p9_a7 JTF_VARCHAR2_TABLE_200

Line 152: , p9_a4 JTF_VARCHAR2_TABLE_100

148: , p9_a0 JTF_VARCHAR2_TABLE_100
149: , p9_a1 JTF_NUMBER_TABLE
150: , p9_a2 JTF_NUMBER_TABLE
151: , p9_a3 JTF_VARCHAR2_TABLE_100
152: , p9_a4 JTF_VARCHAR2_TABLE_100
153: , p9_a5 JTF_VARCHAR2_TABLE_100
154: , p9_a6 JTF_VARCHAR2_TABLE_100
155: , p9_a7 JTF_VARCHAR2_TABLE_200
156: , p9_a8 JTF_VARCHAR2_TABLE_200

Line 153: , p9_a5 JTF_VARCHAR2_TABLE_100

149: , p9_a1 JTF_NUMBER_TABLE
150: , p9_a2 JTF_NUMBER_TABLE
151: , p9_a3 JTF_VARCHAR2_TABLE_100
152: , p9_a4 JTF_VARCHAR2_TABLE_100
153: , p9_a5 JTF_VARCHAR2_TABLE_100
154: , p9_a6 JTF_VARCHAR2_TABLE_100
155: , p9_a7 JTF_VARCHAR2_TABLE_200
156: , p9_a8 JTF_VARCHAR2_TABLE_200
157: , p9_a9 JTF_VARCHAR2_TABLE_200

Line 154: , p9_a6 JTF_VARCHAR2_TABLE_100

150: , p9_a2 JTF_NUMBER_TABLE
151: , p9_a3 JTF_VARCHAR2_TABLE_100
152: , p9_a4 JTF_VARCHAR2_TABLE_100
153: , p9_a5 JTF_VARCHAR2_TABLE_100
154: , p9_a6 JTF_VARCHAR2_TABLE_100
155: , p9_a7 JTF_VARCHAR2_TABLE_200
156: , p9_a8 JTF_VARCHAR2_TABLE_200
157: , p9_a9 JTF_VARCHAR2_TABLE_200
158: , p9_a10 JTF_VARCHAR2_TABLE_100

Line 158: , p9_a10 JTF_VARCHAR2_TABLE_100

154: , p9_a6 JTF_VARCHAR2_TABLE_100
155: , p9_a7 JTF_VARCHAR2_TABLE_200
156: , p9_a8 JTF_VARCHAR2_TABLE_200
157: , p9_a9 JTF_VARCHAR2_TABLE_200
158: , p9_a10 JTF_VARCHAR2_TABLE_100
159: , p9_a11 JTF_VARCHAR2_TABLE_100
160: , p9_a12 JTF_VARCHAR2_TABLE_100
161: , p9_a13 JTF_NUMBER_TABLE
162: , p9_a14 JTF_NUMBER_TABLE

Line 159: , p9_a11 JTF_VARCHAR2_TABLE_100

155: , p9_a7 JTF_VARCHAR2_TABLE_200
156: , p9_a8 JTF_VARCHAR2_TABLE_200
157: , p9_a9 JTF_VARCHAR2_TABLE_200
158: , p9_a10 JTF_VARCHAR2_TABLE_100
159: , p9_a11 JTF_VARCHAR2_TABLE_100
160: , p9_a12 JTF_VARCHAR2_TABLE_100
161: , p9_a13 JTF_NUMBER_TABLE
162: , p9_a14 JTF_NUMBER_TABLE
163: , p9_a15 JTF_NUMBER_TABLE

Line 160: , p9_a12 JTF_VARCHAR2_TABLE_100

156: , p9_a8 JTF_VARCHAR2_TABLE_200
157: , p9_a9 JTF_VARCHAR2_TABLE_200
158: , p9_a10 JTF_VARCHAR2_TABLE_100
159: , p9_a11 JTF_VARCHAR2_TABLE_100
160: , p9_a12 JTF_VARCHAR2_TABLE_100
161: , p9_a13 JTF_NUMBER_TABLE
162: , p9_a14 JTF_NUMBER_TABLE
163: , p9_a15 JTF_NUMBER_TABLE
164: , p9_a16 JTF_VARCHAR2_TABLE_100

Line 164: , p9_a16 JTF_VARCHAR2_TABLE_100

160: , p9_a12 JTF_VARCHAR2_TABLE_100
161: , p9_a13 JTF_NUMBER_TABLE
162: , p9_a14 JTF_NUMBER_TABLE
163: , p9_a15 JTF_NUMBER_TABLE
164: , p9_a16 JTF_VARCHAR2_TABLE_100
165: , p9_a17 JTF_VARCHAR2_TABLE_2000
166: , p9_a18 JTF_VARCHAR2_TABLE_100
167: , p9_a19 JTF_VARCHAR2_TABLE_100
168: , p9_a20 JTF_VARCHAR2_TABLE_500

Line 166: , p9_a18 JTF_VARCHAR2_TABLE_100

162: , p9_a14 JTF_NUMBER_TABLE
163: , p9_a15 JTF_NUMBER_TABLE
164: , p9_a16 JTF_VARCHAR2_TABLE_100
165: , p9_a17 JTF_VARCHAR2_TABLE_2000
166: , p9_a18 JTF_VARCHAR2_TABLE_100
167: , p9_a19 JTF_VARCHAR2_TABLE_100
168: , p9_a20 JTF_VARCHAR2_TABLE_500
169: , p9_a21 JTF_VARCHAR2_TABLE_500
170: , p9_a22 JTF_VARCHAR2_TABLE_500

Line 167: , p9_a19 JTF_VARCHAR2_TABLE_100

163: , p9_a15 JTF_NUMBER_TABLE
164: , p9_a16 JTF_VARCHAR2_TABLE_100
165: , p9_a17 JTF_VARCHAR2_TABLE_2000
166: , p9_a18 JTF_VARCHAR2_TABLE_100
167: , p9_a19 JTF_VARCHAR2_TABLE_100
168: , p9_a20 JTF_VARCHAR2_TABLE_500
169: , p9_a21 JTF_VARCHAR2_TABLE_500
170: , p9_a22 JTF_VARCHAR2_TABLE_500
171: , p9_a23 JTF_VARCHAR2_TABLE_500

Line 188: , p9_a40 JTF_VARCHAR2_TABLE_100

184: , p9_a36 JTF_DATE_TABLE
185: , p9_a37 JTF_NUMBER_TABLE
186: , p9_a38 JTF_DATE_TABLE
187: , p9_a39 JTF_NUMBER_TABLE
188: , p9_a40 JTF_VARCHAR2_TABLE_100
189: , p9_a41 JTF_VARCHAR2_TABLE_500
190: , p9_a42 JTF_VARCHAR2_TABLE_500
191: , p9_a43 JTF_VARCHAR2_TABLE_500
192: , p9_a44 JTF_VARCHAR2_TABLE_500

Line 204: , p9_a56 JTF_VARCHAR2_TABLE_100

200: , p9_a52 JTF_VARCHAR2_TABLE_500
201: , p9_a53 JTF_VARCHAR2_TABLE_500
202: , p9_a54 JTF_VARCHAR2_TABLE_500
203: , p9_a55 JTF_VARCHAR2_TABLE_500
204: , p9_a56 JTF_VARCHAR2_TABLE_100
205: , p9_a57 JTF_VARCHAR2_TABLE_100
206: , p9_a58 JTF_VARCHAR2_TABLE_100
207: , p9_a59 JTF_VARCHAR2_TABLE_100
208: , p9_a60 JTF_NUMBER_TABLE

Line 205: , p9_a57 JTF_VARCHAR2_TABLE_100

201: , p9_a53 JTF_VARCHAR2_TABLE_500
202: , p9_a54 JTF_VARCHAR2_TABLE_500
203: , p9_a55 JTF_VARCHAR2_TABLE_500
204: , p9_a56 JTF_VARCHAR2_TABLE_100
205: , p9_a57 JTF_VARCHAR2_TABLE_100
206: , p9_a58 JTF_VARCHAR2_TABLE_100
207: , p9_a59 JTF_VARCHAR2_TABLE_100
208: , p9_a60 JTF_NUMBER_TABLE
209: );

Line 206: , p9_a58 JTF_VARCHAR2_TABLE_100

202: , p9_a54 JTF_VARCHAR2_TABLE_500
203: , p9_a55 JTF_VARCHAR2_TABLE_500
204: , p9_a56 JTF_VARCHAR2_TABLE_100
205: , p9_a57 JTF_VARCHAR2_TABLE_100
206: , p9_a58 JTF_VARCHAR2_TABLE_100
207: , p9_a59 JTF_VARCHAR2_TABLE_100
208: , p9_a60 JTF_NUMBER_TABLE
209: );
210: procedure process_template_rules(p_api_version NUMBER

Line 207: , p9_a59 JTF_VARCHAR2_TABLE_100

203: , p9_a55 JTF_VARCHAR2_TABLE_500
204: , p9_a56 JTF_VARCHAR2_TABLE_100
205: , p9_a57 JTF_VARCHAR2_TABLE_100
206: , p9_a58 JTF_VARCHAR2_TABLE_100
207: , p9_a59 JTF_VARCHAR2_TABLE_100
208: , p9_a60 JTF_NUMBER_TABLE
209: );
210: procedure process_template_rules(p_api_version NUMBER
211: , p_init_msg_list VARCHAR2

Line 216: , p6_a0 JTF_VARCHAR2_TABLE_100

212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p_id NUMBER
216: , p6_a0 JTF_VARCHAR2_TABLE_100
217: , p6_a1 JTF_NUMBER_TABLE
218: , p6_a2 JTF_NUMBER_TABLE
219: , p6_a3 JTF_VARCHAR2_TABLE_100
220: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 219: , p6_a3 JTF_VARCHAR2_TABLE_100

215: , p_id NUMBER
216: , p6_a0 JTF_VARCHAR2_TABLE_100
217: , p6_a1 JTF_NUMBER_TABLE
218: , p6_a2 JTF_NUMBER_TABLE
219: , p6_a3 JTF_VARCHAR2_TABLE_100
220: , p6_a4 JTF_VARCHAR2_TABLE_100
221: , p6_a5 JTF_VARCHAR2_TABLE_100
222: , p6_a6 JTF_VARCHAR2_TABLE_100
223: , p6_a7 JTF_VARCHAR2_TABLE_200

Line 220: , p6_a4 JTF_VARCHAR2_TABLE_100

216: , p6_a0 JTF_VARCHAR2_TABLE_100
217: , p6_a1 JTF_NUMBER_TABLE
218: , p6_a2 JTF_NUMBER_TABLE
219: , p6_a3 JTF_VARCHAR2_TABLE_100
220: , p6_a4 JTF_VARCHAR2_TABLE_100
221: , p6_a5 JTF_VARCHAR2_TABLE_100
222: , p6_a6 JTF_VARCHAR2_TABLE_100
223: , p6_a7 JTF_VARCHAR2_TABLE_200
224: , p6_a8 JTF_VARCHAR2_TABLE_200

Line 221: , p6_a5 JTF_VARCHAR2_TABLE_100

217: , p6_a1 JTF_NUMBER_TABLE
218: , p6_a2 JTF_NUMBER_TABLE
219: , p6_a3 JTF_VARCHAR2_TABLE_100
220: , p6_a4 JTF_VARCHAR2_TABLE_100
221: , p6_a5 JTF_VARCHAR2_TABLE_100
222: , p6_a6 JTF_VARCHAR2_TABLE_100
223: , p6_a7 JTF_VARCHAR2_TABLE_200
224: , p6_a8 JTF_VARCHAR2_TABLE_200
225: , p6_a9 JTF_VARCHAR2_TABLE_200

Line 222: , p6_a6 JTF_VARCHAR2_TABLE_100

218: , p6_a2 JTF_NUMBER_TABLE
219: , p6_a3 JTF_VARCHAR2_TABLE_100
220: , p6_a4 JTF_VARCHAR2_TABLE_100
221: , p6_a5 JTF_VARCHAR2_TABLE_100
222: , p6_a6 JTF_VARCHAR2_TABLE_100
223: , p6_a7 JTF_VARCHAR2_TABLE_200
224: , p6_a8 JTF_VARCHAR2_TABLE_200
225: , p6_a9 JTF_VARCHAR2_TABLE_200
226: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 226: , p6_a10 JTF_VARCHAR2_TABLE_100

222: , p6_a6 JTF_VARCHAR2_TABLE_100
223: , p6_a7 JTF_VARCHAR2_TABLE_200
224: , p6_a8 JTF_VARCHAR2_TABLE_200
225: , p6_a9 JTF_VARCHAR2_TABLE_200
226: , p6_a10 JTF_VARCHAR2_TABLE_100
227: , p6_a11 JTF_VARCHAR2_TABLE_100
228: , p6_a12 JTF_VARCHAR2_TABLE_100
229: , p6_a13 JTF_NUMBER_TABLE
230: , p6_a14 JTF_NUMBER_TABLE

Line 227: , p6_a11 JTF_VARCHAR2_TABLE_100

223: , p6_a7 JTF_VARCHAR2_TABLE_200
224: , p6_a8 JTF_VARCHAR2_TABLE_200
225: , p6_a9 JTF_VARCHAR2_TABLE_200
226: , p6_a10 JTF_VARCHAR2_TABLE_100
227: , p6_a11 JTF_VARCHAR2_TABLE_100
228: , p6_a12 JTF_VARCHAR2_TABLE_100
229: , p6_a13 JTF_NUMBER_TABLE
230: , p6_a14 JTF_NUMBER_TABLE
231: , p6_a15 JTF_NUMBER_TABLE

Line 228: , p6_a12 JTF_VARCHAR2_TABLE_100

224: , p6_a8 JTF_VARCHAR2_TABLE_200
225: , p6_a9 JTF_VARCHAR2_TABLE_200
226: , p6_a10 JTF_VARCHAR2_TABLE_100
227: , p6_a11 JTF_VARCHAR2_TABLE_100
228: , p6_a12 JTF_VARCHAR2_TABLE_100
229: , p6_a13 JTF_NUMBER_TABLE
230: , p6_a14 JTF_NUMBER_TABLE
231: , p6_a15 JTF_NUMBER_TABLE
232: , p6_a16 JTF_VARCHAR2_TABLE_100

Line 232: , p6_a16 JTF_VARCHAR2_TABLE_100

228: , p6_a12 JTF_VARCHAR2_TABLE_100
229: , p6_a13 JTF_NUMBER_TABLE
230: , p6_a14 JTF_NUMBER_TABLE
231: , p6_a15 JTF_NUMBER_TABLE
232: , p6_a16 JTF_VARCHAR2_TABLE_100
233: , p6_a17 JTF_VARCHAR2_TABLE_2000
234: , p6_a18 JTF_VARCHAR2_TABLE_100
235: , p6_a19 JTF_VARCHAR2_TABLE_100
236: , p6_a20 JTF_VARCHAR2_TABLE_500

Line 234: , p6_a18 JTF_VARCHAR2_TABLE_100

230: , p6_a14 JTF_NUMBER_TABLE
231: , p6_a15 JTF_NUMBER_TABLE
232: , p6_a16 JTF_VARCHAR2_TABLE_100
233: , p6_a17 JTF_VARCHAR2_TABLE_2000
234: , p6_a18 JTF_VARCHAR2_TABLE_100
235: , p6_a19 JTF_VARCHAR2_TABLE_100
236: , p6_a20 JTF_VARCHAR2_TABLE_500
237: , p6_a21 JTF_VARCHAR2_TABLE_500
238: , p6_a22 JTF_VARCHAR2_TABLE_500

Line 235: , p6_a19 JTF_VARCHAR2_TABLE_100

231: , p6_a15 JTF_NUMBER_TABLE
232: , p6_a16 JTF_VARCHAR2_TABLE_100
233: , p6_a17 JTF_VARCHAR2_TABLE_2000
234: , p6_a18 JTF_VARCHAR2_TABLE_100
235: , p6_a19 JTF_VARCHAR2_TABLE_100
236: , p6_a20 JTF_VARCHAR2_TABLE_500
237: , p6_a21 JTF_VARCHAR2_TABLE_500
238: , p6_a22 JTF_VARCHAR2_TABLE_500
239: , p6_a23 JTF_VARCHAR2_TABLE_500

Line 256: , p6_a40 JTF_VARCHAR2_TABLE_100

252: , p6_a36 JTF_DATE_TABLE
253: , p6_a37 JTF_NUMBER_TABLE
254: , p6_a38 JTF_DATE_TABLE
255: , p6_a39 JTF_NUMBER_TABLE
256: , p6_a40 JTF_VARCHAR2_TABLE_100
257: , p6_a41 JTF_VARCHAR2_TABLE_500
258: , p6_a42 JTF_VARCHAR2_TABLE_500
259: , p6_a43 JTF_VARCHAR2_TABLE_500
260: , p6_a44 JTF_VARCHAR2_TABLE_500

Line 272: , p6_a56 JTF_VARCHAR2_TABLE_100

268: , p6_a52 JTF_VARCHAR2_TABLE_500
269: , p6_a53 JTF_VARCHAR2_TABLE_500
270: , p6_a54 JTF_VARCHAR2_TABLE_500
271: , p6_a55 JTF_VARCHAR2_TABLE_500
272: , p6_a56 JTF_VARCHAR2_TABLE_100
273: , p6_a57 JTF_VARCHAR2_TABLE_100
274: , p6_a58 JTF_VARCHAR2_TABLE_100
275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE

Line 273: , p6_a57 JTF_VARCHAR2_TABLE_100

269: , p6_a53 JTF_VARCHAR2_TABLE_500
270: , p6_a54 JTF_VARCHAR2_TABLE_500
271: , p6_a55 JTF_VARCHAR2_TABLE_500
272: , p6_a56 JTF_VARCHAR2_TABLE_100
273: , p6_a57 JTF_VARCHAR2_TABLE_100
274: , p6_a58 JTF_VARCHAR2_TABLE_100
275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 274: , p6_a58 JTF_VARCHAR2_TABLE_100

270: , p6_a54 JTF_VARCHAR2_TABLE_500
271: , p6_a55 JTF_VARCHAR2_TABLE_500
272: , p6_a56 JTF_VARCHAR2_TABLE_100
273: , p6_a57 JTF_VARCHAR2_TABLE_100
274: , p6_a58 JTF_VARCHAR2_TABLE_100
275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE
278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 275: , p6_a59 JTF_VARCHAR2_TABLE_100

271: , p6_a55 JTF_VARCHAR2_TABLE_500
272: , p6_a56 JTF_VARCHAR2_TABLE_100
273: , p6_a57 JTF_VARCHAR2_TABLE_100
274: , p6_a58 JTF_VARCHAR2_TABLE_100
275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE
278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
279: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

274: , p6_a58 JTF_VARCHAR2_TABLE_100
275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE
278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
279: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
281: );
282: end okl_rgrp_rules_process_pvt_w;

Line 279: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

275: , p6_a59 JTF_VARCHAR2_TABLE_100
276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE
278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
279: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
281: );
282: end okl_rgrp_rules_process_pvt_w;

Line 280: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

276: , p6_a60 JTF_NUMBER_TABLE
277: , p7_a0 out nocopy JTF_NUMBER_TABLE
278: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
279: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
281: );
282: end okl_rgrp_rules_process_pvt_w;