APPS.OKL_SETUP_PRD_PRCTEMPL_PUB_W dependencies on JTF_NUMBER_TABLE

Line 76: , p5_a0 JTF_NUMBER_TABLE

72: , p_init_msg_list VARCHAR2
73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 JTF_NUMBER_TABLE
77: , p5_a1 JTF_NUMBER_TABLE
78: , p5_a2 JTF_NUMBER_TABLE
79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 77: , p5_a1 JTF_NUMBER_TABLE

73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 JTF_NUMBER_TABLE
77: , p5_a1 JTF_NUMBER_TABLE
78: , p5_a2 JTF_NUMBER_TABLE
79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_400
81: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 78: , p5_a2 JTF_NUMBER_TABLE

74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 JTF_NUMBER_TABLE
77: , p5_a1 JTF_NUMBER_TABLE
78: , p5_a2 JTF_NUMBER_TABLE
79: , p5_a3 JTF_VARCHAR2_TABLE_200
80: , p5_a4 JTF_VARCHAR2_TABLE_400
81: , p5_a5 JTF_VARCHAR2_TABLE_100
82: , p5_a6 JTF_DATE_TABLE

Line 85: , p5_a9 JTF_NUMBER_TABLE

81: , p5_a5 JTF_VARCHAR2_TABLE_100
82: , p5_a6 JTF_DATE_TABLE
83: , p5_a7 JTF_DATE_TABLE
84: , p5_a8 JTF_VARCHAR2_TABLE_2000
85: , p5_a9 JTF_NUMBER_TABLE
86: , p5_a10 JTF_DATE_TABLE
87: , p5_a11 JTF_NUMBER_TABLE
88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE

Line 87: , p5_a11 JTF_NUMBER_TABLE

83: , p5_a7 JTF_DATE_TABLE
84: , p5_a8 JTF_VARCHAR2_TABLE_2000
85: , p5_a9 JTF_NUMBER_TABLE
86: , p5_a10 JTF_DATE_TABLE
87: , p5_a11 JTF_NUMBER_TABLE
88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 89: , p5_a13 JTF_NUMBER_TABLE

85: , p5_a9 JTF_NUMBER_TABLE
86: , p5_a10 JTF_DATE_TABLE
87: , p5_a11 JTF_NUMBER_TABLE
88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 90: , p6_a0 out nocopy JTF_NUMBER_TABLE

86: , p5_a10 JTF_DATE_TABLE
87: , p5_a11 JTF_NUMBER_TABLE
88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
94: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 91: , p6_a1 out nocopy JTF_NUMBER_TABLE

87: , p5_a11 JTF_NUMBER_TABLE
88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
94: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
95: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , p6_a2 out nocopy JTF_NUMBER_TABLE

88: , p5_a12 JTF_DATE_TABLE
89: , p5_a13 JTF_NUMBER_TABLE
90: , p6_a0 out nocopy JTF_NUMBER_TABLE
91: , p6_a1 out nocopy JTF_NUMBER_TABLE
92: , p6_a2 out nocopy JTF_NUMBER_TABLE
93: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
94: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
95: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
96: , p6_a6 out nocopy JTF_DATE_TABLE

Line 99: , p6_a9 out nocopy JTF_NUMBER_TABLE

95: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
96: , p6_a6 out nocopy JTF_DATE_TABLE
97: , p6_a7 out nocopy JTF_DATE_TABLE
98: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
99: , p6_a9 out nocopy JTF_NUMBER_TABLE
100: , p6_a10 out nocopy JTF_DATE_TABLE
101: , p6_a11 out nocopy JTF_NUMBER_TABLE
102: , p6_a12 out nocopy JTF_DATE_TABLE
103: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 101: , p6_a11 out nocopy JTF_NUMBER_TABLE

97: , p6_a7 out nocopy JTF_DATE_TABLE
98: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
99: , p6_a9 out nocopy JTF_NUMBER_TABLE
100: , p6_a10 out nocopy JTF_DATE_TABLE
101: , p6_a11 out nocopy JTF_NUMBER_TABLE
102: , p6_a12 out nocopy JTF_DATE_TABLE
103: , p6_a13 out nocopy JTF_NUMBER_TABLE
104: );
105: procedure update_prd_price_tmpls(p_api_version NUMBER

Line 103: , p6_a13 out nocopy JTF_NUMBER_TABLE

99: , p6_a9 out nocopy JTF_NUMBER_TABLE
100: , p6_a10 out nocopy JTF_DATE_TABLE
101: , p6_a11 out nocopy JTF_NUMBER_TABLE
102: , p6_a12 out nocopy JTF_DATE_TABLE
103: , p6_a13 out nocopy JTF_NUMBER_TABLE
104: );
105: procedure update_prd_price_tmpls(p_api_version NUMBER
106: , p_init_msg_list VARCHAR2
107: , x_return_status out nocopy VARCHAR2

Line 110: , p5_a0 JTF_NUMBER_TABLE

106: , p_init_msg_list VARCHAR2
107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_NUMBER_TABLE
112: , p5_a2 JTF_NUMBER_TABLE
113: , p5_a3 JTF_VARCHAR2_TABLE_200
114: , p5_a4 JTF_VARCHAR2_TABLE_400

Line 111: , p5_a1 JTF_NUMBER_TABLE

107: , x_return_status out nocopy VARCHAR2
108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_NUMBER_TABLE
112: , p5_a2 JTF_NUMBER_TABLE
113: , p5_a3 JTF_VARCHAR2_TABLE_200
114: , p5_a4 JTF_VARCHAR2_TABLE_400
115: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 112: , p5_a2 JTF_NUMBER_TABLE

108: , x_msg_count out nocopy NUMBER
109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_NUMBER_TABLE
112: , p5_a2 JTF_NUMBER_TABLE
113: , p5_a3 JTF_VARCHAR2_TABLE_200
114: , p5_a4 JTF_VARCHAR2_TABLE_400
115: , p5_a5 JTF_VARCHAR2_TABLE_100
116: , p5_a6 JTF_DATE_TABLE

Line 119: , p5_a9 JTF_NUMBER_TABLE

115: , p5_a5 JTF_VARCHAR2_TABLE_100
116: , p5_a6 JTF_DATE_TABLE
117: , p5_a7 JTF_DATE_TABLE
118: , p5_a8 JTF_VARCHAR2_TABLE_2000
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE

Line 121: , p5_a11 JTF_NUMBER_TABLE

117: , p5_a7 JTF_DATE_TABLE
118: , p5_a8 JTF_VARCHAR2_TABLE_2000
119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p6_a0 out nocopy JTF_NUMBER_TABLE
125: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 123: , p5_a13 JTF_NUMBER_TABLE

119: , p5_a9 JTF_NUMBER_TABLE
120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p6_a0 out nocopy JTF_NUMBER_TABLE
125: , p6_a1 out nocopy JTF_NUMBER_TABLE
126: , p6_a2 out nocopy JTF_NUMBER_TABLE
127: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 124: , p6_a0 out nocopy JTF_NUMBER_TABLE

120: , p5_a10 JTF_DATE_TABLE
121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p6_a0 out nocopy JTF_NUMBER_TABLE
125: , p6_a1 out nocopy JTF_NUMBER_TABLE
126: , p6_a2 out nocopy JTF_NUMBER_TABLE
127: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 125: , p6_a1 out nocopy JTF_NUMBER_TABLE

121: , p5_a11 JTF_NUMBER_TABLE
122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p6_a0 out nocopy JTF_NUMBER_TABLE
125: , p6_a1 out nocopy JTF_NUMBER_TABLE
126: , p6_a2 out nocopy JTF_NUMBER_TABLE
127: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
129: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 126: , p6_a2 out nocopy JTF_NUMBER_TABLE

122: , p5_a12 JTF_DATE_TABLE
123: , p5_a13 JTF_NUMBER_TABLE
124: , p6_a0 out nocopy JTF_NUMBER_TABLE
125: , p6_a1 out nocopy JTF_NUMBER_TABLE
126: , p6_a2 out nocopy JTF_NUMBER_TABLE
127: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
129: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a6 out nocopy JTF_DATE_TABLE

Line 133: , p6_a9 out nocopy JTF_NUMBER_TABLE

129: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a6 out nocopy JTF_DATE_TABLE
131: , p6_a7 out nocopy JTF_DATE_TABLE
132: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p6_a9 out nocopy JTF_NUMBER_TABLE
134: , p6_a10 out nocopy JTF_DATE_TABLE
135: , p6_a11 out nocopy JTF_NUMBER_TABLE
136: , p6_a12 out nocopy JTF_DATE_TABLE
137: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a11 out nocopy JTF_NUMBER_TABLE

131: , p6_a7 out nocopy JTF_DATE_TABLE
132: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
133: , p6_a9 out nocopy JTF_NUMBER_TABLE
134: , p6_a10 out nocopy JTF_DATE_TABLE
135: , p6_a11 out nocopy JTF_NUMBER_TABLE
136: , p6_a12 out nocopy JTF_DATE_TABLE
137: , p6_a13 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure check_product_constraints(p_api_version NUMBER

Line 137: , p6_a13 out nocopy JTF_NUMBER_TABLE

133: , p6_a9 out nocopy JTF_NUMBER_TABLE
134: , p6_a10 out nocopy JTF_DATE_TABLE
135: , p6_a11 out nocopy JTF_NUMBER_TABLE
136: , p6_a12 out nocopy JTF_DATE_TABLE
137: , p6_a13 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure check_product_constraints(p_api_version NUMBER
140: , p_init_msg_list VARCHAR2
141: , x_return_status out nocopy VARCHAR2

Line 184: , p5_a0 JTF_NUMBER_TABLE

180: , p_init_msg_list VARCHAR2
181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 185: , p5_a1 JTF_NUMBER_TABLE

181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_VARCHAR2_TABLE_200
189: , p5_a5 JTF_VARCHAR2_TABLE_2000

Line 186: , p5_a2 JTF_NUMBER_TABLE

182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_VARCHAR2_TABLE_200
189: , p5_a5 JTF_VARCHAR2_TABLE_2000
190: , p5_a6 JTF_NUMBER_TABLE

Line 187: , p5_a3 JTF_NUMBER_TABLE

183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_VARCHAR2_TABLE_200
189: , p5_a5 JTF_VARCHAR2_TABLE_2000
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 190: , p5_a6 JTF_NUMBER_TABLE

186: , p5_a2 JTF_NUMBER_TABLE
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_VARCHAR2_TABLE_200
189: , p5_a5 JTF_VARCHAR2_TABLE_2000
190: , p5_a6 JTF_NUMBER_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_100
192: , p5_a8 JTF_VARCHAR2_TABLE_100
193: , p5_a9 JTF_DATE_TABLE
194: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 212: , p5_a28 JTF_NUMBER_TABLE

208: , p5_a24 JTF_VARCHAR2_TABLE_500
209: , p5_a25 JTF_VARCHAR2_TABLE_500
210: , p5_a26 JTF_VARCHAR2_TABLE_500
211: , p5_a27 JTF_VARCHAR2_TABLE_500
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_DATE_TABLE
214: , p5_a30 JTF_NUMBER_TABLE
215: , p5_a31 JTF_DATE_TABLE
216: , p5_a32 JTF_NUMBER_TABLE

Line 214: , p5_a30 JTF_NUMBER_TABLE

210: , p5_a26 JTF_VARCHAR2_TABLE_500
211: , p5_a27 JTF_VARCHAR2_TABLE_500
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_DATE_TABLE
214: , p5_a30 JTF_NUMBER_TABLE
215: , p5_a31 JTF_DATE_TABLE
216: , p5_a32 JTF_NUMBER_TABLE
217: , x_validated out nocopy VARCHAR2
218: );

Line 216: , p5_a32 JTF_NUMBER_TABLE

212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_DATE_TABLE
214: , p5_a30 JTF_NUMBER_TABLE
215: , p5_a31 JTF_DATE_TABLE
216: , p5_a32 JTF_NUMBER_TABLE
217: , x_validated out nocopy VARCHAR2
218: );
219: end okl_setup_prd_prctempl_pub_w;