APPS.OKL_PMR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pmr_pvt.pmr_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_pmr_pvt_w as
2: /* $Header: OKLIPMRS.pls 120.1 2005/07/14 11:58:08 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pmr_pvt.pmr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIPMRS.pls 120.1 2005/07/14 11:58:08 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pmr_pvt.pmr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_200
16: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 14: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_200
16: , a2 out nocopy JTF_VARCHAR2_TABLE_200
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 17: , a3 out nocopy JTF_NUMBER_TABLE

13: );
14: procedure rosetta_table_copy_out_p2(t okl_pmr_pvt.pmr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_VARCHAR2_TABLE_200
16: , a2 out nocopy JTF_VARCHAR2_TABLE_200
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE

Line 19: , a5 out nocopy JTF_NUMBER_TABLE

15: , a1 out nocopy JTF_VARCHAR2_TABLE_200
16: , a2 out nocopy JTF_VARCHAR2_TABLE_200
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE

Line 21: , a7 out nocopy JTF_NUMBER_TABLE

17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:

Line 23: , a9 out nocopy JTF_NUMBER_TABLE

19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_VARCHAR2_TABLE_100

Line 26: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE

22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure rosetta_table_copy_in_p5(t out nocopy okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 JTF_NUMBER_TABLE
27: , a1 JTF_VARCHAR2_TABLE_100
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_2000

Line 31: , a5 JTF_NUMBER_TABLE

27: , a1 JTF_VARCHAR2_TABLE_100
28: , a2 JTF_VARCHAR2_TABLE_100
29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_2000
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE

Line 33: , a7 JTF_NUMBER_TABLE

29: , a3 JTF_VARCHAR2_TABLE_100
30: , a4 JTF_VARCHAR2_TABLE_2000
31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 35: , a9 JTF_NUMBER_TABLE

31: , a5 JTF_NUMBER_TABLE
32: , a6 JTF_DATE_TABLE
33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_100
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

33: , a7 JTF_NUMBER_TABLE
34: , a8 JTF_DATE_TABLE
35: , a9 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p5(t okl_pmr_pvt.okl_parameters_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_100
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 42: , a5 out nocopy JTF_NUMBER_TABLE

38: , a1 out nocopy JTF_VARCHAR2_TABLE_100
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE

Line 44: , a7 out nocopy JTF_NUMBER_TABLE

40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:

Line 46: , a9 out nocopy JTF_NUMBER_TABLE

42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_DATE_TABLE
44: , a7 out nocopy JTF_NUMBER_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE

Line 49: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE

45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_VARCHAR2_TABLE_100
52: , a3 JTF_VARCHAR2_TABLE_100
53: , a4 JTF_VARCHAR2_TABLE_200

Line 50: , a1 JTF_NUMBER_TABLE

46: , a9 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure rosetta_table_copy_in_p8(t out nocopy okl_pmr_pvt.pmrv_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_VARCHAR2_TABLE_100
52: , a3 JTF_VARCHAR2_TABLE_100
53: , a4 JTF_VARCHAR2_TABLE_200
54: , a5 JTF_VARCHAR2_TABLE_200

Line 56: , a7 JTF_NUMBER_TABLE

52: , a3 JTF_VARCHAR2_TABLE_100
53: , a4 JTF_VARCHAR2_TABLE_200
54: , a5 JTF_VARCHAR2_TABLE_200
55: , a6 JTF_VARCHAR2_TABLE_2000
56: , a7 JTF_NUMBER_TABLE
57: , a8 JTF_DATE_TABLE
58: , a9 JTF_NUMBER_TABLE
59: , a10 JTF_DATE_TABLE
60: , a11 JTF_NUMBER_TABLE

Line 58: , a9 JTF_NUMBER_TABLE

54: , a5 JTF_VARCHAR2_TABLE_200
55: , a6 JTF_VARCHAR2_TABLE_2000
56: , a7 JTF_NUMBER_TABLE
57: , a8 JTF_DATE_TABLE
58: , a9 JTF_NUMBER_TABLE
59: , a10 JTF_DATE_TABLE
60: , a11 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 60: , a11 JTF_NUMBER_TABLE

56: , a7 JTF_NUMBER_TABLE
57: , a8 JTF_DATE_TABLE
58: , a9 JTF_NUMBER_TABLE
59: , a10 JTF_DATE_TABLE
60: , a11 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

58: , a9 JTF_NUMBER_TABLE
59: , a10 JTF_DATE_TABLE
60: , a11 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_100
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 63: , a1 out nocopy JTF_NUMBER_TABLE

59: , a10 JTF_DATE_TABLE
60: , a11 JTF_NUMBER_TABLE
61: );
62: procedure rosetta_table_copy_out_p8(t okl_pmr_pvt.pmrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
63: , a1 out nocopy JTF_NUMBER_TABLE
64: , a2 out nocopy JTF_VARCHAR2_TABLE_100
65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_200
67: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a7 out nocopy JTF_NUMBER_TABLE

65: , a3 out nocopy JTF_VARCHAR2_TABLE_100
66: , a4 out nocopy JTF_VARCHAR2_TABLE_200
67: , a5 out nocopy JTF_VARCHAR2_TABLE_200
68: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a7 out nocopy JTF_NUMBER_TABLE
70: , a8 out nocopy JTF_DATE_TABLE
71: , a9 out nocopy JTF_NUMBER_TABLE
72: , a10 out nocopy JTF_DATE_TABLE
73: , a11 out nocopy JTF_NUMBER_TABLE

Line 71: , a9 out nocopy JTF_NUMBER_TABLE

67: , a5 out nocopy JTF_VARCHAR2_TABLE_200
68: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
69: , a7 out nocopy JTF_NUMBER_TABLE
70: , a8 out nocopy JTF_DATE_TABLE
71: , a9 out nocopy JTF_NUMBER_TABLE
72: , a10 out nocopy JTF_DATE_TABLE
73: , a11 out nocopy JTF_NUMBER_TABLE
74: );
75:

Line 73: , a11 out nocopy JTF_NUMBER_TABLE

69: , a7 out nocopy JTF_NUMBER_TABLE
70: , a8 out nocopy JTF_DATE_TABLE
71: , a9 out nocopy JTF_NUMBER_TABLE
72: , a10 out nocopy JTF_DATE_TABLE
73: , a11 out nocopy JTF_NUMBER_TABLE
74: );
75:
76: procedure insert_row(p_api_version NUMBER
77: , p_init_msg_list VARCHAR2

Line 111: , p5_a0 JTF_NUMBER_TABLE

107: , p_init_msg_list VARCHAR2
108: , x_return_status out nocopy VARCHAR2
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: , p5_a0 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_VARCHAR2_TABLE_100
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 112: , p5_a1 JTF_NUMBER_TABLE

108: , x_return_status out nocopy VARCHAR2
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: , p5_a0 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_VARCHAR2_TABLE_100
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_200
116: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 118: , p5_a7 JTF_NUMBER_TABLE

114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_200
116: , p5_a5 JTF_VARCHAR2_TABLE_200
117: , p5_a6 JTF_VARCHAR2_TABLE_2000
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_DATE_TABLE
120: , p5_a9 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_NUMBER_TABLE

Line 120: , p5_a9 JTF_NUMBER_TABLE

116: , p5_a5 JTF_VARCHAR2_TABLE_200
117: , p5_a6 JTF_VARCHAR2_TABLE_2000
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_DATE_TABLE
120: , p5_a9 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_NUMBER_TABLE
123: , p6_a0 out nocopy JTF_NUMBER_TABLE
124: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 122: , p5_a11 JTF_NUMBER_TABLE

118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_DATE_TABLE
120: , p5_a9 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_NUMBER_TABLE
123: , p6_a0 out nocopy JTF_NUMBER_TABLE
124: , p6_a1 out nocopy JTF_NUMBER_TABLE
125: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 123: , p6_a0 out nocopy JTF_NUMBER_TABLE

119: , p5_a8 JTF_DATE_TABLE
120: , p5_a9 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_NUMBER_TABLE
123: , p6_a0 out nocopy JTF_NUMBER_TABLE
124: , p6_a1 out nocopy JTF_NUMBER_TABLE
125: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 124: , p6_a1 out nocopy JTF_NUMBER_TABLE

120: , p5_a9 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_NUMBER_TABLE
123: , p6_a0 out nocopy JTF_NUMBER_TABLE
124: , p6_a1 out nocopy JTF_NUMBER_TABLE
125: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
126: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 130: , p6_a7 out nocopy JTF_NUMBER_TABLE

126: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
128: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
129: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
130: , p6_a7 out nocopy JTF_NUMBER_TABLE
131: , p6_a8 out nocopy JTF_DATE_TABLE
132: , p6_a9 out nocopy JTF_NUMBER_TABLE
133: , p6_a10 out nocopy JTF_DATE_TABLE
134: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 132: , p6_a9 out nocopy JTF_NUMBER_TABLE

128: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
129: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
130: , p6_a7 out nocopy JTF_NUMBER_TABLE
131: , p6_a8 out nocopy JTF_DATE_TABLE
132: , p6_a9 out nocopy JTF_NUMBER_TABLE
133: , p6_a10 out nocopy JTF_DATE_TABLE
134: , p6_a11 out nocopy JTF_NUMBER_TABLE
135: );
136: procedure lock_row(p_api_version NUMBER

Line 134: , p6_a11 out nocopy JTF_NUMBER_TABLE

130: , p6_a7 out nocopy JTF_NUMBER_TABLE
131: , p6_a8 out nocopy JTF_DATE_TABLE
132: , p6_a9 out nocopy JTF_NUMBER_TABLE
133: , p6_a10 out nocopy JTF_DATE_TABLE
134: , p6_a11 out nocopy JTF_NUMBER_TABLE
135: );
136: procedure lock_row(p_api_version NUMBER
137: , p_init_msg_list VARCHAR2
138: , x_return_status out nocopy VARCHAR2

Line 159: , p5_a0 JTF_NUMBER_TABLE

155: , p_init_msg_list VARCHAR2
156: , x_return_status out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
158: , x_msg_data out nocopy VARCHAR2
159: , p5_a0 JTF_NUMBER_TABLE
160: , p5_a1 JTF_NUMBER_TABLE
161: , p5_a2 JTF_VARCHAR2_TABLE_100
162: , p5_a3 JTF_VARCHAR2_TABLE_100
163: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 160: , p5_a1 JTF_NUMBER_TABLE

156: , x_return_status out nocopy VARCHAR2
157: , x_msg_count out nocopy NUMBER
158: , x_msg_data out nocopy VARCHAR2
159: , p5_a0 JTF_NUMBER_TABLE
160: , p5_a1 JTF_NUMBER_TABLE
161: , p5_a2 JTF_VARCHAR2_TABLE_100
162: , p5_a3 JTF_VARCHAR2_TABLE_100
163: , p5_a4 JTF_VARCHAR2_TABLE_200
164: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 166: , p5_a7 JTF_NUMBER_TABLE

162: , p5_a3 JTF_VARCHAR2_TABLE_100
163: , p5_a4 JTF_VARCHAR2_TABLE_200
164: , p5_a5 JTF_VARCHAR2_TABLE_200
165: , p5_a6 JTF_VARCHAR2_TABLE_2000
166: , p5_a7 JTF_NUMBER_TABLE
167: , p5_a8 JTF_DATE_TABLE
168: , p5_a9 JTF_NUMBER_TABLE
169: , p5_a10 JTF_DATE_TABLE
170: , p5_a11 JTF_NUMBER_TABLE

Line 168: , p5_a9 JTF_NUMBER_TABLE

164: , p5_a5 JTF_VARCHAR2_TABLE_200
165: , p5_a6 JTF_VARCHAR2_TABLE_2000
166: , p5_a7 JTF_NUMBER_TABLE
167: , p5_a8 JTF_DATE_TABLE
168: , p5_a9 JTF_NUMBER_TABLE
169: , p5_a10 JTF_DATE_TABLE
170: , p5_a11 JTF_NUMBER_TABLE
171: );
172: procedure update_row(p_api_version NUMBER

Line 170: , p5_a11 JTF_NUMBER_TABLE

166: , p5_a7 JTF_NUMBER_TABLE
167: , p5_a8 JTF_DATE_TABLE
168: , p5_a9 JTF_NUMBER_TABLE
169: , p5_a10 JTF_DATE_TABLE
170: , p5_a11 JTF_NUMBER_TABLE
171: );
172: procedure update_row(p_api_version NUMBER
173: , p_init_msg_list VARCHAR2
174: , x_return_status out nocopy VARCHAR2

Line 207: , p5_a0 JTF_NUMBER_TABLE

203: , p_init_msg_list VARCHAR2
204: , x_return_status out nocopy VARCHAR2
205: , x_msg_count out nocopy NUMBER
206: , x_msg_data out nocopy VARCHAR2
207: , p5_a0 JTF_NUMBER_TABLE
208: , p5_a1 JTF_NUMBER_TABLE
209: , p5_a2 JTF_VARCHAR2_TABLE_100
210: , p5_a3 JTF_VARCHAR2_TABLE_100
211: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 208: , p5_a1 JTF_NUMBER_TABLE

204: , x_return_status out nocopy VARCHAR2
205: , x_msg_count out nocopy NUMBER
206: , x_msg_data out nocopy VARCHAR2
207: , p5_a0 JTF_NUMBER_TABLE
208: , p5_a1 JTF_NUMBER_TABLE
209: , p5_a2 JTF_VARCHAR2_TABLE_100
210: , p5_a3 JTF_VARCHAR2_TABLE_100
211: , p5_a4 JTF_VARCHAR2_TABLE_200
212: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 214: , p5_a7 JTF_NUMBER_TABLE

210: , p5_a3 JTF_VARCHAR2_TABLE_100
211: , p5_a4 JTF_VARCHAR2_TABLE_200
212: , p5_a5 JTF_VARCHAR2_TABLE_200
213: , p5_a6 JTF_VARCHAR2_TABLE_2000
214: , p5_a7 JTF_NUMBER_TABLE
215: , p5_a8 JTF_DATE_TABLE
216: , p5_a9 JTF_NUMBER_TABLE
217: , p5_a10 JTF_DATE_TABLE
218: , p5_a11 JTF_NUMBER_TABLE

Line 216: , p5_a9 JTF_NUMBER_TABLE

212: , p5_a5 JTF_VARCHAR2_TABLE_200
213: , p5_a6 JTF_VARCHAR2_TABLE_2000
214: , p5_a7 JTF_NUMBER_TABLE
215: , p5_a8 JTF_DATE_TABLE
216: , p5_a9 JTF_NUMBER_TABLE
217: , p5_a10 JTF_DATE_TABLE
218: , p5_a11 JTF_NUMBER_TABLE
219: , p6_a0 out nocopy JTF_NUMBER_TABLE
220: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 218: , p5_a11 JTF_NUMBER_TABLE

214: , p5_a7 JTF_NUMBER_TABLE
215: , p5_a8 JTF_DATE_TABLE
216: , p5_a9 JTF_NUMBER_TABLE
217: , p5_a10 JTF_DATE_TABLE
218: , p5_a11 JTF_NUMBER_TABLE
219: , p6_a0 out nocopy JTF_NUMBER_TABLE
220: , p6_a1 out nocopy JTF_NUMBER_TABLE
221: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 219: , p6_a0 out nocopy JTF_NUMBER_TABLE

215: , p5_a8 JTF_DATE_TABLE
216: , p5_a9 JTF_NUMBER_TABLE
217: , p5_a10 JTF_DATE_TABLE
218: , p5_a11 JTF_NUMBER_TABLE
219: , p6_a0 out nocopy JTF_NUMBER_TABLE
220: , p6_a1 out nocopy JTF_NUMBER_TABLE
221: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 220: , p6_a1 out nocopy JTF_NUMBER_TABLE

216: , p5_a9 JTF_NUMBER_TABLE
217: , p5_a10 JTF_DATE_TABLE
218: , p5_a11 JTF_NUMBER_TABLE
219: , p6_a0 out nocopy JTF_NUMBER_TABLE
220: , p6_a1 out nocopy JTF_NUMBER_TABLE
221: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
222: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
224: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 226: , p6_a7 out nocopy JTF_NUMBER_TABLE

222: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
224: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a7 out nocopy JTF_NUMBER_TABLE
227: , p6_a8 out nocopy JTF_DATE_TABLE
228: , p6_a9 out nocopy JTF_NUMBER_TABLE
229: , p6_a10 out nocopy JTF_DATE_TABLE
230: , p6_a11 out nocopy JTF_NUMBER_TABLE

Line 228: , p6_a9 out nocopy JTF_NUMBER_TABLE

224: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
225: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a7 out nocopy JTF_NUMBER_TABLE
227: , p6_a8 out nocopy JTF_DATE_TABLE
228: , p6_a9 out nocopy JTF_NUMBER_TABLE
229: , p6_a10 out nocopy JTF_DATE_TABLE
230: , p6_a11 out nocopy JTF_NUMBER_TABLE
231: );
232: procedure delete_row(p_api_version NUMBER

Line 230: , p6_a11 out nocopy JTF_NUMBER_TABLE

226: , p6_a7 out nocopy JTF_NUMBER_TABLE
227: , p6_a8 out nocopy JTF_DATE_TABLE
228: , p6_a9 out nocopy JTF_NUMBER_TABLE
229: , p6_a10 out nocopy JTF_DATE_TABLE
230: , p6_a11 out nocopy JTF_NUMBER_TABLE
231: );
232: procedure delete_row(p_api_version NUMBER
233: , p_init_msg_list VARCHAR2
234: , x_return_status out nocopy VARCHAR2

Line 255: , p5_a0 JTF_NUMBER_TABLE

251: , p_init_msg_list VARCHAR2
252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_NUMBER_TABLE
257: , p5_a2 JTF_VARCHAR2_TABLE_100
258: , p5_a3 JTF_VARCHAR2_TABLE_100
259: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 256: , p5_a1 JTF_NUMBER_TABLE

252: , x_return_status out nocopy VARCHAR2
253: , x_msg_count out nocopy NUMBER
254: , x_msg_data out nocopy VARCHAR2
255: , p5_a0 JTF_NUMBER_TABLE
256: , p5_a1 JTF_NUMBER_TABLE
257: , p5_a2 JTF_VARCHAR2_TABLE_100
258: , p5_a3 JTF_VARCHAR2_TABLE_100
259: , p5_a4 JTF_VARCHAR2_TABLE_200
260: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 262: , p5_a7 JTF_NUMBER_TABLE

258: , p5_a3 JTF_VARCHAR2_TABLE_100
259: , p5_a4 JTF_VARCHAR2_TABLE_200
260: , p5_a5 JTF_VARCHAR2_TABLE_200
261: , p5_a6 JTF_VARCHAR2_TABLE_2000
262: , p5_a7 JTF_NUMBER_TABLE
263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_DATE_TABLE
266: , p5_a11 JTF_NUMBER_TABLE

Line 264: , p5_a9 JTF_NUMBER_TABLE

260: , p5_a5 JTF_VARCHAR2_TABLE_200
261: , p5_a6 JTF_VARCHAR2_TABLE_2000
262: , p5_a7 JTF_NUMBER_TABLE
263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_DATE_TABLE
266: , p5_a11 JTF_NUMBER_TABLE
267: );
268: procedure validate_row(p_api_version NUMBER

Line 266: , p5_a11 JTF_NUMBER_TABLE

262: , p5_a7 JTF_NUMBER_TABLE
263: , p5_a8 JTF_DATE_TABLE
264: , p5_a9 JTF_NUMBER_TABLE
265: , p5_a10 JTF_DATE_TABLE
266: , p5_a11 JTF_NUMBER_TABLE
267: );
268: procedure validate_row(p_api_version NUMBER
269: , p_init_msg_list VARCHAR2
270: , x_return_status out nocopy VARCHAR2

Line 291: , p5_a0 JTF_NUMBER_TABLE

287: , p_init_msg_list VARCHAR2
288: , x_return_status out nocopy VARCHAR2
289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p5_a0 JTF_NUMBER_TABLE
292: , p5_a1 JTF_NUMBER_TABLE
293: , p5_a2 JTF_VARCHAR2_TABLE_100
294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_200

Line 292: , p5_a1 JTF_NUMBER_TABLE

288: , x_return_status out nocopy VARCHAR2
289: , x_msg_count out nocopy NUMBER
290: , x_msg_data out nocopy VARCHAR2
291: , p5_a0 JTF_NUMBER_TABLE
292: , p5_a1 JTF_NUMBER_TABLE
293: , p5_a2 JTF_VARCHAR2_TABLE_100
294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_200
296: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 298: , p5_a7 JTF_NUMBER_TABLE

294: , p5_a3 JTF_VARCHAR2_TABLE_100
295: , p5_a4 JTF_VARCHAR2_TABLE_200
296: , p5_a5 JTF_VARCHAR2_TABLE_200
297: , p5_a6 JTF_VARCHAR2_TABLE_2000
298: , p5_a7 JTF_NUMBER_TABLE
299: , p5_a8 JTF_DATE_TABLE
300: , p5_a9 JTF_NUMBER_TABLE
301: , p5_a10 JTF_DATE_TABLE
302: , p5_a11 JTF_NUMBER_TABLE

Line 300: , p5_a9 JTF_NUMBER_TABLE

296: , p5_a5 JTF_VARCHAR2_TABLE_200
297: , p5_a6 JTF_VARCHAR2_TABLE_2000
298: , p5_a7 JTF_NUMBER_TABLE
299: , p5_a8 JTF_DATE_TABLE
300: , p5_a9 JTF_NUMBER_TABLE
301: , p5_a10 JTF_DATE_TABLE
302: , p5_a11 JTF_NUMBER_TABLE
303: );
304: end okl_pmr_pvt_w;

Line 302: , p5_a11 JTF_NUMBER_TABLE

298: , p5_a7 JTF_NUMBER_TABLE
299: , p5_a8 JTF_DATE_TABLE
300: , p5_a9 JTF_NUMBER_TABLE
301: , p5_a10 JTF_DATE_TABLE
302: , p5_a11 JTF_NUMBER_TABLE
303: );
304: end okl_pmr_pvt_w;