APPS.CS_TP_TEMPLATES_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 5: , a2 JTF_VARCHAR2_TABLE_200

1: package cs_tp_templates_pvt_w as
2: /* $Header: cstprtms.pls 120.2 2005/06/30 11:05 appldev ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_1000
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_600
9: , a6 JTF_VARCHAR2_TABLE_200

Line 6: , a3 JTF_VARCHAR2_TABLE_200

2: /* $Header: cstprtms.pls 120.2 2005/06/30 11:05 appldev ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_templates_pvt.template_list, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_1000
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_600
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_200

5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_600
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE

Line 15: , a2 out nocopy JTF_VARCHAR2_TABLE_200

11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
15: , a2 out nocopy JTF_VARCHAR2_TABLE_200
16: , a3 out nocopy JTF_VARCHAR2_TABLE_200
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_600
19: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 16: , a3 out nocopy JTF_VARCHAR2_TABLE_200

12: );
13: procedure rosetta_table_copy_out_p1(t cs_tp_templates_pvt.template_list, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
15: , a2 out nocopy JTF_VARCHAR2_TABLE_200
16: , a3 out nocopy JTF_VARCHAR2_TABLE_200
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_600
19: , a6 out nocopy JTF_VARCHAR2_TABLE_200
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a6 out nocopy JTF_VARCHAR2_TABLE_200

15: , a2 out nocopy JTF_VARCHAR2_TABLE_200
16: , a3 out nocopy JTF_VARCHAR2_TABLE_200
17: , a4 out nocopy JTF_VARCHAR2_TABLE_100
18: , a5 out nocopy JTF_VARCHAR2_TABLE_600
19: , a6 out nocopy JTF_VARCHAR2_TABLE_200
20: , a7 out nocopy JTF_VARCHAR2_TABLE_100
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:

Line 28: , a4 JTF_VARCHAR2_TABLE_200

24: procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE
25: , a1 JTF_VARCHAR2_TABLE_1000
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_VARCHAR2_TABLE_200
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_VARCHAR2_TABLE_200
31: , a7 JTF_VARCHAR2_TABLE_200
32: );

Line 30: , a6 JTF_VARCHAR2_TABLE_200

26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_VARCHAR2_TABLE_200
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_VARCHAR2_TABLE_200
31: , a7 JTF_VARCHAR2_TABLE_200
32: );
33: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

Line 31: , a7 JTF_VARCHAR2_TABLE_200

27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_VARCHAR2_TABLE_200
29: , a5 JTF_NUMBER_TABLE
30: , a6 JTF_VARCHAR2_TABLE_200
31: , a7 JTF_VARCHAR2_TABLE_200
32: );
33: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
35: , a2 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_VARCHAR2_TABLE_200

33: procedure rosetta_table_copy_out_p3(t cs_tp_templates_pvt.template_attribute_list, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_VARCHAR2_TABLE_200
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_200
40: , a7 out nocopy JTF_VARCHAR2_TABLE_200
41: );

Line 39: , a6 out nocopy JTF_VARCHAR2_TABLE_200

35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_VARCHAR2_TABLE_200
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_200
40: , a7 out nocopy JTF_VARCHAR2_TABLE_200
41: );
42:
43: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE

Line 40: , a7 out nocopy JTF_VARCHAR2_TABLE_200

36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_VARCHAR2_TABLE_200
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_200
40: , a7 out nocopy JTF_VARCHAR2_TABLE_200
41: );
42:
43: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
44: , a1 JTF_VARCHAR2_TABLE_1000

Line 46: , a3 JTF_VARCHAR2_TABLE_200

42:
43: procedure rosetta_table_copy_in_p5(t out nocopy cs_tp_templates_pvt.template_link_list, a0 JTF_NUMBER_TABLE
44: , a1 JTF_VARCHAR2_TABLE_1000
45: , a2 JTF_VARCHAR2_TABLE_1000
46: , a3 JTF_VARCHAR2_TABLE_200
47: , a4 JTF_NUMBER_TABLE
48: , a5 JTF_VARCHAR2_TABLE_100
49: , a6 JTF_VARCHAR2_TABLE_100
50: , a7 JTF_VARCHAR2_TABLE_200

Line 50: , a7 JTF_VARCHAR2_TABLE_200

46: , a3 JTF_VARCHAR2_TABLE_200
47: , a4 JTF_NUMBER_TABLE
48: , a5 JTF_VARCHAR2_TABLE_100
49: , a6 JTF_VARCHAR2_TABLE_100
50: , a7 JTF_VARCHAR2_TABLE_200
51: );
52: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
54: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

Line 55: , a3 out nocopy JTF_VARCHAR2_TABLE_200

51: );
52: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
54: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
55: , a3 out nocopy JTF_VARCHAR2_TABLE_200
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 59: , a7 out nocopy JTF_VARCHAR2_TABLE_200

55: , a3 out nocopy JTF_VARCHAR2_TABLE_200
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_VARCHAR2_TABLE_200
60: );
61:
62: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000
63: , a1 JTF_VARCHAR2_TABLE_1000

Line 119: , p4_a4 JTF_VARCHAR2_TABLE_200

115: , p4_a0 JTF_NUMBER_TABLE
116: , p4_a1 JTF_VARCHAR2_TABLE_1000
117: , p4_a2 JTF_NUMBER_TABLE
118: , p4_a3 JTF_NUMBER_TABLE
119: , p4_a4 JTF_VARCHAR2_TABLE_200
120: , p4_a5 JTF_NUMBER_TABLE
121: , p4_a6 JTF_VARCHAR2_TABLE_200
122: , p4_a7 JTF_VARCHAR2_TABLE_200
123: , x_msg_count out nocopy NUMBER

Line 121: , p4_a6 JTF_VARCHAR2_TABLE_200

117: , p4_a2 JTF_NUMBER_TABLE
118: , p4_a3 JTF_NUMBER_TABLE
119: , p4_a4 JTF_VARCHAR2_TABLE_200
120: , p4_a5 JTF_NUMBER_TABLE
121: , p4_a6 JTF_VARCHAR2_TABLE_200
122: , p4_a7 JTF_VARCHAR2_TABLE_200
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , x_return_status out nocopy VARCHAR2

Line 122: , p4_a7 JTF_VARCHAR2_TABLE_200

118: , p4_a3 JTF_NUMBER_TABLE
119: , p4_a4 JTF_VARCHAR2_TABLE_200
120: , p4_a5 JTF_NUMBER_TABLE
121: , p4_a6 JTF_VARCHAR2_TABLE_200
122: , p4_a7 JTF_VARCHAR2_TABLE_200
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , x_return_status out nocopy VARCHAR2
126: );

Line 135: , p5_a3 JTF_VARCHAR2_TABLE_200

131: , p_jtf_object_code VARCHAR2
132: , p5_a0 JTF_NUMBER_TABLE
133: , p5_a1 JTF_VARCHAR2_TABLE_1000
134: , p5_a2 JTF_VARCHAR2_TABLE_1000
135: , p5_a3 JTF_VARCHAR2_TABLE_200
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_VARCHAR2_TABLE_100
138: , p5_a6 JTF_VARCHAR2_TABLE_100
139: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 139: , p5_a7 JTF_VARCHAR2_TABLE_200

135: , p5_a3 JTF_VARCHAR2_TABLE_200
136: , p5_a4 JTF_NUMBER_TABLE
137: , p5_a5 JTF_VARCHAR2_TABLE_100
138: , p5_a6 JTF_VARCHAR2_TABLE_100
139: , p5_a7 JTF_VARCHAR2_TABLE_200
140: , x_msg_count out nocopy NUMBER
141: , x_msg_data out nocopy VARCHAR2
142: , x_return_status out nocopy VARCHAR2
143: );

Line 156: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200

152: , x_msg_data out nocopy VARCHAR2
153: , x_return_status out nocopy VARCHAR2
154: , p10_a0 out nocopy JTF_NUMBER_TABLE
155: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
156: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
157: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
158: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
160: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 157: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200

153: , x_return_status out nocopy VARCHAR2
154: , p10_a0 out nocopy JTF_NUMBER_TABLE
155: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
156: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
157: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
158: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
160: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
161: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200

156: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
157: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
158: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_600
160: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_200
161: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
162: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
163: , x_total_templates out nocopy NUMBER
164: , x_retrieved_template_num out nocopy NUMBER

Line 194: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200

190: , x_msg_data out nocopy VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , p7_a0 out nocopy JTF_NUMBER_TABLE
193: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
194: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
195: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
196: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
198: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 195: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

191: , x_return_status out nocopy VARCHAR2
192: , p7_a0 out nocopy JTF_NUMBER_TABLE
193: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
194: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
195: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
196: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
198: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
199: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 198: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200

194: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
195: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
196: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_600
198: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_200
199: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
201: );
202: procedure show_template_attributes(p_api_version_number NUMBER

Line 214: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200

210: , p8_a0 out nocopy JTF_NUMBER_TABLE
211: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
212: , p8_a2 out nocopy JTF_NUMBER_TABLE
213: , p8_a3 out nocopy JTF_NUMBER_TABLE
214: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200
215: , p8_a5 out nocopy JTF_NUMBER_TABLE
216: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
217: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
218: );

Line 216: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200

212: , p8_a2 out nocopy JTF_NUMBER_TABLE
213: , p8_a3 out nocopy JTF_NUMBER_TABLE
214: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200
215: , p8_a5 out nocopy JTF_NUMBER_TABLE
216: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
217: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
218: );
219: procedure show_template_links(p_api_version_number NUMBER
220: , p_init_msg_list VARCHAR2

Line 217: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

213: , p8_a3 out nocopy JTF_NUMBER_TABLE
214: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_200
215: , p8_a5 out nocopy JTF_NUMBER_TABLE
216: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_200
217: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
218: );
219: procedure show_template_links(p_api_version_number NUMBER
220: , p_init_msg_list VARCHAR2
221: , p_commit VARCHAR

Line 230: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

226: , x_return_status out nocopy VARCHAR2
227: , p8_a0 out nocopy JTF_NUMBER_TABLE
228: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
229: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
230: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
231: , p8_a4 out nocopy JTF_NUMBER_TABLE
232: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
234: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 234: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

230: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
231: , p8_a4 out nocopy JTF_NUMBER_TABLE
232: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
233: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
234: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
235: );
236: procedure show_non_asso_links(p_api_version_number NUMBER
237: , p_init_msg_list VARCHAR2
238: , p_commit VARCHAR

Line 247: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200

243: , x_return_status out nocopy VARCHAR2
244: , p8_a0 out nocopy JTF_NUMBER_TABLE
245: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
246: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000
247: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
248: , p8_a4 out nocopy JTF_NUMBER_TABLE
249: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
251: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 251: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200

247: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_200
248: , p8_a4 out nocopy JTF_NUMBER_TABLE
249: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
250: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
251: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_200
252: );
253: procedure show_link_attribute_list(p_api_version_number NUMBER
254: , p_init_msg_list VARCHAR2
255: , p_commit VARCHAR2

Line 301: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200

297: , x_return_status out nocopy VARCHAR2
298: , p10_a0 out nocopy JTF_NUMBER_TABLE
299: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000
300: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000
301: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
302: , p10_a4 out nocopy JTF_NUMBER_TABLE
303: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
304: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
305: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 305: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200

301: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_200
302: , p10_a4 out nocopy JTF_NUMBER_TABLE
303: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
304: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
305: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_200
306: , x_total_link_number out nocopy NUMBER
307: , x_retrieved_link_number out nocopy NUMBER
308: );
309: procedure show_non_asso_links_two(p_api_version_number NUMBER

Line 323: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200

319: , x_return_status out nocopy VARCHAR2
320: , p11_a0 out nocopy JTF_NUMBER_TABLE
321: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000
322: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000
323: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
324: , p11_a4 out nocopy JTF_NUMBER_TABLE
325: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
326: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
327: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 327: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200

323: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_200
324: , p11_a4 out nocopy JTF_NUMBER_TABLE
325: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100
326: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
327: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_200
328: , x_total_link_number out nocopy NUMBER
329: , x_retrieved_link_number out nocopy NUMBER
330: );
331: procedure delete_template_links(p_api_version_number NUMBER

Line 339: , p5_a3 JTF_VARCHAR2_TABLE_200

335: , p_jtf_object_code VARCHAR2
336: , p5_a0 JTF_NUMBER_TABLE
337: , p5_a1 JTF_VARCHAR2_TABLE_1000
338: , p5_a2 JTF_VARCHAR2_TABLE_1000
339: , p5_a3 JTF_VARCHAR2_TABLE_200
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_VARCHAR2_TABLE_100
342: , p5_a6 JTF_VARCHAR2_TABLE_100
343: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 343: , p5_a7 JTF_VARCHAR2_TABLE_200

339: , p5_a3 JTF_VARCHAR2_TABLE_200
340: , p5_a4 JTF_NUMBER_TABLE
341: , p5_a5 JTF_VARCHAR2_TABLE_100
342: , p5_a6 JTF_VARCHAR2_TABLE_100
343: , p5_a7 JTF_VARCHAR2_TABLE_200
344: , x_msg_count out nocopy NUMBER
345: , x_msg_data out nocopy VARCHAR2
346: , x_return_status out nocopy VARCHAR2
347: );

Line 356: , p5_a3 JTF_VARCHAR2_TABLE_200

352: , p_jtf_object_code VARCHAR2
353: , p5_a0 JTF_NUMBER_TABLE
354: , p5_a1 JTF_VARCHAR2_TABLE_1000
355: , p5_a2 JTF_VARCHAR2_TABLE_1000
356: , p5_a3 JTF_VARCHAR2_TABLE_200
357: , p5_a4 JTF_NUMBER_TABLE
358: , p5_a5 JTF_VARCHAR2_TABLE_100
359: , p5_a6 JTF_VARCHAR2_TABLE_100
360: , p5_a7 JTF_VARCHAR2_TABLE_200

Line 360: , p5_a7 JTF_VARCHAR2_TABLE_200

356: , p5_a3 JTF_VARCHAR2_TABLE_200
357: , p5_a4 JTF_NUMBER_TABLE
358: , p5_a5 JTF_VARCHAR2_TABLE_100
359: , p5_a6 JTF_VARCHAR2_TABLE_100
360: , p5_a7 JTF_VARCHAR2_TABLE_200
361: , x_msg_count out nocopy NUMBER
362: , x_msg_data out nocopy VARCHAR2
363: , x_return_status out nocopy VARCHAR2
364: );