APPS.OKL_QLS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_qls_pvt_w as
2: /* $Header: OKLIQLSS.pls 120.2 2005/07/18 15:55:09 viselvar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_qls_pvt_w as
2: /* $Header: OKLIQLSS.pls 120.2 2005/07/18 15:55:09 viselvar noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_qls_pvt.qlsv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 13: , a10 JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_NUMBER_TABLE

Line 15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE

Line 17: , a2 out nocopy JTF_NUMBER_TABLE

13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p2(t okl_qls_pvt.qlsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE

Line 19: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 20: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 21: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 23: , a8 out nocopy JTF_NUMBER_TABLE

19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:

Line 25: , a10 out nocopy JTF_NUMBER_TABLE

21: , a6 out nocopy JTF_NUMBER_TABLE
22: , a7 out nocopy JTF_DATE_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100

Line 28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE

24: , a9 out nocopy JTF_DATE_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE

Line 30: , a2 JTF_NUMBER_TABLE

26: );
27:
28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE

Line 32: , a4 JTF_NUMBER_TABLE

28: procedure rosetta_table_copy_in_p5(t out nocopy okl_qls_pvt.qls_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_VARCHAR2_TABLE_100
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE

Line 33: , a5 JTF_NUMBER_TABLE

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

Line 34: , a6 JTF_NUMBER_TABLE

30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE

Line 36: , a8 JTF_NUMBER_TABLE

32: , a4 JTF_NUMBER_TABLE
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 38: , a10 JTF_NUMBER_TABLE

34: , a6 JTF_NUMBER_TABLE
35: , a7 JTF_DATE_TABLE
36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE

Line 40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

36: , a8 JTF_NUMBER_TABLE
37: , a9 JTF_DATE_TABLE
38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE

Line 42: , a2 out nocopy JTF_NUMBER_TABLE

38: , a10 JTF_NUMBER_TABLE
39: );
40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE

Line 44: , a4 out nocopy JTF_NUMBER_TABLE

40: procedure rosetta_table_copy_out_p5(t okl_qls_pvt.qls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE

Line 45: , a5 out nocopy JTF_NUMBER_TABLE

41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE

Line 46: , a6 out nocopy JTF_NUMBER_TABLE

42: , a2 out nocopy JTF_NUMBER_TABLE
43: , a3 out nocopy JTF_VARCHAR2_TABLE_100
44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE

Line 48: , a8 out nocopy JTF_NUMBER_TABLE

44: , a4 out nocopy JTF_NUMBER_TABLE
45: , a5 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: );
52:

Line 50: , a10 out nocopy JTF_NUMBER_TABLE

46: , a6 out nocopy JTF_NUMBER_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: );
52:
53: procedure insert_row(p_api_version NUMBER
54: , p_init_msg_list VARCHAR2

Line 86: , p5_a0 JTF_NUMBER_TABLE

82: , p_init_msg_list VARCHAR2
83: , x_return_status out nocopy VARCHAR2
84: , x_msg_count out nocopy NUMBER
85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE

Line 88: , p5_a2 JTF_NUMBER_TABLE

84: , x_msg_count out nocopy NUMBER
85: , x_msg_data out nocopy VARCHAR2
86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE

Line 90: , p5_a4 JTF_NUMBER_TABLE

86: , p5_a0 JTF_NUMBER_TABLE
87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE

Line 91: , p5_a5 JTF_NUMBER_TABLE

87: , p5_a1 JTF_VARCHAR2_TABLE_100
88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE

Line 92: , p5_a6 JTF_NUMBER_TABLE

88: , p5_a2 JTF_NUMBER_TABLE
89: , p5_a3 JTF_VARCHAR2_TABLE_100
90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE

Line 94: , p5_a8 JTF_NUMBER_TABLE

90: , p5_a4 JTF_NUMBER_TABLE
91: , p5_a5 JTF_NUMBER_TABLE
92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 96: , p5_a10 JTF_NUMBER_TABLE

92: , p5_a6 JTF_NUMBER_TABLE
93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , p6_a0 out nocopy JTF_NUMBER_TABLE

93: , p5_a7 JTF_DATE_TABLE
94: , p5_a8 JTF_NUMBER_TABLE
95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 99: , p6_a2 out nocopy JTF_NUMBER_TABLE

95: , p5_a9 JTF_DATE_TABLE
96: , p5_a10 JTF_NUMBER_TABLE
97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 101: , p6_a4 out nocopy JTF_NUMBER_TABLE

97: , p6_a0 out nocopy JTF_NUMBER_TABLE
98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 102: , p6_a5 out nocopy JTF_NUMBER_TABLE

98: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE

Line 103: , p6_a6 out nocopy JTF_NUMBER_TABLE

99: , p6_a2 out nocopy JTF_NUMBER_TABLE
100: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 105: , p6_a8 out nocopy JTF_NUMBER_TABLE

101: , p6_a4 out nocopy JTF_NUMBER_TABLE
102: , p6_a5 out nocopy JTF_NUMBER_TABLE
103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 107: , p6_a10 out nocopy JTF_NUMBER_TABLE

103: , p6_a6 out nocopy JTF_NUMBER_TABLE
104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 108: , p7_a0 in out nocopy JTF_NUMBER_TABLE

104: , p6_a7 out nocopy JTF_DATE_TABLE
105: , p6_a8 out nocopy JTF_NUMBER_TABLE
106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 110: , p7_a2 in out nocopy JTF_NUMBER_TABLE

106: , p6_a9 out nocopy JTF_DATE_TABLE
107: , p6_a10 out nocopy JTF_NUMBER_TABLE
108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE
113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , p7_a4 in out nocopy JTF_NUMBER_TABLE

108: , p7_a0 in out nocopy JTF_NUMBER_TABLE
109: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
110: , p7_a2 in out nocopy JTF_NUMBER_TABLE
111: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
112: , p7_a4 in out nocopy JTF_NUMBER_TABLE
113: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
114: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
115: );
116: procedure insert_row(p_api_version NUMBER

Line 121: , p5_a0 JTF_NUMBER_TABLE

117: , p_init_msg_list VARCHAR2
118: , x_return_status out nocopy VARCHAR2
119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE

Line 123: , p5_a2 JTF_NUMBER_TABLE

119: , x_msg_count out nocopy NUMBER
120: , x_msg_data out nocopy VARCHAR2
121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE

Line 125: , p5_a4 JTF_NUMBER_TABLE

121: , p5_a0 JTF_NUMBER_TABLE
122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE

Line 126: , p5_a5 JTF_NUMBER_TABLE

122: , p5_a1 JTF_VARCHAR2_TABLE_100
123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE

Line 127: , p5_a6 JTF_NUMBER_TABLE

123: , p5_a2 JTF_NUMBER_TABLE
124: , p5_a3 JTF_VARCHAR2_TABLE_100
125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE

Line 129: , p5_a8 JTF_NUMBER_TABLE

125: , p5_a4 JTF_NUMBER_TABLE
126: , p5_a5 JTF_NUMBER_TABLE
127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 131: , p5_a10 JTF_NUMBER_TABLE

127: , p5_a6 JTF_NUMBER_TABLE
128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , p6_a0 out nocopy JTF_NUMBER_TABLE

128: , p5_a7 JTF_DATE_TABLE
129: , p5_a8 JTF_NUMBER_TABLE
130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 134: , p6_a2 out nocopy JTF_NUMBER_TABLE

130: , p5_a9 JTF_DATE_TABLE
131: , p5_a10 JTF_NUMBER_TABLE
132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 136: , p6_a4 out nocopy JTF_NUMBER_TABLE

132: , p6_a0 out nocopy JTF_NUMBER_TABLE
133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 137: , p6_a5 out nocopy JTF_NUMBER_TABLE

133: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE

Line 138: , p6_a6 out nocopy JTF_NUMBER_TABLE

134: , p6_a2 out nocopy JTF_NUMBER_TABLE
135: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE
142: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 140: , p6_a8 out nocopy JTF_NUMBER_TABLE

136: , p6_a4 out nocopy JTF_NUMBER_TABLE
137: , p6_a5 out nocopy JTF_NUMBER_TABLE
138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE
142: , p6_a10 out nocopy JTF_NUMBER_TABLE
143: );
144: procedure lock_row(p_api_version NUMBER

Line 142: , p6_a10 out nocopy JTF_NUMBER_TABLE

138: , p6_a6 out nocopy JTF_NUMBER_TABLE
139: , p6_a7 out nocopy JTF_DATE_TABLE
140: , p6_a8 out nocopy JTF_NUMBER_TABLE
141: , p6_a9 out nocopy JTF_DATE_TABLE
142: , p6_a10 out nocopy JTF_NUMBER_TABLE
143: );
144: procedure lock_row(p_api_version NUMBER
145: , p_init_msg_list VARCHAR2
146: , x_return_status out nocopy VARCHAR2

Line 166: , p5_a0 JTF_NUMBER_TABLE

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

Line 168: , p5_a2 JTF_NUMBER_TABLE

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

Line 170: , p5_a4 JTF_NUMBER_TABLE

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

Line 171: , p5_a5 JTF_NUMBER_TABLE

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

Line 172: , p5_a6 JTF_NUMBER_TABLE

168: , p5_a2 JTF_NUMBER_TABLE
169: , p5_a3 JTF_VARCHAR2_TABLE_100
170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_NUMBER_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE

Line 174: , p5_a8 JTF_NUMBER_TABLE

170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_NUMBER_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 176: , p5_a10 JTF_NUMBER_TABLE

172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 177: , p6_a0 in out nocopy JTF_NUMBER_TABLE

173: , p5_a7 JTF_DATE_TABLE
174: , p5_a8 JTF_NUMBER_TABLE
175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 179: , p6_a2 in out nocopy JTF_NUMBER_TABLE

175: , p5_a9 JTF_DATE_TABLE
176: , p5_a10 JTF_NUMBER_TABLE
177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE
182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , p6_a4 in out nocopy JTF_NUMBER_TABLE

177: , p6_a0 in out nocopy JTF_NUMBER_TABLE
178: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
179: , p6_a2 in out nocopy JTF_NUMBER_TABLE
180: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
181: , p6_a4 in out nocopy JTF_NUMBER_TABLE
182: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
184: );
185: procedure lock_row(p_api_version NUMBER

Line 190: , p5_a0 JTF_NUMBER_TABLE

186: , p_init_msg_list VARCHAR2
187: , x_return_status out nocopy VARCHAR2
188: , x_msg_count out nocopy NUMBER
189: , x_msg_data out nocopy VARCHAR2
190: , p5_a0 JTF_NUMBER_TABLE
191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE

Line 192: , p5_a2 JTF_NUMBER_TABLE

188: , x_msg_count out nocopy NUMBER
189: , x_msg_data out nocopy VARCHAR2
190: , p5_a0 JTF_NUMBER_TABLE
191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE

Line 194: , p5_a4 JTF_NUMBER_TABLE

190: , p5_a0 JTF_NUMBER_TABLE
191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE

Line 195: , p5_a5 JTF_NUMBER_TABLE

191: , p5_a1 JTF_VARCHAR2_TABLE_100
192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE

Line 196: , p5_a6 JTF_NUMBER_TABLE

192: , p5_a2 JTF_NUMBER_TABLE
193: , p5_a3 JTF_VARCHAR2_TABLE_100
194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE
200: , p5_a10 JTF_NUMBER_TABLE

Line 198: , p5_a8 JTF_NUMBER_TABLE

194: , p5_a4 JTF_NUMBER_TABLE
195: , p5_a5 JTF_NUMBER_TABLE
196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE
200: , p5_a10 JTF_NUMBER_TABLE
201: );
202: procedure update_row(p_api_version NUMBER

Line 200: , p5_a10 JTF_NUMBER_TABLE

196: , p5_a6 JTF_NUMBER_TABLE
197: , p5_a7 JTF_DATE_TABLE
198: , p5_a8 JTF_NUMBER_TABLE
199: , p5_a9 JTF_DATE_TABLE
200: , p5_a10 JTF_NUMBER_TABLE
201: );
202: procedure update_row(p_api_version NUMBER
203: , p_init_msg_list VARCHAR2
204: , x_return_status out nocopy VARCHAR2

Line 235: , p5_a0 JTF_NUMBER_TABLE

231: , p_init_msg_list VARCHAR2
232: , x_return_status out nocopy VARCHAR2
233: , x_msg_count out nocopy NUMBER
234: , x_msg_data out nocopy VARCHAR2
235: , p5_a0 JTF_NUMBER_TABLE
236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE

Line 237: , p5_a2 JTF_NUMBER_TABLE

233: , x_msg_count out nocopy NUMBER
234: , x_msg_data out nocopy VARCHAR2
235: , p5_a0 JTF_NUMBER_TABLE
236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE

Line 239: , p5_a4 JTF_NUMBER_TABLE

235: , p5_a0 JTF_NUMBER_TABLE
236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE

Line 240: , p5_a5 JTF_NUMBER_TABLE

236: , p5_a1 JTF_VARCHAR2_TABLE_100
237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE

Line 241: , p5_a6 JTF_NUMBER_TABLE

237: , p5_a2 JTF_NUMBER_TABLE
238: , p5_a3 JTF_VARCHAR2_TABLE_100
239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE

Line 243: , p5_a8 JTF_NUMBER_TABLE

239: , p5_a4 JTF_NUMBER_TABLE
240: , p5_a5 JTF_NUMBER_TABLE
241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 245: , p5_a10 JTF_NUMBER_TABLE

241: , p5_a6 JTF_NUMBER_TABLE
242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , p6_a0 out nocopy JTF_NUMBER_TABLE

242: , p5_a7 JTF_DATE_TABLE
243: , p5_a8 JTF_NUMBER_TABLE
244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 248: , p6_a2 out nocopy JTF_NUMBER_TABLE

244: , p5_a9 JTF_DATE_TABLE
245: , p5_a10 JTF_NUMBER_TABLE
246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 250: , p6_a4 out nocopy JTF_NUMBER_TABLE

246: , p6_a0 out nocopy JTF_NUMBER_TABLE
247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 251: , p6_a5 out nocopy JTF_NUMBER_TABLE

247: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE

Line 252: , p6_a6 out nocopy JTF_NUMBER_TABLE

248: , p6_a2 out nocopy JTF_NUMBER_TABLE
249: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 254: , p6_a8 out nocopy JTF_NUMBER_TABLE

250: , p6_a4 out nocopy JTF_NUMBER_TABLE
251: , p6_a5 out nocopy JTF_NUMBER_TABLE
252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 256: , p6_a10 out nocopy JTF_NUMBER_TABLE

252: , p6_a6 out nocopy JTF_NUMBER_TABLE
253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 257: , p7_a0 in out nocopy JTF_NUMBER_TABLE

253: , p6_a7 out nocopy JTF_DATE_TABLE
254: , p6_a8 out nocopy JTF_NUMBER_TABLE
255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE

Line 259: , p7_a2 in out nocopy JTF_NUMBER_TABLE

255: , p6_a9 out nocopy JTF_DATE_TABLE
256: , p6_a10 out nocopy JTF_NUMBER_TABLE
257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE
262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 261: , p7_a4 in out nocopy JTF_NUMBER_TABLE

257: , p7_a0 in out nocopy JTF_NUMBER_TABLE
258: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a2 in out nocopy JTF_NUMBER_TABLE
260: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
261: , p7_a4 in out nocopy JTF_NUMBER_TABLE
262: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
264: );
265: procedure update_row(p_api_version NUMBER

Line 270: , p5_a0 JTF_NUMBER_TABLE

266: , p_init_msg_list VARCHAR2
267: , x_return_status out nocopy VARCHAR2
268: , x_msg_count out nocopy NUMBER
269: , x_msg_data out nocopy VARCHAR2
270: , p5_a0 JTF_NUMBER_TABLE
271: , p5_a1 JTF_VARCHAR2_TABLE_100
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE

Line 272: , p5_a2 JTF_NUMBER_TABLE

268: , x_msg_count out nocopy NUMBER
269: , x_msg_data out nocopy VARCHAR2
270: , p5_a0 JTF_NUMBER_TABLE
271: , p5_a1 JTF_VARCHAR2_TABLE_100
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE

Line 274: , p5_a4 JTF_NUMBER_TABLE

270: , p5_a0 JTF_NUMBER_TABLE
271: , p5_a1 JTF_VARCHAR2_TABLE_100
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE

Line 275: , p5_a5 JTF_NUMBER_TABLE

271: , p5_a1 JTF_VARCHAR2_TABLE_100
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE

Line 276: , p5_a6 JTF_NUMBER_TABLE

272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE

Line 278: , p5_a8 JTF_NUMBER_TABLE

274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 280: , p5_a10 JTF_NUMBER_TABLE

276: , p5_a6 JTF_NUMBER_TABLE
277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 281: , p6_a0 out nocopy JTF_NUMBER_TABLE

277: , p5_a7 JTF_DATE_TABLE
278: , p5_a8 JTF_NUMBER_TABLE
279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 283: , p6_a2 out nocopy JTF_NUMBER_TABLE

279: , p5_a9 JTF_DATE_TABLE
280: , p5_a10 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 285: , p6_a4 out nocopy JTF_NUMBER_TABLE

281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 286: , p6_a5 out nocopy JTF_NUMBER_TABLE

282: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE

Line 287: , p6_a6 out nocopy JTF_NUMBER_TABLE

283: , p6_a2 out nocopy JTF_NUMBER_TABLE
284: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE
291: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 289: , p6_a8 out nocopy JTF_NUMBER_TABLE

285: , p6_a4 out nocopy JTF_NUMBER_TABLE
286: , p6_a5 out nocopy JTF_NUMBER_TABLE
287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE
291: , p6_a10 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure delete_row(p_api_version NUMBER

Line 291: , p6_a10 out nocopy JTF_NUMBER_TABLE

287: , p6_a6 out nocopy JTF_NUMBER_TABLE
288: , p6_a7 out nocopy JTF_DATE_TABLE
289: , p6_a8 out nocopy JTF_NUMBER_TABLE
290: , p6_a9 out nocopy JTF_DATE_TABLE
291: , p6_a10 out nocopy JTF_NUMBER_TABLE
292: );
293: procedure delete_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2

Line 315: , p5_a0 JTF_NUMBER_TABLE

311: , p_init_msg_list VARCHAR2
312: , x_return_status out nocopy VARCHAR2
313: , x_msg_count out nocopy NUMBER
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE

Line 317: , p5_a2 JTF_NUMBER_TABLE

313: , x_msg_count out nocopy NUMBER
314: , x_msg_data out nocopy VARCHAR2
315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE

Line 319: , p5_a4 JTF_NUMBER_TABLE

315: , p5_a0 JTF_NUMBER_TABLE
316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE

Line 320: , p5_a5 JTF_NUMBER_TABLE

316: , p5_a1 JTF_VARCHAR2_TABLE_100
317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE

Line 321: , p5_a6 JTF_NUMBER_TABLE

317: , p5_a2 JTF_NUMBER_TABLE
318: , p5_a3 JTF_VARCHAR2_TABLE_100
319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE

Line 323: , p5_a8 JTF_NUMBER_TABLE

319: , p5_a4 JTF_NUMBER_TABLE
320: , p5_a5 JTF_NUMBER_TABLE
321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 325: , p5_a10 JTF_NUMBER_TABLE

321: , p5_a6 JTF_NUMBER_TABLE
322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 326: , p6_a0 in out nocopy JTF_NUMBER_TABLE

322: , p5_a7 JTF_DATE_TABLE
323: , p5_a8 JTF_NUMBER_TABLE
324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 328: , p6_a2 in out nocopy JTF_NUMBER_TABLE

324: , p5_a9 JTF_DATE_TABLE
325: , p5_a10 JTF_NUMBER_TABLE
326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE
331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 330: , p6_a4 in out nocopy JTF_NUMBER_TABLE

326: , p6_a0 in out nocopy JTF_NUMBER_TABLE
327: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a2 in out nocopy JTF_NUMBER_TABLE
329: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
330: , p6_a4 in out nocopy JTF_NUMBER_TABLE
331: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
333: );
334: procedure delete_row(p_api_version NUMBER

Line 339: , p5_a0 JTF_NUMBER_TABLE

335: , p_init_msg_list VARCHAR2
336: , x_return_status out nocopy VARCHAR2
337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE

Line 341: , p5_a2 JTF_NUMBER_TABLE

337: , x_msg_count out nocopy NUMBER
338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE

Line 343: , p5_a4 JTF_NUMBER_TABLE

339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE

Line 344: , p5_a5 JTF_NUMBER_TABLE

340: , p5_a1 JTF_VARCHAR2_TABLE_100
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE

Line 345: , p5_a6 JTF_NUMBER_TABLE

341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_NUMBER_TABLE

Line 347: , p5_a8 JTF_NUMBER_TABLE

343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_NUMBER_TABLE
350: );
351: procedure validate_row(p_api_version NUMBER

Line 349: , p5_a10 JTF_NUMBER_TABLE

345: , p5_a6 JTF_NUMBER_TABLE
346: , p5_a7 JTF_DATE_TABLE
347: , p5_a8 JTF_NUMBER_TABLE
348: , p5_a9 JTF_DATE_TABLE
349: , p5_a10 JTF_NUMBER_TABLE
350: );
351: procedure validate_row(p_api_version NUMBER
352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2

Line 373: , p5_a0 JTF_NUMBER_TABLE

369: , p_init_msg_list VARCHAR2
370: , x_return_status out nocopy VARCHAR2
371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE

Line 375: , p5_a2 JTF_NUMBER_TABLE

371: , x_msg_count out nocopy NUMBER
372: , x_msg_data out nocopy VARCHAR2
373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE

Line 377: , p5_a4 JTF_NUMBER_TABLE

373: , p5_a0 JTF_NUMBER_TABLE
374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE

Line 378: , p5_a5 JTF_NUMBER_TABLE

374: , p5_a1 JTF_VARCHAR2_TABLE_100
375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE

Line 379: , p5_a6 JTF_NUMBER_TABLE

375: , p5_a2 JTF_NUMBER_TABLE
376: , p5_a3 JTF_VARCHAR2_TABLE_100
377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE

Line 381: , p5_a8 JTF_NUMBER_TABLE

377: , p5_a4 JTF_NUMBER_TABLE
378: , p5_a5 JTF_NUMBER_TABLE
379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100

Line 383: , p5_a10 JTF_NUMBER_TABLE

379: , p5_a6 JTF_NUMBER_TABLE
380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a2 in out nocopy JTF_NUMBER_TABLE
387: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 384: , p6_a0 in out nocopy JTF_NUMBER_TABLE

380: , p5_a7 JTF_DATE_TABLE
381: , p5_a8 JTF_NUMBER_TABLE
382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a2 in out nocopy JTF_NUMBER_TABLE
387: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
388: , p6_a4 in out nocopy JTF_NUMBER_TABLE

Line 386: , p6_a2 in out nocopy JTF_NUMBER_TABLE

382: , p5_a9 JTF_DATE_TABLE
383: , p5_a10 JTF_NUMBER_TABLE
384: , p6_a0 in out nocopy JTF_NUMBER_TABLE
385: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
386: , p6_a2 in out nocopy JTF_NUMBER_TABLE
387: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
388: , p6_a4 in out nocopy JTF_NUMBER_TABLE
389: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
390: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 388: , p6_a4 in out nocopy JTF_NUMBER_TABLE

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

Line 397: , p5_a0 JTF_NUMBER_TABLE

393: , p_init_msg_list VARCHAR2
394: , x_return_status out nocopy VARCHAR2
395: , x_msg_count out nocopy NUMBER
396: , x_msg_data out nocopy VARCHAR2
397: , p5_a0 JTF_NUMBER_TABLE
398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE

Line 399: , p5_a2 JTF_NUMBER_TABLE

395: , x_msg_count out nocopy NUMBER
396: , x_msg_data out nocopy VARCHAR2
397: , p5_a0 JTF_NUMBER_TABLE
398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE

Line 401: , p5_a4 JTF_NUMBER_TABLE

397: , p5_a0 JTF_NUMBER_TABLE
398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE

Line 402: , p5_a5 JTF_NUMBER_TABLE

398: , p5_a1 JTF_VARCHAR2_TABLE_100
399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE

Line 403: , p5_a6 JTF_NUMBER_TABLE

399: , p5_a2 JTF_NUMBER_TABLE
400: , p5_a3 JTF_VARCHAR2_TABLE_100
401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE
407: , p5_a10 JTF_NUMBER_TABLE

Line 405: , p5_a8 JTF_NUMBER_TABLE

401: , p5_a4 JTF_NUMBER_TABLE
402: , p5_a5 JTF_NUMBER_TABLE
403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE
407: , p5_a10 JTF_NUMBER_TABLE
408: );
409: end okl_qls_pvt_w;

Line 407: , p5_a10 JTF_NUMBER_TABLE

403: , p5_a6 JTF_NUMBER_TABLE
404: , p5_a7 JTF_DATE_TABLE
405: , p5_a8 JTF_NUMBER_TABLE
406: , p5_a9 JTF_DATE_TABLE
407: , p5_a10 JTF_NUMBER_TABLE
408: );
409: end okl_qls_pvt_w;