APPS.OKL_RPP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_rpp_pvt_w as
2: /* $Header: OKLIRPPS.pls 120.0 2007/12/10 18:28:44 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_rpp_pvt_w as
2: /* $Header: OKLIRPPS.pls 120.0 2007/12/10 18:28:44 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIRPPS.pls 120.0 2007/12/10 18:28:44 dcshanmu noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_rpp_pvt.rpp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 17: , a1 out nocopy JTF_NUMBER_TABLE

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300
21: , a5 out nocopy JTF_DATE_TABLE

Line 19: , a3 out nocopy JTF_NUMBER_TABLE

15: );
16: procedure rosetta_table_copy_out_p2(t okl_rpp_pvt.rpp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
17: , a1 out nocopy JTF_NUMBER_TABLE
18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300
21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: , a6 out nocopy JTF_NUMBER_TABLE

18: , a2 out nocopy JTF_VARCHAR2_TABLE_100
19: , a3 out nocopy JTF_NUMBER_TABLE
20: , a4 out nocopy JTF_VARCHAR2_TABLE_300
21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_VARCHAR2_TABLE_100
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_DATE_TABLE

Line 25: , a9 out nocopy JTF_NUMBER_TABLE

21: , a5 out nocopy JTF_DATE_TABLE
22: , a6 out nocopy JTF_NUMBER_TABLE
23: , a7 out nocopy JTF_VARCHAR2_TABLE_100
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_DATE_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE
28: );
29:

Line 27: , a11 out nocopy JTF_NUMBER_TABLE

23: , a7 out nocopy JTF_VARCHAR2_TABLE_100
24: , a8 out nocopy JTF_DATE_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_DATE_TABLE
27: , a11 out nocopy JTF_NUMBER_TABLE
28: );
29:
30: procedure insert_row(p_api_version NUMBER
31: , p_init_msg_list VARCHAR2

Line 65: , p5_a0 JTF_NUMBER_TABLE

61: , p_init_msg_list VARCHAR2
62: , x_return_status out nocopy VARCHAR2
63: , x_msg_count out nocopy NUMBER
64: , x_msg_data out nocopy VARCHAR2
65: , p5_a0 JTF_NUMBER_TABLE
66: , p5_a1 JTF_NUMBER_TABLE
67: , p5_a2 JTF_VARCHAR2_TABLE_100
68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 66: , p5_a1 JTF_NUMBER_TABLE

62: , x_return_status out nocopy VARCHAR2
63: , x_msg_count out nocopy NUMBER
64: , x_msg_data out nocopy VARCHAR2
65: , p5_a0 JTF_NUMBER_TABLE
66: , p5_a1 JTF_NUMBER_TABLE
67: , p5_a2 JTF_VARCHAR2_TABLE_100
68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300
70: , p5_a5 JTF_DATE_TABLE

Line 68: , p5_a3 JTF_NUMBER_TABLE

64: , x_msg_data out nocopy VARCHAR2
65: , p5_a0 JTF_NUMBER_TABLE
66: , p5_a1 JTF_NUMBER_TABLE
67: , p5_a2 JTF_VARCHAR2_TABLE_100
68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300
70: , p5_a5 JTF_DATE_TABLE
71: , p5_a6 JTF_NUMBER_TABLE
72: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 71: , p5_a6 JTF_NUMBER_TABLE

67: , p5_a2 JTF_VARCHAR2_TABLE_100
68: , p5_a3 JTF_NUMBER_TABLE
69: , p5_a4 JTF_VARCHAR2_TABLE_300
70: , p5_a5 JTF_DATE_TABLE
71: , p5_a6 JTF_NUMBER_TABLE
72: , p5_a7 JTF_VARCHAR2_TABLE_100
73: , p5_a8 JTF_DATE_TABLE
74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE

Line 74: , p5_a9 JTF_NUMBER_TABLE

70: , p5_a5 JTF_DATE_TABLE
71: , p5_a6 JTF_NUMBER_TABLE
72: , p5_a7 JTF_VARCHAR2_TABLE_100
73: , p5_a8 JTF_DATE_TABLE
74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 76: , p5_a11 JTF_NUMBER_TABLE

72: , p5_a7 JTF_VARCHAR2_TABLE_100
73: , p5_a8 JTF_DATE_TABLE
74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE
79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 77: , p6_a0 out nocopy JTF_NUMBER_TABLE

73: , p5_a8 JTF_DATE_TABLE
74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE
79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 78: , p6_a1 out nocopy JTF_NUMBER_TABLE

74: , p5_a9 JTF_NUMBER_TABLE
75: , p5_a10 JTF_DATE_TABLE
76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE
79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , p6_a5 out nocopy JTF_DATE_TABLE

Line 80: , p6_a3 out nocopy JTF_NUMBER_TABLE

76: , p5_a11 JTF_NUMBER_TABLE
77: , p6_a0 out nocopy JTF_NUMBER_TABLE
78: , p6_a1 out nocopy JTF_NUMBER_TABLE
79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , p6_a5 out nocopy JTF_DATE_TABLE
83: , p6_a6 out nocopy JTF_NUMBER_TABLE
84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , p6_a6 out nocopy JTF_NUMBER_TABLE

79: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a3 out nocopy JTF_NUMBER_TABLE
81: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
82: , p6_a5 out nocopy JTF_DATE_TABLE
83: , p6_a6 out nocopy JTF_NUMBER_TABLE
84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
85: , p6_a8 out nocopy JTF_DATE_TABLE
86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE

Line 86: , p6_a9 out nocopy JTF_NUMBER_TABLE

82: , p6_a5 out nocopy JTF_DATE_TABLE
83: , p6_a6 out nocopy JTF_NUMBER_TABLE
84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
85: , p6_a8 out nocopy JTF_DATE_TABLE
86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE
89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , p6_a11 out nocopy JTF_NUMBER_TABLE

84: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
85: , p6_a8 out nocopy JTF_DATE_TABLE
86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE
89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 89: , p7_a0 in out nocopy JTF_NUMBER_TABLE

85: , p6_a8 out nocopy JTF_DATE_TABLE
86: , p6_a9 out nocopy JTF_NUMBER_TABLE
87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE
89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 91: , p7_a2 in out nocopy JTF_NUMBER_TABLE

87: , p6_a10 out nocopy JTF_DATE_TABLE
88: , p6_a11 out nocopy JTF_NUMBER_TABLE
89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE
94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , p7_a4 in out nocopy JTF_NUMBER_TABLE

89: , p7_a0 in out nocopy JTF_NUMBER_TABLE
90: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p7_a2 in out nocopy JTF_NUMBER_TABLE
92: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
93: , p7_a4 in out nocopy JTF_NUMBER_TABLE
94: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
96: );
97: procedure insert_row(p_api_version NUMBER

Line 102: , p5_a0 JTF_NUMBER_TABLE

98: , p_init_msg_list VARCHAR2
99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_VARCHAR2_TABLE_100
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 103: , p5_a1 JTF_NUMBER_TABLE

99: , x_return_status out nocopy VARCHAR2
100: , x_msg_count out nocopy NUMBER
101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_VARCHAR2_TABLE_100
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300
107: , p5_a5 JTF_DATE_TABLE

Line 105: , p5_a3 JTF_NUMBER_TABLE

101: , x_msg_data out nocopy VARCHAR2
102: , p5_a0 JTF_NUMBER_TABLE
103: , p5_a1 JTF_NUMBER_TABLE
104: , p5_a2 JTF_VARCHAR2_TABLE_100
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300
107: , p5_a5 JTF_DATE_TABLE
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 108: , p5_a6 JTF_NUMBER_TABLE

104: , p5_a2 JTF_VARCHAR2_TABLE_100
105: , p5_a3 JTF_NUMBER_TABLE
106: , p5_a4 JTF_VARCHAR2_TABLE_300
107: , p5_a5 JTF_DATE_TABLE
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_DATE_TABLE
111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE

Line 111: , p5_a9 JTF_NUMBER_TABLE

107: , p5_a5 JTF_DATE_TABLE
108: , p5_a6 JTF_NUMBER_TABLE
109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_DATE_TABLE
111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 113: , p5_a11 JTF_NUMBER_TABLE

109: , p5_a7 JTF_VARCHAR2_TABLE_100
110: , p5_a8 JTF_DATE_TABLE
111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE
116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 114: , p6_a0 out nocopy JTF_NUMBER_TABLE

110: , p5_a8 JTF_DATE_TABLE
111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE
116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 115: , p6_a1 out nocopy JTF_NUMBER_TABLE

111: , p5_a9 JTF_NUMBER_TABLE
112: , p5_a10 JTF_DATE_TABLE
113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE
116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
119: , p6_a5 out nocopy JTF_DATE_TABLE

Line 117: , p6_a3 out nocopy JTF_NUMBER_TABLE

113: , p5_a11 JTF_NUMBER_TABLE
114: , p6_a0 out nocopy JTF_NUMBER_TABLE
115: , p6_a1 out nocopy JTF_NUMBER_TABLE
116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
119: , p6_a5 out nocopy JTF_DATE_TABLE
120: , p6_a6 out nocopy JTF_NUMBER_TABLE
121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 120: , p6_a6 out nocopy JTF_NUMBER_TABLE

116: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
117: , p6_a3 out nocopy JTF_NUMBER_TABLE
118: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
119: , p6_a5 out nocopy JTF_DATE_TABLE
120: , p6_a6 out nocopy JTF_NUMBER_TABLE
121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
122: , p6_a8 out nocopy JTF_DATE_TABLE
123: , p6_a9 out nocopy JTF_NUMBER_TABLE
124: , p6_a10 out nocopy JTF_DATE_TABLE

Line 123: , p6_a9 out nocopy JTF_NUMBER_TABLE

119: , p6_a5 out nocopy JTF_DATE_TABLE
120: , p6_a6 out nocopy JTF_NUMBER_TABLE
121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
122: , p6_a8 out nocopy JTF_DATE_TABLE
123: , p6_a9 out nocopy JTF_NUMBER_TABLE
124: , p6_a10 out nocopy JTF_DATE_TABLE
125: , p6_a11 out nocopy JTF_NUMBER_TABLE
126: );
127: procedure lock_row(p_api_version NUMBER

Line 125: , p6_a11 out nocopy JTF_NUMBER_TABLE

121: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
122: , p6_a8 out nocopy JTF_DATE_TABLE
123: , p6_a9 out nocopy JTF_NUMBER_TABLE
124: , p6_a10 out nocopy JTF_DATE_TABLE
125: , p6_a11 out nocopy JTF_NUMBER_TABLE
126: );
127: procedure lock_row(p_api_version NUMBER
128: , p_init_msg_list VARCHAR2
129: , x_return_status out nocopy VARCHAR2

Line 150: , p5_a0 JTF_NUMBER_TABLE

146: , p_init_msg_list VARCHAR2
147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_NUMBER_TABLE
152: , p5_a2 JTF_VARCHAR2_TABLE_100
153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 151: , p5_a1 JTF_NUMBER_TABLE

147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_NUMBER_TABLE
152: , p5_a2 JTF_VARCHAR2_TABLE_100
153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300
155: , p5_a5 JTF_DATE_TABLE

Line 153: , p5_a3 JTF_NUMBER_TABLE

149: , x_msg_data out nocopy VARCHAR2
150: , p5_a0 JTF_NUMBER_TABLE
151: , p5_a1 JTF_NUMBER_TABLE
152: , p5_a2 JTF_VARCHAR2_TABLE_100
153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_NUMBER_TABLE
157: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 156: , p5_a6 JTF_NUMBER_TABLE

152: , p5_a2 JTF_VARCHAR2_TABLE_100
153: , p5_a3 JTF_NUMBER_TABLE
154: , p5_a4 JTF_VARCHAR2_TABLE_300
155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_NUMBER_TABLE
157: , p5_a7 JTF_VARCHAR2_TABLE_100
158: , p5_a8 JTF_DATE_TABLE
159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE

Line 159: , p5_a9 JTF_NUMBER_TABLE

155: , p5_a5 JTF_DATE_TABLE
156: , p5_a6 JTF_NUMBER_TABLE
157: , p5_a7 JTF_VARCHAR2_TABLE_100
158: , p5_a8 JTF_DATE_TABLE
159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE
162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 161: , p5_a11 JTF_NUMBER_TABLE

157: , p5_a7 JTF_VARCHAR2_TABLE_100
158: , p5_a8 JTF_DATE_TABLE
159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE
162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 162: , p6_a0 in out nocopy JTF_NUMBER_TABLE

158: , p5_a8 JTF_DATE_TABLE
159: , p5_a9 JTF_NUMBER_TABLE
160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE
162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 164: , p6_a2 in out nocopy JTF_NUMBER_TABLE

160: , p5_a10 JTF_DATE_TABLE
161: , p5_a11 JTF_NUMBER_TABLE
162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , p6_a4 in out nocopy JTF_NUMBER_TABLE

162: , p6_a0 in out nocopy JTF_NUMBER_TABLE
163: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
164: , p6_a2 in out nocopy JTF_NUMBER_TABLE
165: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
166: , p6_a4 in out nocopy JTF_NUMBER_TABLE
167: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
168: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
169: );
170: procedure lock_row(p_api_version NUMBER

Line 175: , p5_a0 JTF_NUMBER_TABLE

171: , p_init_msg_list VARCHAR2
172: , x_return_status out nocopy VARCHAR2
173: , x_msg_count out nocopy NUMBER
174: , x_msg_data out nocopy VARCHAR2
175: , p5_a0 JTF_NUMBER_TABLE
176: , p5_a1 JTF_NUMBER_TABLE
177: , p5_a2 JTF_VARCHAR2_TABLE_100
178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 176: , p5_a1 JTF_NUMBER_TABLE

172: , x_return_status out nocopy VARCHAR2
173: , x_msg_count out nocopy NUMBER
174: , x_msg_data out nocopy VARCHAR2
175: , p5_a0 JTF_NUMBER_TABLE
176: , p5_a1 JTF_NUMBER_TABLE
177: , p5_a2 JTF_VARCHAR2_TABLE_100
178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300
180: , p5_a5 JTF_DATE_TABLE

Line 178: , p5_a3 JTF_NUMBER_TABLE

174: , x_msg_data out nocopy VARCHAR2
175: , p5_a0 JTF_NUMBER_TABLE
176: , p5_a1 JTF_NUMBER_TABLE
177: , p5_a2 JTF_VARCHAR2_TABLE_100
178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300
180: , p5_a5 JTF_DATE_TABLE
181: , p5_a6 JTF_NUMBER_TABLE
182: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 181: , p5_a6 JTF_NUMBER_TABLE

177: , p5_a2 JTF_VARCHAR2_TABLE_100
178: , p5_a3 JTF_NUMBER_TABLE
179: , p5_a4 JTF_VARCHAR2_TABLE_300
180: , p5_a5 JTF_DATE_TABLE
181: , p5_a6 JTF_NUMBER_TABLE
182: , p5_a7 JTF_VARCHAR2_TABLE_100
183: , p5_a8 JTF_DATE_TABLE
184: , p5_a9 JTF_NUMBER_TABLE
185: , p5_a10 JTF_DATE_TABLE

Line 184: , p5_a9 JTF_NUMBER_TABLE

180: , p5_a5 JTF_DATE_TABLE
181: , p5_a6 JTF_NUMBER_TABLE
182: , p5_a7 JTF_VARCHAR2_TABLE_100
183: , p5_a8 JTF_DATE_TABLE
184: , p5_a9 JTF_NUMBER_TABLE
185: , p5_a10 JTF_DATE_TABLE
186: , p5_a11 JTF_NUMBER_TABLE
187: );
188: procedure update_row(p_api_version NUMBER

Line 186: , p5_a11 JTF_NUMBER_TABLE

182: , p5_a7 JTF_VARCHAR2_TABLE_100
183: , p5_a8 JTF_DATE_TABLE
184: , p5_a9 JTF_NUMBER_TABLE
185: , p5_a10 JTF_DATE_TABLE
186: , p5_a11 JTF_NUMBER_TABLE
187: );
188: procedure update_row(p_api_version NUMBER
189: , p_init_msg_list VARCHAR2
190: , x_return_status out nocopy VARCHAR2

Line 223: , p5_a0 JTF_NUMBER_TABLE

219: , p_init_msg_list VARCHAR2
220: , x_return_status out nocopy VARCHAR2
221: , x_msg_count out nocopy NUMBER
222: , x_msg_data out nocopy VARCHAR2
223: , p5_a0 JTF_NUMBER_TABLE
224: , p5_a1 JTF_NUMBER_TABLE
225: , p5_a2 JTF_VARCHAR2_TABLE_100
226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 224: , p5_a1 JTF_NUMBER_TABLE

220: , x_return_status out nocopy VARCHAR2
221: , x_msg_count out nocopy NUMBER
222: , x_msg_data out nocopy VARCHAR2
223: , p5_a0 JTF_NUMBER_TABLE
224: , p5_a1 JTF_NUMBER_TABLE
225: , p5_a2 JTF_VARCHAR2_TABLE_100
226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300
228: , p5_a5 JTF_DATE_TABLE

Line 226: , p5_a3 JTF_NUMBER_TABLE

222: , x_msg_data out nocopy VARCHAR2
223: , p5_a0 JTF_NUMBER_TABLE
224: , p5_a1 JTF_NUMBER_TABLE
225: , p5_a2 JTF_VARCHAR2_TABLE_100
226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300
228: , p5_a5 JTF_DATE_TABLE
229: , p5_a6 JTF_NUMBER_TABLE
230: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 229: , p5_a6 JTF_NUMBER_TABLE

225: , p5_a2 JTF_VARCHAR2_TABLE_100
226: , p5_a3 JTF_NUMBER_TABLE
227: , p5_a4 JTF_VARCHAR2_TABLE_300
228: , p5_a5 JTF_DATE_TABLE
229: , p5_a6 JTF_NUMBER_TABLE
230: , p5_a7 JTF_VARCHAR2_TABLE_100
231: , p5_a8 JTF_DATE_TABLE
232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE

Line 232: , p5_a9 JTF_NUMBER_TABLE

228: , p5_a5 JTF_DATE_TABLE
229: , p5_a6 JTF_NUMBER_TABLE
230: , p5_a7 JTF_VARCHAR2_TABLE_100
231: , p5_a8 JTF_DATE_TABLE
232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 234: , p5_a11 JTF_NUMBER_TABLE

230: , p5_a7 JTF_VARCHAR2_TABLE_100
231: , p5_a8 JTF_DATE_TABLE
232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 235: , p6_a0 out nocopy JTF_NUMBER_TABLE

231: , p5_a8 JTF_DATE_TABLE
232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 236: , p6_a1 out nocopy JTF_NUMBER_TABLE

232: , p5_a9 JTF_NUMBER_TABLE
233: , p5_a10 JTF_DATE_TABLE
234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
240: , p6_a5 out nocopy JTF_DATE_TABLE

Line 238: , p6_a3 out nocopy JTF_NUMBER_TABLE

234: , p5_a11 JTF_NUMBER_TABLE
235: , p6_a0 out nocopy JTF_NUMBER_TABLE
236: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
240: , p6_a5 out nocopy JTF_DATE_TABLE
241: , p6_a6 out nocopy JTF_NUMBER_TABLE
242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 241: , p6_a6 out nocopy JTF_NUMBER_TABLE

237: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
238: , p6_a3 out nocopy JTF_NUMBER_TABLE
239: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
240: , p6_a5 out nocopy JTF_DATE_TABLE
241: , p6_a6 out nocopy JTF_NUMBER_TABLE
242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a8 out nocopy JTF_DATE_TABLE
244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE

Line 244: , p6_a9 out nocopy JTF_NUMBER_TABLE

240: , p6_a5 out nocopy JTF_DATE_TABLE
241: , p6_a6 out nocopy JTF_NUMBER_TABLE
242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a8 out nocopy JTF_DATE_TABLE
244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE
247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , p6_a11 out nocopy JTF_NUMBER_TABLE

242: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
243: , p6_a8 out nocopy JTF_DATE_TABLE
244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE
247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 247: , p7_a0 in out nocopy JTF_NUMBER_TABLE

243: , p6_a8 out nocopy JTF_DATE_TABLE
244: , p6_a9 out nocopy JTF_NUMBER_TABLE
245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE
247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 249: , p7_a2 in out nocopy JTF_NUMBER_TABLE

245: , p6_a10 out nocopy JTF_DATE_TABLE
246: , p6_a11 out nocopy JTF_NUMBER_TABLE
247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE
252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , p7_a4 in out nocopy JTF_NUMBER_TABLE

247: , p7_a0 in out nocopy JTF_NUMBER_TABLE
248: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
249: , p7_a2 in out nocopy JTF_NUMBER_TABLE
250: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
251: , p7_a4 in out nocopy JTF_NUMBER_TABLE
252: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
254: );
255: procedure update_row(p_api_version NUMBER

Line 260: , p5_a0 JTF_NUMBER_TABLE

256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 261: , p5_a1 JTF_NUMBER_TABLE

257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300
265: , p5_a5 JTF_DATE_TABLE

Line 263: , p5_a3 JTF_NUMBER_TABLE

259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300
265: , p5_a5 JTF_DATE_TABLE
266: , p5_a6 JTF_NUMBER_TABLE
267: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 266: , p5_a6 JTF_NUMBER_TABLE

262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_300
265: , p5_a5 JTF_DATE_TABLE
266: , p5_a6 JTF_NUMBER_TABLE
267: , p5_a7 JTF_VARCHAR2_TABLE_100
268: , p5_a8 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE

Line 269: , p5_a9 JTF_NUMBER_TABLE

265: , p5_a5 JTF_DATE_TABLE
266: , p5_a6 JTF_NUMBER_TABLE
267: , p5_a7 JTF_VARCHAR2_TABLE_100
268: , p5_a8 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 271: , p5_a11 JTF_NUMBER_TABLE

267: , p5_a7 JTF_VARCHAR2_TABLE_100
268: , p5_a8 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 272: , p6_a0 out nocopy JTF_NUMBER_TABLE

268: , p5_a8 JTF_DATE_TABLE
269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 273: , p6_a1 out nocopy JTF_NUMBER_TABLE

269: , p5_a9 JTF_NUMBER_TABLE
270: , p5_a10 JTF_DATE_TABLE
271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a5 out nocopy JTF_DATE_TABLE

Line 275: , p6_a3 out nocopy JTF_NUMBER_TABLE

271: , p5_a11 JTF_NUMBER_TABLE
272: , p6_a0 out nocopy JTF_NUMBER_TABLE
273: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a5 out nocopy JTF_DATE_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 278: , p6_a6 out nocopy JTF_NUMBER_TABLE

274: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a3 out nocopy JTF_NUMBER_TABLE
276: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_300
277: , p6_a5 out nocopy JTF_DATE_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a8 out nocopy JTF_DATE_TABLE
281: , p6_a9 out nocopy JTF_NUMBER_TABLE
282: , p6_a10 out nocopy JTF_DATE_TABLE

Line 281: , p6_a9 out nocopy JTF_NUMBER_TABLE

277: , p6_a5 out nocopy JTF_DATE_TABLE
278: , p6_a6 out nocopy JTF_NUMBER_TABLE
279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a8 out nocopy JTF_DATE_TABLE
281: , p6_a9 out nocopy JTF_NUMBER_TABLE
282: , p6_a10 out nocopy JTF_DATE_TABLE
283: , p6_a11 out nocopy JTF_NUMBER_TABLE
284: );
285: procedure delete_row(p_api_version NUMBER

Line 283: , p6_a11 out nocopy JTF_NUMBER_TABLE

279: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a8 out nocopy JTF_DATE_TABLE
281: , p6_a9 out nocopy JTF_NUMBER_TABLE
282: , p6_a10 out nocopy JTF_DATE_TABLE
283: , p6_a11 out nocopy JTF_NUMBER_TABLE
284: );
285: procedure delete_row(p_api_version NUMBER
286: , p_init_msg_list VARCHAR2
287: , x_return_status out nocopy VARCHAR2

Line 308: , p5_a0 JTF_NUMBER_TABLE

304: , p_init_msg_list VARCHAR2
305: , x_return_status out nocopy VARCHAR2
306: , x_msg_count out nocopy NUMBER
307: , x_msg_data out nocopy VARCHAR2
308: , p5_a0 JTF_NUMBER_TABLE
309: , p5_a1 JTF_NUMBER_TABLE
310: , p5_a2 JTF_VARCHAR2_TABLE_100
311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 309: , p5_a1 JTF_NUMBER_TABLE

305: , x_return_status out nocopy VARCHAR2
306: , x_msg_count out nocopy NUMBER
307: , x_msg_data out nocopy VARCHAR2
308: , p5_a0 JTF_NUMBER_TABLE
309: , p5_a1 JTF_NUMBER_TABLE
310: , p5_a2 JTF_VARCHAR2_TABLE_100
311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300
313: , p5_a5 JTF_DATE_TABLE

Line 311: , p5_a3 JTF_NUMBER_TABLE

307: , x_msg_data out nocopy VARCHAR2
308: , p5_a0 JTF_NUMBER_TABLE
309: , p5_a1 JTF_NUMBER_TABLE
310: , p5_a2 JTF_VARCHAR2_TABLE_100
311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300
313: , p5_a5 JTF_DATE_TABLE
314: , p5_a6 JTF_NUMBER_TABLE
315: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 314: , p5_a6 JTF_NUMBER_TABLE

310: , p5_a2 JTF_VARCHAR2_TABLE_100
311: , p5_a3 JTF_NUMBER_TABLE
312: , p5_a4 JTF_VARCHAR2_TABLE_300
313: , p5_a5 JTF_DATE_TABLE
314: , p5_a6 JTF_NUMBER_TABLE
315: , p5_a7 JTF_VARCHAR2_TABLE_100
316: , p5_a8 JTF_DATE_TABLE
317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE

Line 317: , p5_a9 JTF_NUMBER_TABLE

313: , p5_a5 JTF_DATE_TABLE
314: , p5_a6 JTF_NUMBER_TABLE
315: , p5_a7 JTF_VARCHAR2_TABLE_100
316: , p5_a8 JTF_DATE_TABLE
317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE
320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p5_a11 JTF_NUMBER_TABLE

315: , p5_a7 JTF_VARCHAR2_TABLE_100
316: , p5_a8 JTF_DATE_TABLE
317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE
320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 320: , p6_a0 in out nocopy JTF_NUMBER_TABLE

316: , p5_a8 JTF_DATE_TABLE
317: , p5_a9 JTF_NUMBER_TABLE
318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE
320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 322: , p6_a2 in out nocopy JTF_NUMBER_TABLE

318: , p5_a10 JTF_DATE_TABLE
319: , p5_a11 JTF_NUMBER_TABLE
320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE
325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 324: , p6_a4 in out nocopy JTF_NUMBER_TABLE

320: , p6_a0 in out nocopy JTF_NUMBER_TABLE
321: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a2 in out nocopy JTF_NUMBER_TABLE
323: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
324: , p6_a4 in out nocopy JTF_NUMBER_TABLE
325: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
327: );
328: procedure delete_row(p_api_version NUMBER

Line 333: , p5_a0 JTF_NUMBER_TABLE

329: , p_init_msg_list VARCHAR2
330: , x_return_status out nocopy VARCHAR2
331: , x_msg_count out nocopy NUMBER
332: , x_msg_data out nocopy VARCHAR2
333: , p5_a0 JTF_NUMBER_TABLE
334: , p5_a1 JTF_NUMBER_TABLE
335: , p5_a2 JTF_VARCHAR2_TABLE_100
336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 334: , p5_a1 JTF_NUMBER_TABLE

330: , x_return_status out nocopy VARCHAR2
331: , x_msg_count out nocopy NUMBER
332: , x_msg_data out nocopy VARCHAR2
333: , p5_a0 JTF_NUMBER_TABLE
334: , p5_a1 JTF_NUMBER_TABLE
335: , p5_a2 JTF_VARCHAR2_TABLE_100
336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300
338: , p5_a5 JTF_DATE_TABLE

Line 336: , p5_a3 JTF_NUMBER_TABLE

332: , x_msg_data out nocopy VARCHAR2
333: , p5_a0 JTF_NUMBER_TABLE
334: , p5_a1 JTF_NUMBER_TABLE
335: , p5_a2 JTF_VARCHAR2_TABLE_100
336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300
338: , p5_a5 JTF_DATE_TABLE
339: , p5_a6 JTF_NUMBER_TABLE
340: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 339: , p5_a6 JTF_NUMBER_TABLE

335: , p5_a2 JTF_VARCHAR2_TABLE_100
336: , p5_a3 JTF_NUMBER_TABLE
337: , p5_a4 JTF_VARCHAR2_TABLE_300
338: , p5_a5 JTF_DATE_TABLE
339: , p5_a6 JTF_NUMBER_TABLE
340: , p5_a7 JTF_VARCHAR2_TABLE_100
341: , p5_a8 JTF_DATE_TABLE
342: , p5_a9 JTF_NUMBER_TABLE
343: , p5_a10 JTF_DATE_TABLE

Line 342: , p5_a9 JTF_NUMBER_TABLE

338: , p5_a5 JTF_DATE_TABLE
339: , p5_a6 JTF_NUMBER_TABLE
340: , p5_a7 JTF_VARCHAR2_TABLE_100
341: , p5_a8 JTF_DATE_TABLE
342: , p5_a9 JTF_NUMBER_TABLE
343: , p5_a10 JTF_DATE_TABLE
344: , p5_a11 JTF_NUMBER_TABLE
345: );
346: procedure validate_row(p_api_version NUMBER

Line 344: , p5_a11 JTF_NUMBER_TABLE

340: , p5_a7 JTF_VARCHAR2_TABLE_100
341: , p5_a8 JTF_DATE_TABLE
342: , p5_a9 JTF_NUMBER_TABLE
343: , p5_a10 JTF_DATE_TABLE
344: , p5_a11 JTF_NUMBER_TABLE
345: );
346: procedure validate_row(p_api_version NUMBER
347: , p_init_msg_list VARCHAR2
348: , x_return_status out nocopy VARCHAR2

Line 369: , p5_a0 JTF_NUMBER_TABLE

365: , p_init_msg_list VARCHAR2
366: , x_return_status out nocopy VARCHAR2
367: , x_msg_count out nocopy NUMBER
368: , x_msg_data out nocopy VARCHAR2
369: , p5_a0 JTF_NUMBER_TABLE
370: , p5_a1 JTF_NUMBER_TABLE
371: , p5_a2 JTF_VARCHAR2_TABLE_100
372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 370: , p5_a1 JTF_NUMBER_TABLE

366: , x_return_status out nocopy VARCHAR2
367: , x_msg_count out nocopy NUMBER
368: , x_msg_data out nocopy VARCHAR2
369: , p5_a0 JTF_NUMBER_TABLE
370: , p5_a1 JTF_NUMBER_TABLE
371: , p5_a2 JTF_VARCHAR2_TABLE_100
372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300
374: , p5_a5 JTF_DATE_TABLE

Line 372: , p5_a3 JTF_NUMBER_TABLE

368: , x_msg_data out nocopy VARCHAR2
369: , p5_a0 JTF_NUMBER_TABLE
370: , p5_a1 JTF_NUMBER_TABLE
371: , p5_a2 JTF_VARCHAR2_TABLE_100
372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300
374: , p5_a5 JTF_DATE_TABLE
375: , p5_a6 JTF_NUMBER_TABLE
376: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 375: , p5_a6 JTF_NUMBER_TABLE

371: , p5_a2 JTF_VARCHAR2_TABLE_100
372: , p5_a3 JTF_NUMBER_TABLE
373: , p5_a4 JTF_VARCHAR2_TABLE_300
374: , p5_a5 JTF_DATE_TABLE
375: , p5_a6 JTF_NUMBER_TABLE
376: , p5_a7 JTF_VARCHAR2_TABLE_100
377: , p5_a8 JTF_DATE_TABLE
378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE

Line 378: , p5_a9 JTF_NUMBER_TABLE

374: , p5_a5 JTF_DATE_TABLE
375: , p5_a6 JTF_NUMBER_TABLE
376: , p5_a7 JTF_VARCHAR2_TABLE_100
377: , p5_a8 JTF_DATE_TABLE
378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE
381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 380: , p5_a11 JTF_NUMBER_TABLE

376: , p5_a7 JTF_VARCHAR2_TABLE_100
377: , p5_a8 JTF_DATE_TABLE
378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE
381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 381: , p6_a0 in out nocopy JTF_NUMBER_TABLE

377: , p5_a8 JTF_DATE_TABLE
378: , p5_a9 JTF_NUMBER_TABLE
379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE
381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 383: , p6_a2 in out nocopy JTF_NUMBER_TABLE

379: , p5_a10 JTF_DATE_TABLE
380: , p5_a11 JTF_NUMBER_TABLE
381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE
386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 385: , p6_a4 in out nocopy JTF_NUMBER_TABLE

381: , p6_a0 in out nocopy JTF_NUMBER_TABLE
382: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
383: , p6_a2 in out nocopy JTF_NUMBER_TABLE
384: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
385: , p6_a4 in out nocopy JTF_NUMBER_TABLE
386: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
388: );
389: procedure validate_row(p_api_version NUMBER

Line 394: , p5_a0 JTF_NUMBER_TABLE

390: , p_init_msg_list VARCHAR2
391: , x_return_status out nocopy VARCHAR2
392: , x_msg_count out nocopy NUMBER
393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_NUMBER_TABLE
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_VARCHAR2_TABLE_100
397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300

Line 395: , p5_a1 JTF_NUMBER_TABLE

391: , x_return_status out nocopy VARCHAR2
392: , x_msg_count out nocopy NUMBER
393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_NUMBER_TABLE
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_VARCHAR2_TABLE_100
397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300
399: , p5_a5 JTF_DATE_TABLE

Line 397: , p5_a3 JTF_NUMBER_TABLE

393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_NUMBER_TABLE
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_VARCHAR2_TABLE_100
397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300
399: , p5_a5 JTF_DATE_TABLE
400: , p5_a6 JTF_NUMBER_TABLE
401: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 400: , p5_a6 JTF_NUMBER_TABLE

396: , p5_a2 JTF_VARCHAR2_TABLE_100
397: , p5_a3 JTF_NUMBER_TABLE
398: , p5_a4 JTF_VARCHAR2_TABLE_300
399: , p5_a5 JTF_DATE_TABLE
400: , p5_a6 JTF_NUMBER_TABLE
401: , p5_a7 JTF_VARCHAR2_TABLE_100
402: , p5_a8 JTF_DATE_TABLE
403: , p5_a9 JTF_NUMBER_TABLE
404: , p5_a10 JTF_DATE_TABLE

Line 403: , p5_a9 JTF_NUMBER_TABLE

399: , p5_a5 JTF_DATE_TABLE
400: , p5_a6 JTF_NUMBER_TABLE
401: , p5_a7 JTF_VARCHAR2_TABLE_100
402: , p5_a8 JTF_DATE_TABLE
403: , p5_a9 JTF_NUMBER_TABLE
404: , p5_a10 JTF_DATE_TABLE
405: , p5_a11 JTF_NUMBER_TABLE
406: );
407: end okl_rpp_pvt_w;

Line 405: , p5_a11 JTF_NUMBER_TABLE

401: , p5_a7 JTF_VARCHAR2_TABLE_100
402: , p5_a8 JTF_DATE_TABLE
403: , p5_a9 JTF_NUMBER_TABLE
404: , p5_a10 JTF_DATE_TABLE
405: , p5_a11 JTF_NUMBER_TABLE
406: );
407: end okl_rpp_pvt_w;