APPS.CS_TP_TEMPLATES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_1000

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

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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
11: , a8 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

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
14: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

Line 11: , a8 JTF_VARCHAR2_TABLE_100

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
14: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
15: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 14: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

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
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

Line 17: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 20: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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:
24: procedure rosetta_table_copy_in_p3(t out nocopy cs_tp_templates_pvt.template_attribute_list, a0 JTF_NUMBER_TABLE

Line 21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

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:
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

Line 25: , a1 JTF_VARCHAR2_TABLE_1000

21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
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

Line 34: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

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
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_VARCHAR2_TABLE_200
38: , a5 out nocopy JTF_NUMBER_TABLE

Line 44: , a1 JTF_VARCHAR2_TABLE_1000

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
45: , a2 JTF_VARCHAR2_TABLE_1000
46: , a3 JTF_VARCHAR2_TABLE_200
47: , a4 JTF_NUMBER_TABLE
48: , a5 JTF_VARCHAR2_TABLE_100

Line 45: , a2 JTF_VARCHAR2_TABLE_1000

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
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

Line 48: , a5 JTF_VARCHAR2_TABLE_100

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
51: );
52: procedure rosetta_table_copy_out_p5(t cs_tp_templates_pvt.template_link_list, a0 out nocopy JTF_NUMBER_TABLE

Line 49: , a6 JTF_VARCHAR2_TABLE_100

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
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

Line 53: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

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
55: , a3 out nocopy JTF_VARCHAR2_TABLE_200
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

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
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

Line 57: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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
60: );
61:

Line 58: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
60: );
61:
62: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000

Line 62: procedure rosetta_table_copy_in_p7(t out nocopy cs_tp_templates_pvt.id_name_pairs, a0 JTF_VARCHAR2_TABLE_1000

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
64: );
65: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

Line 63: , a1 JTF_VARCHAR2_TABLE_1000

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
64: );
65: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
67: );

Line 65: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000

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
64: );
65: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
67: );
68:
69: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE

Line 66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

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
64: );
65: procedure rosetta_table_copy_out_p7(t cs_tp_templates_pvt.id_name_pairs, a0 out nocopy JTF_VARCHAR2_TABLE_1000
66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
67: );
68:
69: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
70: , a1 JTF_VARCHAR2_TABLE_100

Line 70: , a1 JTF_VARCHAR2_TABLE_100

66: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
67: );
68:
69: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
70: , a1 JTF_VARCHAR2_TABLE_100
71: , a2 JTF_VARCHAR2_TABLE_1000
72: );
73: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 71: , a2 JTF_VARCHAR2_TABLE_1000

67: );
68:
69: procedure rosetta_table_copy_in_p9(t out nocopy cs_tp_templates_pvt.object_other_id_pairs, a0 JTF_NUMBER_TABLE
70: , a1 JTF_VARCHAR2_TABLE_100
71: , a2 JTF_VARCHAR2_TABLE_1000
72: );
73: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

Line 74: , a1 out nocopy JTF_VARCHAR2_TABLE_100

70: , a1 JTF_VARCHAR2_TABLE_100
71: , a2 JTF_VARCHAR2_TABLE_1000
72: );
73: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
76: );
77:
78: procedure add_template(p_api_version_number NUMBER

Line 75: , a2 out nocopy JTF_VARCHAR2_TABLE_1000

71: , a2 JTF_VARCHAR2_TABLE_1000
72: );
73: procedure rosetta_table_copy_out_p9(t cs_tp_templates_pvt.object_other_id_pairs, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_VARCHAR2_TABLE_100
75: , a2 out nocopy JTF_VARCHAR2_TABLE_1000
76: );
77:
78: procedure add_template(p_api_version_number NUMBER
79: , p_init_msg_list VARCHAR2

Line 116: , p4_a1 JTF_VARCHAR2_TABLE_1000

112: , p_init_msg_list VARCHAR2
113: , p_commit VARCHAR
114: , p_template_id NUMBER
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

Line 133: , p5_a1 JTF_VARCHAR2_TABLE_1000

129: , p_commit VARCHAR
130: , p_template_id NUMBER
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

Line 134: , p5_a2 JTF_VARCHAR2_TABLE_1000

130: , p_template_id NUMBER
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

Line 137: , p5_a5 JTF_VARCHAR2_TABLE_100

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
140: , x_msg_count out nocopy NUMBER
141: , x_msg_data out nocopy VARCHAR2

Line 138: , p5_a6 JTF_VARCHAR2_TABLE_100

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
140: , x_msg_count out nocopy NUMBER
141: , x_msg_data out nocopy VARCHAR2
142: , x_return_status out nocopy VARCHAR2

Line 155: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000

151: , x_msg_count out nocopy NUMBER
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

Line 158: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
162: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

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
165: );

Line 162: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
165: );
166: procedure show_template(p_api_version_number NUMBER

Line 187: , p3_a1 JTF_VARCHAR2_TABLE_100

183: procedure show_templates_with_link(p_api_version_number NUMBER
184: , p_init_msg_list VARCHAR2
185: , p_commit VARCHAR
186: , p3_a0 JTF_NUMBER_TABLE
187: , p3_a1 JTF_VARCHAR2_TABLE_100
188: , p3_a2 JTF_VARCHAR2_TABLE_1000
189: , x_msg_count out nocopy NUMBER
190: , x_msg_data out nocopy VARCHAR2
191: , x_return_status out nocopy VARCHAR2

Line 188: , p3_a2 JTF_VARCHAR2_TABLE_1000

184: , p_init_msg_list VARCHAR2
185: , p_commit VARCHAR
186: , p3_a0 JTF_NUMBER_TABLE
187: , p3_a1 JTF_VARCHAR2_TABLE_100
188: , p3_a2 JTF_VARCHAR2_TABLE_1000
189: , x_msg_count out nocopy NUMBER
190: , x_msg_data out nocopy VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 193: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000

189: , x_msg_count out nocopy NUMBER
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

Line 196: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

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
200: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 199: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

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
203: , p_init_msg_list VARCHAR2

Line 200: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100

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
203: , p_init_msg_list VARCHAR2
204: , p_commit VARCHAR

Line 211: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

207: , x_msg_count out nocopy NUMBER
208: , x_msg_data out nocopy VARCHAR2
209: , x_return_status out nocopy VARCHAR2
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

Line 228: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

224: , x_msg_count out nocopy NUMBER
225: , x_msg_data out nocopy VARCHAR2
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

Line 229: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000

225: , x_msg_data out nocopy VARCHAR2
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

Line 232: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
235: );
236: procedure show_non_asso_links(p_api_version_number NUMBER

Line 233: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
235: );
236: procedure show_non_asso_links(p_api_version_number NUMBER
237: , p_init_msg_list VARCHAR2

Line 245: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

241: , x_msg_count out nocopy NUMBER
242: , x_msg_data out nocopy VARCHAR2
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

Line 246: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_1000

242: , x_msg_data out nocopy VARCHAR2
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

Line 249: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
252: );
253: procedure show_link_attribute_list(p_api_version_number NUMBER

Line 250: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
252: );
253: procedure show_link_attribute_list(p_api_version_number NUMBER
254: , p_init_msg_list VARCHAR2

Line 260: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000

256: , p_identify VARCHAR2
257: , x_msg_count out nocopy NUMBER
258: , x_msg_data out nocopy VARCHAR2
259: , x_return_status out nocopy VARCHAR2
260: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000
261: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
262: );
263: procedure retrieve_constants(p_api_version_number NUMBER
264: , p_init_msg_list VARCHAR2

Line 261: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000

257: , x_msg_count out nocopy NUMBER
258: , x_msg_data out nocopy VARCHAR2
259: , x_return_status out nocopy VARCHAR2
260: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_1000
261: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_1000
262: );
263: procedure retrieve_constants(p_api_version_number NUMBER
264: , p_init_msg_list VARCHAR2
265: , p_commit VARCHAR2

Line 269: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000

265: , p_commit VARCHAR2
266: , x_msg_count out nocopy NUMBER
267: , x_msg_data out nocopy VARCHAR2
268: , x_return_status out nocopy VARCHAR2
269: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
271: );
272: procedure show_default_template(p_api_version_number NUMBER
273: , p_init_msg_list VARCHAR2

Line 270: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000

266: , x_msg_count out nocopy NUMBER
267: , x_msg_data out nocopy VARCHAR2
268: , x_return_status out nocopy VARCHAR2
269: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_1000
270: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_1000
271: );
272: procedure show_default_template(p_api_version_number NUMBER
273: , p_init_msg_list VARCHAR2
274: , p_commit VARCHAR2

Line 299: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_1000

295: , x_msg_count out nocopy NUMBER
296: , x_msg_data out nocopy VARCHAR2
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

Line 300: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_1000

296: , x_msg_data out nocopy VARCHAR2
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

Line 303: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
306: , x_total_link_number out nocopy NUMBER
307: , x_retrieved_link_number out nocopy NUMBER

Line 304: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
306: , x_total_link_number out nocopy NUMBER
307: , x_retrieved_link_number out nocopy NUMBER
308: );

Line 321: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_1000

317: , x_msg_count out nocopy NUMBER
318: , x_msg_data out nocopy VARCHAR2
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

Line 322: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_1000

318: , x_msg_data out nocopy VARCHAR2
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

Line 325: , p11_a5 out nocopy JTF_VARCHAR2_TABLE_100

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
328: , x_total_link_number out nocopy NUMBER
329: , x_retrieved_link_number out nocopy NUMBER

Line 326: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

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
328: , x_total_link_number out nocopy NUMBER
329: , x_retrieved_link_number out nocopy NUMBER
330: );

Line 337: , p5_a1 JTF_VARCHAR2_TABLE_1000

333: , p_commit VARCHAR
334: , p_template_id NUMBER
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

Line 338: , p5_a2 JTF_VARCHAR2_TABLE_1000

334: , p_template_id NUMBER
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

Line 341: , p5_a5 JTF_VARCHAR2_TABLE_100

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
344: , x_msg_count out nocopy NUMBER
345: , x_msg_data out nocopy VARCHAR2

Line 342: , p5_a6 JTF_VARCHAR2_TABLE_100

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
344: , x_msg_count out nocopy NUMBER
345: , x_msg_data out nocopy VARCHAR2
346: , x_return_status out nocopy VARCHAR2

Line 354: , p5_a1 JTF_VARCHAR2_TABLE_1000

350: , p_commit VARCHAR
351: , p_template_id NUMBER
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

Line 355: , p5_a2 JTF_VARCHAR2_TABLE_1000

351: , p_template_id NUMBER
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

Line 358: , p5_a5 JTF_VARCHAR2_TABLE_100

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
361: , x_msg_count out nocopy NUMBER
362: , x_msg_data out nocopy VARCHAR2

Line 359: , p5_a6 JTF_VARCHAR2_TABLE_100

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
361: , x_msg_count out nocopy NUMBER
362: , x_msg_data out nocopy VARCHAR2
363: , x_return_status out nocopy VARCHAR2