APPS.AHL_UC_INSTANCE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIS.pls 120.1.12010000.4 2008/11/20 11:47:07 sathapli ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );

Line 5: , a2 JTF_NUMBER_TABLE

1: package ahl_uc_instance_pvt_w as
2: /* $Header: AHLWUCIS.pls 120.1.12010000.4 2008/11/20 11:47:07 sathapli ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_uc_instance_pvt.uc_child_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 10: , a1 out nocopy JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
10: , a1 out nocopy JTF_NUMBER_TABLE
11: , a2 out nocopy JTF_NUMBER_TABLE
12: , a3 out nocopy JTF_VARCHAR2_TABLE_100
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );

Line 11: , a2 out nocopy JTF_NUMBER_TABLE

7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p3(t ahl_uc_instance_pvt.uc_child_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
10: , a1 out nocopy JTF_NUMBER_TABLE
11: , a2 out nocopy JTF_NUMBER_TABLE
12: , a3 out nocopy JTF_VARCHAR2_TABLE_100
13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:

Line 17: , a1 JTF_NUMBER_TABLE

13: , a4 out nocopy JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_NUMBER_TABLE

14: );
15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100

Line 19: , a3 JTF_NUMBER_TABLE

15:
16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: );

Line 20: , a4 JTF_NUMBER_TABLE

16: procedure rosetta_table_copy_in_p5(t out nocopy ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_NUMBER_TABLE
20: , a4 JTF_NUMBER_TABLE
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 25: , a1 out nocopy JTF_NUMBER_TABLE

21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 26: , a2 out nocopy JTF_NUMBER_TABLE

22: , a6 JTF_VARCHAR2_TABLE_100
23: );
24: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 27: , a3 out nocopy JTF_NUMBER_TABLE

23: );
24: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: );

Line 28: , a4 out nocopy JTF_NUMBER_TABLE

24: procedure rosetta_table_copy_out_p5(t ahl_uc_instance_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_NUMBER_TABLE
29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: );
32:

Line 33: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE

29: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: );
32:
33: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
34: , a1 JTF_NUMBER_TABLE
35: , a2 JTF_NUMBER_TABLE
36: , a3 JTF_NUMBER_TABLE
37: , a4 JTF_VARCHAR2_TABLE_100

Line 34: , a1 JTF_NUMBER_TABLE

30: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: );
32:
33: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
34: , a1 JTF_NUMBER_TABLE
35: , a2 JTF_NUMBER_TABLE
36: , a3 JTF_NUMBER_TABLE
37: , a4 JTF_VARCHAR2_TABLE_100
38: , a5 JTF_VARCHAR2_TABLE_300

Line 35: , a2 JTF_NUMBER_TABLE

31: );
32:
33: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
34: , a1 JTF_NUMBER_TABLE
35: , a2 JTF_NUMBER_TABLE
36: , a3 JTF_NUMBER_TABLE
37: , a4 JTF_VARCHAR2_TABLE_100
38: , a5 JTF_VARCHAR2_TABLE_300
39: , a6 JTF_VARCHAR2_TABLE_300

Line 36: , a3 JTF_NUMBER_TABLE

32:
33: procedure rosetta_table_copy_in_p7(t out nocopy ahl_uc_instance_pvt.available_instance_tbl_type, a0 JTF_NUMBER_TABLE
34: , a1 JTF_NUMBER_TABLE
35: , a2 JTF_NUMBER_TABLE
36: , a3 JTF_NUMBER_TABLE
37: , a4 JTF_VARCHAR2_TABLE_100
38: , a5 JTF_VARCHAR2_TABLE_300
39: , a6 JTF_VARCHAR2_TABLE_300
40: , a7 JTF_VARCHAR2_TABLE_100

Line 45: , a12 JTF_NUMBER_TABLE

41: , a8 JTF_VARCHAR2_TABLE_100
42: , a9 JTF_VARCHAR2_TABLE_100
43: , a10 JTF_VARCHAR2_TABLE_100
44: , a11 JTF_VARCHAR2_TABLE_100
45: , a12 JTF_NUMBER_TABLE
46: , a13 JTF_NUMBER_TABLE
47: , a14 JTF_DATE_TABLE
48: , a15 JTF_DATE_TABLE
49: , a16 JTF_VARCHAR2_TABLE_4000

Line 46: , a13 JTF_NUMBER_TABLE

42: , a9 JTF_VARCHAR2_TABLE_100
43: , a10 JTF_VARCHAR2_TABLE_100
44: , a11 JTF_VARCHAR2_TABLE_100
45: , a12 JTF_NUMBER_TABLE
46: , a13 JTF_NUMBER_TABLE
47: , a14 JTF_DATE_TABLE
48: , a15 JTF_DATE_TABLE
49: , a16 JTF_VARCHAR2_TABLE_4000
50: , a17 JTF_VARCHAR2_TABLE_100

Line 51: , a18 JTF_NUMBER_TABLE

47: , a14 JTF_DATE_TABLE
48: , a15 JTF_DATE_TABLE
49: , a16 JTF_VARCHAR2_TABLE_4000
50: , a17 JTF_VARCHAR2_TABLE_100
51: , a18 JTF_NUMBER_TABLE
52: , a19 JTF_VARCHAR2_TABLE_400
53: , a20 JTF_VARCHAR2_TABLE_400
54: , a21 JTF_NUMBER_TABLE
55: , a22 JTF_VARCHAR2_TABLE_100

Line 54: , a21 JTF_NUMBER_TABLE

50: , a17 JTF_VARCHAR2_TABLE_100
51: , a18 JTF_NUMBER_TABLE
52: , a19 JTF_VARCHAR2_TABLE_400
53: , a20 JTF_VARCHAR2_TABLE_400
54: , a21 JTF_NUMBER_TABLE
55: , a22 JTF_VARCHAR2_TABLE_100
56: , a23 JTF_NUMBER_TABLE
57: , a24 JTF_VARCHAR2_TABLE_100
58: , a25 JTF_VARCHAR2_TABLE_300

Line 56: , a23 JTF_NUMBER_TABLE

52: , a19 JTF_VARCHAR2_TABLE_400
53: , a20 JTF_VARCHAR2_TABLE_400
54: , a21 JTF_NUMBER_TABLE
55: , a22 JTF_VARCHAR2_TABLE_100
56: , a23 JTF_NUMBER_TABLE
57: , a24 JTF_VARCHAR2_TABLE_100
58: , a25 JTF_VARCHAR2_TABLE_300
59: , a26 JTF_NUMBER_TABLE
60: , a27 JTF_VARCHAR2_TABLE_100

Line 59: , a26 JTF_NUMBER_TABLE

55: , a22 JTF_VARCHAR2_TABLE_100
56: , a23 JTF_NUMBER_TABLE
57: , a24 JTF_VARCHAR2_TABLE_100
58: , a25 JTF_VARCHAR2_TABLE_300
59: , a26 JTF_NUMBER_TABLE
60: , a27 JTF_VARCHAR2_TABLE_100
61: , a28 JTF_VARCHAR2_TABLE_100
62: , a29 JTF_NUMBER_TABLE
63: , a30 JTF_VARCHAR2_TABLE_100

Line 62: , a29 JTF_NUMBER_TABLE

58: , a25 JTF_VARCHAR2_TABLE_300
59: , a26 JTF_NUMBER_TABLE
60: , a27 JTF_VARCHAR2_TABLE_100
61: , a28 JTF_VARCHAR2_TABLE_100
62: , a29 JTF_NUMBER_TABLE
63: , a30 JTF_VARCHAR2_TABLE_100
64: , a31 JTF_VARCHAR2_TABLE_100
65: , a32 JTF_VARCHAR2_TABLE_100
66: , a33 JTF_VARCHAR2_TABLE_100

Line 68: , a35 JTF_NUMBER_TABLE

64: , a31 JTF_VARCHAR2_TABLE_100
65: , a32 JTF_VARCHAR2_TABLE_100
66: , a33 JTF_VARCHAR2_TABLE_100
67: , a34 JTF_VARCHAR2_TABLE_300
68: , a35 JTF_NUMBER_TABLE
69: , a36 JTF_VARCHAR2_TABLE_100
70: , a37 JTF_NUMBER_TABLE
71: , a38 JTF_VARCHAR2_TABLE_300
72: );

Line 70: , a37 JTF_NUMBER_TABLE

66: , a33 JTF_VARCHAR2_TABLE_100
67: , a34 JTF_VARCHAR2_TABLE_300
68: , a35 JTF_NUMBER_TABLE
69: , a36 JTF_VARCHAR2_TABLE_100
70: , a37 JTF_NUMBER_TABLE
71: , a38 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE

Line 73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

69: , a36 JTF_VARCHAR2_TABLE_100
70: , a37 JTF_NUMBER_TABLE
71: , a38 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a1 out nocopy JTF_NUMBER_TABLE

70: , a37 JTF_NUMBER_TABLE
71: , a38 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 75: , a2 out nocopy JTF_NUMBER_TABLE

71: , a38 JTF_VARCHAR2_TABLE_300
72: );
73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_300
79: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 76: , a3 out nocopy JTF_NUMBER_TABLE

72: );
73: procedure rosetta_table_copy_out_p7(t ahl_uc_instance_pvt.available_instance_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
74: , a1 out nocopy JTF_NUMBER_TABLE
75: , a2 out nocopy JTF_NUMBER_TABLE
76: , a3 out nocopy JTF_NUMBER_TABLE
77: , a4 out nocopy JTF_VARCHAR2_TABLE_100
78: , a5 out nocopy JTF_VARCHAR2_TABLE_300
79: , a6 out nocopy JTF_VARCHAR2_TABLE_300
80: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , a12 out nocopy JTF_NUMBER_TABLE

81: , a8 out nocopy JTF_VARCHAR2_TABLE_100
82: , a9 out nocopy JTF_VARCHAR2_TABLE_100
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_VARCHAR2_TABLE_100
85: , a12 out nocopy JTF_NUMBER_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_DATE_TABLE
89: , a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 86: , a13 out nocopy JTF_NUMBER_TABLE

82: , a9 out nocopy JTF_VARCHAR2_TABLE_100
83: , a10 out nocopy JTF_VARCHAR2_TABLE_100
84: , a11 out nocopy JTF_VARCHAR2_TABLE_100
85: , a12 out nocopy JTF_NUMBER_TABLE
86: , a13 out nocopy JTF_NUMBER_TABLE
87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_DATE_TABLE
89: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
90: , a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 91: , a18 out nocopy JTF_NUMBER_TABLE

87: , a14 out nocopy JTF_DATE_TABLE
88: , a15 out nocopy JTF_DATE_TABLE
89: , a16 out nocopy JTF_VARCHAR2_TABLE_4000
90: , a17 out nocopy JTF_VARCHAR2_TABLE_100
91: , a18 out nocopy JTF_NUMBER_TABLE
92: , a19 out nocopy JTF_VARCHAR2_TABLE_400
93: , a20 out nocopy JTF_VARCHAR2_TABLE_400
94: , a21 out nocopy JTF_NUMBER_TABLE
95: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 94: , a21 out nocopy JTF_NUMBER_TABLE

90: , a17 out nocopy JTF_VARCHAR2_TABLE_100
91: , a18 out nocopy JTF_NUMBER_TABLE
92: , a19 out nocopy JTF_VARCHAR2_TABLE_400
93: , a20 out nocopy JTF_VARCHAR2_TABLE_400
94: , a21 out nocopy JTF_NUMBER_TABLE
95: , a22 out nocopy JTF_VARCHAR2_TABLE_100
96: , a23 out nocopy JTF_NUMBER_TABLE
97: , a24 out nocopy JTF_VARCHAR2_TABLE_100
98: , a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 96: , a23 out nocopy JTF_NUMBER_TABLE

92: , a19 out nocopy JTF_VARCHAR2_TABLE_400
93: , a20 out nocopy JTF_VARCHAR2_TABLE_400
94: , a21 out nocopy JTF_NUMBER_TABLE
95: , a22 out nocopy JTF_VARCHAR2_TABLE_100
96: , a23 out nocopy JTF_NUMBER_TABLE
97: , a24 out nocopy JTF_VARCHAR2_TABLE_100
98: , a25 out nocopy JTF_VARCHAR2_TABLE_300
99: , a26 out nocopy JTF_NUMBER_TABLE
100: , a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 99: , a26 out nocopy JTF_NUMBER_TABLE

95: , a22 out nocopy JTF_VARCHAR2_TABLE_100
96: , a23 out nocopy JTF_NUMBER_TABLE
97: , a24 out nocopy JTF_VARCHAR2_TABLE_100
98: , a25 out nocopy JTF_VARCHAR2_TABLE_300
99: , a26 out nocopy JTF_NUMBER_TABLE
100: , a27 out nocopy JTF_VARCHAR2_TABLE_100
101: , a28 out nocopy JTF_VARCHAR2_TABLE_100
102: , a29 out nocopy JTF_NUMBER_TABLE
103: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , a29 out nocopy JTF_NUMBER_TABLE

98: , a25 out nocopy JTF_VARCHAR2_TABLE_300
99: , a26 out nocopy JTF_NUMBER_TABLE
100: , a27 out nocopy JTF_VARCHAR2_TABLE_100
101: , a28 out nocopy JTF_VARCHAR2_TABLE_100
102: , a29 out nocopy JTF_NUMBER_TABLE
103: , a30 out nocopy JTF_VARCHAR2_TABLE_100
104: , a31 out nocopy JTF_VARCHAR2_TABLE_100
105: , a32 out nocopy JTF_VARCHAR2_TABLE_100
106: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a35 out nocopy JTF_NUMBER_TABLE

104: , a31 out nocopy JTF_VARCHAR2_TABLE_100
105: , a32 out nocopy JTF_VARCHAR2_TABLE_100
106: , a33 out nocopy JTF_VARCHAR2_TABLE_100
107: , a34 out nocopy JTF_VARCHAR2_TABLE_300
108: , a35 out nocopy JTF_NUMBER_TABLE
109: , a36 out nocopy JTF_VARCHAR2_TABLE_100
110: , a37 out nocopy JTF_NUMBER_TABLE
111: , a38 out nocopy JTF_VARCHAR2_TABLE_300
112: );

Line 110: , a37 out nocopy JTF_NUMBER_TABLE

106: , a33 out nocopy JTF_VARCHAR2_TABLE_100
107: , a34 out nocopy JTF_VARCHAR2_TABLE_300
108: , a35 out nocopy JTF_NUMBER_TABLE
109: , a36 out nocopy JTF_VARCHAR2_TABLE_100
110: , a37 out nocopy JTF_NUMBER_TABLE
111: , a38 out nocopy JTF_VARCHAR2_TABLE_300
112: );
113:
114: procedure update_instance_attr(p_api_version NUMBER

Line 308: , p14_a0 out nocopy JTF_NUMBER_TABLE

304: , p_instance_number VARCHAR2
305: , p_workorder_id NUMBER
306: , p_start_row_index NUMBER
307: , p_max_rows NUMBER
308: , p14_a0 out nocopy JTF_NUMBER_TABLE
309: , p14_a1 out nocopy JTF_NUMBER_TABLE
310: , p14_a2 out nocopy JTF_NUMBER_TABLE
311: , p14_a3 out nocopy JTF_NUMBER_TABLE
312: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 309: , p14_a1 out nocopy JTF_NUMBER_TABLE

305: , p_workorder_id NUMBER
306: , p_start_row_index NUMBER
307: , p_max_rows NUMBER
308: , p14_a0 out nocopy JTF_NUMBER_TABLE
309: , p14_a1 out nocopy JTF_NUMBER_TABLE
310: , p14_a2 out nocopy JTF_NUMBER_TABLE
311: , p14_a3 out nocopy JTF_NUMBER_TABLE
312: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 310: , p14_a2 out nocopy JTF_NUMBER_TABLE

306: , p_start_row_index NUMBER
307: , p_max_rows NUMBER
308: , p14_a0 out nocopy JTF_NUMBER_TABLE
309: , p14_a1 out nocopy JTF_NUMBER_TABLE
310: , p14_a2 out nocopy JTF_NUMBER_TABLE
311: , p14_a3 out nocopy JTF_NUMBER_TABLE
312: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
314: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 311: , p14_a3 out nocopy JTF_NUMBER_TABLE

307: , p_max_rows NUMBER
308: , p14_a0 out nocopy JTF_NUMBER_TABLE
309: , p14_a1 out nocopy JTF_NUMBER_TABLE
310: , p14_a2 out nocopy JTF_NUMBER_TABLE
311: , p14_a3 out nocopy JTF_NUMBER_TABLE
312: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
313: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
314: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
315: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 320: , p14_a12 out nocopy JTF_NUMBER_TABLE

316: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
317: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
320: , p14_a12 out nocopy JTF_NUMBER_TABLE
321: , p14_a13 out nocopy JTF_NUMBER_TABLE
322: , p14_a14 out nocopy JTF_DATE_TABLE
323: , p14_a15 out nocopy JTF_DATE_TABLE
324: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 321: , p14_a13 out nocopy JTF_NUMBER_TABLE

317: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
318: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100
319: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
320: , p14_a12 out nocopy JTF_NUMBER_TABLE
321: , p14_a13 out nocopy JTF_NUMBER_TABLE
322: , p14_a14 out nocopy JTF_DATE_TABLE
323: , p14_a15 out nocopy JTF_DATE_TABLE
324: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
325: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: , p14_a18 out nocopy JTF_NUMBER_TABLE

322: , p14_a14 out nocopy JTF_DATE_TABLE
323: , p14_a15 out nocopy JTF_DATE_TABLE
324: , p14_a16 out nocopy JTF_VARCHAR2_TABLE_4000
325: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
326: , p14_a18 out nocopy JTF_NUMBER_TABLE
327: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
328: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
329: , p14_a21 out nocopy JTF_NUMBER_TABLE
330: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 329: , p14_a21 out nocopy JTF_NUMBER_TABLE

325: , p14_a17 out nocopy JTF_VARCHAR2_TABLE_100
326: , p14_a18 out nocopy JTF_NUMBER_TABLE
327: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
328: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
329: , p14_a21 out nocopy JTF_NUMBER_TABLE
330: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
331: , p14_a23 out nocopy JTF_NUMBER_TABLE
332: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
333: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 331: , p14_a23 out nocopy JTF_NUMBER_TABLE

327: , p14_a19 out nocopy JTF_VARCHAR2_TABLE_400
328: , p14_a20 out nocopy JTF_VARCHAR2_TABLE_400
329: , p14_a21 out nocopy JTF_NUMBER_TABLE
330: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
331: , p14_a23 out nocopy JTF_NUMBER_TABLE
332: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
333: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
334: , p14_a26 out nocopy JTF_NUMBER_TABLE
335: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 334: , p14_a26 out nocopy JTF_NUMBER_TABLE

330: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
331: , p14_a23 out nocopy JTF_NUMBER_TABLE
332: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
333: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
334: , p14_a26 out nocopy JTF_NUMBER_TABLE
335: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
336: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
337: , p14_a29 out nocopy JTF_NUMBER_TABLE
338: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 337: , p14_a29 out nocopy JTF_NUMBER_TABLE

333: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
334: , p14_a26 out nocopy JTF_NUMBER_TABLE
335: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
336: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
337: , p14_a29 out nocopy JTF_NUMBER_TABLE
338: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
339: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
340: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
341: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 343: , p14_a35 out nocopy JTF_NUMBER_TABLE

339: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
340: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
341: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
342: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
343: , p14_a35 out nocopy JTF_NUMBER_TABLE
344: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
345: , p14_a37 out nocopy JTF_NUMBER_TABLE
346: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
347: , x_tbl_count out nocopy NUMBER

Line 345: , p14_a37 out nocopy JTF_NUMBER_TABLE

341: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
342: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
343: , p14_a35 out nocopy JTF_NUMBER_TABLE
344: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
345: , p14_a37 out nocopy JTF_NUMBER_TABLE
346: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
347: , x_tbl_count out nocopy NUMBER
348: );
349: procedure get_avail_subinv_instances(p_api_version NUMBER

Line 362: , p13_a0 out nocopy JTF_NUMBER_TABLE

358: , p_instance_number VARCHAR2
359: , p_workorder_id NUMBER
360: , p_start_row_index NUMBER
361: , p_max_rows NUMBER
362: , p13_a0 out nocopy JTF_NUMBER_TABLE
363: , p13_a1 out nocopy JTF_NUMBER_TABLE
364: , p13_a2 out nocopy JTF_NUMBER_TABLE
365: , p13_a3 out nocopy JTF_NUMBER_TABLE
366: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 363: , p13_a1 out nocopy JTF_NUMBER_TABLE

359: , p_workorder_id NUMBER
360: , p_start_row_index NUMBER
361: , p_max_rows NUMBER
362: , p13_a0 out nocopy JTF_NUMBER_TABLE
363: , p13_a1 out nocopy JTF_NUMBER_TABLE
364: , p13_a2 out nocopy JTF_NUMBER_TABLE
365: , p13_a3 out nocopy JTF_NUMBER_TABLE
366: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
367: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 364: , p13_a2 out nocopy JTF_NUMBER_TABLE

360: , p_start_row_index NUMBER
361: , p_max_rows NUMBER
362: , p13_a0 out nocopy JTF_NUMBER_TABLE
363: , p13_a1 out nocopy JTF_NUMBER_TABLE
364: , p13_a2 out nocopy JTF_NUMBER_TABLE
365: , p13_a3 out nocopy JTF_NUMBER_TABLE
366: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
367: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
368: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 365: , p13_a3 out nocopy JTF_NUMBER_TABLE

361: , p_max_rows NUMBER
362: , p13_a0 out nocopy JTF_NUMBER_TABLE
363: , p13_a1 out nocopy JTF_NUMBER_TABLE
364: , p13_a2 out nocopy JTF_NUMBER_TABLE
365: , p13_a3 out nocopy JTF_NUMBER_TABLE
366: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
367: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
368: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
369: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 374: , p13_a12 out nocopy JTF_NUMBER_TABLE

370: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
371: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
372: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
373: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
374: , p13_a12 out nocopy JTF_NUMBER_TABLE
375: , p13_a13 out nocopy JTF_NUMBER_TABLE
376: , p13_a14 out nocopy JTF_DATE_TABLE
377: , p13_a15 out nocopy JTF_DATE_TABLE
378: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000

Line 375: , p13_a13 out nocopy JTF_NUMBER_TABLE

371: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
372: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100
373: , p13_a11 out nocopy JTF_VARCHAR2_TABLE_100
374: , p13_a12 out nocopy JTF_NUMBER_TABLE
375: , p13_a13 out nocopy JTF_NUMBER_TABLE
376: , p13_a14 out nocopy JTF_DATE_TABLE
377: , p13_a15 out nocopy JTF_DATE_TABLE
378: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
379: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100

Line 380: , p13_a18 out nocopy JTF_NUMBER_TABLE

376: , p13_a14 out nocopy JTF_DATE_TABLE
377: , p13_a15 out nocopy JTF_DATE_TABLE
378: , p13_a16 out nocopy JTF_VARCHAR2_TABLE_4000
379: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
380: , p13_a18 out nocopy JTF_NUMBER_TABLE
381: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
382: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
383: , p13_a21 out nocopy JTF_NUMBER_TABLE
384: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 383: , p13_a21 out nocopy JTF_NUMBER_TABLE

379: , p13_a17 out nocopy JTF_VARCHAR2_TABLE_100
380: , p13_a18 out nocopy JTF_NUMBER_TABLE
381: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
382: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
383: , p13_a21 out nocopy JTF_NUMBER_TABLE
384: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
385: , p13_a23 out nocopy JTF_NUMBER_TABLE
386: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
387: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300

Line 385: , p13_a23 out nocopy JTF_NUMBER_TABLE

381: , p13_a19 out nocopy JTF_VARCHAR2_TABLE_400
382: , p13_a20 out nocopy JTF_VARCHAR2_TABLE_400
383: , p13_a21 out nocopy JTF_NUMBER_TABLE
384: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
385: , p13_a23 out nocopy JTF_NUMBER_TABLE
386: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
387: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
388: , p13_a26 out nocopy JTF_NUMBER_TABLE
389: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100

Line 388: , p13_a26 out nocopy JTF_NUMBER_TABLE

384: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
385: , p13_a23 out nocopy JTF_NUMBER_TABLE
386: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
387: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
388: , p13_a26 out nocopy JTF_NUMBER_TABLE
389: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
390: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
391: , p13_a29 out nocopy JTF_NUMBER_TABLE
392: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 391: , p13_a29 out nocopy JTF_NUMBER_TABLE

387: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
388: , p13_a26 out nocopy JTF_NUMBER_TABLE
389: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
390: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
391: , p13_a29 out nocopy JTF_NUMBER_TABLE
392: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
393: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
394: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
395: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 397: , p13_a35 out nocopy JTF_NUMBER_TABLE

393: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
394: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
395: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
396: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
397: , p13_a35 out nocopy JTF_NUMBER_TABLE
398: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
399: , p13_a37 out nocopy JTF_NUMBER_TABLE
400: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
401: );

Line 399: , p13_a37 out nocopy JTF_NUMBER_TABLE

395: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
396: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
397: , p13_a35 out nocopy JTF_NUMBER_TABLE
398: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
399: , p13_a37 out nocopy JTF_NUMBER_TABLE
400: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
401: );
402: procedure create_unassigned_instance(p_api_version NUMBER
403: , p_init_msg_list VARCHAR2