APPS.AHL_COMPLETIONS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_completions_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWPRCS.pls 120.5.12020000.2 2012/12/14 03:39:15 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_completions_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWPRCS.pls 120.5.12020000.2 2012/12/14 03:39:15 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_completions_pvt.workorder_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE

Line 18: , a15 JTF_NUMBER_TABLE

14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_NUMBER_TABLE

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 21: , a18 JTF_NUMBER_TABLE

17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE

Line 29: , a1 out nocopy JTF_NUMBER_TABLE

25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: );
28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE

Line 32: , a4 out nocopy JTF_NUMBER_TABLE

28: procedure rosetta_table_copy_out_p1(t ahl_completions_pvt.workorder_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE

Line 33: , a5 out nocopy JTF_NUMBER_TABLE

29: , a1 out nocopy JTF_NUMBER_TABLE
30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE

Line 34: , a6 out nocopy JTF_NUMBER_TABLE

30: , a2 out nocopy JTF_VARCHAR2_TABLE_100
31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE

Line 35: , a7 out nocopy JTF_NUMBER_TABLE

31: , a3 out nocopy JTF_VARCHAR2_TABLE_100
32: , a4 out nocopy JTF_NUMBER_TABLE
33: , a5 out nocopy JTF_NUMBER_TABLE
34: , a6 out nocopy JTF_NUMBER_TABLE
35: , a7 out nocopy JTF_NUMBER_TABLE
36: , a8 out nocopy JTF_DATE_TABLE
37: , a9 out nocopy JTF_DATE_TABLE
38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE

Line 42: , a14 out nocopy JTF_NUMBER_TABLE

38: , a10 out nocopy JTF_DATE_TABLE
39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE

Line 43: , a15 out nocopy JTF_NUMBER_TABLE

39: , a11 out nocopy JTF_DATE_TABLE
40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a16 out nocopy JTF_NUMBER_TABLE

40: , a12 out nocopy JTF_VARCHAR2_TABLE_100
41: , a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a18 out nocopy JTF_NUMBER_TABLE

42: , a14 out nocopy JTF_NUMBER_TABLE
43: , a15 out nocopy JTF_NUMBER_TABLE
44: , a16 out nocopy JTF_NUMBER_TABLE
45: , a17 out nocopy JTF_VARCHAR2_TABLE_100
46: , a18 out nocopy JTF_NUMBER_TABLE
47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a23 out nocopy JTF_NUMBER_TABLE

47: , a19 out nocopy JTF_VARCHAR2_TABLE_100
48: , a20 out nocopy JTF_VARCHAR2_TABLE_100
49: , a21 out nocopy JTF_VARCHAR2_TABLE_100
50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE

Line 54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE

50: , a22 out nocopy JTF_VARCHAR2_TABLE_100
51: , a23 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE

Line 55: , a1 JTF_NUMBER_TABLE

51: , a23 out nocopy JTF_NUMBER_TABLE
52: );
53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE

Line 56: , a2 JTF_NUMBER_TABLE

52: );
53:
54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE

Line 58: , a4 JTF_NUMBER_TABLE

54: procedure rosetta_table_copy_in_p3(t out nocopy ahl_completions_pvt.operation_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE

Line 59: , a5 JTF_NUMBER_TABLE

55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE

Line 60: , a6 JTF_NUMBER_TABLE

56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE

Line 62: , a8 JTF_NUMBER_TABLE

58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE

Line 63: , a9 JTF_NUMBER_TABLE

59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_NUMBER_TABLE
61: , a7 JTF_VARCHAR2_TABLE_2000
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_DATE_TABLE
65: , a11 JTF_DATE_TABLE
66: , a12 JTF_DATE_TABLE
67: , a13 JTF_DATE_TABLE

Line 71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE

Line 72: , a1 out nocopy JTF_NUMBER_TABLE

68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE

Line 73: , a2 out nocopy JTF_NUMBER_TABLE

69: , a15 JTF_VARCHAR2_TABLE_100
70: );
71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE

Line 75: , a4 out nocopy JTF_NUMBER_TABLE

71: procedure rosetta_table_copy_out_p3(t ahl_completions_pvt.operation_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE

Line 76: , a5 out nocopy JTF_NUMBER_TABLE

72: , a1 out nocopy JTF_NUMBER_TABLE
73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE

Line 77: , a6 out nocopy JTF_NUMBER_TABLE

73: , a2 out nocopy JTF_NUMBER_TABLE
74: , a3 out nocopy JTF_VARCHAR2_TABLE_100
75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE

Line 79: , a8 out nocopy JTF_NUMBER_TABLE

75: , a4 out nocopy JTF_NUMBER_TABLE
76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE

Line 80: , a9 out nocopy JTF_NUMBER_TABLE

76: , a5 out nocopy JTF_NUMBER_TABLE
77: , a6 out nocopy JTF_NUMBER_TABLE
78: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
79: , a8 out nocopy JTF_NUMBER_TABLE
80: , a9 out nocopy JTF_NUMBER_TABLE
81: , a10 out nocopy JTF_DATE_TABLE
82: , a11 out nocopy JTF_DATE_TABLE
83: , a12 out nocopy JTF_DATE_TABLE
84: , a13 out nocopy JTF_DATE_TABLE

Line 89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE

85: , a14 out nocopy JTF_VARCHAR2_TABLE_100
86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE

Line 90: , a1 JTF_NUMBER_TABLE

86: , a15 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:
89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE

Line 93: , a4 JTF_NUMBER_TABLE

89: procedure rosetta_table_copy_in_p7(t out nocopy ahl_completions_pvt.mr_tbl_type, a0 JTF_NUMBER_TABLE
90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE

Line 94: , a5 JTF_NUMBER_TABLE

90: , a1 JTF_NUMBER_TABLE
91: , a2 JTF_VARCHAR2_TABLE_100
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE

Line 97: , a8 JTF_NUMBER_TABLE

93: , a4 JTF_NUMBER_TABLE
94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );

Line 98: , a9 JTF_NUMBER_TABLE

94: , a5 JTF_NUMBER_TABLE
95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 99: , a10 JTF_NUMBER_TABLE

95: , a6 JTF_VARCHAR2_TABLE_100
96: , a7 JTF_VARCHAR2_TABLE_200
97: , a8 JTF_NUMBER_TABLE
98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE

Line 102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

98: , a9 JTF_NUMBER_TABLE
99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE

Line 103: , a1 out nocopy JTF_NUMBER_TABLE

99: , a10 JTF_NUMBER_TABLE
100: , a11 JTF_DATE_TABLE
101: );
102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE

Line 106: , a4 out nocopy JTF_NUMBER_TABLE

102: procedure rosetta_table_copy_out_p7(t ahl_completions_pvt.mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE

Line 107: , a5 out nocopy JTF_NUMBER_TABLE

103: , a1 out nocopy JTF_NUMBER_TABLE
104: , a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE

Line 110: , a8 out nocopy JTF_NUMBER_TABLE

106: , a4 out nocopy JTF_NUMBER_TABLE
107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_DATE_TABLE
114: );

Line 111: , a9 out nocopy JTF_NUMBER_TABLE

107: , a5 out nocopy JTF_NUMBER_TABLE
108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_DATE_TABLE
114: );
115:

Line 112: , a10 out nocopy JTF_NUMBER_TABLE

108: , a6 out nocopy JTF_VARCHAR2_TABLE_100
109: , a7 out nocopy JTF_VARCHAR2_TABLE_200
110: , a8 out nocopy JTF_NUMBER_TABLE
111: , a9 out nocopy JTF_NUMBER_TABLE
112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_DATE_TABLE
114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE

Line 116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE

112: , a10 out nocopy JTF_NUMBER_TABLE
113: , a11 out nocopy JTF_DATE_TABLE
114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE

Line 117: , a1 JTF_NUMBER_TABLE

113: , a11 out nocopy JTF_DATE_TABLE
114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE

Line 118: , a2 JTF_NUMBER_TABLE

114: );
115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100

Line 119: , a3 JTF_NUMBER_TABLE

115:
116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE

Line 120: , a4 JTF_NUMBER_TABLE

116: procedure rosetta_table_copy_in_p9(t out nocopy ahl_completions_pvt.counter_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );

Line 121: , a5 JTF_NUMBER_TABLE

117: , a1 JTF_NUMBER_TABLE
118: , a2 JTF_NUMBER_TABLE
119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 123: , a7 JTF_NUMBER_TABLE

119: , a3 JTF_NUMBER_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE

Line 125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

121: , a5 JTF_NUMBER_TABLE
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE

Line 126: , a1 out nocopy JTF_NUMBER_TABLE

122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE

Line 127: , a2 out nocopy JTF_NUMBER_TABLE

123: , a7 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , a3 out nocopy JTF_NUMBER_TABLE

124: );
125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE

Line 129: , a4 out nocopy JTF_NUMBER_TABLE

125: procedure rosetta_table_copy_out_p9(t ahl_completions_pvt.counter_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE
133: );

Line 130: , a5 out nocopy JTF_NUMBER_TABLE

126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE
133: );
134:

Line 132: , a7 out nocopy JTF_NUMBER_TABLE

128: , a3 out nocopy JTF_NUMBER_TABLE
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_NUMBER_TABLE
131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

Line 135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);

131: , a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , a7 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100

Line 136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);

132: , a7 out nocopy JTF_NUMBER_TABLE
133: );
134:
135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE

Line 138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE

134:
135: procedure rosetta_table_copy_in_p10(t out nocopy ahl_completions_pvt.route_tbl_type, a0 JTF_NUMBER_TABLE);
136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE

Line 140: , a2 JTF_NUMBER_TABLE

136: procedure rosetta_table_copy_out_p10(t ahl_completions_pvt.route_tbl_type, a0 out nocopy JTF_NUMBER_TABLE);
137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100

Line 141: , a3 JTF_NUMBER_TABLE

137:
138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE

Line 142: , a4 JTF_NUMBER_TABLE

138: procedure rosetta_table_copy_in_p18(t out nocopy ahl_completions_pvt.resource_req_tbl_type, a0 JTF_NUMBER_TABLE
139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE

Line 143: , a5 JTF_NUMBER_TABLE

139: , a1 JTF_VARCHAR2_TABLE_100
140: , a2 JTF_NUMBER_TABLE
141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE

Line 145: , a7 JTF_NUMBER_TABLE

141: , a3 JTF_NUMBER_TABLE
142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100

Line 146: , a8 JTF_NUMBER_TABLE

142: , a4 JTF_NUMBER_TABLE
143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE

Line 147: , a9 JTF_NUMBER_TABLE

143: , a5 JTF_NUMBER_TABLE
144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE
151: , a13 JTF_NUMBER_TABLE

Line 148: , a10 JTF_NUMBER_TABLE

144: , a6 JTF_VARCHAR2_TABLE_100
145: , a7 JTF_NUMBER_TABLE
146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE
151: , a13 JTF_NUMBER_TABLE
152: );

Line 150: , a12 JTF_NUMBER_TABLE

146: , a8 JTF_NUMBER_TABLE
147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE
151: , a13 JTF_NUMBER_TABLE
152: );
153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , a13 JTF_NUMBER_TABLE

147: , a9 JTF_NUMBER_TABLE
148: , a10 JTF_NUMBER_TABLE
149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE
151: , a13 JTF_NUMBER_TABLE
152: );
153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE

Line 153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

149: , a11 JTF_VARCHAR2_TABLE_100
150: , a12 JTF_NUMBER_TABLE
151: , a13 JTF_NUMBER_TABLE
152: );
153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE

Line 155: , a2 out nocopy JTF_NUMBER_TABLE

151: , a13 JTF_NUMBER_TABLE
152: );
153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a3 out nocopy JTF_NUMBER_TABLE

152: );
153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE

Line 157: , a4 out nocopy JTF_NUMBER_TABLE

153: procedure rosetta_table_copy_out_p18(t ahl_completions_pvt.resource_req_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE

Line 158: , a5 out nocopy JTF_NUMBER_TABLE

154: , a1 out nocopy JTF_VARCHAR2_TABLE_100
155: , a2 out nocopy JTF_NUMBER_TABLE
156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE

Line 160: , a7 out nocopy JTF_NUMBER_TABLE

156: , a3 out nocopy JTF_NUMBER_TABLE
157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , a8 out nocopy JTF_NUMBER_TABLE

157: , a4 out nocopy JTF_NUMBER_TABLE
158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_NUMBER_TABLE

Line 162: , a9 out nocopy JTF_NUMBER_TABLE

158: , a5 out nocopy JTF_NUMBER_TABLE
159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_NUMBER_TABLE
166: , a13 out nocopy JTF_NUMBER_TABLE

Line 163: , a10 out nocopy JTF_NUMBER_TABLE

159: , a6 out nocopy JTF_VARCHAR2_TABLE_100
160: , a7 out nocopy JTF_NUMBER_TABLE
161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_NUMBER_TABLE
166: , a13 out nocopy JTF_NUMBER_TABLE
167: );

Line 165: , a12 out nocopy JTF_NUMBER_TABLE

161: , a8 out nocopy JTF_NUMBER_TABLE
162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_NUMBER_TABLE
166: , a13 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure complete_mr_instance(p_api_version NUMBER

Line 166: , a13 out nocopy JTF_NUMBER_TABLE

162: , a9 out nocopy JTF_NUMBER_TABLE
163: , a10 out nocopy JTF_NUMBER_TABLE
164: , a11 out nocopy JTF_VARCHAR2_TABLE_100
165: , a12 out nocopy JTF_NUMBER_TABLE
166: , a13 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure complete_mr_instance(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2

Line 239: , p3_a0 in out nocopy JTF_NUMBER_TABLE

235: );
236: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p3_a0 in out nocopy JTF_NUMBER_TABLE
240: , p3_a1 in out nocopy JTF_NUMBER_TABLE
241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE

Line 240: , p3_a1 in out nocopy JTF_NUMBER_TABLE

236: procedure get_default_op_actual_dates(x_return_status out nocopy VARCHAR2
237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p3_a0 in out nocopy JTF_NUMBER_TABLE
240: , p3_a1 in out nocopy JTF_NUMBER_TABLE
241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE

Line 241: , p3_a2 in out nocopy JTF_NUMBER_TABLE

237: , x_msg_count out nocopy NUMBER
238: , x_msg_data out nocopy VARCHAR2
239: , p3_a0 in out nocopy JTF_NUMBER_TABLE
240: , p3_a1 in out nocopy JTF_NUMBER_TABLE
241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE

Line 243: , p3_a4 in out nocopy JTF_NUMBER_TABLE

239: , p3_a0 in out nocopy JTF_NUMBER_TABLE
240: , p3_a1 in out nocopy JTF_NUMBER_TABLE
241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE

Line 244: , p3_a5 in out nocopy JTF_NUMBER_TABLE

240: , p3_a1 in out nocopy JTF_NUMBER_TABLE
241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE

Line 245: , p3_a6 in out nocopy JTF_NUMBER_TABLE

241: , p3_a2 in out nocopy JTF_NUMBER_TABLE
242: , p3_a3 in out nocopy JTF_VARCHAR2_TABLE_100
243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE

Line 247: , p3_a8 in out nocopy JTF_NUMBER_TABLE

243: , p3_a4 in out nocopy JTF_NUMBER_TABLE
244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE

Line 248: , p3_a9 in out nocopy JTF_NUMBER_TABLE

244: , p3_a5 in out nocopy JTF_NUMBER_TABLE
245: , p3_a6 in out nocopy JTF_NUMBER_TABLE
246: , p3_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
247: , p3_a8 in out nocopy JTF_NUMBER_TABLE
248: , p3_a9 in out nocopy JTF_NUMBER_TABLE
249: , p3_a10 in out nocopy JTF_DATE_TABLE
250: , p3_a11 in out nocopy JTF_DATE_TABLE
251: , p3_a12 in out nocopy JTF_DATE_TABLE
252: , p3_a13 in out nocopy JTF_DATE_TABLE

Line 257: , p1_a0 in out nocopy JTF_NUMBER_TABLE

253: , p3_a14 in out nocopy JTF_VARCHAR2_TABLE_100
254: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
255: );
256: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
257: , p1_a0 in out nocopy JTF_NUMBER_TABLE
258: , p1_a1 in out nocopy JTF_NUMBER_TABLE
259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 258: , p1_a1 in out nocopy JTF_NUMBER_TABLE

254: , p3_a15 in out nocopy JTF_VARCHAR2_TABLE_100
255: );
256: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
257: , p1_a0 in out nocopy JTF_NUMBER_TABLE
258: , p1_a1 in out nocopy JTF_NUMBER_TABLE
259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE

Line 259: , p1_a2 in out nocopy JTF_NUMBER_TABLE

255: );
256: procedure get_op_actual_dates(x_return_status out nocopy VARCHAR2
257: , p1_a0 in out nocopy JTF_NUMBER_TABLE
258: , p1_a1 in out nocopy JTF_NUMBER_TABLE
259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE

Line 261: , p1_a4 in out nocopy JTF_NUMBER_TABLE

257: , p1_a0 in out nocopy JTF_NUMBER_TABLE
258: , p1_a1 in out nocopy JTF_NUMBER_TABLE
259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE

Line 262: , p1_a5 in out nocopy JTF_NUMBER_TABLE

258: , p1_a1 in out nocopy JTF_NUMBER_TABLE
259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE

Line 263: , p1_a6 in out nocopy JTF_NUMBER_TABLE

259: , p1_a2 in out nocopy JTF_NUMBER_TABLE
260: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE

Line 265: , p1_a8 in out nocopy JTF_NUMBER_TABLE

261: , p1_a4 in out nocopy JTF_NUMBER_TABLE
262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE

Line 266: , p1_a9 in out nocopy JTF_NUMBER_TABLE

262: , p1_a5 in out nocopy JTF_NUMBER_TABLE
263: , p1_a6 in out nocopy JTF_NUMBER_TABLE
264: , p1_a7 in out nocopy JTF_VARCHAR2_TABLE_2000
265: , p1_a8 in out nocopy JTF_NUMBER_TABLE
266: , p1_a9 in out nocopy JTF_NUMBER_TABLE
267: , p1_a10 in out nocopy JTF_DATE_TABLE
268: , p1_a11 in out nocopy JTF_DATE_TABLE
269: , p1_a12 in out nocopy JTF_DATE_TABLE
270: , p1_a13 in out nocopy JTF_DATE_TABLE

Line 282: , p3_a0 out nocopy JTF_NUMBER_TABLE

278: ) return varchar2;
279: function get_reset_counters(p_mr_header_id NUMBER
280: , p_item_instance_id NUMBER
281: , p_actual_date date
282: , p3_a0 out nocopy JTF_NUMBER_TABLE
283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 283: , p3_a1 out nocopy JTF_NUMBER_TABLE

279: function get_reset_counters(p_mr_header_id NUMBER
280: , p_item_instance_id NUMBER
281: , p_actual_date date
282: , p3_a0 out nocopy JTF_NUMBER_TABLE
283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 284: , p3_a2 out nocopy JTF_NUMBER_TABLE

280: , p_item_instance_id NUMBER
281: , p_actual_date date
282: , p3_a0 out nocopy JTF_NUMBER_TABLE
283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE
288: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 285: , p3_a3 out nocopy JTF_NUMBER_TABLE

281: , p_actual_date date
282: , p3_a0 out nocopy JTF_NUMBER_TABLE
283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE
288: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
289: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 286: , p3_a4 out nocopy JTF_NUMBER_TABLE

282: , p3_a0 out nocopy JTF_NUMBER_TABLE
283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE
288: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
289: , p3_a7 out nocopy JTF_NUMBER_TABLE
290: ) return varchar2;

Line 287: , p3_a5 out nocopy JTF_NUMBER_TABLE

283: , p3_a1 out nocopy JTF_NUMBER_TABLE
284: , p3_a2 out nocopy JTF_NUMBER_TABLE
285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE
288: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
289: , p3_a7 out nocopy JTF_NUMBER_TABLE
290: ) return varchar2;
291: function reset_counters(p0_a0 NUMBER

Line 289: , p3_a7 out nocopy JTF_NUMBER_TABLE

285: , p3_a3 out nocopy JTF_NUMBER_TABLE
286: , p3_a4 out nocopy JTF_NUMBER_TABLE
287: , p3_a5 out nocopy JTF_NUMBER_TABLE
288: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
289: , p3_a7 out nocopy JTF_NUMBER_TABLE
290: ) return varchar2;
291: function reset_counters(p0_a0 NUMBER
292: , p0_a1 NUMBER
293: , p0_a2 VARCHAR2

Line 303: , p1_a0 in out nocopy JTF_NUMBER_TABLE

299: , p0_a8 NUMBER
300: , p0_a9 NUMBER
301: , p0_a10 NUMBER
302: , p0_a11 DATE
303: , p1_a0 in out nocopy JTF_NUMBER_TABLE
304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE

Line 304: , p1_a1 in out nocopy JTF_NUMBER_TABLE

300: , p0_a9 NUMBER
301: , p0_a10 NUMBER
302: , p0_a11 DATE
303: , p1_a0 in out nocopy JTF_NUMBER_TABLE
304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE

Line 305: , p1_a2 in out nocopy JTF_NUMBER_TABLE

301: , p0_a10 NUMBER
302: , p0_a11 DATE
303: , p1_a0 in out nocopy JTF_NUMBER_TABLE
304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE
309: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p1_a3 in out nocopy JTF_NUMBER_TABLE

302: , p0_a11 DATE
303: , p1_a0 in out nocopy JTF_NUMBER_TABLE
304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE
309: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p1_a7 in out nocopy JTF_NUMBER_TABLE

Line 307: , p1_a4 in out nocopy JTF_NUMBER_TABLE

303: , p1_a0 in out nocopy JTF_NUMBER_TABLE
304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE
309: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p1_a7 in out nocopy JTF_NUMBER_TABLE
311: , p_actual_end_date date

Line 308: , p1_a5 in out nocopy JTF_NUMBER_TABLE

304: , p1_a1 in out nocopy JTF_NUMBER_TABLE
305: , p1_a2 in out nocopy JTF_NUMBER_TABLE
306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE
309: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p1_a7 in out nocopy JTF_NUMBER_TABLE
311: , p_actual_end_date date
312: , x_msg_count out nocopy VARCHAR2

Line 310: , p1_a7 in out nocopy JTF_NUMBER_TABLE

306: , p1_a3 in out nocopy JTF_NUMBER_TABLE
307: , p1_a4 in out nocopy JTF_NUMBER_TABLE
308: , p1_a5 in out nocopy JTF_NUMBER_TABLE
309: , p1_a6 in out nocopy JTF_VARCHAR2_TABLE_100
310: , p1_a7 in out nocopy JTF_NUMBER_TABLE
311: , p_actual_end_date date
312: , x_msg_count out nocopy VARCHAR2
313: , x_msg_data out nocopy VARCHAR2
314: ) return varchar2;

Line 318: , p3_a0 out nocopy JTF_NUMBER_TABLE

314: ) return varchar2;
315: function get_cp_counters(p_item_instance_id NUMBER
316: , p_wip_entity_id NUMBER
317: , p_actual_date date
318: , p3_a0 out nocopy JTF_NUMBER_TABLE
319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 319: , p3_a1 out nocopy JTF_NUMBER_TABLE

315: function get_cp_counters(p_item_instance_id NUMBER
316: , p_wip_entity_id NUMBER
317: , p_actual_date date
318: , p3_a0 out nocopy JTF_NUMBER_TABLE
319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 320: , p3_a2 out nocopy JTF_NUMBER_TABLE

316: , p_wip_entity_id NUMBER
317: , p_actual_date date
318: , p3_a0 out nocopy JTF_NUMBER_TABLE
319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE
324: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , p3_a3 out nocopy JTF_NUMBER_TABLE

317: , p_actual_date date
318: , p3_a0 out nocopy JTF_NUMBER_TABLE
319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE
324: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 322: , p3_a4 out nocopy JTF_NUMBER_TABLE

318: , p3_a0 out nocopy JTF_NUMBER_TABLE
319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE
324: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , p3_a7 out nocopy JTF_NUMBER_TABLE
326: ) return varchar2;

Line 323: , p3_a5 out nocopy JTF_NUMBER_TABLE

319: , p3_a1 out nocopy JTF_NUMBER_TABLE
320: , p3_a2 out nocopy JTF_NUMBER_TABLE
321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE
324: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , p3_a7 out nocopy JTF_NUMBER_TABLE
326: ) return varchar2;
327: function update_ump(p_unit_effectivity_id NUMBER

Line 325: , p3_a7 out nocopy JTF_NUMBER_TABLE

321: , p3_a3 out nocopy JTF_NUMBER_TABLE
322: , p3_a4 out nocopy JTF_NUMBER_TABLE
323: , p3_a5 out nocopy JTF_NUMBER_TABLE
324: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
325: , p3_a7 out nocopy JTF_NUMBER_TABLE
326: ) return varchar2;
327: function update_ump(p_unit_effectivity_id NUMBER
328: , p_ue_object_version NUMBER
329: , p_actual_end_date date

Line 330: , p3_a0 JTF_NUMBER_TABLE

326: ) return varchar2;
327: function update_ump(p_unit_effectivity_id NUMBER
328: , p_ue_object_version NUMBER
329: , p_actual_end_date date
330: , p3_a0 JTF_NUMBER_TABLE
331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE

Line 331: , p3_a1 JTF_NUMBER_TABLE

327: function update_ump(p_unit_effectivity_id NUMBER
328: , p_ue_object_version NUMBER
329: , p_actual_end_date date
330: , p3_a0 JTF_NUMBER_TABLE
331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE

Line 332: , p3_a2 JTF_NUMBER_TABLE

328: , p_ue_object_version NUMBER
329: , p_actual_end_date date
330: , p3_a0 JTF_NUMBER_TABLE
331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE
336: , p3_a6 JTF_VARCHAR2_TABLE_100

Line 333: , p3_a3 JTF_NUMBER_TABLE

329: , p_actual_end_date date
330: , p3_a0 JTF_NUMBER_TABLE
331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE
336: , p3_a6 JTF_VARCHAR2_TABLE_100
337: , p3_a7 JTF_NUMBER_TABLE

Line 334: , p3_a4 JTF_NUMBER_TABLE

330: , p3_a0 JTF_NUMBER_TABLE
331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE
336: , p3_a6 JTF_VARCHAR2_TABLE_100
337: , p3_a7 JTF_NUMBER_TABLE
338: , p_dml_flag VARCHAR2

Line 335: , p3_a5 JTF_NUMBER_TABLE

331: , p3_a1 JTF_NUMBER_TABLE
332: , p3_a2 JTF_NUMBER_TABLE
333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE
336: , p3_a6 JTF_VARCHAR2_TABLE_100
337: , p3_a7 JTF_NUMBER_TABLE
338: , p_dml_flag VARCHAR2
339: , x_msg_count out nocopy VARCHAR2

Line 337: , p3_a7 JTF_NUMBER_TABLE

333: , p3_a3 JTF_NUMBER_TABLE
334: , p3_a4 JTF_NUMBER_TABLE
335: , p3_a5 JTF_NUMBER_TABLE
336: , p3_a6 JTF_VARCHAR2_TABLE_100
337: , p3_a7 JTF_NUMBER_TABLE
338: , p_dml_flag VARCHAR2
339: , x_msg_count out nocopy VARCHAR2
340: , x_msg_data out nocopy VARCHAR2
341: ) return varchar2;