APPS.OKL_QPY_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_qpy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIQPYS.pls 115.3 2002/12/04 03:23:30 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_qpy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIQPYS.pls 115.3 2002/12/04 03:23:30 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_qpy_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIQPYS.pls 115.3 2002/12/04 03:23:30 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIQPYS.pls 115.3 2002/12/04 03:23:30 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_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: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 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: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_600

Line 14: , a11 JTF_NUMBER_TABLE

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

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_600
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_200

Line 24: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_200
23: );
24: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE

Line 25: , a1 out nocopy JTF_NUMBER_TABLE

21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_200
23: );
24: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE

Line 26: , a2 out nocopy JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_200
23: );
24: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE

Line 27: , a3 out nocopy JTF_NUMBER_TABLE

23: );
24: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE

Line 29: , a5 out nocopy JTF_NUMBER_TABLE

25: , a1 out nocopy JTF_NUMBER_TABLE
26: , a2 out nocopy JTF_NUMBER_TABLE
27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_NUMBER_TABLE

Line 31: , a7 out nocopy JTF_NUMBER_TABLE

27: , a3 out nocopy JTF_NUMBER_TABLE
28: , a4 out nocopy JTF_DATE_TABLE
29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_NUMBER_TABLE

Line 33: , a9 out nocopy JTF_NUMBER_TABLE

29: , a5 out nocopy JTF_NUMBER_TABLE
30: , a6 out nocopy JTF_DATE_TABLE
31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_VARCHAR2_TABLE_600

Line 35: , a11 out nocopy JTF_NUMBER_TABLE

31: , a7 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_VARCHAR2_TABLE_600
38: , a14 out nocopy JTF_VARCHAR2_TABLE_100
39: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 36: , a12 out nocopy JTF_NUMBER_TABLE

32: , a8 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_NUMBER_TABLE
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_NUMBER_TABLE
37: , a13 out nocopy JTF_VARCHAR2_TABLE_600
38: , a14 out nocopy JTF_VARCHAR2_TABLE_100
39: , a15 out nocopy JTF_VARCHAR2_TABLE_100
40: , a16 out nocopy JTF_VARCHAR2_TABLE_200

Line 46: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE

42: , a18 out nocopy JTF_VARCHAR2_TABLE_100
43: , a19 out nocopy JTF_VARCHAR2_TABLE_200
44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_NUMBER_TABLE
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE

Line 47: , a1 JTF_NUMBER_TABLE

43: , a19 out nocopy JTF_VARCHAR2_TABLE_200
44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_NUMBER_TABLE
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100

Line 48: , a2 JTF_NUMBER_TABLE

44: );
45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_NUMBER_TABLE
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_NUMBER_TABLE

Line 49: , a3 JTF_NUMBER_TABLE

45:
46: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE
47: , a1 JTF_NUMBER_TABLE
48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_NUMBER_TABLE
53: , a7 JTF_NUMBER_TABLE

Line 52: , a6 JTF_NUMBER_TABLE

48: , a2 JTF_NUMBER_TABLE
49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_NUMBER_TABLE
53: , a7 JTF_NUMBER_TABLE
54: , a8 JTF_VARCHAR2_TABLE_600
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100

Line 53: , a7 JTF_NUMBER_TABLE

49: , a3 JTF_NUMBER_TABLE
50: , a4 JTF_DATE_TABLE
51: , a5 JTF_VARCHAR2_TABLE_100
52: , a6 JTF_NUMBER_TABLE
53: , a7 JTF_NUMBER_TABLE
54: , a8 JTF_VARCHAR2_TABLE_600
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_200

Line 61: , a15 JTF_NUMBER_TABLE

57: , a11 JTF_VARCHAR2_TABLE_200
58: , a12 JTF_VARCHAR2_TABLE_100
59: , a13 JTF_VARCHAR2_TABLE_100
60: , a14 JTF_VARCHAR2_TABLE_200
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE

Line 63: , a17 JTF_NUMBER_TABLE

59: , a13 JTF_VARCHAR2_TABLE_100
60: , a14 JTF_VARCHAR2_TABLE_200
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 65: , a19 JTF_NUMBER_TABLE

61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE

Line 67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE

Line 68: , a1 out nocopy JTF_NUMBER_TABLE

64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 69: , a2 out nocopy JTF_NUMBER_TABLE

65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_VARCHAR2_TABLE_100
73: , a6 out nocopy JTF_NUMBER_TABLE

Line 70: , a3 out nocopy JTF_NUMBER_TABLE

66: );
67: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_VARCHAR2_TABLE_100
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE

Line 73: , a6 out nocopy JTF_NUMBER_TABLE

69: , a2 out nocopy JTF_NUMBER_TABLE
70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_VARCHAR2_TABLE_100
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_VARCHAR2_TABLE_600
76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a7 out nocopy JTF_NUMBER_TABLE

70: , a3 out nocopy JTF_NUMBER_TABLE
71: , a4 out nocopy JTF_DATE_TABLE
72: , a5 out nocopy JTF_VARCHAR2_TABLE_100
73: , a6 out nocopy JTF_NUMBER_TABLE
74: , a7 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_VARCHAR2_TABLE_600
76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100
78: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 82: , a15 out nocopy JTF_NUMBER_TABLE

78: , a11 out nocopy JTF_VARCHAR2_TABLE_200
79: , a12 out nocopy JTF_VARCHAR2_TABLE_100
80: , a13 out nocopy JTF_VARCHAR2_TABLE_100
81: , a14 out nocopy JTF_VARCHAR2_TABLE_200
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE

Line 84: , a17 out nocopy JTF_NUMBER_TABLE

80: , a13 out nocopy JTF_VARCHAR2_TABLE_100
81: , a14 out nocopy JTF_VARCHAR2_TABLE_200
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );
88:

Line 86: , a19 out nocopy JTF_NUMBER_TABLE

82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure insert_row(p_api_version NUMBER
90: , p_init_msg_list VARCHAR2

Line 140: , p5_a0 JTF_NUMBER_TABLE

136: , p_init_msg_list VARCHAR2
137: , x_return_status out nocopy VARCHAR2
138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_NUMBER_TABLE
143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE

Line 141: , p5_a1 JTF_NUMBER_TABLE

137: , x_return_status out nocopy VARCHAR2
138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_NUMBER_TABLE
143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 142: , p5_a2 JTF_NUMBER_TABLE

138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_NUMBER_TABLE
143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_100
146: , p5_a6 JTF_NUMBER_TABLE

Line 143: , p5_a3 JTF_NUMBER_TABLE

139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_NUMBER_TABLE
143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_100
146: , p5_a6 JTF_NUMBER_TABLE
147: , p5_a7 JTF_NUMBER_TABLE

Line 146: , p5_a6 JTF_NUMBER_TABLE

142: , p5_a2 JTF_NUMBER_TABLE
143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_100
146: , p5_a6 JTF_NUMBER_TABLE
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_VARCHAR2_TABLE_600
149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 147: , p5_a7 JTF_NUMBER_TABLE

143: , p5_a3 JTF_NUMBER_TABLE
144: , p5_a4 JTF_DATE_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_100
146: , p5_a6 JTF_NUMBER_TABLE
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_VARCHAR2_TABLE_600
149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 155: , p5_a15 JTF_NUMBER_TABLE

151: , p5_a11 JTF_VARCHAR2_TABLE_200
152: , p5_a12 JTF_VARCHAR2_TABLE_100
153: , p5_a13 JTF_VARCHAR2_TABLE_100
154: , p5_a14 JTF_VARCHAR2_TABLE_200
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE

Line 157: , p5_a17 JTF_NUMBER_TABLE

153: , p5_a13 JTF_VARCHAR2_TABLE_100
154: , p5_a14 JTF_VARCHAR2_TABLE_200
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 159: , p5_a19 JTF_NUMBER_TABLE

155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 160: , p6_a0 out nocopy JTF_NUMBER_TABLE

156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE

Line 161: , p6_a1 out nocopy JTF_NUMBER_TABLE

157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE
165: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: , p6_a2 out nocopy JTF_NUMBER_TABLE

158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE
165: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 163: , p6_a3 out nocopy JTF_NUMBER_TABLE

159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE
165: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a6 out nocopy JTF_NUMBER_TABLE
167: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 166: , p6_a6 out nocopy JTF_NUMBER_TABLE

162: , p6_a2 out nocopy JTF_NUMBER_TABLE
163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE
165: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a6 out nocopy JTF_NUMBER_TABLE
167: , p6_a7 out nocopy JTF_NUMBER_TABLE
168: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p6_a7 out nocopy JTF_NUMBER_TABLE

163: , p6_a3 out nocopy JTF_NUMBER_TABLE
164: , p6_a4 out nocopy JTF_DATE_TABLE
165: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
166: , p6_a6 out nocopy JTF_NUMBER_TABLE
167: , p6_a7 out nocopy JTF_NUMBER_TABLE
168: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 175: , p6_a15 out nocopy JTF_NUMBER_TABLE

171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
172: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 177: , p6_a17 out nocopy JTF_NUMBER_TABLE

173: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );
181: procedure lock_row(p_api_version NUMBER

Line 179: , p6_a19 out nocopy JTF_NUMBER_TABLE

175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );
181: procedure lock_row(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2
183: , x_return_status out nocopy VARCHAR2

Line 212: , p5_a0 JTF_NUMBER_TABLE

208: , p_init_msg_list VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE

Line 213: , p5_a1 JTF_NUMBER_TABLE

209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 214: , p5_a2 JTF_NUMBER_TABLE

210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_NUMBER_TABLE

Line 215: , p5_a3 JTF_NUMBER_TABLE

211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_NUMBER_TABLE
219: , p5_a7 JTF_NUMBER_TABLE

Line 218: , p5_a6 JTF_NUMBER_TABLE

214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_NUMBER_TABLE
219: , p5_a7 JTF_NUMBER_TABLE
220: , p5_a8 JTF_VARCHAR2_TABLE_600
221: , p5_a9 JTF_VARCHAR2_TABLE_100
222: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 219: , p5_a7 JTF_NUMBER_TABLE

215: , p5_a3 JTF_NUMBER_TABLE
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_NUMBER_TABLE
219: , p5_a7 JTF_NUMBER_TABLE
220: , p5_a8 JTF_VARCHAR2_TABLE_600
221: , p5_a9 JTF_VARCHAR2_TABLE_100
222: , p5_a10 JTF_VARCHAR2_TABLE_100
223: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 227: , p5_a15 JTF_NUMBER_TABLE

223: , p5_a11 JTF_VARCHAR2_TABLE_200
224: , p5_a12 JTF_VARCHAR2_TABLE_100
225: , p5_a13 JTF_VARCHAR2_TABLE_100
226: , p5_a14 JTF_VARCHAR2_TABLE_200
227: , p5_a15 JTF_NUMBER_TABLE
228: , p5_a16 JTF_DATE_TABLE
229: , p5_a17 JTF_NUMBER_TABLE
230: , p5_a18 JTF_DATE_TABLE
231: , p5_a19 JTF_NUMBER_TABLE

Line 229: , p5_a17 JTF_NUMBER_TABLE

225: , p5_a13 JTF_VARCHAR2_TABLE_100
226: , p5_a14 JTF_VARCHAR2_TABLE_200
227: , p5_a15 JTF_NUMBER_TABLE
228: , p5_a16 JTF_DATE_TABLE
229: , p5_a17 JTF_NUMBER_TABLE
230: , p5_a18 JTF_DATE_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: );
233: procedure update_row(p_api_version NUMBER

Line 231: , p5_a19 JTF_NUMBER_TABLE

227: , p5_a15 JTF_NUMBER_TABLE
228: , p5_a16 JTF_DATE_TABLE
229: , p5_a17 JTF_NUMBER_TABLE
230: , p5_a18 JTF_DATE_TABLE
231: , p5_a19 JTF_NUMBER_TABLE
232: );
233: procedure update_row(p_api_version NUMBER
234: , p_init_msg_list VARCHAR2
235: , x_return_status out nocopy VARCHAR2

Line 284: , p5_a0 JTF_NUMBER_TABLE

280: , p_init_msg_list VARCHAR2
281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE

Line 285: , p5_a1 JTF_NUMBER_TABLE

281: , x_return_status out nocopy VARCHAR2
282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 286: , p5_a2 JTF_NUMBER_TABLE

282: , x_msg_count out nocopy NUMBER
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE

Line 287: , p5_a3 JTF_NUMBER_TABLE

283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_NUMBER_TABLE

Line 290: , p5_a6 JTF_NUMBER_TABLE

286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_NUMBER_TABLE
292: , p5_a8 JTF_VARCHAR2_TABLE_600
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 291: , p5_a7 JTF_NUMBER_TABLE

287: , p5_a3 JTF_NUMBER_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_VARCHAR2_TABLE_100
290: , p5_a6 JTF_NUMBER_TABLE
291: , p5_a7 JTF_NUMBER_TABLE
292: , p5_a8 JTF_VARCHAR2_TABLE_600
293: , p5_a9 JTF_VARCHAR2_TABLE_100
294: , p5_a10 JTF_VARCHAR2_TABLE_100
295: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 299: , p5_a15 JTF_NUMBER_TABLE

295: , p5_a11 JTF_VARCHAR2_TABLE_200
296: , p5_a12 JTF_VARCHAR2_TABLE_100
297: , p5_a13 JTF_VARCHAR2_TABLE_100
298: , p5_a14 JTF_VARCHAR2_TABLE_200
299: , p5_a15 JTF_NUMBER_TABLE
300: , p5_a16 JTF_DATE_TABLE
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE

Line 301: , p5_a17 JTF_NUMBER_TABLE

297: , p5_a13 JTF_VARCHAR2_TABLE_100
298: , p5_a14 JTF_VARCHAR2_TABLE_200
299: , p5_a15 JTF_NUMBER_TABLE
300: , p5_a16 JTF_DATE_TABLE
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 303: , p5_a19 JTF_NUMBER_TABLE

299: , p5_a15 JTF_NUMBER_TABLE
300: , p5_a16 JTF_DATE_TABLE
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 304: , p6_a0 out nocopy JTF_NUMBER_TABLE

300: , p5_a16 JTF_DATE_TABLE
301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE

Line 305: , p6_a1 out nocopy JTF_NUMBER_TABLE

301: , p5_a17 JTF_NUMBER_TABLE
302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE
309: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 306: , p6_a2 out nocopy JTF_NUMBER_TABLE

302: , p5_a18 JTF_DATE_TABLE
303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE
309: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 307: , p6_a3 out nocopy JTF_NUMBER_TABLE

303: , p5_a19 JTF_NUMBER_TABLE
304: , p6_a0 out nocopy JTF_NUMBER_TABLE
305: , p6_a1 out nocopy JTF_NUMBER_TABLE
306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE
309: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a6 out nocopy JTF_NUMBER_TABLE
311: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 310: , p6_a6 out nocopy JTF_NUMBER_TABLE

306: , p6_a2 out nocopy JTF_NUMBER_TABLE
307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE
309: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a6 out nocopy JTF_NUMBER_TABLE
311: , p6_a7 out nocopy JTF_NUMBER_TABLE
312: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
313: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 311: , p6_a7 out nocopy JTF_NUMBER_TABLE

307: , p6_a3 out nocopy JTF_NUMBER_TABLE
308: , p6_a4 out nocopy JTF_DATE_TABLE
309: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a6 out nocopy JTF_NUMBER_TABLE
311: , p6_a7 out nocopy JTF_NUMBER_TABLE
312: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
313: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
314: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 319: , p6_a15 out nocopy JTF_NUMBER_TABLE

315: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
316: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
319: , p6_a15 out nocopy JTF_NUMBER_TABLE
320: , p6_a16 out nocopy JTF_DATE_TABLE
321: , p6_a17 out nocopy JTF_NUMBER_TABLE
322: , p6_a18 out nocopy JTF_DATE_TABLE
323: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 321: , p6_a17 out nocopy JTF_NUMBER_TABLE

317: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
318: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
319: , p6_a15 out nocopy JTF_NUMBER_TABLE
320: , p6_a16 out nocopy JTF_DATE_TABLE
321: , p6_a17 out nocopy JTF_NUMBER_TABLE
322: , p6_a18 out nocopy JTF_DATE_TABLE
323: , p6_a19 out nocopy JTF_NUMBER_TABLE
324: );
325: procedure delete_row(p_api_version NUMBER

Line 323: , p6_a19 out nocopy JTF_NUMBER_TABLE

319: , p6_a15 out nocopy JTF_NUMBER_TABLE
320: , p6_a16 out nocopy JTF_DATE_TABLE
321: , p6_a17 out nocopy JTF_NUMBER_TABLE
322: , p6_a18 out nocopy JTF_DATE_TABLE
323: , p6_a19 out nocopy JTF_NUMBER_TABLE
324: );
325: procedure delete_row(p_api_version NUMBER
326: , p_init_msg_list VARCHAR2
327: , x_return_status out nocopy VARCHAR2

Line 356: , p5_a0 JTF_NUMBER_TABLE

352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE

Line 357: , p5_a1 JTF_NUMBER_TABLE

353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE
361: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 358: , p5_a2 JTF_NUMBER_TABLE

354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_NUMBER_TABLE

Line 359: , p5_a3 JTF_NUMBER_TABLE

355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE

Line 362: , p5_a6 JTF_NUMBER_TABLE

358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_VARCHAR2_TABLE_600
365: , p5_a9 JTF_VARCHAR2_TABLE_100
366: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 363: , p5_a7 JTF_NUMBER_TABLE

359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_DATE_TABLE
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_NUMBER_TABLE
363: , p5_a7 JTF_NUMBER_TABLE
364: , p5_a8 JTF_VARCHAR2_TABLE_600
365: , p5_a9 JTF_VARCHAR2_TABLE_100
366: , p5_a10 JTF_VARCHAR2_TABLE_100
367: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 371: , p5_a15 JTF_NUMBER_TABLE

367: , p5_a11 JTF_VARCHAR2_TABLE_200
368: , p5_a12 JTF_VARCHAR2_TABLE_100
369: , p5_a13 JTF_VARCHAR2_TABLE_100
370: , p5_a14 JTF_VARCHAR2_TABLE_200
371: , p5_a15 JTF_NUMBER_TABLE
372: , p5_a16 JTF_DATE_TABLE
373: , p5_a17 JTF_NUMBER_TABLE
374: , p5_a18 JTF_DATE_TABLE
375: , p5_a19 JTF_NUMBER_TABLE

Line 373: , p5_a17 JTF_NUMBER_TABLE

369: , p5_a13 JTF_VARCHAR2_TABLE_100
370: , p5_a14 JTF_VARCHAR2_TABLE_200
371: , p5_a15 JTF_NUMBER_TABLE
372: , p5_a16 JTF_DATE_TABLE
373: , p5_a17 JTF_NUMBER_TABLE
374: , p5_a18 JTF_DATE_TABLE
375: , p5_a19 JTF_NUMBER_TABLE
376: );
377: procedure validate_row(p_api_version NUMBER

Line 375: , p5_a19 JTF_NUMBER_TABLE

371: , p5_a15 JTF_NUMBER_TABLE
372: , p5_a16 JTF_DATE_TABLE
373: , p5_a17 JTF_NUMBER_TABLE
374: , p5_a18 JTF_DATE_TABLE
375: , p5_a19 JTF_NUMBER_TABLE
376: );
377: procedure validate_row(p_api_version NUMBER
378: , p_init_msg_list VARCHAR2
379: , x_return_status out nocopy VARCHAR2

Line 408: , p5_a0 JTF_NUMBER_TABLE

404: , p_init_msg_list VARCHAR2
405: , x_return_status out nocopy VARCHAR2
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE

Line 409: , p5_a1 JTF_NUMBER_TABLE

405: , x_return_status out nocopy VARCHAR2
406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 410: , p5_a2 JTF_NUMBER_TABLE

406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_NUMBER_TABLE

Line 411: , p5_a3 JTF_NUMBER_TABLE

407: , x_msg_data out nocopy VARCHAR2
408: , p5_a0 JTF_NUMBER_TABLE
409: , p5_a1 JTF_NUMBER_TABLE
410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_NUMBER_TABLE
415: , p5_a7 JTF_NUMBER_TABLE

Line 414: , p5_a6 JTF_NUMBER_TABLE

410: , p5_a2 JTF_NUMBER_TABLE
411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_NUMBER_TABLE
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_VARCHAR2_TABLE_600
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 415: , p5_a7 JTF_NUMBER_TABLE

411: , p5_a3 JTF_NUMBER_TABLE
412: , p5_a4 JTF_DATE_TABLE
413: , p5_a5 JTF_VARCHAR2_TABLE_100
414: , p5_a6 JTF_NUMBER_TABLE
415: , p5_a7 JTF_NUMBER_TABLE
416: , p5_a8 JTF_VARCHAR2_TABLE_600
417: , p5_a9 JTF_VARCHAR2_TABLE_100
418: , p5_a10 JTF_VARCHAR2_TABLE_100
419: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 423: , p5_a15 JTF_NUMBER_TABLE

419: , p5_a11 JTF_VARCHAR2_TABLE_200
420: , p5_a12 JTF_VARCHAR2_TABLE_100
421: , p5_a13 JTF_VARCHAR2_TABLE_100
422: , p5_a14 JTF_VARCHAR2_TABLE_200
423: , p5_a15 JTF_NUMBER_TABLE
424: , p5_a16 JTF_DATE_TABLE
425: , p5_a17 JTF_NUMBER_TABLE
426: , p5_a18 JTF_DATE_TABLE
427: , p5_a19 JTF_NUMBER_TABLE

Line 425: , p5_a17 JTF_NUMBER_TABLE

421: , p5_a13 JTF_VARCHAR2_TABLE_100
422: , p5_a14 JTF_VARCHAR2_TABLE_200
423: , p5_a15 JTF_NUMBER_TABLE
424: , p5_a16 JTF_DATE_TABLE
425: , p5_a17 JTF_NUMBER_TABLE
426: , p5_a18 JTF_DATE_TABLE
427: , p5_a19 JTF_NUMBER_TABLE
428: );
429: end okl_qpy_pvt_w;

Line 427: , p5_a19 JTF_NUMBER_TABLE

423: , p5_a15 JTF_NUMBER_TABLE
424: , p5_a16 JTF_DATE_TABLE
425: , p5_a17 JTF_NUMBER_TABLE
426: , p5_a18 JTF_DATE_TABLE
427: , p5_a19 JTF_NUMBER_TABLE
428: );
429: end okl_qpy_pvt_w;