DBA Data[Home] [Help]

APPS.OKL_OVD_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_ovd_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOVDS.pls 115.3 2002/12/24 04:06:39 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_ovd_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOVDS.pls 115.3 2002/12/24 04:06:39 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIOVDS.pls 115.3 2002/12/24 04:06:39 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ovd_pvt.ovd_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_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_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_2000

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: );

Line 17: , a14 JTF_NUMBER_TABLE

13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE

Line 19: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 21: , a2 out nocopy JTF_NUMBER_TABLE

17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE

Line 22: , a3 out nocopy JTF_NUMBER_TABLE

18: );
19: procedure rosetta_table_copy_out_p2(t okl_ovd_pvt.ovd_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE

Line 24: , a5 out nocopy JTF_NUMBER_TABLE

20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_NUMBER_TABLE

Line 25: , a6 out nocopy JTF_NUMBER_TABLE

21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE

Line 26: , a7 out nocopy JTF_NUMBER_TABLE

22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE

Line 28: , a9 out nocopy JTF_NUMBER_TABLE

24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_2000

Line 30: , a11 out nocopy JTF_NUMBER_TABLE

26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_NUMBER_TABLE
29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );

Line 33: , a14 out nocopy JTF_NUMBER_TABLE

29: , a10 out nocopy JTF_DATE_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_DATE_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_VARCHAR2_TABLE_100

Line 36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE

32: , a13 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_NUMBER_TABLE
39: , a3 JTF_NUMBER_TABLE
40: , a4 JTF_NUMBER_TABLE

Line 38: , a2 JTF_NUMBER_TABLE

34: );
35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_NUMBER_TABLE
39: , a3 JTF_NUMBER_TABLE
40: , a4 JTF_NUMBER_TABLE
41: , a5 JTF_VARCHAR2_TABLE_2000
42: , a6 JTF_VARCHAR2_TABLE_100

Line 39: , a3 JTF_NUMBER_TABLE

35:
36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_NUMBER_TABLE
39: , a3 JTF_NUMBER_TABLE
40: , a4 JTF_NUMBER_TABLE
41: , a5 JTF_VARCHAR2_TABLE_2000
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_NUMBER_TABLE

Line 40: , a4 JTF_NUMBER_TABLE

36: procedure rosetta_table_copy_in_p5(t out nocopy okl_ovd_pvt.ovdv_tbl_type, a0 JTF_NUMBER_TABLE
37: , a1 JTF_VARCHAR2_TABLE_100
38: , a2 JTF_NUMBER_TABLE
39: , a3 JTF_NUMBER_TABLE
40: , a4 JTF_NUMBER_TABLE
41: , a5 JTF_VARCHAR2_TABLE_2000
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_NUMBER_TABLE
44: , a8 JTF_NUMBER_TABLE

Line 43: , a7 JTF_NUMBER_TABLE

39: , a3 JTF_NUMBER_TABLE
40: , a4 JTF_NUMBER_TABLE
41: , a5 JTF_VARCHAR2_TABLE_2000
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_NUMBER_TABLE
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_NUMBER_TABLE
47: , a11 JTF_DATE_TABLE

Line 44: , a8 JTF_NUMBER_TABLE

40: , a4 JTF_NUMBER_TABLE
41: , a5 JTF_VARCHAR2_TABLE_2000
42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_NUMBER_TABLE
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_NUMBER_TABLE
47: , a11 JTF_DATE_TABLE
48: , a12 JTF_NUMBER_TABLE

Line 46: , a10 JTF_NUMBER_TABLE

42: , a6 JTF_VARCHAR2_TABLE_100
43: , a7 JTF_NUMBER_TABLE
44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_NUMBER_TABLE
47: , a11 JTF_DATE_TABLE
48: , a12 JTF_NUMBER_TABLE
49: , a13 JTF_DATE_TABLE
50: , a14 JTF_NUMBER_TABLE

Line 48: , a12 JTF_NUMBER_TABLE

44: , a8 JTF_NUMBER_TABLE
45: , a9 JTF_VARCHAR2_TABLE_100
46: , a10 JTF_NUMBER_TABLE
47: , a11 JTF_DATE_TABLE
48: , a12 JTF_NUMBER_TABLE
49: , a13 JTF_DATE_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 50: , a14 JTF_NUMBER_TABLE

46: , a10 JTF_NUMBER_TABLE
47: , a11 JTF_DATE_TABLE
48: , a12 JTF_NUMBER_TABLE
49: , a13 JTF_DATE_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_NUMBER_TABLE

Line 52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

48: , a12 JTF_NUMBER_TABLE
49: , a13 JTF_DATE_TABLE
50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_NUMBER_TABLE
55: , a3 out nocopy JTF_NUMBER_TABLE
56: , a4 out nocopy JTF_NUMBER_TABLE

Line 54: , a2 out nocopy JTF_NUMBER_TABLE

50: , a14 JTF_NUMBER_TABLE
51: );
52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_NUMBER_TABLE
55: , a3 out nocopy JTF_NUMBER_TABLE
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a3 out nocopy JTF_NUMBER_TABLE

51: );
52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_NUMBER_TABLE
55: , a3 out nocopy JTF_NUMBER_TABLE
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE

Line 56: , a4 out nocopy JTF_NUMBER_TABLE

52: procedure rosetta_table_copy_out_p5(t okl_ovd_pvt.ovdv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
53: , a1 out nocopy JTF_VARCHAR2_TABLE_100
54: , a2 out nocopy JTF_NUMBER_TABLE
55: , a3 out nocopy JTF_NUMBER_TABLE
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE

Line 59: , a7 out nocopy JTF_NUMBER_TABLE

55: , a3 out nocopy JTF_NUMBER_TABLE
56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_NUMBER_TABLE
63: , a11 out nocopy JTF_DATE_TABLE

Line 60: , a8 out nocopy JTF_NUMBER_TABLE

56: , a4 out nocopy JTF_NUMBER_TABLE
57: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_NUMBER_TABLE
63: , a11 out nocopy JTF_DATE_TABLE
64: , a12 out nocopy JTF_NUMBER_TABLE

Line 62: , a10 out nocopy JTF_NUMBER_TABLE

58: , a6 out nocopy JTF_VARCHAR2_TABLE_100
59: , a7 out nocopy JTF_NUMBER_TABLE
60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_NUMBER_TABLE
63: , a11 out nocopy JTF_DATE_TABLE
64: , a12 out nocopy JTF_NUMBER_TABLE
65: , a13 out nocopy JTF_DATE_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE

Line 64: , a12 out nocopy JTF_NUMBER_TABLE

60: , a8 out nocopy JTF_NUMBER_TABLE
61: , a9 out nocopy JTF_VARCHAR2_TABLE_100
62: , a10 out nocopy JTF_NUMBER_TABLE
63: , a11 out nocopy JTF_DATE_TABLE
64: , a12 out nocopy JTF_NUMBER_TABLE
65: , a13 out nocopy JTF_DATE_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: );
68:

Line 66: , a14 out nocopy JTF_NUMBER_TABLE

62: , a10 out nocopy JTF_NUMBER_TABLE
63: , a11 out nocopy JTF_DATE_TABLE
64: , a12 out nocopy JTF_NUMBER_TABLE
65: , a13 out nocopy JTF_DATE_TABLE
66: , a14 out nocopy JTF_NUMBER_TABLE
67: );
68:
69: procedure insert_row(p_api_version NUMBER
70: , p_init_msg_list VARCHAR2

Line 110: , p5_a0 JTF_NUMBER_TABLE

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

Line 112: , p5_a2 JTF_NUMBER_TABLE

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

Line 113: , p5_a3 JTF_NUMBER_TABLE

109: , x_msg_data out nocopy VARCHAR2
110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_VARCHAR2_TABLE_100
112: , p5_a2 JTF_NUMBER_TABLE
113: , p5_a3 JTF_NUMBER_TABLE
114: , p5_a4 JTF_NUMBER_TABLE
115: , p5_a5 JTF_VARCHAR2_TABLE_2000
116: , p5_a6 JTF_VARCHAR2_TABLE_100
117: , p5_a7 JTF_NUMBER_TABLE

Line 114: , p5_a4 JTF_NUMBER_TABLE

110: , p5_a0 JTF_NUMBER_TABLE
111: , p5_a1 JTF_VARCHAR2_TABLE_100
112: , p5_a2 JTF_NUMBER_TABLE
113: , p5_a3 JTF_NUMBER_TABLE
114: , p5_a4 JTF_NUMBER_TABLE
115: , p5_a5 JTF_VARCHAR2_TABLE_2000
116: , p5_a6 JTF_VARCHAR2_TABLE_100
117: , p5_a7 JTF_NUMBER_TABLE
118: , p5_a8 JTF_NUMBER_TABLE

Line 117: , p5_a7 JTF_NUMBER_TABLE

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

Line 118: , p5_a8 JTF_NUMBER_TABLE

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

Line 120: , p5_a10 JTF_NUMBER_TABLE

116: , p5_a6 JTF_VARCHAR2_TABLE_100
117: , p5_a7 JTF_NUMBER_TABLE
118: , p5_a8 JTF_NUMBER_TABLE
119: , p5_a9 JTF_VARCHAR2_TABLE_100
120: , p5_a10 JTF_NUMBER_TABLE
121: , p5_a11 JTF_DATE_TABLE
122: , p5_a12 JTF_NUMBER_TABLE
123: , p5_a13 JTF_DATE_TABLE
124: , p5_a14 JTF_NUMBER_TABLE

Line 122: , p5_a12 JTF_NUMBER_TABLE

118: , p5_a8 JTF_NUMBER_TABLE
119: , p5_a9 JTF_VARCHAR2_TABLE_100
120: , p5_a10 JTF_NUMBER_TABLE
121: , p5_a11 JTF_DATE_TABLE
122: , p5_a12 JTF_NUMBER_TABLE
123: , p5_a13 JTF_DATE_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p5_a14 JTF_NUMBER_TABLE

120: , p5_a10 JTF_NUMBER_TABLE
121: , p5_a11 JTF_DATE_TABLE
122: , p5_a12 JTF_NUMBER_TABLE
123: , p5_a13 JTF_DATE_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a2 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 125: , p6_a0 out nocopy JTF_NUMBER_TABLE

121: , p5_a11 JTF_DATE_TABLE
122: , p5_a12 JTF_NUMBER_TABLE
123: , p5_a13 JTF_DATE_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a2 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 127: , p6_a2 out nocopy JTF_NUMBER_TABLE

123: , p5_a13 JTF_DATE_TABLE
124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a2 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , p6_a3 out nocopy JTF_NUMBER_TABLE

124: , p5_a14 JTF_NUMBER_TABLE
125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a2 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 129: , p6_a4 out nocopy JTF_NUMBER_TABLE

125: , p6_a0 out nocopy JTF_NUMBER_TABLE
126: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
127: , p6_a2 out nocopy JTF_NUMBER_TABLE
128: , p6_a3 out nocopy JTF_NUMBER_TABLE
129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a7 out nocopy JTF_NUMBER_TABLE
133: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 132: , p6_a7 out nocopy JTF_NUMBER_TABLE

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

Line 133: , p6_a8 out nocopy JTF_NUMBER_TABLE

129: , p6_a4 out nocopy JTF_NUMBER_TABLE
130: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a7 out nocopy JTF_NUMBER_TABLE
133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , p6_a10 out nocopy JTF_NUMBER_TABLE
136: , p6_a11 out nocopy JTF_DATE_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 135: , p6_a10 out nocopy JTF_NUMBER_TABLE

131: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a7 out nocopy JTF_NUMBER_TABLE
133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , p6_a10 out nocopy JTF_NUMBER_TABLE
136: , p6_a11 out nocopy JTF_DATE_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_DATE_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 137: , p6_a12 out nocopy JTF_NUMBER_TABLE

133: , p6_a8 out nocopy JTF_NUMBER_TABLE
134: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , p6_a10 out nocopy JTF_NUMBER_TABLE
136: , p6_a11 out nocopy JTF_DATE_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_DATE_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: );
141: procedure lock_row(p_api_version NUMBER

Line 139: , p6_a14 out nocopy JTF_NUMBER_TABLE

135: , p6_a10 out nocopy JTF_NUMBER_TABLE
136: , p6_a11 out nocopy JTF_DATE_TABLE
137: , p6_a12 out nocopy JTF_NUMBER_TABLE
138: , p6_a13 out nocopy JTF_DATE_TABLE
139: , p6_a14 out nocopy JTF_NUMBER_TABLE
140: );
141: procedure lock_row(p_api_version NUMBER
142: , p_init_msg_list VARCHAR2
143: , x_return_status out nocopy VARCHAR2

Line 167: , p5_a0 JTF_NUMBER_TABLE

163: , p_init_msg_list VARCHAR2
164: , x_return_status out nocopy VARCHAR2
165: , x_msg_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p5_a0 JTF_NUMBER_TABLE
168: , p5_a1 JTF_VARCHAR2_TABLE_100
169: , p5_a2 JTF_NUMBER_TABLE
170: , p5_a3 JTF_NUMBER_TABLE
171: , p5_a4 JTF_NUMBER_TABLE

Line 169: , p5_a2 JTF_NUMBER_TABLE

165: , x_msg_count out nocopy NUMBER
166: , x_msg_data out nocopy VARCHAR2
167: , p5_a0 JTF_NUMBER_TABLE
168: , p5_a1 JTF_VARCHAR2_TABLE_100
169: , p5_a2 JTF_NUMBER_TABLE
170: , p5_a3 JTF_NUMBER_TABLE
171: , p5_a4 JTF_NUMBER_TABLE
172: , p5_a5 JTF_VARCHAR2_TABLE_2000
173: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 170: , p5_a3 JTF_NUMBER_TABLE

166: , x_msg_data out nocopy VARCHAR2
167: , p5_a0 JTF_NUMBER_TABLE
168: , p5_a1 JTF_VARCHAR2_TABLE_100
169: , p5_a2 JTF_NUMBER_TABLE
170: , p5_a3 JTF_NUMBER_TABLE
171: , p5_a4 JTF_NUMBER_TABLE
172: , p5_a5 JTF_VARCHAR2_TABLE_2000
173: , p5_a6 JTF_VARCHAR2_TABLE_100
174: , p5_a7 JTF_NUMBER_TABLE

Line 171: , p5_a4 JTF_NUMBER_TABLE

167: , p5_a0 JTF_NUMBER_TABLE
168: , p5_a1 JTF_VARCHAR2_TABLE_100
169: , p5_a2 JTF_NUMBER_TABLE
170: , p5_a3 JTF_NUMBER_TABLE
171: , p5_a4 JTF_NUMBER_TABLE
172: , p5_a5 JTF_VARCHAR2_TABLE_2000
173: , p5_a6 JTF_VARCHAR2_TABLE_100
174: , p5_a7 JTF_NUMBER_TABLE
175: , p5_a8 JTF_NUMBER_TABLE

Line 174: , p5_a7 JTF_NUMBER_TABLE

170: , p5_a3 JTF_NUMBER_TABLE
171: , p5_a4 JTF_NUMBER_TABLE
172: , p5_a5 JTF_VARCHAR2_TABLE_2000
173: , p5_a6 JTF_VARCHAR2_TABLE_100
174: , p5_a7 JTF_NUMBER_TABLE
175: , p5_a8 JTF_NUMBER_TABLE
176: , p5_a9 JTF_VARCHAR2_TABLE_100
177: , p5_a10 JTF_NUMBER_TABLE
178: , p5_a11 JTF_DATE_TABLE

Line 175: , p5_a8 JTF_NUMBER_TABLE

171: , p5_a4 JTF_NUMBER_TABLE
172: , p5_a5 JTF_VARCHAR2_TABLE_2000
173: , p5_a6 JTF_VARCHAR2_TABLE_100
174: , p5_a7 JTF_NUMBER_TABLE
175: , p5_a8 JTF_NUMBER_TABLE
176: , p5_a9 JTF_VARCHAR2_TABLE_100
177: , p5_a10 JTF_NUMBER_TABLE
178: , p5_a11 JTF_DATE_TABLE
179: , p5_a12 JTF_NUMBER_TABLE

Line 177: , p5_a10 JTF_NUMBER_TABLE

173: , p5_a6 JTF_VARCHAR2_TABLE_100
174: , p5_a7 JTF_NUMBER_TABLE
175: , p5_a8 JTF_NUMBER_TABLE
176: , p5_a9 JTF_VARCHAR2_TABLE_100
177: , p5_a10 JTF_NUMBER_TABLE
178: , p5_a11 JTF_DATE_TABLE
179: , p5_a12 JTF_NUMBER_TABLE
180: , p5_a13 JTF_DATE_TABLE
181: , p5_a14 JTF_NUMBER_TABLE

Line 179: , p5_a12 JTF_NUMBER_TABLE

175: , p5_a8 JTF_NUMBER_TABLE
176: , p5_a9 JTF_VARCHAR2_TABLE_100
177: , p5_a10 JTF_NUMBER_TABLE
178: , p5_a11 JTF_DATE_TABLE
179: , p5_a12 JTF_NUMBER_TABLE
180: , p5_a13 JTF_DATE_TABLE
181: , p5_a14 JTF_NUMBER_TABLE
182: );
183: procedure update_row(p_api_version NUMBER

Line 181: , p5_a14 JTF_NUMBER_TABLE

177: , p5_a10 JTF_NUMBER_TABLE
178: , p5_a11 JTF_DATE_TABLE
179: , p5_a12 JTF_NUMBER_TABLE
180: , p5_a13 JTF_DATE_TABLE
181: , p5_a14 JTF_NUMBER_TABLE
182: );
183: procedure update_row(p_api_version NUMBER
184: , p_init_msg_list VARCHAR2
185: , x_return_status out nocopy VARCHAR2

Line 224: , p5_a0 JTF_NUMBER_TABLE

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

Line 226: , p5_a2 JTF_NUMBER_TABLE

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

Line 227: , p5_a3 JTF_NUMBER_TABLE

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

Line 228: , p5_a4 JTF_NUMBER_TABLE

224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_VARCHAR2_TABLE_100
226: , p5_a2 JTF_NUMBER_TABLE
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_2000
230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE

Line 231: , p5_a7 JTF_NUMBER_TABLE

227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_2000
230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE

Line 232: , p5_a8 JTF_NUMBER_TABLE

228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_2000
230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE

Line 234: , p5_a10 JTF_NUMBER_TABLE

230: , p5_a6 JTF_VARCHAR2_TABLE_100
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_DATE_TABLE
238: , p5_a14 JTF_NUMBER_TABLE

Line 236: , p5_a12 JTF_NUMBER_TABLE

232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_DATE_TABLE
238: , p5_a14 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 238: , p5_a14 JTF_NUMBER_TABLE

234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_DATE_TABLE
238: , p5_a14 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 239: , p6_a0 out nocopy JTF_NUMBER_TABLE

235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_DATE_TABLE
238: , p5_a14 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 241: , p6_a2 out nocopy JTF_NUMBER_TABLE

237: , p5_a13 JTF_DATE_TABLE
238: , p5_a14 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 242: , p6_a3 out nocopy JTF_NUMBER_TABLE

238: , p5_a14 JTF_NUMBER_TABLE
239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 243: , p6_a4 out nocopy JTF_NUMBER_TABLE

239: , p6_a0 out nocopy JTF_NUMBER_TABLE
240: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a2 out nocopy JTF_NUMBER_TABLE
242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_NUMBER_TABLE
247: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 246: , p6_a7 out nocopy JTF_NUMBER_TABLE

242: , p6_a3 out nocopy JTF_NUMBER_TABLE
243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_NUMBER_TABLE
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE

Line 247: , p6_a8 out nocopy JTF_NUMBER_TABLE

243: , p6_a4 out nocopy JTF_NUMBER_TABLE
244: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_NUMBER_TABLE
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 249: , p6_a10 out nocopy JTF_NUMBER_TABLE

245: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a7 out nocopy JTF_NUMBER_TABLE
247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE
252: , p6_a13 out nocopy JTF_DATE_TABLE
253: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 251: , p6_a12 out nocopy JTF_NUMBER_TABLE

247: , p6_a8 out nocopy JTF_NUMBER_TABLE
248: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE
252: , p6_a13 out nocopy JTF_DATE_TABLE
253: , p6_a14 out nocopy JTF_NUMBER_TABLE
254: );
255: procedure delete_row(p_api_version NUMBER

Line 253: , p6_a14 out nocopy JTF_NUMBER_TABLE

249: , p6_a10 out nocopy JTF_NUMBER_TABLE
250: , p6_a11 out nocopy JTF_DATE_TABLE
251: , p6_a12 out nocopy JTF_NUMBER_TABLE
252: , p6_a13 out nocopy JTF_DATE_TABLE
253: , p6_a14 out nocopy JTF_NUMBER_TABLE
254: );
255: procedure delete_row(p_api_version NUMBER
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2

Line 281: , p5_a0 JTF_NUMBER_TABLE

277: , p_init_msg_list VARCHAR2
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_VARCHAR2_TABLE_100
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_NUMBER_TABLE

Line 283: , p5_a2 JTF_NUMBER_TABLE

279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_VARCHAR2_TABLE_100
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_NUMBER_TABLE
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 284: , p5_a3 JTF_NUMBER_TABLE

280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_VARCHAR2_TABLE_100
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_NUMBER_TABLE
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_NUMBER_TABLE

Line 285: , p5_a4 JTF_NUMBER_TABLE

281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_VARCHAR2_TABLE_100
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_NUMBER_TABLE
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_NUMBER_TABLE
289: , p5_a8 JTF_NUMBER_TABLE

Line 288: , p5_a7 JTF_NUMBER_TABLE

284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_NUMBER_TABLE
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_NUMBER_TABLE
289: , p5_a8 JTF_NUMBER_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_100
291: , p5_a10 JTF_NUMBER_TABLE
292: , p5_a11 JTF_DATE_TABLE

Line 289: , p5_a8 JTF_NUMBER_TABLE

285: , p5_a4 JTF_NUMBER_TABLE
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_NUMBER_TABLE
289: , p5_a8 JTF_NUMBER_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_100
291: , p5_a10 JTF_NUMBER_TABLE
292: , p5_a11 JTF_DATE_TABLE
293: , p5_a12 JTF_NUMBER_TABLE

Line 291: , p5_a10 JTF_NUMBER_TABLE

287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_NUMBER_TABLE
289: , p5_a8 JTF_NUMBER_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_100
291: , p5_a10 JTF_NUMBER_TABLE
292: , p5_a11 JTF_DATE_TABLE
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_DATE_TABLE
295: , p5_a14 JTF_NUMBER_TABLE

Line 293: , p5_a12 JTF_NUMBER_TABLE

289: , p5_a8 JTF_NUMBER_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_100
291: , p5_a10 JTF_NUMBER_TABLE
292: , p5_a11 JTF_DATE_TABLE
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_DATE_TABLE
295: , p5_a14 JTF_NUMBER_TABLE
296: );
297: procedure validate_row(p_api_version NUMBER

Line 295: , p5_a14 JTF_NUMBER_TABLE

291: , p5_a10 JTF_NUMBER_TABLE
292: , p5_a11 JTF_DATE_TABLE
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_DATE_TABLE
295: , p5_a14 JTF_NUMBER_TABLE
296: );
297: procedure validate_row(p_api_version NUMBER
298: , p_init_msg_list VARCHAR2
299: , x_return_status out nocopy VARCHAR2

Line 323: , p5_a0 JTF_NUMBER_TABLE

319: , p_init_msg_list VARCHAR2
320: , x_return_status out nocopy VARCHAR2
321: , x_msg_count out nocopy NUMBER
322: , x_msg_data out nocopy VARCHAR2
323: , p5_a0 JTF_NUMBER_TABLE
324: , p5_a1 JTF_VARCHAR2_TABLE_100
325: , p5_a2 JTF_NUMBER_TABLE
326: , p5_a3 JTF_NUMBER_TABLE
327: , p5_a4 JTF_NUMBER_TABLE

Line 325: , p5_a2 JTF_NUMBER_TABLE

321: , x_msg_count out nocopy NUMBER
322: , x_msg_data out nocopy VARCHAR2
323: , p5_a0 JTF_NUMBER_TABLE
324: , p5_a1 JTF_VARCHAR2_TABLE_100
325: , p5_a2 JTF_NUMBER_TABLE
326: , p5_a3 JTF_NUMBER_TABLE
327: , p5_a4 JTF_NUMBER_TABLE
328: , p5_a5 JTF_VARCHAR2_TABLE_2000
329: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 326: , p5_a3 JTF_NUMBER_TABLE

322: , x_msg_data out nocopy VARCHAR2
323: , p5_a0 JTF_NUMBER_TABLE
324: , p5_a1 JTF_VARCHAR2_TABLE_100
325: , p5_a2 JTF_NUMBER_TABLE
326: , p5_a3 JTF_NUMBER_TABLE
327: , p5_a4 JTF_NUMBER_TABLE
328: , p5_a5 JTF_VARCHAR2_TABLE_2000
329: , p5_a6 JTF_VARCHAR2_TABLE_100
330: , p5_a7 JTF_NUMBER_TABLE

Line 327: , p5_a4 JTF_NUMBER_TABLE

323: , p5_a0 JTF_NUMBER_TABLE
324: , p5_a1 JTF_VARCHAR2_TABLE_100
325: , p5_a2 JTF_NUMBER_TABLE
326: , p5_a3 JTF_NUMBER_TABLE
327: , p5_a4 JTF_NUMBER_TABLE
328: , p5_a5 JTF_VARCHAR2_TABLE_2000
329: , p5_a6 JTF_VARCHAR2_TABLE_100
330: , p5_a7 JTF_NUMBER_TABLE
331: , p5_a8 JTF_NUMBER_TABLE

Line 330: , p5_a7 JTF_NUMBER_TABLE

326: , p5_a3 JTF_NUMBER_TABLE
327: , p5_a4 JTF_NUMBER_TABLE
328: , p5_a5 JTF_VARCHAR2_TABLE_2000
329: , p5_a6 JTF_VARCHAR2_TABLE_100
330: , p5_a7 JTF_NUMBER_TABLE
331: , p5_a8 JTF_NUMBER_TABLE
332: , p5_a9 JTF_VARCHAR2_TABLE_100
333: , p5_a10 JTF_NUMBER_TABLE
334: , p5_a11 JTF_DATE_TABLE

Line 331: , p5_a8 JTF_NUMBER_TABLE

327: , p5_a4 JTF_NUMBER_TABLE
328: , p5_a5 JTF_VARCHAR2_TABLE_2000
329: , p5_a6 JTF_VARCHAR2_TABLE_100
330: , p5_a7 JTF_NUMBER_TABLE
331: , p5_a8 JTF_NUMBER_TABLE
332: , p5_a9 JTF_VARCHAR2_TABLE_100
333: , p5_a10 JTF_NUMBER_TABLE
334: , p5_a11 JTF_DATE_TABLE
335: , p5_a12 JTF_NUMBER_TABLE

Line 333: , p5_a10 JTF_NUMBER_TABLE

329: , p5_a6 JTF_VARCHAR2_TABLE_100
330: , p5_a7 JTF_NUMBER_TABLE
331: , p5_a8 JTF_NUMBER_TABLE
332: , p5_a9 JTF_VARCHAR2_TABLE_100
333: , p5_a10 JTF_NUMBER_TABLE
334: , p5_a11 JTF_DATE_TABLE
335: , p5_a12 JTF_NUMBER_TABLE
336: , p5_a13 JTF_DATE_TABLE
337: , p5_a14 JTF_NUMBER_TABLE

Line 335: , p5_a12 JTF_NUMBER_TABLE

331: , p5_a8 JTF_NUMBER_TABLE
332: , p5_a9 JTF_VARCHAR2_TABLE_100
333: , p5_a10 JTF_NUMBER_TABLE
334: , p5_a11 JTF_DATE_TABLE
335: , p5_a12 JTF_NUMBER_TABLE
336: , p5_a13 JTF_DATE_TABLE
337: , p5_a14 JTF_NUMBER_TABLE
338: );
339: end okl_ovd_pvt_w;

Line 337: , p5_a14 JTF_NUMBER_TABLE

333: , p5_a10 JTF_NUMBER_TABLE
334: , p5_a11 JTF_DATE_TABLE
335: , p5_a12 JTF_NUMBER_TABLE
336: , p5_a13 JTF_DATE_TABLE
337: , p5_a14 JTF_NUMBER_TABLE
338: );
339: end okl_ovd_pvt_w;