DBA Data[Home] [Help]

APPS.JTF_ASSIGN_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package jtf_assign_pub_w as
2: /* $Header: jtfampws.pls 120.2 2006/06/27 12:02:18 abraina ship $ */
3: procedure rosetta_table_copy_in_p8(t out nocopy jtf_assign_pub.avail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );

Line 10: , a1 out nocopy JTF_VARCHAR2_TABLE_100

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: );
9: procedure rosetta_table_copy_out_p8(t jtf_assign_pub.avail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
10: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11: , a2 out nocopy JTF_DATE_TABLE
12: , a3 out nocopy JTF_DATE_TABLE
13: , a4 out nocopy JTF_NUMBER_TABLE
14: );

Line 18: , a2 JTF_VARCHAR2_TABLE_100

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

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p11(t out nocopy jtf_assign_pub.assignresources_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_DATE_TABLE
21: , a5 JTF_DATE_TABLE
22: , a6 JTF_NUMBER_TABLE
23: , a7 JTF_NUMBER_TABLE

Line 27: , a11 JTF_VARCHAR2_TABLE_100

23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE

Line 28: , a12 JTF_VARCHAR2_TABLE_100

24: , a8 JTF_VARCHAR2_TABLE_300
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100

Line 29: , a13 JTF_VARCHAR2_TABLE_100

25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE

Line 30: , a14 JTF_VARCHAR2_TABLE_100

26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100

Line 32: , a16 JTF_VARCHAR2_TABLE_100

28: , a12 JTF_VARCHAR2_TABLE_100
29: , a13 JTF_VARCHAR2_TABLE_100
30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_DATE_TABLE

Line 34: , a18 JTF_VARCHAR2_TABLE_100

30: , a14 JTF_VARCHAR2_TABLE_100
31: , a15 JTF_NUMBER_TABLE
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_100
35: , a19 JTF_DATE_TABLE
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_200

Line 39: , a23 JTF_VARCHAR2_TABLE_100

35: , a19 JTF_DATE_TABLE
36: , a20 JTF_DATE_TABLE
37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_200
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );

Line 41: , a25 JTF_VARCHAR2_TABLE_100

37: , a21 JTF_NUMBER_TABLE
38: , a22 JTF_VARCHAR2_TABLE_200
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE

Line 42: , a26 JTF_VARCHAR2_TABLE_100

38: , a22 JTF_VARCHAR2_TABLE_200
39: , a23 JTF_VARCHAR2_TABLE_100
40: , a24 JTF_NUMBER_TABLE
41: , a25 JTF_VARCHAR2_TABLE_100
42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a2 out nocopy JTF_VARCHAR2_TABLE_100

42: , a26 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE

Line 47: , a3 out nocopy JTF_VARCHAR2_TABLE_100

43: );
44: procedure rosetta_table_copy_out_p11(t jtf_assign_pub.assignresources_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_VARCHAR2_TABLE_100
48: , a4 out nocopy JTF_DATE_TABLE
49: , a5 out nocopy JTF_DATE_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE

Line 55: , a11 out nocopy JTF_VARCHAR2_TABLE_100

51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE

Line 56: , a12 out nocopy JTF_VARCHAR2_TABLE_100

52: , a8 out nocopy JTF_VARCHAR2_TABLE_300
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , a13 out nocopy JTF_VARCHAR2_TABLE_100

53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE

Line 58: , a14 out nocopy JTF_VARCHAR2_TABLE_100

54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_VARCHAR2_TABLE_100
56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a16 out nocopy JTF_VARCHAR2_TABLE_100

56: , a12 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_DATE_TABLE
64: , a20 out nocopy JTF_DATE_TABLE

Line 62: , a18 out nocopy JTF_VARCHAR2_TABLE_100

58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_NUMBER_TABLE
60: , a16 out nocopy JTF_VARCHAR2_TABLE_100
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_DATE_TABLE
64: , a20 out nocopy JTF_DATE_TABLE
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 67: , a23 out nocopy JTF_VARCHAR2_TABLE_100

63: , a19 out nocopy JTF_DATE_TABLE
64: , a20 out nocopy JTF_DATE_TABLE
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_200
67: , a23 out nocopy JTF_VARCHAR2_TABLE_100
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );

Line 69: , a25 out nocopy JTF_VARCHAR2_TABLE_100

65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_200
67: , a23 out nocopy JTF_VARCHAR2_TABLE_100
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE

Line 70: , a26 out nocopy JTF_VARCHAR2_TABLE_100

66: , a22 out nocopy JTF_VARCHAR2_TABLE_200
67: , a23 out nocopy JTF_VARCHAR2_TABLE_100
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_VARCHAR2_TABLE_100
70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100

Line 74: , a1 JTF_VARCHAR2_TABLE_100

70: , a26 out nocopy JTF_VARCHAR2_TABLE_100
71: );
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );

Line 75: , a2 JTF_VARCHAR2_TABLE_100

71: );
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 76: , a3 JTF_VARCHAR2_TABLE_100

72:
73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 77: , a4 JTF_VARCHAR2_TABLE_100

73: procedure rosetta_table_copy_in_p24(t out nocopy jtf_assign_pub.prfeng_tbl_type, a0 JTF_NUMBER_TABLE
74: , a1 JTF_VARCHAR2_TABLE_100
75: , a2 JTF_VARCHAR2_TABLE_100
76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 80: , a1 out nocopy JTF_VARCHAR2_TABLE_100

76: , a3 JTF_VARCHAR2_TABLE_100
77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );

Line 81: , a2 out nocopy JTF_VARCHAR2_TABLE_100

77: , a4 JTF_VARCHAR2_TABLE_100
78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:

Line 82: , a3 out nocopy JTF_VARCHAR2_TABLE_100

78: );
79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE

Line 83: , a4 out nocopy JTF_VARCHAR2_TABLE_100

79: procedure rosetta_table_copy_out_p24(t jtf_assign_pub.prfeng_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_VARCHAR2_TABLE_100
81: , a2 out nocopy JTF_VARCHAR2_TABLE_100
82: , a3 out nocopy JTF_VARCHAR2_TABLE_100
83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100

Line 87: , a1 JTF_VARCHAR2_TABLE_100

83: , a4 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 88: , a2 JTF_VARCHAR2_TABLE_100

84: );
85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 89: , a3 JTF_VARCHAR2_TABLE_100

85:
86: procedure rosetta_table_copy_in_p26(t out nocopy jtf_assign_pub.preferred_engineers_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_100
88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 92: , a1 out nocopy JTF_VARCHAR2_TABLE_100

88: , a2 JTF_VARCHAR2_TABLE_100
89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:

Line 93: , a2 out nocopy JTF_VARCHAR2_TABLE_100

89: , a3 JTF_VARCHAR2_TABLE_100
90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE

Line 94: , a3 out nocopy JTF_VARCHAR2_TABLE_100

90: );
91: procedure rosetta_table_copy_out_p26(t jtf_assign_pub.preferred_engineers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_VARCHAR2_TABLE_100
93: , a2 out nocopy JTF_VARCHAR2_TABLE_100
94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98: , a1 JTF_VARCHAR2_TABLE_100

Line 98: , a1 JTF_VARCHAR2_TABLE_100

94: , a3 out nocopy JTF_VARCHAR2_TABLE_100
95: );
96:
97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98: , a1 JTF_VARCHAR2_TABLE_100
99: );
100: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: );

Line 101: , a1 out nocopy JTF_VARCHAR2_TABLE_100

97: procedure rosetta_table_copy_in_p28(t out nocopy jtf_assign_pub.escalations_tbl_type, a0 JTF_NUMBER_TABLE
98: , a1 JTF_VARCHAR2_TABLE_100
99: );
100: procedure rosetta_table_copy_out_p28(t jtf_assign_pub.escalations_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: );
103:
104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105: , a1 JTF_VARCHAR2_TABLE_100

Line 105: , a1 JTF_VARCHAR2_TABLE_100

101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: );
103:
104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105: , a1 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: );

Line 108: , a1 out nocopy JTF_VARCHAR2_TABLE_100

104: procedure rosetta_table_copy_in_p30(t out nocopy jtf_assign_pub.excluded_tbl_type, a0 JTF_NUMBER_TABLE
105: , a1 JTF_VARCHAR2_TABLE_100
106: );
107: procedure rosetta_table_copy_out_p30(t jtf_assign_pub.excluded_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_VARCHAR2_TABLE_100
109: );
110:
111: procedure get_assign_resources(p_api_version NUMBER
112: , p_init_msg_list VARCHAR2

Line 142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100

138: , p_business_process_date date
139: , p_filter_excluded_resource VARCHAR2
140: , p32_a0 out nocopy JTF_NUMBER_TABLE
141: , p32_a1 out nocopy JTF_NUMBER_TABLE
142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
145: , p32_a5 out nocopy JTF_DATE_TABLE
146: , p32_a6 out nocopy JTF_NUMBER_TABLE

Line 143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100

139: , p_filter_excluded_resource VARCHAR2
140: , p32_a0 out nocopy JTF_NUMBER_TABLE
141: , p32_a1 out nocopy JTF_NUMBER_TABLE
142: , p32_a2 out nocopy JTF_VARCHAR2_TABLE_100
143: , p32_a3 out nocopy JTF_VARCHAR2_TABLE_100
144: , p32_a4 out nocopy JTF_DATE_TABLE
145: , p32_a5 out nocopy JTF_DATE_TABLE
146: , p32_a6 out nocopy JTF_NUMBER_TABLE
147: , p32_a7 out nocopy JTF_NUMBER_TABLE

Line 151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100

147: , p32_a7 out nocopy JTF_NUMBER_TABLE
148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE

Line 152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100

148: , p32_a8 out nocopy JTF_VARCHAR2_TABLE_300
149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100

149: , p32_a9 out nocopy JTF_NUMBER_TABLE
150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE

Line 154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100

150: , p32_a10 out nocopy JTF_NUMBER_TABLE
151: , p32_a11 out nocopy JTF_VARCHAR2_TABLE_100
152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100

152: , p32_a12 out nocopy JTF_VARCHAR2_TABLE_100
153: , p32_a13 out nocopy JTF_VARCHAR2_TABLE_100
154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , p32_a19 out nocopy JTF_DATE_TABLE
160: , p32_a20 out nocopy JTF_DATE_TABLE

Line 158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100

154: , p32_a14 out nocopy JTF_VARCHAR2_TABLE_100
155: , p32_a15 out nocopy JTF_NUMBER_TABLE
156: , p32_a16 out nocopy JTF_VARCHAR2_TABLE_100
157: , p32_a17 out nocopy JTF_NUMBER_TABLE
158: , p32_a18 out nocopy JTF_VARCHAR2_TABLE_100
159: , p32_a19 out nocopy JTF_DATE_TABLE
160: , p32_a20 out nocopy JTF_DATE_TABLE
161: , p32_a21 out nocopy JTF_NUMBER_TABLE
162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100

159: , p32_a19 out nocopy JTF_DATE_TABLE
160: , p32_a20 out nocopy JTF_DATE_TABLE
161: , p32_a21 out nocopy JTF_NUMBER_TABLE
162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164: , p32_a24 out nocopy JTF_NUMBER_TABLE
165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
166: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2

Line 165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100

161: , p32_a21 out nocopy JTF_NUMBER_TABLE
162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164: , p32_a24 out nocopy JTF_NUMBER_TABLE
165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
166: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2
168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2

Line 166: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100

162: , p32_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p32_a23 out nocopy JTF_VARCHAR2_TABLE_100
164: , p32_a24 out nocopy JTF_NUMBER_TABLE
165: , p32_a25 out nocopy JTF_VARCHAR2_TABLE_100
166: , p32_a26 out nocopy JTF_VARCHAR2_TABLE_100
167: , x_return_status out nocopy VARCHAR2
168: , x_msg_count out nocopy NUMBER
169: , x_msg_data out nocopy VARCHAR2
170: , p26_a0 NUMBER := 0-1962.0724

Line 370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100

366: , p_business_process_date date
367: , p_filter_excluded_resource VARCHAR2
368: , p20_a0 out nocopy JTF_NUMBER_TABLE
369: , p20_a1 out nocopy JTF_NUMBER_TABLE
370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
373: , p20_a5 out nocopy JTF_DATE_TABLE
374: , p20_a6 out nocopy JTF_NUMBER_TABLE

Line 371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100

367: , p_filter_excluded_resource VARCHAR2
368: , p20_a0 out nocopy JTF_NUMBER_TABLE
369: , p20_a1 out nocopy JTF_NUMBER_TABLE
370: , p20_a2 out nocopy JTF_VARCHAR2_TABLE_100
371: , p20_a3 out nocopy JTF_VARCHAR2_TABLE_100
372: , p20_a4 out nocopy JTF_DATE_TABLE
373: , p20_a5 out nocopy JTF_DATE_TABLE
374: , p20_a6 out nocopy JTF_NUMBER_TABLE
375: , p20_a7 out nocopy JTF_NUMBER_TABLE

Line 379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100

375: , p20_a7 out nocopy JTF_NUMBER_TABLE
376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE

Line 380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100

376: , p20_a8 out nocopy JTF_VARCHAR2_TABLE_300
377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100

377: , p20_a9 out nocopy JTF_NUMBER_TABLE
378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE

Line 382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100

378: , p20_a10 out nocopy JTF_NUMBER_TABLE
379: , p20_a11 out nocopy JTF_VARCHAR2_TABLE_100
380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100

380: , p20_a12 out nocopy JTF_VARCHAR2_TABLE_100
381: , p20_a13 out nocopy JTF_VARCHAR2_TABLE_100
382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387: , p20_a19 out nocopy JTF_DATE_TABLE
388: , p20_a20 out nocopy JTF_DATE_TABLE

Line 386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100

382: , p20_a14 out nocopy JTF_VARCHAR2_TABLE_100
383: , p20_a15 out nocopy JTF_NUMBER_TABLE
384: , p20_a16 out nocopy JTF_VARCHAR2_TABLE_100
385: , p20_a17 out nocopy JTF_NUMBER_TABLE
386: , p20_a18 out nocopy JTF_VARCHAR2_TABLE_100
387: , p20_a19 out nocopy JTF_DATE_TABLE
388: , p20_a20 out nocopy JTF_DATE_TABLE
389: , p20_a21 out nocopy JTF_NUMBER_TABLE
390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100

387: , p20_a19 out nocopy JTF_DATE_TABLE
388: , p20_a20 out nocopy JTF_DATE_TABLE
389: , p20_a21 out nocopy JTF_NUMBER_TABLE
390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392: , p20_a24 out nocopy JTF_NUMBER_TABLE
393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
394: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
395: , x_return_status out nocopy VARCHAR2

Line 393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100

389: , p20_a21 out nocopy JTF_NUMBER_TABLE
390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392: , p20_a24 out nocopy JTF_NUMBER_TABLE
393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
394: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
395: , x_return_status out nocopy VARCHAR2
396: , x_msg_count out nocopy NUMBER
397: , x_msg_data out nocopy VARCHAR2

Line 394: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100

390: , p20_a22 out nocopy JTF_VARCHAR2_TABLE_200
391: , p20_a23 out nocopy JTF_VARCHAR2_TABLE_100
392: , p20_a24 out nocopy JTF_NUMBER_TABLE
393: , p20_a25 out nocopy JTF_VARCHAR2_TABLE_100
394: , p20_a26 out nocopy JTF_VARCHAR2_TABLE_100
395: , x_return_status out nocopy VARCHAR2
396: , x_msg_count out nocopy NUMBER
397: , x_msg_data out nocopy VARCHAR2
398: );

Line 427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100

423: , p_business_process_date date
424: , p_filter_excluded_resource VARCHAR2
425: , p27_a0 out nocopy JTF_NUMBER_TABLE
426: , p27_a1 out nocopy JTF_NUMBER_TABLE
427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
430: , p27_a5 out nocopy JTF_DATE_TABLE
431: , p27_a6 out nocopy JTF_NUMBER_TABLE

Line 428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100

424: , p_filter_excluded_resource VARCHAR2
425: , p27_a0 out nocopy JTF_NUMBER_TABLE
426: , p27_a1 out nocopy JTF_NUMBER_TABLE
427: , p27_a2 out nocopy JTF_VARCHAR2_TABLE_100
428: , p27_a3 out nocopy JTF_VARCHAR2_TABLE_100
429: , p27_a4 out nocopy JTF_DATE_TABLE
430: , p27_a5 out nocopy JTF_DATE_TABLE
431: , p27_a6 out nocopy JTF_NUMBER_TABLE
432: , p27_a7 out nocopy JTF_NUMBER_TABLE

Line 436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100

432: , p27_a7 out nocopy JTF_NUMBER_TABLE
433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE

Line 437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100

433: , p27_a8 out nocopy JTF_VARCHAR2_TABLE_300
434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100

434: , p27_a9 out nocopy JTF_NUMBER_TABLE
435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE

Line 439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100

435: , p27_a10 out nocopy JTF_NUMBER_TABLE
436: , p27_a11 out nocopy JTF_VARCHAR2_TABLE_100
437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100

437: , p27_a12 out nocopy JTF_VARCHAR2_TABLE_100
438: , p27_a13 out nocopy JTF_VARCHAR2_TABLE_100
439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444: , p27_a19 out nocopy JTF_DATE_TABLE
445: , p27_a20 out nocopy JTF_DATE_TABLE

Line 443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100

439: , p27_a14 out nocopy JTF_VARCHAR2_TABLE_100
440: , p27_a15 out nocopy JTF_NUMBER_TABLE
441: , p27_a16 out nocopy JTF_VARCHAR2_TABLE_100
442: , p27_a17 out nocopy JTF_NUMBER_TABLE
443: , p27_a18 out nocopy JTF_VARCHAR2_TABLE_100
444: , p27_a19 out nocopy JTF_DATE_TABLE
445: , p27_a20 out nocopy JTF_DATE_TABLE
446: , p27_a21 out nocopy JTF_NUMBER_TABLE
447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100

444: , p27_a19 out nocopy JTF_DATE_TABLE
445: , p27_a20 out nocopy JTF_DATE_TABLE
446: , p27_a21 out nocopy JTF_NUMBER_TABLE
447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449: , p27_a24 out nocopy JTF_NUMBER_TABLE
450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
451: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
452: , x_return_status out nocopy VARCHAR2

Line 450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100

446: , p27_a21 out nocopy JTF_NUMBER_TABLE
447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449: , p27_a24 out nocopy JTF_NUMBER_TABLE
450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
451: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
452: , x_return_status out nocopy VARCHAR2
453: , x_msg_count out nocopy NUMBER
454: , x_msg_data out nocopy VARCHAR2

Line 451: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100

447: , p27_a22 out nocopy JTF_VARCHAR2_TABLE_200
448: , p27_a23 out nocopy JTF_VARCHAR2_TABLE_100
449: , p27_a24 out nocopy JTF_NUMBER_TABLE
450: , p27_a25 out nocopy JTF_VARCHAR2_TABLE_100
451: , p27_a26 out nocopy JTF_VARCHAR2_TABLE_100
452: , x_return_status out nocopy VARCHAR2
453: , x_msg_count out nocopy NUMBER
454: , x_msg_data out nocopy VARCHAR2
455: , p23_a0 NUMBER := 0-1962.0724

Line 528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100

524: , p_business_process_id NUMBER
525: , p_business_process_date date
526: , p15_a0 out nocopy JTF_NUMBER_TABLE
527: , p15_a1 out nocopy JTF_NUMBER_TABLE
528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
531: , p15_a5 out nocopy JTF_DATE_TABLE
532: , p15_a6 out nocopy JTF_NUMBER_TABLE

Line 529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

525: , p_business_process_date date
526: , p15_a0 out nocopy JTF_NUMBER_TABLE
527: , p15_a1 out nocopy JTF_NUMBER_TABLE
528: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
529: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
530: , p15_a4 out nocopy JTF_DATE_TABLE
531: , p15_a5 out nocopy JTF_DATE_TABLE
532: , p15_a6 out nocopy JTF_NUMBER_TABLE
533: , p15_a7 out nocopy JTF_NUMBER_TABLE

Line 537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

533: , p15_a7 out nocopy JTF_NUMBER_TABLE
534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE

Line 538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100

534: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

535: , p15_a9 out nocopy JTF_NUMBER_TABLE
536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE

Line 540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

536: , p15_a10 out nocopy JTF_NUMBER_TABLE
537: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

538: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
539: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545: , p15_a19 out nocopy JTF_DATE_TABLE
546: , p15_a20 out nocopy JTF_DATE_TABLE

Line 544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

540: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
541: , p15_a15 out nocopy JTF_NUMBER_TABLE
542: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
543: , p15_a17 out nocopy JTF_NUMBER_TABLE
544: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
545: , p15_a19 out nocopy JTF_DATE_TABLE
546: , p15_a20 out nocopy JTF_DATE_TABLE
547: , p15_a21 out nocopy JTF_NUMBER_TABLE
548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100

545: , p15_a19 out nocopy JTF_DATE_TABLE
546: , p15_a20 out nocopy JTF_DATE_TABLE
547: , p15_a21 out nocopy JTF_NUMBER_TABLE
548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550: , p15_a24 out nocopy JTF_NUMBER_TABLE
551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
552: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
553: , x_return_status out nocopy VARCHAR2

Line 551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

547: , p15_a21 out nocopy JTF_NUMBER_TABLE
548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550: , p15_a24 out nocopy JTF_NUMBER_TABLE
551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
552: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2

Line 552: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100

548: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
549: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
550: , p15_a24 out nocopy JTF_NUMBER_TABLE
551: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
552: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
553: , x_return_status out nocopy VARCHAR2
554: , x_msg_count out nocopy NUMBER
555: , x_msg_data out nocopy VARCHAR2
556: , p12_a0 NUMBER := 0-1962.0724

Line 624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100

620: , p_business_process_id NUMBER
621: , p_business_process_date date
622: , p15_a0 out nocopy JTF_NUMBER_TABLE
623: , p15_a1 out nocopy JTF_NUMBER_TABLE
624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
627: , p15_a5 out nocopy JTF_DATE_TABLE
628: , p15_a6 out nocopy JTF_NUMBER_TABLE

Line 625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

621: , p_business_process_date date
622: , p15_a0 out nocopy JTF_NUMBER_TABLE
623: , p15_a1 out nocopy JTF_NUMBER_TABLE
624: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
625: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
626: , p15_a4 out nocopy JTF_DATE_TABLE
627: , p15_a5 out nocopy JTF_DATE_TABLE
628: , p15_a6 out nocopy JTF_NUMBER_TABLE
629: , p15_a7 out nocopy JTF_NUMBER_TABLE

Line 633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

629: , p15_a7 out nocopy JTF_NUMBER_TABLE
630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE

Line 634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100

630: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

631: , p15_a9 out nocopy JTF_NUMBER_TABLE
632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE

Line 636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

632: , p15_a10 out nocopy JTF_NUMBER_TABLE
633: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

634: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
635: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641: , p15_a19 out nocopy JTF_DATE_TABLE
642: , p15_a20 out nocopy JTF_DATE_TABLE

Line 640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

636: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
637: , p15_a15 out nocopy JTF_NUMBER_TABLE
638: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
639: , p15_a17 out nocopy JTF_NUMBER_TABLE
640: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
641: , p15_a19 out nocopy JTF_DATE_TABLE
642: , p15_a20 out nocopy JTF_DATE_TABLE
643: , p15_a21 out nocopy JTF_NUMBER_TABLE
644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100

641: , p15_a19 out nocopy JTF_DATE_TABLE
642: , p15_a20 out nocopy JTF_DATE_TABLE
643: , p15_a21 out nocopy JTF_NUMBER_TABLE
644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646: , p15_a24 out nocopy JTF_NUMBER_TABLE
647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
648: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
649: , x_return_status out nocopy VARCHAR2

Line 647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

643: , p15_a21 out nocopy JTF_NUMBER_TABLE
644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646: , p15_a24 out nocopy JTF_NUMBER_TABLE
647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
648: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
649: , x_return_status out nocopy VARCHAR2
650: , x_msg_count out nocopy NUMBER
651: , x_msg_data out nocopy VARCHAR2

Line 648: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100

644: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
645: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
646: , p15_a24 out nocopy JTF_NUMBER_TABLE
647: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
648: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
649: , x_return_status out nocopy VARCHAR2
650: , x_msg_count out nocopy NUMBER
651: , x_msg_data out nocopy VARCHAR2
652: , p12_a0 NUMBER := 0-1962.0724

Line 717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100

713: , p_business_process_id NUMBER
714: , p_business_process_date date
715: , p15_a0 out nocopy JTF_NUMBER_TABLE
716: , p15_a1 out nocopy JTF_NUMBER_TABLE
717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
720: , p15_a5 out nocopy JTF_DATE_TABLE
721: , p15_a6 out nocopy JTF_NUMBER_TABLE

Line 718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

714: , p_business_process_date date
715: , p15_a0 out nocopy JTF_NUMBER_TABLE
716: , p15_a1 out nocopy JTF_NUMBER_TABLE
717: , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
718: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
719: , p15_a4 out nocopy JTF_DATE_TABLE
720: , p15_a5 out nocopy JTF_DATE_TABLE
721: , p15_a6 out nocopy JTF_NUMBER_TABLE
722: , p15_a7 out nocopy JTF_NUMBER_TABLE

Line 726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100

722: , p15_a7 out nocopy JTF_NUMBER_TABLE
723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE

Line 727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100

723: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_300
724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100

724: , p15_a9 out nocopy JTF_NUMBER_TABLE
725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE

Line 729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100

725: , p15_a10 out nocopy JTF_NUMBER_TABLE
726: , p15_a11 out nocopy JTF_VARCHAR2_TABLE_100
727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100

727: , p15_a12 out nocopy JTF_VARCHAR2_TABLE_100
728: , p15_a13 out nocopy JTF_VARCHAR2_TABLE_100
729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734: , p15_a19 out nocopy JTF_DATE_TABLE
735: , p15_a20 out nocopy JTF_DATE_TABLE

Line 733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100

729: , p15_a14 out nocopy JTF_VARCHAR2_TABLE_100
730: , p15_a15 out nocopy JTF_NUMBER_TABLE
731: , p15_a16 out nocopy JTF_VARCHAR2_TABLE_100
732: , p15_a17 out nocopy JTF_NUMBER_TABLE
733: , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
734: , p15_a19 out nocopy JTF_DATE_TABLE
735: , p15_a20 out nocopy JTF_DATE_TABLE
736: , p15_a21 out nocopy JTF_NUMBER_TABLE
737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100

734: , p15_a19 out nocopy JTF_DATE_TABLE
735: , p15_a20 out nocopy JTF_DATE_TABLE
736: , p15_a21 out nocopy JTF_NUMBER_TABLE
737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739: , p15_a24 out nocopy JTF_NUMBER_TABLE
740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
741: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
742: , x_return_status out nocopy VARCHAR2

Line 740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100

736: , p15_a21 out nocopy JTF_NUMBER_TABLE
737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739: , p15_a24 out nocopy JTF_NUMBER_TABLE
740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
741: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
742: , x_return_status out nocopy VARCHAR2
743: , x_msg_count out nocopy NUMBER
744: , x_msg_data out nocopy VARCHAR2

Line 741: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100

737: , p15_a22 out nocopy JTF_VARCHAR2_TABLE_200
738: , p15_a23 out nocopy JTF_VARCHAR2_TABLE_100
739: , p15_a24 out nocopy JTF_NUMBER_TABLE
740: , p15_a25 out nocopy JTF_VARCHAR2_TABLE_100
741: , p15_a26 out nocopy JTF_VARCHAR2_TABLE_100
742: , x_return_status out nocopy VARCHAR2
743: , x_msg_count out nocopy NUMBER
744: , x_msg_data out nocopy VARCHAR2
745: , p12_a0 VARCHAR2 := fnd_api.g_miss_char

Line 797: , p13_a1 JTF_VARCHAR2_TABLE_100

793: , p_territory_flag VARCHAR2
794: , p_calendar_flag VARCHAR2
795: , p_web_availability_flag VARCHAR2
796: , p13_a0 JTF_NUMBER_TABLE
797: , p13_a1 JTF_VARCHAR2_TABLE_100
798: , p_business_process_id NUMBER
799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
801: , p16_a1 out nocopy JTF_NUMBER_TABLE

Line 802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

798: , p_business_process_id NUMBER
799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
801: , p16_a1 out nocopy JTF_NUMBER_TABLE
802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
805: , p16_a5 out nocopy JTF_DATE_TABLE
806: , p16_a6 out nocopy JTF_NUMBER_TABLE

Line 803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100

799: , p_business_process_date date
800: , p16_a0 out nocopy JTF_NUMBER_TABLE
801: , p16_a1 out nocopy JTF_NUMBER_TABLE
802: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
803: , p16_a3 out nocopy JTF_VARCHAR2_TABLE_100
804: , p16_a4 out nocopy JTF_DATE_TABLE
805: , p16_a5 out nocopy JTF_DATE_TABLE
806: , p16_a6 out nocopy JTF_NUMBER_TABLE
807: , p16_a7 out nocopy JTF_NUMBER_TABLE

Line 811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100

807: , p16_a7 out nocopy JTF_NUMBER_TABLE
808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE

Line 812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100

808: , p16_a8 out nocopy JTF_VARCHAR2_TABLE_300
809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100

809: , p16_a9 out nocopy JTF_NUMBER_TABLE
810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE

Line 814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100

810: , p16_a10 out nocopy JTF_NUMBER_TABLE
811: , p16_a11 out nocopy JTF_VARCHAR2_TABLE_100
812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100

812: , p16_a12 out nocopy JTF_VARCHAR2_TABLE_100
813: , p16_a13 out nocopy JTF_VARCHAR2_TABLE_100
814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819: , p16_a19 out nocopy JTF_DATE_TABLE
820: , p16_a20 out nocopy JTF_DATE_TABLE

Line 818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100

814: , p16_a14 out nocopy JTF_VARCHAR2_TABLE_100
815: , p16_a15 out nocopy JTF_NUMBER_TABLE
816: , p16_a16 out nocopy JTF_VARCHAR2_TABLE_100
817: , p16_a17 out nocopy JTF_NUMBER_TABLE
818: , p16_a18 out nocopy JTF_VARCHAR2_TABLE_100
819: , p16_a19 out nocopy JTF_DATE_TABLE
820: , p16_a20 out nocopy JTF_DATE_TABLE
821: , p16_a21 out nocopy JTF_NUMBER_TABLE
822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100

819: , p16_a19 out nocopy JTF_DATE_TABLE
820: , p16_a20 out nocopy JTF_DATE_TABLE
821: , p16_a21 out nocopy JTF_NUMBER_TABLE
822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824: , p16_a24 out nocopy JTF_NUMBER_TABLE
825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
826: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
827: , x_return_status out nocopy VARCHAR2

Line 825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100

821: , p16_a21 out nocopy JTF_NUMBER_TABLE
822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824: , p16_a24 out nocopy JTF_NUMBER_TABLE
825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
826: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2

Line 826: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100

822: , p16_a22 out nocopy JTF_VARCHAR2_TABLE_200
823: , p16_a23 out nocopy JTF_VARCHAR2_TABLE_100
824: , p16_a24 out nocopy JTF_NUMBER_TABLE
825: , p16_a25 out nocopy JTF_VARCHAR2_TABLE_100
826: , p16_a26 out nocopy JTF_VARCHAR2_TABLE_100
827: , x_return_status out nocopy VARCHAR2
828: , x_msg_count out nocopy NUMBER
829: , x_msg_data out nocopy VARCHAR2
830: );

Line 841: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100

837: , p_calling_doc_type VARCHAR2
838: , p_business_process_id NUMBER
839: , p_business_process_date date
840: , p12_a0 out nocopy JTF_NUMBER_TABLE
841: , p12_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2
845: , p7_a0 NUMBER := 0-1962.0724

Line 1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100

1026: , x_msg_count in out nocopy NUMBER
1027: , x_msg_data in out nocopy VARCHAR2
1028: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE

Line 1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100

1027: , x_msg_data in out nocopy VARCHAR2
1028: , p14_a0 in out nocopy JTF_NUMBER_TABLE
1029: , p14_a1 in out nocopy JTF_NUMBER_TABLE
1030: , p14_a2 in out nocopy JTF_VARCHAR2_TABLE_100
1031: , p14_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1032: , p14_a4 in out nocopy JTF_DATE_TABLE
1033: , p14_a5 in out nocopy JTF_DATE_TABLE
1034: , p14_a6 in out nocopy JTF_NUMBER_TABLE
1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE

Line 1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100

1035: , p14_a7 in out nocopy JTF_NUMBER_TABLE
1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE

Line 1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100

1036: , p14_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100

1037: , p14_a9 in out nocopy JTF_NUMBER_TABLE
1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE

Line 1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100

1038: , p14_a10 in out nocopy JTF_NUMBER_TABLE
1039: , p14_a11 in out nocopy JTF_VARCHAR2_TABLE_100
1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100

1040: , p14_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1041: , p14_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1048: , p14_a20 in out nocopy JTF_DATE_TABLE

Line 1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100

1042: , p14_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1043: , p14_a15 in out nocopy JTF_NUMBER_TABLE
1044: , p14_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1045: , p14_a17 in out nocopy JTF_NUMBER_TABLE
1046: , p14_a18 in out nocopy JTF_VARCHAR2_TABLE_100
1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1048: , p14_a20 in out nocopy JTF_DATE_TABLE
1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100

1047: , p14_a19 in out nocopy JTF_DATE_TABLE
1048: , p14_a20 in out nocopy JTF_DATE_TABLE
1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1055: );

Line 1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100

1049: , p14_a21 in out nocopy JTF_NUMBER_TABLE
1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1055: );
1056: end jtf_assign_pub_w;

Line 1054: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100

1050: , p14_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1051: , p14_a23 in out nocopy JTF_VARCHAR2_TABLE_100
1052: , p14_a24 in out nocopy JTF_NUMBER_TABLE
1053: , p14_a25 in out nocopy JTF_VARCHAR2_TABLE_100
1054: , p14_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1055: );
1056: end jtf_assign_pub_w;