DBA Data[Home] [Help]

APPS.OKL_RGRP_RULES_PROCESS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 13: , p9_a1 JTF_NUMBER_TABLE

9: , p_line_id NUMBER
10: , p_cpl_id NUMBER
11: , p_rrd_id NUMBER
12: , p9_a0 JTF_VARCHAR2_TABLE_100
13: , p9_a1 JTF_NUMBER_TABLE
14: , p9_a2 JTF_NUMBER_TABLE
15: , p9_a3 JTF_VARCHAR2_TABLE_100
16: , p9_a4 JTF_VARCHAR2_TABLE_100
17: , p9_a5 JTF_VARCHAR2_TABLE_100

Line 14: , p9_a2 JTF_NUMBER_TABLE

10: , p_cpl_id NUMBER
11: , p_rrd_id NUMBER
12: , p9_a0 JTF_VARCHAR2_TABLE_100
13: , p9_a1 JTF_NUMBER_TABLE
14: , p9_a2 JTF_NUMBER_TABLE
15: , p9_a3 JTF_VARCHAR2_TABLE_100
16: , p9_a4 JTF_VARCHAR2_TABLE_100
17: , p9_a5 JTF_VARCHAR2_TABLE_100
18: , p9_a6 JTF_VARCHAR2_TABLE_100

Line 25: , p9_a13 JTF_NUMBER_TABLE

21: , p9_a9 JTF_VARCHAR2_TABLE_200
22: , p9_a10 JTF_VARCHAR2_TABLE_100
23: , p9_a11 JTF_VARCHAR2_TABLE_100
24: , p9_a12 JTF_VARCHAR2_TABLE_100
25: , p9_a13 JTF_NUMBER_TABLE
26: , p9_a14 JTF_NUMBER_TABLE
27: , p9_a15 JTF_NUMBER_TABLE
28: , p9_a16 JTF_VARCHAR2_TABLE_100
29: , p9_a17 JTF_VARCHAR2_TABLE_2000

Line 26: , p9_a14 JTF_NUMBER_TABLE

22: , p9_a10 JTF_VARCHAR2_TABLE_100
23: , p9_a11 JTF_VARCHAR2_TABLE_100
24: , p9_a12 JTF_VARCHAR2_TABLE_100
25: , p9_a13 JTF_NUMBER_TABLE
26: , p9_a14 JTF_NUMBER_TABLE
27: , p9_a15 JTF_NUMBER_TABLE
28: , p9_a16 JTF_VARCHAR2_TABLE_100
29: , p9_a17 JTF_VARCHAR2_TABLE_2000
30: , p9_a18 JTF_VARCHAR2_TABLE_100

Line 27: , p9_a15 JTF_NUMBER_TABLE

23: , p9_a11 JTF_VARCHAR2_TABLE_100
24: , p9_a12 JTF_VARCHAR2_TABLE_100
25: , p9_a13 JTF_NUMBER_TABLE
26: , p9_a14 JTF_NUMBER_TABLE
27: , p9_a15 JTF_NUMBER_TABLE
28: , p9_a16 JTF_VARCHAR2_TABLE_100
29: , p9_a17 JTF_VARCHAR2_TABLE_2000
30: , p9_a18 JTF_VARCHAR2_TABLE_100
31: , p9_a19 JTF_VARCHAR2_TABLE_100

Line 47: , p9_a35 JTF_NUMBER_TABLE

43: , p9_a31 JTF_VARCHAR2_TABLE_500
44: , p9_a32 JTF_VARCHAR2_TABLE_500
45: , p9_a33 JTF_VARCHAR2_TABLE_500
46: , p9_a34 JTF_VARCHAR2_TABLE_500
47: , p9_a35 JTF_NUMBER_TABLE
48: , p9_a36 JTF_DATE_TABLE
49: , p9_a37 JTF_NUMBER_TABLE
50: , p9_a38 JTF_DATE_TABLE
51: , p9_a39 JTF_NUMBER_TABLE

Line 49: , p9_a37 JTF_NUMBER_TABLE

45: , p9_a33 JTF_VARCHAR2_TABLE_500
46: , p9_a34 JTF_VARCHAR2_TABLE_500
47: , p9_a35 JTF_NUMBER_TABLE
48: , p9_a36 JTF_DATE_TABLE
49: , p9_a37 JTF_NUMBER_TABLE
50: , p9_a38 JTF_DATE_TABLE
51: , p9_a39 JTF_NUMBER_TABLE
52: , p9_a40 JTF_VARCHAR2_TABLE_100
53: , p9_a41 JTF_VARCHAR2_TABLE_500

Line 51: , p9_a39 JTF_NUMBER_TABLE

47: , p9_a35 JTF_NUMBER_TABLE
48: , p9_a36 JTF_DATE_TABLE
49: , p9_a37 JTF_NUMBER_TABLE
50: , p9_a38 JTF_DATE_TABLE
51: , p9_a39 JTF_NUMBER_TABLE
52: , p9_a40 JTF_VARCHAR2_TABLE_100
53: , p9_a41 JTF_VARCHAR2_TABLE_500
54: , p9_a42 JTF_VARCHAR2_TABLE_500
55: , p9_a43 JTF_VARCHAR2_TABLE_500

Line 72: , p9_a60 JTF_NUMBER_TABLE

68: , p9_a56 JTF_VARCHAR2_TABLE_100
69: , p9_a57 JTF_VARCHAR2_TABLE_100
70: , p9_a58 JTF_VARCHAR2_TABLE_100
71: , p9_a59 JTF_VARCHAR2_TABLE_100
72: , p9_a60 JTF_NUMBER_TABLE
73: );
74: procedure process_template_rules(p_api_version NUMBER
75: , p_init_msg_list VARCHAR2
76: , x_return_status out nocopy VARCHAR2

Line 81: , p6_a1 JTF_NUMBER_TABLE

77: , x_msg_count out nocopy NUMBER
78: , x_msg_data out nocopy VARCHAR2
79: , p_id NUMBER
80: , p6_a0 JTF_VARCHAR2_TABLE_100
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_VARCHAR2_TABLE_100
84: , p6_a4 JTF_VARCHAR2_TABLE_100
85: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 82: , p6_a2 JTF_NUMBER_TABLE

78: , x_msg_data out nocopy VARCHAR2
79: , p_id NUMBER
80: , p6_a0 JTF_VARCHAR2_TABLE_100
81: , p6_a1 JTF_NUMBER_TABLE
82: , p6_a2 JTF_NUMBER_TABLE
83: , p6_a3 JTF_VARCHAR2_TABLE_100
84: , p6_a4 JTF_VARCHAR2_TABLE_100
85: , p6_a5 JTF_VARCHAR2_TABLE_100
86: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 93: , p6_a13 JTF_NUMBER_TABLE

89: , p6_a9 JTF_VARCHAR2_TABLE_200
90: , p6_a10 JTF_VARCHAR2_TABLE_100
91: , p6_a11 JTF_VARCHAR2_TABLE_100
92: , p6_a12 JTF_VARCHAR2_TABLE_100
93: , p6_a13 JTF_NUMBER_TABLE
94: , p6_a14 JTF_NUMBER_TABLE
95: , p6_a15 JTF_NUMBER_TABLE
96: , p6_a16 JTF_VARCHAR2_TABLE_100
97: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 94: , p6_a14 JTF_NUMBER_TABLE

90: , p6_a10 JTF_VARCHAR2_TABLE_100
91: , p6_a11 JTF_VARCHAR2_TABLE_100
92: , p6_a12 JTF_VARCHAR2_TABLE_100
93: , p6_a13 JTF_NUMBER_TABLE
94: , p6_a14 JTF_NUMBER_TABLE
95: , p6_a15 JTF_NUMBER_TABLE
96: , p6_a16 JTF_VARCHAR2_TABLE_100
97: , p6_a17 JTF_VARCHAR2_TABLE_2000
98: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 95: , p6_a15 JTF_NUMBER_TABLE

91: , p6_a11 JTF_VARCHAR2_TABLE_100
92: , p6_a12 JTF_VARCHAR2_TABLE_100
93: , p6_a13 JTF_NUMBER_TABLE
94: , p6_a14 JTF_NUMBER_TABLE
95: , p6_a15 JTF_NUMBER_TABLE
96: , p6_a16 JTF_VARCHAR2_TABLE_100
97: , p6_a17 JTF_VARCHAR2_TABLE_2000
98: , p6_a18 JTF_VARCHAR2_TABLE_100
99: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 115: , p6_a35 JTF_NUMBER_TABLE

111: , p6_a31 JTF_VARCHAR2_TABLE_500
112: , p6_a32 JTF_VARCHAR2_TABLE_500
113: , p6_a33 JTF_VARCHAR2_TABLE_500
114: , p6_a34 JTF_VARCHAR2_TABLE_500
115: , p6_a35 JTF_NUMBER_TABLE
116: , p6_a36 JTF_DATE_TABLE
117: , p6_a37 JTF_NUMBER_TABLE
118: , p6_a38 JTF_DATE_TABLE
119: , p6_a39 JTF_NUMBER_TABLE

Line 117: , p6_a37 JTF_NUMBER_TABLE

113: , p6_a33 JTF_VARCHAR2_TABLE_500
114: , p6_a34 JTF_VARCHAR2_TABLE_500
115: , p6_a35 JTF_NUMBER_TABLE
116: , p6_a36 JTF_DATE_TABLE
117: , p6_a37 JTF_NUMBER_TABLE
118: , p6_a38 JTF_DATE_TABLE
119: , p6_a39 JTF_NUMBER_TABLE
120: , p6_a40 JTF_VARCHAR2_TABLE_100
121: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 119: , p6_a39 JTF_NUMBER_TABLE

115: , p6_a35 JTF_NUMBER_TABLE
116: , p6_a36 JTF_DATE_TABLE
117: , p6_a37 JTF_NUMBER_TABLE
118: , p6_a38 JTF_DATE_TABLE
119: , p6_a39 JTF_NUMBER_TABLE
120: , p6_a40 JTF_VARCHAR2_TABLE_100
121: , p6_a41 JTF_VARCHAR2_TABLE_500
122: , p6_a42 JTF_VARCHAR2_TABLE_500
123: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 140: , p6_a60 JTF_NUMBER_TABLE

136: , p6_a56 JTF_VARCHAR2_TABLE_100
137: , p6_a57 JTF_VARCHAR2_TABLE_100
138: , p6_a58 JTF_VARCHAR2_TABLE_100
139: , p6_a59 JTF_VARCHAR2_TABLE_100
140: , p6_a60 JTF_NUMBER_TABLE
141: , p7_a0 out nocopy JTF_NUMBER_TABLE
142: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 141: , p7_a0 out nocopy JTF_NUMBER_TABLE

137: , p6_a57 JTF_VARCHAR2_TABLE_100
138: , p6_a58 JTF_VARCHAR2_TABLE_100
139: , p6_a59 JTF_VARCHAR2_TABLE_100
140: , p6_a60 JTF_NUMBER_TABLE
141: , p7_a0 out nocopy JTF_NUMBER_TABLE
142: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
143: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
144: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
145: );