APPS.CSP_SCH_INT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE

1: package csp_sch_int_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cspvscis.pls 120.6.12020000.2 2012/07/17 08:04:34 htank ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

2: /* $Header: cspvscis.pls 120.6.12020000.2 2012/07/17 08:04:34 htank ship $ */
3: procedure rosetta_table_copy_in_p13(t out nocopy csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE

Line 10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE

6: procedure rosetta_table_copy_out_p13(t csp_sch_int_pvt.csp_sch_resource_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_NUMBER_TABLE

Line 13: , a3 JTF_NUMBER_TABLE

9:
10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_4000
17: , a7 JTF_VARCHAR2_TABLE_4000

Line 14: , a4 JTF_NUMBER_TABLE

10: procedure rosetta_table_copy_in_p14(t out nocopy csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 JTF_NUMBER_TABLE
11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_4000
17: , a7 JTF_VARCHAR2_TABLE_4000
18: , a8 JTF_VARCHAR2_TABLE_4000

Line 15: , a5 JTF_NUMBER_TABLE

11: , a1 JTF_VARCHAR2_TABLE_100
12: , a2 JTF_DATE_TABLE
13: , a3 JTF_NUMBER_TABLE
14: , a4 JTF_NUMBER_TABLE
15: , a5 JTF_NUMBER_TABLE
16: , a6 JTF_VARCHAR2_TABLE_4000
17: , a7 JTF_VARCHAR2_TABLE_4000
18: , a8 JTF_VARCHAR2_TABLE_4000
19: );

Line 20: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

16: , a6 JTF_VARCHAR2_TABLE_4000
17: , a7 JTF_VARCHAR2_TABLE_4000
18: , a8 JTF_VARCHAR2_TABLE_4000
19: );
20: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_VARCHAR2_TABLE_100
22: , a2 out nocopy JTF_DATE_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE

Line 23: , a3 out nocopy JTF_NUMBER_TABLE

19: );
20: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_VARCHAR2_TABLE_100
22: , a2 out nocopy JTF_DATE_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_NUMBER_TABLE
26: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
27: , a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 24: , a4 out nocopy JTF_NUMBER_TABLE

20: procedure rosetta_table_copy_out_p14(t csp_sch_int_pvt.csp_sch_options_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_VARCHAR2_TABLE_100
22: , a2 out nocopy JTF_DATE_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_NUMBER_TABLE
26: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
27: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
28: , a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 25: , a5 out nocopy JTF_NUMBER_TABLE

21: , a1 out nocopy JTF_VARCHAR2_TABLE_100
22: , a2 out nocopy JTF_DATE_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_NUMBER_TABLE
26: , a6 out nocopy JTF_VARCHAR2_TABLE_4000
27: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
28: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
29: );

Line 31: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE

27: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
28: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
29: );
30:
31: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
32: , a1 JTF_VARCHAR2_TABLE_100
33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100

Line 33: , a2 JTF_NUMBER_TABLE

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

Line 34: , a3 JTF_NUMBER_TABLE

30:
31: procedure rosetta_table_copy_in_p15(t out nocopy csp_sch_int_pvt.csp_unavailability_tbl_type, a0 JTF_NUMBER_TABLE
32: , a1 JTF_VARCHAR2_TABLE_100
33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE

Line 37: , a6 JTF_NUMBER_TABLE

33: , a2 JTF_NUMBER_TABLE
34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );

Line 38: , a7 JTF_NUMBER_TABLE

34: , a3 JTF_NUMBER_TABLE
35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 39: , a8 JTF_NUMBER_TABLE

35: , a4 JTF_VARCHAR2_TABLE_100
36: , a5 JTF_VARCHAR2_TABLE_100
37: , a6 JTF_NUMBER_TABLE
38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: , a7 JTF_NUMBER_TABLE
39: , a8 JTF_NUMBER_TABLE
40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a2 out nocopy JTF_NUMBER_TABLE

40: , a9 JTF_VARCHAR2_TABLE_100
41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE

Line 45: , a3 out nocopy JTF_NUMBER_TABLE

41: );
42: procedure rosetta_table_copy_out_p15(t csp_sch_int_pvt.csp_unavailability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_VARCHAR2_TABLE_100
44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE

Line 48: , a6 out nocopy JTF_NUMBER_TABLE

44: , a2 out nocopy JTF_NUMBER_TABLE
45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );

Line 49: , a7 out nocopy JTF_NUMBER_TABLE

45: , a3 out nocopy JTF_NUMBER_TABLE
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:

Line 50: , a8 out nocopy JTF_NUMBER_TABLE

46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE

Line 54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE

50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_NUMBER_TABLE
58: , a4 JTF_NUMBER_TABLE

Line 56: , a2 JTF_NUMBER_TABLE

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

Line 57: , a3 JTF_NUMBER_TABLE

53:
54: procedure rosetta_table_copy_in_p16(t out nocopy csp_sch_int_pvt.csp_availability_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_VARCHAR2_TABLE_100
56: , a2 JTF_NUMBER_TABLE
57: , a3 JTF_NUMBER_TABLE
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_NUMBER_TABLE

Line 58: , a4 JTF_NUMBER_TABLE

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

Line 59: , a5 JTF_NUMBER_TABLE

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

Line 61: , a7 JTF_NUMBER_TABLE

57: , a3 JTF_NUMBER_TABLE
58: , a4 JTF_NUMBER_TABLE
59: , a5 JTF_NUMBER_TABLE
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE

Line 63: , a9 JTF_NUMBER_TABLE

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

Line 64: , a10 JTF_NUMBER_TABLE

60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100

Line 65: , a11 JTF_NUMBER_TABLE

61: , a7 JTF_NUMBER_TABLE
62: , a8 JTF_VARCHAR2_TABLE_100
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_NUMBER_TABLE
65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE

Line 69: , a15 JTF_NUMBER_TABLE

65: , a11 JTF_NUMBER_TABLE
66: , a12 JTF_VARCHAR2_TABLE_100
67: , a13 JTF_DATE_TABLE
68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

68: , a14 JTF_VARCHAR2_TABLE_100
69: , a15 JTF_NUMBER_TABLE
70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE

Line 74: , a2 out nocopy JTF_NUMBER_TABLE

70: , a16 JTF_VARCHAR2_TABLE_100
71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , a3 out nocopy JTF_NUMBER_TABLE

71: );
72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , a7 out nocopy JTF_NUMBER_TABLE

Line 76: , a4 out nocopy JTF_NUMBER_TABLE

72: procedure rosetta_table_copy_out_p16(t csp_sch_int_pvt.csp_availability_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_NUMBER_TABLE
78: , a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 79: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 81: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 82: , a10 out nocopy JTF_NUMBER_TABLE

78: , a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , a11 out nocopy JTF_NUMBER_TABLE

79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_NUMBER_TABLE
82: , a10 out nocopy JTF_NUMBER_TABLE
83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a15 out nocopy JTF_NUMBER_TABLE

Line 87: , a15 out nocopy JTF_NUMBER_TABLE

83: , a11 out nocopy JTF_NUMBER_TABLE
84: , a12 out nocopy JTF_VARCHAR2_TABLE_100
85: , a13 out nocopy JTF_DATE_TABLE
86: , a14 out nocopy JTF_VARCHAR2_TABLE_100
87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE

Line 91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE

87: , a15 out nocopy JTF_NUMBER_TABLE
88: , a16 out nocopy JTF_VARCHAR2_TABLE_100
89: );
90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100

Line 94: , a3 JTF_NUMBER_TABLE

90:
91: procedure rosetta_table_copy_in_p17(t out nocopy csp_sch_int_pvt.csp_parts_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 96: , a5 JTF_NUMBER_TABLE

92: , a1 JTF_VARCHAR2_TABLE_100
93: , a2 JTF_VARCHAR2_TABLE_100
94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

94: , a3 JTF_NUMBER_TABLE
95: , a4 JTF_VARCHAR2_TABLE_100
96: , a5 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 101: , a3 out nocopy JTF_NUMBER_TABLE

97: );
98: procedure rosetta_table_copy_out_p17(t csp_sch_int_pvt.csp_parts_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE
104: );
105:

Line 103: , a5 out nocopy JTF_NUMBER_TABLE

99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_NUMBER_TABLE
102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100

Line 106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

102: , a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , a5 out nocopy JTF_NUMBER_TABLE
104: );
105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100

Line 108: , a2 JTF_NUMBER_TABLE

104: );
105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE

Line 109: , a3 JTF_NUMBER_TABLE

105:
106: procedure rosetta_table_copy_in_p18(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE

Line 111: , a5 JTF_NUMBER_TABLE

107: , a1 JTF_VARCHAR2_TABLE_100
108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE

Line 112: , a6 JTF_NUMBER_TABLE

108: , a2 JTF_NUMBER_TABLE
109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE

Line 113: , a7 JTF_NUMBER_TABLE

109: , a3 JTF_NUMBER_TABLE
110: , a4 JTF_VARCHAR2_TABLE_100
111: , a5 JTF_NUMBER_TABLE
112: , a6 JTF_NUMBER_TABLE
113: , a7 JTF_NUMBER_TABLE
114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100

Line 118: , a12 JTF_NUMBER_TABLE

114: , a8 JTF_VARCHAR2_TABLE_100
115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );

Line 119: , a13 JTF_NUMBER_TABLE

115: , a9 JTF_DATE_TABLE
116: , a10 JTF_DATE_TABLE
117: , a11 JTF_VARCHAR2_TABLE_100
118: , a12 JTF_NUMBER_TABLE
119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

Line 123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

119: , a13 JTF_NUMBER_TABLE
120: , a14 JTF_VARCHAR2_TABLE_100
121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , a2 out nocopy JTF_NUMBER_TABLE

121: , a15 JTF_VARCHAR2_TABLE_100
122: );
123: procedure rosetta_table_copy_out_p18(t csp_sch_int_pvt.available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE

Line 126: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 128: , a5 out nocopy JTF_NUMBER_TABLE

124: , a1 out nocopy JTF_VARCHAR2_TABLE_100
125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE

Line 129: , a6 out nocopy JTF_NUMBER_TABLE

125: , a2 out nocopy JTF_NUMBER_TABLE
126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE

Line 130: , a7 out nocopy JTF_NUMBER_TABLE

126: , a3 out nocopy JTF_NUMBER_TABLE
127: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a5 out nocopy JTF_NUMBER_TABLE
129: , a6 out nocopy JTF_NUMBER_TABLE
130: , a7 out nocopy JTF_NUMBER_TABLE
131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , a12 out nocopy JTF_NUMBER_TABLE

131: , a8 out nocopy JTF_VARCHAR2_TABLE_100
132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );

Line 136: , a13 out nocopy JTF_NUMBER_TABLE

132: , a9 out nocopy JTF_DATE_TABLE
133: , a10 out nocopy JTF_DATE_TABLE
134: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a12 out nocopy JTF_NUMBER_TABLE
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:

Line 141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

137: , a14 out nocopy JTF_VARCHAR2_TABLE_100
138: , a15 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100

Line 143: , a2 JTF_NUMBER_TABLE

139: );
140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE

Line 144: , a3 JTF_NUMBER_TABLE

140:
141: procedure rosetta_table_copy_in_p19(t out nocopy csp_sch_int_pvt.available_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE

Line 146: , a5 JTF_NUMBER_TABLE

142: , a1 JTF_VARCHAR2_TABLE_100
143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE

Line 147: , a6 JTF_NUMBER_TABLE

143: , a2 JTF_NUMBER_TABLE
144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE

Line 148: , a7 JTF_NUMBER_TABLE

144: , a3 JTF_NUMBER_TABLE
145: , a4 JTF_VARCHAR2_TABLE_100
146: , a5 JTF_NUMBER_TABLE
147: , a6 JTF_NUMBER_TABLE
148: , a7 JTF_NUMBER_TABLE
149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100

Line 153: , a12 JTF_NUMBER_TABLE

149: , a8 JTF_VARCHAR2_TABLE_100
150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE
154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );

Line 154: , a13 JTF_NUMBER_TABLE

150: , a9 JTF_DATE_TABLE
151: , a10 JTF_DATE_TABLE
152: , a11 JTF_VARCHAR2_TABLE_100
153: , a12 JTF_NUMBER_TABLE
154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

Line 158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

154: , a13 JTF_NUMBER_TABLE
155: , a14 JTF_VARCHAR2_TABLE_100
156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 160: , a2 out nocopy JTF_NUMBER_TABLE

156: , a15 JTF_VARCHAR2_TABLE_100
157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE

Line 161: , a3 out nocopy JTF_NUMBER_TABLE

157: );
158: procedure rosetta_table_copy_out_p19(t csp_sch_int_pvt.available_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE

Line 163: , a5 out nocopy JTF_NUMBER_TABLE

159: , a1 out nocopy JTF_VARCHAR2_TABLE_100
160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE

Line 164: , a6 out nocopy JTF_NUMBER_TABLE

160: , a2 out nocopy JTF_NUMBER_TABLE
161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE

Line 165: , a7 out nocopy JTF_NUMBER_TABLE

161: , a3 out nocopy JTF_NUMBER_TABLE
162: , a4 out nocopy JTF_VARCHAR2_TABLE_100
163: , a5 out nocopy JTF_NUMBER_TABLE
164: , a6 out nocopy JTF_NUMBER_TABLE
165: , a7 out nocopy JTF_NUMBER_TABLE
166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , a12 out nocopy JTF_NUMBER_TABLE

166: , a8 out nocopy JTF_VARCHAR2_TABLE_100
167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE
171: , a13 out nocopy JTF_NUMBER_TABLE
172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );

Line 171: , a13 out nocopy JTF_NUMBER_TABLE

167: , a9 out nocopy JTF_DATE_TABLE
168: , a10 out nocopy JTF_DATE_TABLE
169: , a11 out nocopy JTF_VARCHAR2_TABLE_100
170: , a12 out nocopy JTF_NUMBER_TABLE
171: , a13 out nocopy JTF_NUMBER_TABLE
172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );
175:

Line 176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE

172: , a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , a15 out nocopy JTF_VARCHAR2_TABLE_100
174: );
175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100

Line 179: , a3 JTF_NUMBER_TABLE

175:
176: procedure rosetta_table_copy_in_p20(t out nocopy csp_sch_int_pvt.csp_parts_tbl_typ1, a0 JTF_NUMBER_TABLE
177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

Line 181: , a5 JTF_NUMBER_TABLE

177: , a1 JTF_VARCHAR2_TABLE_100
178: , a2 JTF_VARCHAR2_TABLE_100
179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE

179: , a3 JTF_NUMBER_TABLE
180: , a4 JTF_VARCHAR2_TABLE_100
181: , a5 JTF_NUMBER_TABLE
182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 186: , a3 out nocopy JTF_NUMBER_TABLE

182: );
183: procedure rosetta_table_copy_out_p20(t csp_sch_int_pvt.csp_parts_tbl_typ1, a0 out nocopy JTF_NUMBER_TABLE
184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE
189: );
190:

Line 188: , a5 out nocopy JTF_NUMBER_TABLE

184: , a1 out nocopy JTF_VARCHAR2_TABLE_100
185: , a2 out nocopy JTF_VARCHAR2_TABLE_100
186: , a3 out nocopy JTF_NUMBER_TABLE
187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE
189: );
190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100

Line 191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE

187: , a4 out nocopy JTF_VARCHAR2_TABLE_100
188: , a5 out nocopy JTF_NUMBER_TABLE
189: );
190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100
193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100

Line 193: , a2 JTF_NUMBER_TABLE

189: );
190:
191: procedure rosetta_table_copy_in_p21(t out nocopy csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 JTF_NUMBER_TABLE
192: , a1 JTF_VARCHAR2_TABLE_100
193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE

Line 197: , a6 JTF_NUMBER_TABLE

193: , a2 JTF_NUMBER_TABLE
194: , a3 JTF_VARCHAR2_TABLE_100
195: , a4 JTF_VARCHAR2_TABLE_100
196: , a5 JTF_VARCHAR2_TABLE_300
197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE

Line 201: , a10 JTF_NUMBER_TABLE

197: , a6 JTF_NUMBER_TABLE
198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE

Line 202: , a11 JTF_NUMBER_TABLE

198: , a7 JTF_VARCHAR2_TABLE_300
199: , a8 JTF_VARCHAR2_TABLE_100
200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100

Line 204: , a13 JTF_NUMBER_TABLE

200: , a9 JTF_VARCHAR2_TABLE_100
201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE

Line 205: , a14 JTF_NUMBER_TABLE

201: , a10 JTF_NUMBER_TABLE
202: , a11 JTF_NUMBER_TABLE
203: , a12 JTF_VARCHAR2_TABLE_100
204: , a13 JTF_NUMBER_TABLE
205: , a14 JTF_NUMBER_TABLE
206: , a15 JTF_VARCHAR2_TABLE_100
207: , a16 JTF_VARCHAR2_TABLE_100
208: , a17 JTF_DATE_TABLE
209: , a18 JTF_DATE_TABLE

Line 213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE

209: , a18 JTF_DATE_TABLE
210: , a19 JTF_VARCHAR2_TABLE_100
211: , a20 JTF_VARCHAR2_TABLE_100
212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 215: , a2 out nocopy JTF_NUMBER_TABLE

211: , a20 JTF_VARCHAR2_TABLE_100
212: );
213: procedure rosetta_table_copy_out_p21(t csp_sch_int_pvt.ws_available_parts_tbl_typ, a0 out nocopy JTF_NUMBER_TABLE
214: , a1 out nocopy JTF_VARCHAR2_TABLE_100
215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE

Line 219: , a6 out nocopy JTF_NUMBER_TABLE

215: , a2 out nocopy JTF_NUMBER_TABLE
216: , a3 out nocopy JTF_VARCHAR2_TABLE_100
217: , a4 out nocopy JTF_VARCHAR2_TABLE_100
218: , a5 out nocopy JTF_VARCHAR2_TABLE_300
219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE

Line 223: , a10 out nocopy JTF_NUMBER_TABLE

219: , a6 out nocopy JTF_NUMBER_TABLE
220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE

Line 224: , a11 out nocopy JTF_NUMBER_TABLE

220: , a7 out nocopy JTF_VARCHAR2_TABLE_300
221: , a8 out nocopy JTF_VARCHAR2_TABLE_100
222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 226: , a13 out nocopy JTF_NUMBER_TABLE

222: , a9 out nocopy JTF_VARCHAR2_TABLE_100
223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE

Line 227: , a14 out nocopy JTF_NUMBER_TABLE

223: , a10 out nocopy JTF_NUMBER_TABLE
224: , a11 out nocopy JTF_NUMBER_TABLE
225: , a12 out nocopy JTF_VARCHAR2_TABLE_100
226: , a13 out nocopy JTF_NUMBER_TABLE
227: , a14 out nocopy JTF_NUMBER_TABLE
228: , a15 out nocopy JTF_VARCHAR2_TABLE_100
229: , a16 out nocopy JTF_VARCHAR2_TABLE_100
230: , a17 out nocopy JTF_DATE_TABLE
231: , a18 out nocopy JTF_DATE_TABLE

Line 237: , a1 JTF_NUMBER_TABLE

233: , a20 out nocopy JTF_VARCHAR2_TABLE_100
234: );
235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE
238: , a2 JTF_NUMBER_TABLE
239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300

Line 238: , a2 JTF_NUMBER_TABLE

234: );
235:
236: procedure rosetta_table_copy_in_p22(t out nocopy csp_sch_int_pvt.csp_ws_resource_table_type, a0 JTF_VARCHAR2_TABLE_100
237: , a1 JTF_NUMBER_TABLE
238: , a2 JTF_NUMBER_TABLE
239: , a3 JTF_VARCHAR2_TABLE_100
240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300
242: );

Line 244: , a1 out nocopy JTF_NUMBER_TABLE

240: , a4 JTF_VARCHAR2_TABLE_100
241: , a5 JTF_VARCHAR2_TABLE_300
242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE
245: , a2 out nocopy JTF_NUMBER_TABLE
246: , a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 245: , a2 out nocopy JTF_NUMBER_TABLE

241: , a5 JTF_VARCHAR2_TABLE_300
242: );
243: procedure rosetta_table_copy_out_p22(t csp_sch_int_pvt.csp_ws_resource_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
244: , a1 out nocopy JTF_NUMBER_TABLE
245: , a2 out nocopy JTF_NUMBER_TABLE
246: , a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , a5 out nocopy JTF_VARCHAR2_TABLE_300
249: );

Line 251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE

247: , a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , a5 out nocopy JTF_VARCHAR2_TABLE_300
249: );
250:
251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE

Line 254: , a3 JTF_NUMBER_TABLE

250:
251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE

Line 255: , a4 JTF_NUMBER_TABLE

251: procedure rosetta_table_copy_in_p23(t out nocopy csp_sch_int_pvt.alternate_items_table_type, a0 JTF_NUMBER_TABLE
252: , a1 JTF_VARCHAR2_TABLE_100
253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );

Line 257: , a6 JTF_NUMBER_TABLE

253: , a2 JTF_VARCHAR2_TABLE_100
254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 258: , a7 JTF_NUMBER_TABLE

254: , a3 JTF_NUMBER_TABLE
255: , a4 JTF_NUMBER_TABLE
256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE

256: , a5 JTF_VARCHAR2_TABLE_100
257: , a6 JTF_NUMBER_TABLE
258: , a7 JTF_NUMBER_TABLE
259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE

Line 263: , a3 out nocopy JTF_NUMBER_TABLE

259: );
260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE
267: , a7 out nocopy JTF_NUMBER_TABLE

Line 264: , a4 out nocopy JTF_NUMBER_TABLE

260: procedure rosetta_table_copy_out_p23(t csp_sch_int_pvt.alternate_items_table_type, a0 out nocopy JTF_NUMBER_TABLE
261: , a1 out nocopy JTF_VARCHAR2_TABLE_100
262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE
267: , a7 out nocopy JTF_NUMBER_TABLE
268: );

Line 266: , a6 out nocopy JTF_NUMBER_TABLE

262: , a2 out nocopy JTF_VARCHAR2_TABLE_100
263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE
267: , a7 out nocopy JTF_NUMBER_TABLE
268: );
269:
270: procedure get_availability_options(p_api_version_number NUMBER

Line 267: , a7 out nocopy JTF_NUMBER_TABLE

263: , a3 out nocopy JTF_NUMBER_TABLE
264: , a4 out nocopy JTF_NUMBER_TABLE
265: , a5 out nocopy JTF_VARCHAR2_TABLE_100
266: , a6 out nocopy JTF_NUMBER_TABLE
267: , a7 out nocopy JTF_NUMBER_TABLE
268: );
269:
270: procedure get_availability_options(p_api_version_number NUMBER
271: , p_task_id NUMBER

Line 272: , p2_a0 JTF_NUMBER_TABLE

268: );
269:
270: procedure get_availability_options(p_api_version_number NUMBER
271: , p_task_id NUMBER
272: , p2_a0 JTF_NUMBER_TABLE
273: , p2_a1 JTF_VARCHAR2_TABLE_100
274: , p3_a0 DATE
275: , p3_a1 DATE
276: , p_likelihood NUMBER

Line 281: , p9_a0 out nocopy JTF_NUMBER_TABLE

277: , p_subinv_only number
278: , p_mandatory number
279: , p_trunk number
280: , p_warehouse number
281: , p9_a0 out nocopy JTF_NUMBER_TABLE
282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a2 out nocopy JTF_DATE_TABLE
284: , p9_a3 out nocopy JTF_NUMBER_TABLE
285: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 284: , p9_a3 out nocopy JTF_NUMBER_TABLE

280: , p_warehouse number
281: , p9_a0 out nocopy JTF_NUMBER_TABLE
282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a2 out nocopy JTF_DATE_TABLE
284: , p9_a3 out nocopy JTF_NUMBER_TABLE
285: , p9_a4 out nocopy JTF_NUMBER_TABLE
286: , p9_a5 out nocopy JTF_NUMBER_TABLE
287: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
288: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 285: , p9_a4 out nocopy JTF_NUMBER_TABLE

281: , p9_a0 out nocopy JTF_NUMBER_TABLE
282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a2 out nocopy JTF_DATE_TABLE
284: , p9_a3 out nocopy JTF_NUMBER_TABLE
285: , p9_a4 out nocopy JTF_NUMBER_TABLE
286: , p9_a5 out nocopy JTF_NUMBER_TABLE
287: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
288: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000
289: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 286: , p9_a5 out nocopy JTF_NUMBER_TABLE

282: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p9_a2 out nocopy JTF_DATE_TABLE
284: , p9_a3 out nocopy JTF_NUMBER_TABLE
285: , p9_a4 out nocopy JTF_NUMBER_TABLE
286: , p9_a5 out nocopy JTF_NUMBER_TABLE
287: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_4000
288: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_4000
289: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_4000
290: , x_return_status out nocopy VARCHAR2

Line 319: , p4_a0 JTF_NUMBER_TABLE

315: , p0_a1 VARCHAR2
316: , p_organization_id NUMBER
317: , p_subinv_code VARCHAR2
318: , p_need_by_date date
319: , p4_a0 JTF_NUMBER_TABLE
320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 322: , p4_a3 JTF_NUMBER_TABLE

318: , p_need_by_date date
319: , p4_a0 JTF_NUMBER_TABLE
320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 324: , p4_a5 JTF_NUMBER_TABLE

320: , p4_a1 JTF_VARCHAR2_TABLE_100
321: , p4_a2 JTF_VARCHAR2_TABLE_100
322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 326: , p6_a0 out nocopy JTF_NUMBER_TABLE

322: , p4_a3 JTF_NUMBER_TABLE
323: , p4_a4 JTF_VARCHAR2_TABLE_100
324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 328: , p6_a2 out nocopy JTF_NUMBER_TABLE

324: , p4_a5 JTF_NUMBER_TABLE
325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 329: , p6_a3 out nocopy JTF_NUMBER_TABLE

325: , p_timezone_id NUMBER
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 331: , p6_a5 out nocopy JTF_NUMBER_TABLE

327: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE

Line 332: , p6_a6 out nocopy JTF_NUMBER_TABLE

328: , p6_a2 out nocopy JTF_NUMBER_TABLE
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE

Line 333: , p6_a7 out nocopy JTF_NUMBER_TABLE

329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_NUMBER_TABLE
333: , p6_a7 out nocopy JTF_NUMBER_TABLE
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 338: , p6_a12 out nocopy JTF_NUMBER_TABLE

334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE
339: , p6_a13 out nocopy JTF_NUMBER_TABLE
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
342: , x_return_status out nocopy VARCHAR2

Line 339: , p6_a13 out nocopy JTF_NUMBER_TABLE

335: , p6_a9 out nocopy JTF_DATE_TABLE
336: , p6_a10 out nocopy JTF_DATE_TABLE
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a12 out nocopy JTF_NUMBER_TABLE
339: , p6_a13 out nocopy JTF_NUMBER_TABLE
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
341: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
342: , x_return_status out nocopy VARCHAR2
343: , x_msg_data out nocopy VARCHAR2

Line 360: , p0_a1 JTF_NUMBER_TABLE

356: , x_return_status out nocopy VARCHAR2
357: , x_msg_data out nocopy VARCHAR2
358: ) return number;
359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360: , p0_a1 JTF_NUMBER_TABLE
361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300

Line 361: , p0_a2 JTF_NUMBER_TABLE

357: , x_msg_data out nocopy VARCHAR2
358: ) return number;
359: procedure ws_check_other_eng_subinv(p0_a0 JTF_VARCHAR2_TABLE_100
360: , p0_a1 JTF_NUMBER_TABLE
361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE

Line 365: , p1_a0 JTF_NUMBER_TABLE

361: , p0_a2 JTF_NUMBER_TABLE
362: , p0_a3 JTF_VARCHAR2_TABLE_100
363: , p0_a4 JTF_VARCHAR2_TABLE_100
364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100

Line 368: , p1_a3 JTF_NUMBER_TABLE

364: , p0_a5 JTF_VARCHAR2_TABLE_300
365: , p1_a0 JTF_NUMBER_TABLE
366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE

Line 370: , p1_a5 JTF_NUMBER_TABLE

366: , p1_a1 JTF_VARCHAR2_TABLE_100
367: , p1_a2 JTF_VARCHAR2_TABLE_100
368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE

Line 372: , p3_a0 out nocopy JTF_NUMBER_TABLE

368: , p1_a3 JTF_NUMBER_TABLE
369: , p1_a4 JTF_VARCHAR2_TABLE_100
370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 374: , p3_a2 out nocopy JTF_NUMBER_TABLE

370: , p1_a5 JTF_NUMBER_TABLE
371: , p_include_alternate VARCHAR2
372: , p3_a0 out nocopy JTF_NUMBER_TABLE
373: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 378: , p3_a6 out nocopy JTF_NUMBER_TABLE

374: , p3_a2 out nocopy JTF_NUMBER_TABLE
375: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
376: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
377: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_300
378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 382: , p3_a10 out nocopy JTF_NUMBER_TABLE

378: , p3_a6 out nocopy JTF_NUMBER_TABLE
379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE

Line 383: , p3_a11 out nocopy JTF_NUMBER_TABLE

379: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_300
380: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 385: , p3_a13 out nocopy JTF_NUMBER_TABLE

381: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE

Line 386: , p3_a14 out nocopy JTF_NUMBER_TABLE

382: , p3_a10 out nocopy JTF_NUMBER_TABLE
383: , p3_a11 out nocopy JTF_NUMBER_TABLE
384: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
385: , p3_a13 out nocopy JTF_NUMBER_TABLE
386: , p3_a14 out nocopy JTF_NUMBER_TABLE
387: , p3_a15 out nocopy JTF_VARCHAR2_TABLE_100
388: , p3_a16 out nocopy JTF_VARCHAR2_TABLE_100
389: , p3_a17 out nocopy JTF_DATE_TABLE
390: , p3_a18 out nocopy JTF_DATE_TABLE

Line 399: , p2_a0 JTF_NUMBER_TABLE

395: , x_msg_count out nocopy NUMBER
396: );
397: procedure ws_check_engineers_subinv(p_resource_type VARCHAR2
398: , p_resource_id NUMBER
399: , p2_a0 JTF_NUMBER_TABLE
400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 402: , p2_a3 JTF_NUMBER_TABLE

398: , p_resource_id NUMBER
399: , p2_a0 JTF_NUMBER_TABLE
400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 404: , p2_a5 JTF_NUMBER_TABLE

400: , p2_a1 JTF_VARCHAR2_TABLE_100
401: , p2_a2 JTF_VARCHAR2_TABLE_100
402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 406: , p4_a0 out nocopy JTF_NUMBER_TABLE

402: , p2_a3 JTF_NUMBER_TABLE
403: , p2_a4 JTF_VARCHAR2_TABLE_100
404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 408: , p4_a2 out nocopy JTF_NUMBER_TABLE

404: , p2_a5 JTF_NUMBER_TABLE
405: , p_include_alternate VARCHAR2
406: , p4_a0 out nocopy JTF_NUMBER_TABLE
407: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 412: , p4_a6 out nocopy JTF_NUMBER_TABLE

408: , p4_a2 out nocopy JTF_NUMBER_TABLE
409: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
410: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
411: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 416: , p4_a10 out nocopy JTF_NUMBER_TABLE

412: , p4_a6 out nocopy JTF_NUMBER_TABLE
413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 417: , p4_a11 out nocopy JTF_NUMBER_TABLE

413: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
414: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 419: , p4_a13 out nocopy JTF_NUMBER_TABLE

415: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE

Line 420: , p4_a14 out nocopy JTF_NUMBER_TABLE

416: , p4_a10 out nocopy JTF_NUMBER_TABLE
417: , p4_a11 out nocopy JTF_NUMBER_TABLE
418: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
419: , p4_a13 out nocopy JTF_NUMBER_TABLE
420: , p4_a14 out nocopy JTF_NUMBER_TABLE
421: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
422: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
423: , p4_a17 out nocopy JTF_DATE_TABLE
424: , p4_a18 out nocopy JTF_DATE_TABLE

Line 433: , p2_a0 JTF_NUMBER_TABLE

429: , x_msg_count out nocopy NUMBER
430: );
431: procedure ws_check_organizations(p_resource_type VARCHAR2
432: , p_resource_id NUMBER
433: , p2_a0 JTF_NUMBER_TABLE
434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100

Line 436: , p2_a3 JTF_NUMBER_TABLE

432: , p_resource_id NUMBER
433: , p2_a0 JTF_NUMBER_TABLE
434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE

Line 438: , p2_a5 JTF_NUMBER_TABLE

434: , p2_a1 JTF_VARCHAR2_TABLE_100
435: , p2_a2 JTF_VARCHAR2_TABLE_100
436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE

Line 440: , p4_a0 out nocopy JTF_NUMBER_TABLE

436: , p2_a3 JTF_NUMBER_TABLE
437: , p2_a4 JTF_VARCHAR2_TABLE_100
438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 442: , p4_a2 out nocopy JTF_NUMBER_TABLE

438: , p2_a5 JTF_NUMBER_TABLE
439: , p_include_alternate VARCHAR2
440: , p4_a0 out nocopy JTF_NUMBER_TABLE
441: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 446: , p4_a6 out nocopy JTF_NUMBER_TABLE

442: , p4_a2 out nocopy JTF_NUMBER_TABLE
443: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
444: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
445: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_300
446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 450: , p4_a10 out nocopy JTF_NUMBER_TABLE

446: , p4_a6 out nocopy JTF_NUMBER_TABLE
447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE

Line 451: , p4_a11 out nocopy JTF_NUMBER_TABLE

447: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_300
448: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 453: , p4_a13 out nocopy JTF_NUMBER_TABLE

449: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE

Line 454: , p4_a14 out nocopy JTF_NUMBER_TABLE

450: , p4_a10 out nocopy JTF_NUMBER_TABLE
451: , p4_a11 out nocopy JTF_NUMBER_TABLE
452: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
453: , p4_a13 out nocopy JTF_NUMBER_TABLE
454: , p4_a14 out nocopy JTF_NUMBER_TABLE
455: , p4_a15 out nocopy JTF_VARCHAR2_TABLE_100
456: , p4_a16 out nocopy JTF_VARCHAR2_TABLE_100
457: , p4_a17 out nocopy JTF_DATE_TABLE
458: , p4_a18 out nocopy JTF_DATE_TABLE

Line 472: , p2_a0 in out nocopy JTF_NUMBER_TABLE

468: , p0_a3 NUMBER
469: , p0_a4 VARCHAR2
470: , p0_a5 NUMBER
471: , p_org_id NUMBER
472: , p2_a0 in out nocopy JTF_NUMBER_TABLE
473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE

Line 475: , p2_a3 in out nocopy JTF_NUMBER_TABLE

471: , p_org_id NUMBER
472: , p2_a0 in out nocopy JTF_NUMBER_TABLE
473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE
479: , p2_a7 in out nocopy JTF_NUMBER_TABLE

Line 476: , p2_a4 in out nocopy JTF_NUMBER_TABLE

472: , p2_a0 in out nocopy JTF_NUMBER_TABLE
473: , p2_a1 in out nocopy JTF_VARCHAR2_TABLE_100
474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE
479: , p2_a7 in out nocopy JTF_NUMBER_TABLE
480: , x_return_status out nocopy VARCHAR2

Line 478: , p2_a6 in out nocopy JTF_NUMBER_TABLE

474: , p2_a2 in out nocopy JTF_VARCHAR2_TABLE_100
475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE
479: , p2_a7 in out nocopy JTF_NUMBER_TABLE
480: , x_return_status out nocopy VARCHAR2
481: , x_msg_data out nocopy VARCHAR2
482: , x_msg_count out nocopy NUMBER

Line 479: , p2_a7 in out nocopy JTF_NUMBER_TABLE

475: , p2_a3 in out nocopy JTF_NUMBER_TABLE
476: , p2_a4 in out nocopy JTF_NUMBER_TABLE
477: , p2_a5 in out nocopy JTF_VARCHAR2_TABLE_100
478: , p2_a6 in out nocopy JTF_NUMBER_TABLE
479: , p2_a7 in out nocopy JTF_NUMBER_TABLE
480: , x_return_status out nocopy VARCHAR2
481: , x_msg_data out nocopy VARCHAR2
482: , x_msg_count out nocopy NUMBER
483: );

Line 495: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE

491: function get_arrival_date(p_ship_date date
492: , p_lead_time NUMBER
493: , p_org_id NUMBER
494: ) return date;
495: procedure spares_check2(p0_a0 JTF_NUMBER_TABLE
496: , p0_a1 JTF_VARCHAR2_TABLE_100
497: , p_task_id NUMBER
498: , p_need_by_date date
499: , p_trunk number

Line 502: , p6_a0 out nocopy JTF_NUMBER_TABLE

498: , p_need_by_date date
499: , p_trunk number
500: , p_warehouse number
501: , p_mandatory number
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a2 out nocopy JTF_DATE_TABLE
505: , p6_a3 out nocopy JTF_NUMBER_TABLE
506: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 505: , p6_a3 out nocopy JTF_NUMBER_TABLE

501: , p_mandatory number
502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a2 out nocopy JTF_DATE_TABLE
505: , p6_a3 out nocopy JTF_NUMBER_TABLE
506: , p6_a4 out nocopy JTF_NUMBER_TABLE
507: , p6_a5 out nocopy JTF_NUMBER_TABLE
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000

Line 506: , p6_a4 out nocopy JTF_NUMBER_TABLE

502: , p6_a0 out nocopy JTF_NUMBER_TABLE
503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a2 out nocopy JTF_DATE_TABLE
505: , p6_a3 out nocopy JTF_NUMBER_TABLE
506: , p6_a4 out nocopy JTF_NUMBER_TABLE
507: , p6_a5 out nocopy JTF_NUMBER_TABLE
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000
510: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_4000

Line 507: , p6_a5 out nocopy JTF_NUMBER_TABLE

503: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
504: , p6_a2 out nocopy JTF_DATE_TABLE
505: , p6_a3 out nocopy JTF_NUMBER_TABLE
506: , p6_a4 out nocopy JTF_NUMBER_TABLE
507: , p6_a5 out nocopy JTF_NUMBER_TABLE
508: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_4000
509: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_4000
510: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_4000
511: , x_return_status out nocopy VARCHAR2