APPS.OKL_RCS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_rcs_pvt_w as
2: /* $Header: OKLIRCSS.pls 120.2 2005/09/14 06:41:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_rcs_pvt_w as
2: /* $Header: OKLIRCSS.pls 120.2 2005/09/14 06:41:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_rcs_pvt_w as
2: /* $Header: OKLIRCSS.pls 120.2 2005/09/14 06:41:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIRCSS.pls 120.2 2005/09/14 06:41:40 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_rcs_pvt.okl_rcsv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_2000

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_300
10: , a7 JTF_VARCHAR2_TABLE_2000
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_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_VARCHAR2_TABLE_2000
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_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE

Line 18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 19: , a1 out nocopy JTF_NUMBER_TABLE

15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 20: , a2 out nocopy JTF_NUMBER_TABLE

16: , a13 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 21: , a3 out nocopy JTF_NUMBER_TABLE

17: );
18: procedure rosetta_table_copy_out_p1(t okl_rcs_pvt.okl_rcsv_tbl, a0 out nocopy JTF_NUMBER_TABLE
19: , a1 out nocopy JTF_NUMBER_TABLE
20: , a2 out nocopy JTF_NUMBER_TABLE
21: , a3 out nocopy JTF_NUMBER_TABLE
22: , a4 out nocopy JTF_VARCHAR2_TABLE_100
23: , a5 out nocopy JTF_VARCHAR2_TABLE_100
24: , a6 out nocopy JTF_VARCHAR2_TABLE_300
25: , a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 27: , a9 out nocopy JTF_NUMBER_TABLE

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

Line 29: , a11 out nocopy JTF_NUMBER_TABLE

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

Line 31: , a13 out nocopy JTF_NUMBER_TABLE

27: , a9 out nocopy JTF_NUMBER_TABLE
28: , a10 out nocopy JTF_DATE_TABLE
29: , a11 out nocopy JTF_NUMBER_TABLE
30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
35: , a1 JTF_VARCHAR2_TABLE_300

Line 34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE

30: , a12 out nocopy JTF_DATE_TABLE
31: , a13 out nocopy JTF_NUMBER_TABLE
32: );
33:
34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
35: , a1 JTF_VARCHAR2_TABLE_300
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_NUMBER_TABLE
38: , a4 JTF_NUMBER_TABLE

Line 36: , a2 JTF_NUMBER_TABLE

32: );
33:
34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
35: , a1 JTF_VARCHAR2_TABLE_300
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_NUMBER_TABLE
38: , a4 JTF_NUMBER_TABLE
39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_VARCHAR2_TABLE_100

Line 37: , a3 JTF_NUMBER_TABLE

33:
34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
35: , a1 JTF_VARCHAR2_TABLE_300
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_NUMBER_TABLE
38: , a4 JTF_NUMBER_TABLE
39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_VARCHAR2_TABLE_100
41: , a7 JTF_NUMBER_TABLE

Line 38: , a4 JTF_NUMBER_TABLE

34: procedure rosetta_table_copy_in_p3(t out nocopy okl_rcs_pvt.okl_rcsb_tbl, a0 JTF_NUMBER_TABLE
35: , a1 JTF_VARCHAR2_TABLE_300
36: , a2 JTF_NUMBER_TABLE
37: , a3 JTF_NUMBER_TABLE
38: , a4 JTF_NUMBER_TABLE
39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_VARCHAR2_TABLE_100
41: , a7 JTF_NUMBER_TABLE
42: , a8 JTF_DATE_TABLE

Line 41: , a7 JTF_NUMBER_TABLE

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

Line 43: , a9 JTF_NUMBER_TABLE

39: , a5 JTF_VARCHAR2_TABLE_100
40: , a6 JTF_VARCHAR2_TABLE_100
41: , a7 JTF_NUMBER_TABLE
42: , a8 JTF_DATE_TABLE
43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 45: , a11 JTF_NUMBER_TABLE

41: , a7 JTF_NUMBER_TABLE
42: , a8 JTF_DATE_TABLE
43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_300
49: , a2 out nocopy JTF_NUMBER_TABLE

Line 47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE

43: , a9 JTF_NUMBER_TABLE
44: , a10 JTF_DATE_TABLE
45: , a11 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_300
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE

Line 49: , a2 out nocopy JTF_NUMBER_TABLE

45: , a11 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_300
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 50: , a3 out nocopy JTF_NUMBER_TABLE

46: );
47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_300
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_NUMBER_TABLE

Line 51: , a4 out nocopy JTF_NUMBER_TABLE

47: procedure rosetta_table_copy_out_p3(t okl_rcs_pvt.okl_rcsb_tbl, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_300
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_NUMBER_TABLE
55: , a8 out nocopy JTF_DATE_TABLE

Line 54: , a7 out nocopy JTF_NUMBER_TABLE

50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_NUMBER_TABLE
55: , a8 out nocopy JTF_DATE_TABLE
56: , a9 out nocopy JTF_NUMBER_TABLE
57: , a10 out nocopy JTF_DATE_TABLE
58: , a11 out nocopy JTF_NUMBER_TABLE

Line 56: , a9 out nocopy JTF_NUMBER_TABLE

52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_NUMBER_TABLE
55: , a8 out nocopy JTF_DATE_TABLE
56: , a9 out nocopy JTF_NUMBER_TABLE
57: , a10 out nocopy JTF_DATE_TABLE
58: , a11 out nocopy JTF_NUMBER_TABLE
59: );
60:

Line 58: , a11 out nocopy JTF_NUMBER_TABLE

54: , a7 out nocopy JTF_NUMBER_TABLE
55: , a8 out nocopy JTF_DATE_TABLE
56: , a9 out nocopy JTF_NUMBER_TABLE
57: , a10 out nocopy JTF_DATE_TABLE
58: , a11 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100

Line 61: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE

57: , a10 out nocopy JTF_DATE_TABLE
58: , a11 out nocopy JTF_NUMBER_TABLE
59: );
60:
61: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE

Line 65: , a4 JTF_NUMBER_TABLE

61: procedure rosetta_table_copy_in_p5(t out nocopy okl_rcs_pvt.okl_rcstl_tbl, a0 JTF_NUMBER_TABLE
62: , a1 JTF_VARCHAR2_TABLE_100
63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_DATE_TABLE
67: , a6 JTF_NUMBER_TABLE
68: , a7 JTF_DATE_TABLE
69: , a8 JTF_NUMBER_TABLE

Line 67: , a6 JTF_NUMBER_TABLE

63: , a2 JTF_VARCHAR2_TABLE_100
64: , a3 JTF_VARCHAR2_TABLE_100
65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_DATE_TABLE
67: , a6 JTF_NUMBER_TABLE
68: , a7 JTF_DATE_TABLE
69: , a8 JTF_NUMBER_TABLE
70: , a9 JTF_VARCHAR2_TABLE_2000
71: );

Line 69: , a8 JTF_NUMBER_TABLE

65: , a4 JTF_NUMBER_TABLE
66: , a5 JTF_DATE_TABLE
67: , a6 JTF_NUMBER_TABLE
68: , a7 JTF_DATE_TABLE
69: , a8 JTF_NUMBER_TABLE
70: , a9 JTF_VARCHAR2_TABLE_2000
71: );
72: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 72: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE

68: , a7 JTF_DATE_TABLE
69: , a8 JTF_NUMBER_TABLE
70: , a9 JTF_VARCHAR2_TABLE_2000
71: );
72: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , a4 out nocopy JTF_NUMBER_TABLE

Line 76: , a4 out nocopy JTF_NUMBER_TABLE

72: procedure rosetta_table_copy_out_p5(t okl_rcs_pvt.okl_rcstl_tbl, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_DATE_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_DATE_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE

Line 78: , a6 out nocopy JTF_NUMBER_TABLE

74: , a2 out nocopy JTF_VARCHAR2_TABLE_100
75: , a3 out nocopy JTF_VARCHAR2_TABLE_100
76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_DATE_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_DATE_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
82: );

Line 80: , a8 out nocopy JTF_NUMBER_TABLE

76: , a4 out nocopy JTF_NUMBER_TABLE
77: , a5 out nocopy JTF_DATE_TABLE
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_DATE_TABLE
80: , a8 out nocopy JTF_NUMBER_TABLE
81: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
82: );
83:
84: procedure insert_row(p_api_version NUMBER

Line 123: , p5_a0 JTF_NUMBER_TABLE

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

Line 124: , p5_a1 JTF_NUMBER_TABLE

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

Line 125: , p5_a2 JTF_NUMBER_TABLE

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

Line 126: , p5_a3 JTF_NUMBER_TABLE

122: , x_msg_data out nocopy VARCHAR2
123: , p5_a0 JTF_NUMBER_TABLE
124: , p5_a1 JTF_NUMBER_TABLE
125: , p5_a2 JTF_NUMBER_TABLE
126: , p5_a3 JTF_NUMBER_TABLE
127: , p5_a4 JTF_VARCHAR2_TABLE_100
128: , p5_a5 JTF_VARCHAR2_TABLE_100
129: , p5_a6 JTF_VARCHAR2_TABLE_300
130: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 132: , p5_a9 JTF_NUMBER_TABLE

128: , p5_a5 JTF_VARCHAR2_TABLE_100
129: , p5_a6 JTF_VARCHAR2_TABLE_300
130: , p5_a7 JTF_VARCHAR2_TABLE_2000
131: , p5_a8 JTF_VARCHAR2_TABLE_100
132: , p5_a9 JTF_NUMBER_TABLE
133: , p5_a10 JTF_DATE_TABLE
134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE

Line 134: , p5_a11 JTF_NUMBER_TABLE

130: , p5_a7 JTF_VARCHAR2_TABLE_2000
131: , p5_a8 JTF_VARCHAR2_TABLE_100
132: , p5_a9 JTF_NUMBER_TABLE
133: , p5_a10 JTF_DATE_TABLE
134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 136: , p5_a13 JTF_NUMBER_TABLE

132: , p5_a9 JTF_NUMBER_TABLE
133: , p5_a10 JTF_DATE_TABLE
134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_NUMBER_TABLE
140: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 137: , p6_a0 out nocopy JTF_NUMBER_TABLE

133: , p5_a10 JTF_DATE_TABLE
134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_NUMBER_TABLE
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 138: , p6_a1 out nocopy JTF_NUMBER_TABLE

134: , p5_a11 JTF_NUMBER_TABLE
135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_NUMBER_TABLE
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
142: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , p6_a2 out nocopy JTF_NUMBER_TABLE

135: , p5_a12 JTF_DATE_TABLE
136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_NUMBER_TABLE
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
142: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 140: , p6_a3 out nocopy JTF_NUMBER_TABLE

136: , p5_a13 JTF_NUMBER_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_NUMBER_TABLE
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
142: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
144: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 146: , p6_a9 out nocopy JTF_NUMBER_TABLE

142: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
144: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
145: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a9 out nocopy JTF_NUMBER_TABLE
147: , p6_a10 out nocopy JTF_DATE_TABLE
148: , p6_a11 out nocopy JTF_NUMBER_TABLE
149: , p6_a12 out nocopy JTF_DATE_TABLE
150: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 148: , p6_a11 out nocopy JTF_NUMBER_TABLE

144: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
145: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a9 out nocopy JTF_NUMBER_TABLE
147: , p6_a10 out nocopy JTF_DATE_TABLE
148: , p6_a11 out nocopy JTF_NUMBER_TABLE
149: , p6_a12 out nocopy JTF_DATE_TABLE
150: , p6_a13 out nocopy JTF_NUMBER_TABLE
151: );
152: procedure update_row(p_api_version NUMBER

Line 150: , p6_a13 out nocopy JTF_NUMBER_TABLE

146: , p6_a9 out nocopy JTF_NUMBER_TABLE
147: , p6_a10 out nocopy JTF_DATE_TABLE
148: , p6_a11 out nocopy JTF_NUMBER_TABLE
149: , p6_a12 out nocopy JTF_DATE_TABLE
150: , p6_a13 out nocopy JTF_NUMBER_TABLE
151: );
152: procedure update_row(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2
154: , x_return_status out nocopy VARCHAR2

Line 191: , p5_a0 JTF_NUMBER_TABLE

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

Line 192: , p5_a1 JTF_NUMBER_TABLE

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

Line 193: , p5_a2 JTF_NUMBER_TABLE

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

Line 194: , p5_a3 JTF_NUMBER_TABLE

190: , x_msg_data out nocopy VARCHAR2
191: , p5_a0 JTF_NUMBER_TABLE
192: , p5_a1 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_VARCHAR2_TABLE_100
196: , p5_a5 JTF_VARCHAR2_TABLE_100
197: , p5_a6 JTF_VARCHAR2_TABLE_300
198: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 200: , p5_a9 JTF_NUMBER_TABLE

196: , p5_a5 JTF_VARCHAR2_TABLE_100
197: , p5_a6 JTF_VARCHAR2_TABLE_300
198: , p5_a7 JTF_VARCHAR2_TABLE_2000
199: , p5_a8 JTF_VARCHAR2_TABLE_100
200: , p5_a9 JTF_NUMBER_TABLE
201: , p5_a10 JTF_DATE_TABLE
202: , p5_a11 JTF_NUMBER_TABLE
203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE

Line 202: , p5_a11 JTF_NUMBER_TABLE

198: , p5_a7 JTF_VARCHAR2_TABLE_2000
199: , p5_a8 JTF_VARCHAR2_TABLE_100
200: , p5_a9 JTF_NUMBER_TABLE
201: , p5_a10 JTF_DATE_TABLE
202: , p5_a11 JTF_NUMBER_TABLE
203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 204: , p5_a13 JTF_NUMBER_TABLE

200: , p5_a9 JTF_NUMBER_TABLE
201: , p5_a10 JTF_DATE_TABLE
202: , p5_a11 JTF_NUMBER_TABLE
203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE
207: , p6_a2 out nocopy JTF_NUMBER_TABLE
208: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 205: , p6_a0 out nocopy JTF_NUMBER_TABLE

201: , p5_a10 JTF_DATE_TABLE
202: , p5_a11 JTF_NUMBER_TABLE
203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE
207: , p6_a2 out nocopy JTF_NUMBER_TABLE
208: , p6_a3 out nocopy JTF_NUMBER_TABLE
209: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 206: , p6_a1 out nocopy JTF_NUMBER_TABLE

202: , p5_a11 JTF_NUMBER_TABLE
203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE
207: , p6_a2 out nocopy JTF_NUMBER_TABLE
208: , p6_a3 out nocopy JTF_NUMBER_TABLE
209: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , p6_a2 out nocopy JTF_NUMBER_TABLE

203: , p5_a12 JTF_DATE_TABLE
204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE
207: , p6_a2 out nocopy JTF_NUMBER_TABLE
208: , p6_a3 out nocopy JTF_NUMBER_TABLE
209: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300

Line 208: , p6_a3 out nocopy JTF_NUMBER_TABLE

204: , p5_a13 JTF_NUMBER_TABLE
205: , p6_a0 out nocopy JTF_NUMBER_TABLE
206: , p6_a1 out nocopy JTF_NUMBER_TABLE
207: , p6_a2 out nocopy JTF_NUMBER_TABLE
208: , p6_a3 out nocopy JTF_NUMBER_TABLE
209: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
210: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
212: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 214: , p6_a9 out nocopy JTF_NUMBER_TABLE

210: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
212: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a9 out nocopy JTF_NUMBER_TABLE
215: , p6_a10 out nocopy JTF_DATE_TABLE
216: , p6_a11 out nocopy JTF_NUMBER_TABLE
217: , p6_a12 out nocopy JTF_DATE_TABLE
218: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 216: , p6_a11 out nocopy JTF_NUMBER_TABLE

212: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
214: , p6_a9 out nocopy JTF_NUMBER_TABLE
215: , p6_a10 out nocopy JTF_DATE_TABLE
216: , p6_a11 out nocopy JTF_NUMBER_TABLE
217: , p6_a12 out nocopy JTF_DATE_TABLE
218: , p6_a13 out nocopy JTF_NUMBER_TABLE
219: );
220: procedure delete_row(p_api_version NUMBER

Line 218: , p6_a13 out nocopy JTF_NUMBER_TABLE

214: , p6_a9 out nocopy JTF_NUMBER_TABLE
215: , p6_a10 out nocopy JTF_DATE_TABLE
216: , p6_a11 out nocopy JTF_NUMBER_TABLE
217: , p6_a12 out nocopy JTF_DATE_TABLE
218: , p6_a13 out nocopy JTF_NUMBER_TABLE
219: );
220: procedure delete_row(p_api_version NUMBER
221: , p_init_msg_list VARCHAR2
222: , x_return_status out nocopy VARCHAR2

Line 245: , p5_a0 JTF_NUMBER_TABLE

241: , p_init_msg_list VARCHAR2
242: , x_return_status out nocopy VARCHAR2
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_NUMBER_TABLE
248: , p5_a3 JTF_NUMBER_TABLE
249: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 246: , p5_a1 JTF_NUMBER_TABLE

242: , x_return_status out nocopy VARCHAR2
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_NUMBER_TABLE
248: , p5_a3 JTF_NUMBER_TABLE
249: , p5_a4 JTF_VARCHAR2_TABLE_100
250: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 247: , p5_a2 JTF_NUMBER_TABLE

243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_NUMBER_TABLE
248: , p5_a3 JTF_NUMBER_TABLE
249: , p5_a4 JTF_VARCHAR2_TABLE_100
250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_300

Line 248: , p5_a3 JTF_NUMBER_TABLE

244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_NUMBER_TABLE
248: , p5_a3 JTF_NUMBER_TABLE
249: , p5_a4 JTF_VARCHAR2_TABLE_100
250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_300
252: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 254: , p5_a9 JTF_NUMBER_TABLE

250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_300
252: , p5_a7 JTF_VARCHAR2_TABLE_2000
253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_DATE_TABLE
256: , p5_a11 JTF_NUMBER_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_NUMBER_TABLE

Line 256: , p5_a11 JTF_NUMBER_TABLE

252: , p5_a7 JTF_VARCHAR2_TABLE_2000
253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_DATE_TABLE
256: , p5_a11 JTF_NUMBER_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_NUMBER_TABLE
259: );
260: end okl_rcs_pvt_w;

Line 258: , p5_a13 JTF_NUMBER_TABLE

254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_DATE_TABLE
256: , p5_a11 JTF_NUMBER_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_NUMBER_TABLE
259: );
260: end okl_rcs_pvt_w;