DBA Data[Home] [Help]

APPS.AHL_PRD_RESOURCE_TRANX_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE

1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package ahl_prd_resource_tranx_pvt_w as
2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWTRSS.pls 120.2 2006/01/19 16:47 sikumar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

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

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

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

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_300
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100

Line 17: , a14 JTF_NUMBER_TABLE

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

Line 18: , a15 JTF_NUMBER_TABLE

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

Line 22: , a19 JTF_NUMBER_TABLE

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

Line 23: , a20 JTF_NUMBER_TABLE

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_100

Line 33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_VARCHAR2_TABLE_300
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE

Line 34: , a1 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_DATE_TABLE
31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE

Line 35: , a2 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_DATE_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 36: , a3 out nocopy JTF_NUMBER_TABLE

32: );
33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE

Line 37: , a4 out nocopy JTF_NUMBER_TABLE

33: procedure rosetta_table_copy_out_p1(t ahl_prd_resource_tranx_pvt.prd_resource_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a5 out nocopy JTF_NUMBER_TABLE

34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a10 out nocopy JTF_NUMBER_TABLE

39: , a6 out nocopy JTF_VARCHAR2_TABLE_300
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_300
43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE

Line 45: , a12 out nocopy JTF_NUMBER_TABLE

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

Line 47: , a14 out nocopy JTF_NUMBER_TABLE

43: , a10 out nocopy JTF_NUMBER_TABLE
44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a15 out nocopy JTF_NUMBER_TABLE

44: , a11 out nocopy JTF_VARCHAR2_TABLE_100
45: , a12 out nocopy JTF_NUMBER_TABLE
46: , a13 out nocopy JTF_VARCHAR2_TABLE_100
47: , a14 out nocopy JTF_NUMBER_TABLE
48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE

Line 52: , a19 out nocopy JTF_NUMBER_TABLE

48: , a15 out nocopy JTF_NUMBER_TABLE
49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 53: , a20 out nocopy JTF_NUMBER_TABLE

49: , a16 out nocopy JTF_VARCHAR2_TABLE_100
50: , a17 out nocopy JTF_VARCHAR2_TABLE_100
51: , a18 out nocopy JTF_VARCHAR2_TABLE_100
52: , a19 out nocopy JTF_NUMBER_TABLE
53: , a20 out nocopy JTF_NUMBER_TABLE
54: , a21 out nocopy JTF_VARCHAR2_TABLE_100
55: , a22 out nocopy JTF_VARCHAR2_TABLE_100
56: , a23 out nocopy JTF_VARCHAR2_TABLE_100
57: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE

60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_DATE_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE

Line 65: , a1 JTF_NUMBER_TABLE

61: , a28 out nocopy JTF_DATE_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE

Line 66: , a2 JTF_NUMBER_TABLE

62: );
63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE

Line 67: , a3 JTF_NUMBER_TABLE

63:
64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE

Line 68: , a4 JTF_NUMBER_TABLE

64: procedure rosetta_table_copy_in_p3(t out nocopy ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 JTF_NUMBER_TABLE
65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100

Line 69: , a5 JTF_NUMBER_TABLE

65: , a1 JTF_NUMBER_TABLE
66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE

Line 70: , a6 JTF_NUMBER_TABLE

66: , a2 JTF_NUMBER_TABLE
67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE

Line 71: , a7 JTF_NUMBER_TABLE

67: , a3 JTF_NUMBER_TABLE
68: , a4 JTF_NUMBER_TABLE
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100

Line 73: , a9 JTF_NUMBER_TABLE

69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 74: , a10 JTF_NUMBER_TABLE

70: , a6 JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE

Line 77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE

73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE

Line 78: , a1 out nocopy JTF_NUMBER_TABLE

74: , a10 JTF_NUMBER_TABLE
75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE

Line 79: , a2 out nocopy JTF_NUMBER_TABLE

75: , a11 JTF_VARCHAR2_TABLE_100
76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE

Line 80: , a3 out nocopy JTF_NUMBER_TABLE

76: );
77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE

Line 81: , a4 out nocopy JTF_NUMBER_TABLE

77: procedure rosetta_table_copy_out_p3(t ahl_prd_resource_tranx_pvt.prd_myworkorder_txns_tbl, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a5 out nocopy JTF_NUMBER_TABLE

78: , a1 out nocopy JTF_NUMBER_TABLE
79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE

Line 83: , a6 out nocopy JTF_NUMBER_TABLE

79: , a2 out nocopy JTF_NUMBER_TABLE
80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE

Line 84: , a7 out nocopy JTF_NUMBER_TABLE

80: , a3 out nocopy JTF_NUMBER_TABLE
81: , a4 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a9 out nocopy JTF_NUMBER_TABLE

82: , a5 out nocopy JTF_NUMBER_TABLE
83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:

Line 87: , a10 out nocopy JTF_NUMBER_TABLE

83: , a6 out nocopy JTF_NUMBER_TABLE
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_VARCHAR2_TABLE_100
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_NUMBER_TABLE
88: , a11 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure process_resource_txns(p_api_version NUMBER

Line 100: , p9_a0 in out nocopy JTF_NUMBER_TABLE

96: , p_module_type VARCHAR2
97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE

Line 101: , p9_a1 in out nocopy JTF_NUMBER_TABLE

97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 102: , p9_a2 in out nocopy JTF_NUMBER_TABLE

98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300

Line 103: , p9_a3 in out nocopy JTF_NUMBER_TABLE

99: , x_msg_data out nocopy VARCHAR2
100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 104: , p9_a4 in out nocopy JTF_NUMBER_TABLE

100: , p9_a0 in out nocopy JTF_NUMBER_TABLE
101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 105: , p9_a5 in out nocopy JTF_NUMBER_TABLE

101: , p9_a1 in out nocopy JTF_NUMBER_TABLE
102: , p9_a2 in out nocopy JTF_NUMBER_TABLE
103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300

Line 107: , p9_a7 in out nocopy JTF_NUMBER_TABLE

103: , p9_a3 in out nocopy JTF_NUMBER_TABLE
104: , p9_a4 in out nocopy JTF_NUMBER_TABLE
105: , p9_a5 in out nocopy JTF_NUMBER_TABLE
106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , p9_a10 in out nocopy JTF_NUMBER_TABLE

106: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
107: , p9_a7 in out nocopy JTF_NUMBER_TABLE
108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE

Line 112: , p9_a12 in out nocopy JTF_NUMBER_TABLE

108: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
109: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_300
110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , p9_a14 in out nocopy JTF_NUMBER_TABLE

110: , p9_a10 in out nocopy JTF_NUMBER_TABLE
111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 115: , p9_a15 in out nocopy JTF_NUMBER_TABLE

111: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
112: , p9_a12 in out nocopy JTF_NUMBER_TABLE
113: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p9_a14 in out nocopy JTF_NUMBER_TABLE
115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE

Line 119: , p9_a19 in out nocopy JTF_NUMBER_TABLE

115: , p9_a15 in out nocopy JTF_NUMBER_TABLE
116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE
120: , p9_a20 in out nocopy JTF_NUMBER_TABLE
121: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
123: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p9_a20 in out nocopy JTF_NUMBER_TABLE

116: , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_100
117: , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_100
118: , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_100
119: , p9_a19 in out nocopy JTF_NUMBER_TABLE
120: , p9_a20 in out nocopy JTF_NUMBER_TABLE
121: , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_100
123: , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_100
124: , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , p9_a0 in out nocopy JTF_NUMBER_TABLE

135: , p_module_type VARCHAR2
136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE

Line 140: , p9_a1 in out nocopy JTF_NUMBER_TABLE

136: , x_return_status out nocopy VARCHAR2
137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 141: , p9_a2 in out nocopy JTF_NUMBER_TABLE

137: , x_msg_count out nocopy NUMBER
138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE

Line 142: , p9_a3 in out nocopy JTF_NUMBER_TABLE

138: , x_msg_data out nocopy VARCHAR2
139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 143: , p9_a4 in out nocopy JTF_NUMBER_TABLE

139: , p9_a0 in out nocopy JTF_NUMBER_TABLE
140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

Line 144: , p9_a5 in out nocopy JTF_NUMBER_TABLE

140: , p9_a1 in out nocopy JTF_NUMBER_TABLE
141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE

Line 145: , p9_a6 in out nocopy JTF_NUMBER_TABLE

141: , p9_a2 in out nocopy JTF_NUMBER_TABLE
142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE

Line 146: , p9_a7 in out nocopy JTF_NUMBER_TABLE

142: , p9_a3 in out nocopy JTF_NUMBER_TABLE
143: , p9_a4 in out nocopy JTF_NUMBER_TABLE
144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 148: , p9_a9 in out nocopy JTF_NUMBER_TABLE

144: , p9_a5 in out nocopy JTF_NUMBER_TABLE
145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: procedure get_resource_txn_defaults(p_api_version NUMBER

Line 149: , p9_a10 in out nocopy JTF_NUMBER_TABLE

145: , p9_a6 in out nocopy JTF_NUMBER_TABLE
146: , p9_a7 in out nocopy JTF_NUMBER_TABLE
147: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
148: , p9_a9 in out nocopy JTF_NUMBER_TABLE
149: , p9_a10 in out nocopy JTF_NUMBER_TABLE
150: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
151: );
152: procedure get_resource_txn_defaults(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2

Line 162: , p10_a0 out nocopy JTF_NUMBER_TABLE

158: , p_employee_id NUMBER
159: , p_workorder_id NUMBER
160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE

Line 163: , p10_a1 out nocopy JTF_NUMBER_TABLE

159: , p_workorder_id NUMBER
160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE

Line 164: , p10_a2 out nocopy JTF_NUMBER_TABLE

160: , p_operation_seq_num NUMBER
161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 165: , p10_a3 out nocopy JTF_NUMBER_TABLE

161: , p_function_name VARCHAR2
162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE

Line 166: , p10_a4 out nocopy JTF_NUMBER_TABLE

162: , p10_a0 out nocopy JTF_NUMBER_TABLE
163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p10_a5 out nocopy JTF_NUMBER_TABLE

163: , p10_a1 out nocopy JTF_NUMBER_TABLE
164: , p10_a2 out nocopy JTF_NUMBER_TABLE
165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300

Line 169: , p10_a7 out nocopy JTF_NUMBER_TABLE

165: , p10_a3 out nocopy JTF_NUMBER_TABLE
166: , p10_a4 out nocopy JTF_NUMBER_TABLE
167: , p10_a5 out nocopy JTF_NUMBER_TABLE
168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 172: , p10_a10 out nocopy JTF_NUMBER_TABLE

168: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_300
169: , p10_a7 out nocopy JTF_NUMBER_TABLE
170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE

Line 174: , p10_a12 out nocopy JTF_NUMBER_TABLE

170: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p10_a9 out nocopy JTF_VARCHAR2_TABLE_300
172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , p10_a14 out nocopy JTF_NUMBER_TABLE

172: , p10_a10 out nocopy JTF_NUMBER_TABLE
173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 177: , p10_a15 out nocopy JTF_NUMBER_TABLE

173: , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
174: , p10_a12 out nocopy JTF_NUMBER_TABLE
175: , p10_a13 out nocopy JTF_VARCHAR2_TABLE_100
176: , p10_a14 out nocopy JTF_NUMBER_TABLE
177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE

Line 181: , p10_a19 out nocopy JTF_NUMBER_TABLE

177: , p10_a15 out nocopy JTF_NUMBER_TABLE
178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE
182: , p10_a20 out nocopy JTF_NUMBER_TABLE
183: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
184: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
185: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , p10_a20 out nocopy JTF_NUMBER_TABLE

178: , p10_a16 out nocopy JTF_VARCHAR2_TABLE_100
179: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
180: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
181: , p10_a19 out nocopy JTF_NUMBER_TABLE
182: , p10_a20 out nocopy JTF_NUMBER_TABLE
183: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_100
184: , p10_a22 out nocopy JTF_VARCHAR2_TABLE_100
185: , p10_a23 out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a24 out nocopy JTF_VARCHAR2_TABLE_100