DBA Data[Home] [Help]

APPS.JTF_TASK_INST_TEMPLATES_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE

1: package jtf_task_inst_templates_pub_w as
2: /* $Header: jtfpttws.pls 120.3 2006/04/26 04:36 knayyar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package jtf_task_inst_templates_pub_w as
2: /* $Header: jtfpttws.pls 120.3 2006/04/26 04:36 knayyar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );

Line 6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

2: /* $Header: jtfpttws.pls 120.3 2006/04/26 04:36 knayyar ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE

Line 7: , a1 out nocopy JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy jtf_task_inst_templates_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: );
6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE

Line 10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_out_p1(t jtf_task_inst_templates_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 11: , a1 JTF_NUMBER_TABLE

7: , a1 out nocopy JTF_NUMBER_TABLE
8: );
9:
10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE

Line 14: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE

10: procedure rosetta_table_copy_in_p3(t out nocopy jtf_task_inst_templates_pub.task_contact_points_tbl, a0 JTF_NUMBER_TABLE
11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:

Line 15: , a1 out nocopy JTF_NUMBER_TABLE

11: , a1 JTF_NUMBER_TABLE
12: , a2 JTF_VARCHAR2_TABLE_100
13: );
14: procedure rosetta_table_copy_out_p3(t jtf_task_inst_templates_pub.task_contact_points_tbl, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE

Line 19: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE

15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_4000
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE

Line 22: , a3 JTF_NUMBER_TABLE

18:
19: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_4000
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: , a5 JTF_NUMBER_TABLE
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_NUMBER_TABLE

Line 23: , a4 JTF_NUMBER_TABLE

19: procedure rosetta_table_copy_in_p6(t out nocopy jtf_task_inst_templates_pub.task_template_info_tbl, a0 JTF_NUMBER_TABLE
20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_4000
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: , a5 JTF_NUMBER_TABLE
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_NUMBER_TABLE
27: , a8 JTF_DATE_TABLE

Line 24: , a5 JTF_NUMBER_TABLE

20: , a1 JTF_VARCHAR2_TABLE_100
21: , a2 JTF_VARCHAR2_TABLE_4000
22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: , a5 JTF_NUMBER_TABLE
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_NUMBER_TABLE
27: , a8 JTF_DATE_TABLE
28: , a9 JTF_DATE_TABLE

Line 26: , a7 JTF_NUMBER_TABLE

22: , a3 JTF_NUMBER_TABLE
23: , a4 JTF_NUMBER_TABLE
24: , a5 JTF_NUMBER_TABLE
25: , a6 JTF_VARCHAR2_TABLE_100
26: , a7 JTF_NUMBER_TABLE
27: , a8 JTF_DATE_TABLE
28: , a9 JTF_DATE_TABLE
29: , a10 JTF_DATE_TABLE
30: , a11 JTF_DATE_TABLE

Line 34: , a15 JTF_NUMBER_TABLE

30: , a11 JTF_DATE_TABLE
31: , a12 JTF_DATE_TABLE
32: , a13 JTF_DATE_TABLE
33: , a14 JTF_VARCHAR2_TABLE_100
34: , a15 JTF_NUMBER_TABLE
35: , a16 JTF_NUMBER_TABLE
36: , a17 JTF_VARCHAR2_TABLE_100
37: , a18 JTF_NUMBER_TABLE
38: , a19 JTF_VARCHAR2_TABLE_100

Line 35: , a16 JTF_NUMBER_TABLE

31: , a12 JTF_DATE_TABLE
32: , a13 JTF_DATE_TABLE
33: , a14 JTF_VARCHAR2_TABLE_100
34: , a15 JTF_NUMBER_TABLE
35: , a16 JTF_NUMBER_TABLE
36: , a17 JTF_VARCHAR2_TABLE_100
37: , a18 JTF_NUMBER_TABLE
38: , a19 JTF_VARCHAR2_TABLE_100
39: , a20 JTF_VARCHAR2_TABLE_100

Line 37: , a18 JTF_NUMBER_TABLE

33: , a14 JTF_VARCHAR2_TABLE_100
34: , a15 JTF_NUMBER_TABLE
35: , a16 JTF_NUMBER_TABLE
36: , a17 JTF_VARCHAR2_TABLE_100
37: , a18 JTF_NUMBER_TABLE
38: , a19 JTF_VARCHAR2_TABLE_100
39: , a20 JTF_VARCHAR2_TABLE_100
40: , a21 JTF_VARCHAR2_TABLE_100
41: , a22 JTF_VARCHAR2_TABLE_100

Line 67: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

63: , a44 JTF_VARCHAR2_TABLE_200
64: , a45 JTF_VARCHAR2_TABLE_100
65: , a46 JTF_VARCHAR2_TABLE_100
66: );
67: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_VARCHAR2_TABLE_100
69: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE

Line 70: , a3 out nocopy JTF_NUMBER_TABLE

66: );
67: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_VARCHAR2_TABLE_100
69: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_VARCHAR2_TABLE_100
74: , a7 out nocopy JTF_NUMBER_TABLE

Line 71: , a4 out nocopy JTF_NUMBER_TABLE

67: procedure rosetta_table_copy_out_p6(t jtf_task_inst_templates_pub.task_template_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_VARCHAR2_TABLE_100
69: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_VARCHAR2_TABLE_100
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_DATE_TABLE

Line 72: , a5 out nocopy JTF_NUMBER_TABLE

68: , a1 out nocopy JTF_VARCHAR2_TABLE_100
69: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_VARCHAR2_TABLE_100
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_DATE_TABLE
76: , a9 out nocopy JTF_DATE_TABLE

Line 74: , a7 out nocopy JTF_NUMBER_TABLE

70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_NUMBER_TABLE
72: , a5 out nocopy JTF_NUMBER_TABLE
73: , a6 out nocopy JTF_VARCHAR2_TABLE_100
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_DATE_TABLE
76: , a9 out nocopy JTF_DATE_TABLE
77: , a10 out nocopy JTF_DATE_TABLE
78: , a11 out nocopy JTF_DATE_TABLE

Line 82: , a15 out nocopy JTF_NUMBER_TABLE

78: , a11 out nocopy JTF_DATE_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_VARCHAR2_TABLE_100
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_VARCHAR2_TABLE_100
85: , a18 out nocopy JTF_NUMBER_TABLE
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , a16 out nocopy JTF_NUMBER_TABLE

79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_VARCHAR2_TABLE_100
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_VARCHAR2_TABLE_100
85: , a18 out nocopy JTF_NUMBER_TABLE
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100
87: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , a18 out nocopy JTF_NUMBER_TABLE

81: , a14 out nocopy JTF_VARCHAR2_TABLE_100
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_NUMBER_TABLE
84: , a17 out nocopy JTF_VARCHAR2_TABLE_100
85: , a18 out nocopy JTF_NUMBER_TABLE
86: , a19 out nocopy JTF_VARCHAR2_TABLE_100
87: , a20 out nocopy JTF_VARCHAR2_TABLE_100
88: , a21 out nocopy JTF_VARCHAR2_TABLE_100
89: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 171: , p4_a0 JTF_NUMBER_TABLE

167: , p3_a48 VARCHAR2
168: , p3_a49 VARCHAR2
169: , p3_a50 VARCHAR2
170: , p3_a51 NUMBER
171: , p4_a0 JTF_NUMBER_TABLE
172: , p4_a1 JTF_VARCHAR2_TABLE_100
173: , p4_a2 JTF_VARCHAR2_TABLE_4000
174: , p4_a3 JTF_NUMBER_TABLE
175: , p4_a4 JTF_NUMBER_TABLE

Line 174: , p4_a3 JTF_NUMBER_TABLE

170: , p3_a51 NUMBER
171: , p4_a0 JTF_NUMBER_TABLE
172: , p4_a1 JTF_VARCHAR2_TABLE_100
173: , p4_a2 JTF_VARCHAR2_TABLE_4000
174: , p4_a3 JTF_NUMBER_TABLE
175: , p4_a4 JTF_NUMBER_TABLE
176: , p4_a5 JTF_NUMBER_TABLE
177: , p4_a6 JTF_VARCHAR2_TABLE_100
178: , p4_a7 JTF_NUMBER_TABLE

Line 175: , p4_a4 JTF_NUMBER_TABLE

171: , p4_a0 JTF_NUMBER_TABLE
172: , p4_a1 JTF_VARCHAR2_TABLE_100
173: , p4_a2 JTF_VARCHAR2_TABLE_4000
174: , p4_a3 JTF_NUMBER_TABLE
175: , p4_a4 JTF_NUMBER_TABLE
176: , p4_a5 JTF_NUMBER_TABLE
177: , p4_a6 JTF_VARCHAR2_TABLE_100
178: , p4_a7 JTF_NUMBER_TABLE
179: , p4_a8 JTF_DATE_TABLE

Line 176: , p4_a5 JTF_NUMBER_TABLE

172: , p4_a1 JTF_VARCHAR2_TABLE_100
173: , p4_a2 JTF_VARCHAR2_TABLE_4000
174: , p4_a3 JTF_NUMBER_TABLE
175: , p4_a4 JTF_NUMBER_TABLE
176: , p4_a5 JTF_NUMBER_TABLE
177: , p4_a6 JTF_VARCHAR2_TABLE_100
178: , p4_a7 JTF_NUMBER_TABLE
179: , p4_a8 JTF_DATE_TABLE
180: , p4_a9 JTF_DATE_TABLE

Line 178: , p4_a7 JTF_NUMBER_TABLE

174: , p4_a3 JTF_NUMBER_TABLE
175: , p4_a4 JTF_NUMBER_TABLE
176: , p4_a5 JTF_NUMBER_TABLE
177: , p4_a6 JTF_VARCHAR2_TABLE_100
178: , p4_a7 JTF_NUMBER_TABLE
179: , p4_a8 JTF_DATE_TABLE
180: , p4_a9 JTF_DATE_TABLE
181: , p4_a10 JTF_DATE_TABLE
182: , p4_a11 JTF_DATE_TABLE

Line 186: , p4_a15 JTF_NUMBER_TABLE

182: , p4_a11 JTF_DATE_TABLE
183: , p4_a12 JTF_DATE_TABLE
184: , p4_a13 JTF_DATE_TABLE
185: , p4_a14 JTF_VARCHAR2_TABLE_100
186: , p4_a15 JTF_NUMBER_TABLE
187: , p4_a16 JTF_NUMBER_TABLE
188: , p4_a17 JTF_VARCHAR2_TABLE_100
189: , p4_a18 JTF_NUMBER_TABLE
190: , p4_a19 JTF_VARCHAR2_TABLE_100

Line 187: , p4_a16 JTF_NUMBER_TABLE

183: , p4_a12 JTF_DATE_TABLE
184: , p4_a13 JTF_DATE_TABLE
185: , p4_a14 JTF_VARCHAR2_TABLE_100
186: , p4_a15 JTF_NUMBER_TABLE
187: , p4_a16 JTF_NUMBER_TABLE
188: , p4_a17 JTF_VARCHAR2_TABLE_100
189: , p4_a18 JTF_NUMBER_TABLE
190: , p4_a19 JTF_VARCHAR2_TABLE_100
191: , p4_a20 JTF_VARCHAR2_TABLE_100

Line 189: , p4_a18 JTF_NUMBER_TABLE

185: , p4_a14 JTF_VARCHAR2_TABLE_100
186: , p4_a15 JTF_NUMBER_TABLE
187: , p4_a16 JTF_NUMBER_TABLE
188: , p4_a17 JTF_VARCHAR2_TABLE_100
189: , p4_a18 JTF_NUMBER_TABLE
190: , p4_a19 JTF_VARCHAR2_TABLE_100
191: , p4_a20 JTF_VARCHAR2_TABLE_100
192: , p4_a21 JTF_VARCHAR2_TABLE_100
193: , p4_a22 JTF_VARCHAR2_TABLE_100

Line 218: , p5_a0 JTF_NUMBER_TABLE

214: , p4_a43 JTF_VARCHAR2_TABLE_200
215: , p4_a44 JTF_VARCHAR2_TABLE_200
216: , p4_a45 JTF_VARCHAR2_TABLE_100
217: , p4_a46 JTF_VARCHAR2_TABLE_100
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER

Line 219: , p5_a1 JTF_NUMBER_TABLE

215: , p4_a44 JTF_VARCHAR2_TABLE_200
216: , p4_a45 JTF_VARCHAR2_TABLE_100
217: , p4_a46 JTF_VARCHAR2_TABLE_100
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2

Line 224: , p9_a0 out nocopy JTF_NUMBER_TABLE

220: , p5_a2 JTF_VARCHAR2_TABLE_100
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p9_a0 out nocopy JTF_NUMBER_TABLE
225: , p9_a1 out nocopy JTF_NUMBER_TABLE
226: );
227: end jtf_task_inst_templates_pub_w;

Line 225: , p9_a1 out nocopy JTF_NUMBER_TABLE

221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p9_a0 out nocopy JTF_NUMBER_TABLE
225: , p9_a1 out nocopy JTF_NUMBER_TABLE
226: );
227: end jtf_task_inst_templates_pub_w;