DBA Data[Home] [Help]

APPS.OKL_IRV_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE

1: package okl_irv_pvt_w as
2: /* $Header: OKLIIRVS.pls 120.2 2005/07/22 10:04:35 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_irv_pvt_w as
2: /* $Header: OKLIIRVS.pls 120.2 2005/07/22 10:04:35 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_irv_pvt_w as
2: /* $Header: OKLIIRVS.pls 120.2 2005/07/22 10:04:35 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIIRVS.pls 120.2 2005/07/22 10:04:35 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 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

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 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

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_p1(t okl_irv_pvt.okl_irv_tbl, 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_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE

Line 15: procedure rosetta_table_copy_out_p1(t okl_irv_pvt.okl_irv_tbl, 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_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_NUMBER_TABLE

Line 16: , a1 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_NUMBER_TABLE
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 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_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 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

Line 18: , a3 out nocopy JTF_NUMBER_TABLE

14: );
15: procedure rosetta_table_copy_out_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 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

Line 19: , a4 out nocopy JTF_NUMBER_TABLE

15: procedure rosetta_table_copy_out_p1(t okl_irv_pvt.okl_irv_tbl, a0 out nocopy JTF_NUMBER_TABLE
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 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

Line 20: , a5 out nocopy JTF_NUMBER_TABLE

16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 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

Line 21: , a6 out nocopy JTF_NUMBER_TABLE

17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 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

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 insert_row(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2

Line 61: , p5_a0 JTF_NUMBER_TABLE

57: , p_init_msg_list VARCHAR2
58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE

Line 62: , p5_a1 JTF_NUMBER_TABLE

58: , x_return_status out nocopy VARCHAR2
59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE

Line 63: , p5_a2 JTF_NUMBER_TABLE

59: , x_msg_count out nocopy NUMBER
60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE

Line 64: , p5_a3 JTF_NUMBER_TABLE

60: , x_msg_data out nocopy VARCHAR2
61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE

Line 65: , p5_a4 JTF_NUMBER_TABLE

61: , p5_a0 JTF_NUMBER_TABLE
62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE

Line 66: , p5_a5 JTF_NUMBER_TABLE

62: , p5_a1 JTF_NUMBER_TABLE
63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE

Line 67: , p5_a6 JTF_NUMBER_TABLE

63: , p5_a2 JTF_NUMBER_TABLE
64: , p5_a3 JTF_NUMBER_TABLE
65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE

Line 69: , p5_a8 JTF_NUMBER_TABLE

65: , p5_a4 JTF_NUMBER_TABLE
66: , p5_a5 JTF_NUMBER_TABLE
67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 71: , p5_a10 JTF_NUMBER_TABLE

67: , p5_a6 JTF_NUMBER_TABLE
68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 72: , p6_a0 out nocopy JTF_NUMBER_TABLE

68: , p5_a7 JTF_DATE_TABLE
69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 73: , p6_a1 out nocopy JTF_NUMBER_TABLE

69: , p5_a8 JTF_NUMBER_TABLE
70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 74: , p6_a2 out nocopy JTF_NUMBER_TABLE

70: , p5_a9 JTF_DATE_TABLE
71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 75: , p6_a3 out nocopy JTF_NUMBER_TABLE

71: , p5_a10 JTF_NUMBER_TABLE
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE

Line 76: , p6_a4 out nocopy JTF_NUMBER_TABLE

72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 77: , p6_a5 out nocopy JTF_NUMBER_TABLE

73: , p6_a1 out nocopy JTF_NUMBER_TABLE
74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE

Line 78: , p6_a6 out nocopy JTF_NUMBER_TABLE

74: , p6_a2 out nocopy JTF_NUMBER_TABLE
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a8 out nocopy JTF_NUMBER_TABLE

76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_NUMBER_TABLE
78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE
83: );
84: procedure update_row(p_api_version NUMBER

Line 82: , p6_a10 out nocopy JTF_NUMBER_TABLE

78: , p6_a6 out nocopy JTF_NUMBER_TABLE
79: , p6_a7 out nocopy JTF_DATE_TABLE
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_DATE_TABLE
82: , p6_a10 out nocopy JTF_NUMBER_TABLE
83: );
84: procedure update_row(p_api_version NUMBER
85: , p_init_msg_list VARCHAR2
86: , x_return_status out nocopy VARCHAR2

Line 117: , p5_a0 JTF_NUMBER_TABLE

113: , p_init_msg_list VARCHAR2
114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE

Line 118: , p5_a1 JTF_NUMBER_TABLE

114: , x_return_status out nocopy VARCHAR2
115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE

Line 119: , p5_a2 JTF_NUMBER_TABLE

115: , x_msg_count out nocopy NUMBER
116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE

Line 120: , p5_a3 JTF_NUMBER_TABLE

116: , x_msg_data out nocopy VARCHAR2
117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE

Line 121: , p5_a4 JTF_NUMBER_TABLE

117: , p5_a0 JTF_NUMBER_TABLE
118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE

Line 122: , p5_a5 JTF_NUMBER_TABLE

118: , p5_a1 JTF_NUMBER_TABLE
119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE

Line 123: , p5_a6 JTF_NUMBER_TABLE

119: , p5_a2 JTF_NUMBER_TABLE
120: , p5_a3 JTF_NUMBER_TABLE
121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE

Line 125: , p5_a8 JTF_NUMBER_TABLE

121: , p5_a4 JTF_NUMBER_TABLE
122: , p5_a5 JTF_NUMBER_TABLE
123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 127: , p5_a10 JTF_NUMBER_TABLE

123: , p5_a6 JTF_NUMBER_TABLE
124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 128: , p6_a0 out nocopy JTF_NUMBER_TABLE

124: , p5_a7 JTF_DATE_TABLE
125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 129: , p6_a1 out nocopy JTF_NUMBER_TABLE

125: , p5_a8 JTF_NUMBER_TABLE
126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 130: , p6_a2 out nocopy JTF_NUMBER_TABLE

126: , p5_a9 JTF_DATE_TABLE
127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 131: , p6_a3 out nocopy JTF_NUMBER_TABLE

127: , p5_a10 JTF_NUMBER_TABLE
128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE

Line 132: , p6_a4 out nocopy JTF_NUMBER_TABLE

128: , p6_a0 out nocopy JTF_NUMBER_TABLE
129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 133: , p6_a5 out nocopy JTF_NUMBER_TABLE

129: , p6_a1 out nocopy JTF_NUMBER_TABLE
130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE

Line 134: , p6_a6 out nocopy JTF_NUMBER_TABLE

130: , p6_a2 out nocopy JTF_NUMBER_TABLE
131: , p6_a3 out nocopy JTF_NUMBER_TABLE
132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE

Line 136: , p6_a8 out nocopy JTF_NUMBER_TABLE

132: , p6_a4 out nocopy JTF_NUMBER_TABLE
133: , p6_a5 out nocopy JTF_NUMBER_TABLE
134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure delete_row(p_api_version NUMBER

Line 138: , p6_a10 out nocopy JTF_NUMBER_TABLE

134: , p6_a6 out nocopy JTF_NUMBER_TABLE
135: , p6_a7 out nocopy JTF_DATE_TABLE
136: , p6_a8 out nocopy JTF_NUMBER_TABLE
137: , p6_a9 out nocopy JTF_DATE_TABLE
138: , p6_a10 out nocopy JTF_NUMBER_TABLE
139: );
140: procedure delete_row(p_api_version NUMBER
141: , p_init_msg_list VARCHAR2
142: , x_return_status out nocopy VARCHAR2

Line 162: , p5_a0 JTF_NUMBER_TABLE

158: , p_init_msg_list VARCHAR2
159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE

Line 163: , p5_a1 JTF_NUMBER_TABLE

159: , x_return_status out nocopy VARCHAR2
160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE

Line 164: , p5_a2 JTF_NUMBER_TABLE

160: , x_msg_count out nocopy NUMBER
161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE

Line 165: , p5_a3 JTF_NUMBER_TABLE

161: , x_msg_data out nocopy VARCHAR2
162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE

Line 166: , p5_a4 JTF_NUMBER_TABLE

162: , p5_a0 JTF_NUMBER_TABLE
163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE

Line 167: , p5_a5 JTF_NUMBER_TABLE

163: , p5_a1 JTF_NUMBER_TABLE
164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE

Line 168: , p5_a6 JTF_NUMBER_TABLE

164: , p5_a2 JTF_NUMBER_TABLE
165: , p5_a3 JTF_NUMBER_TABLE
166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE

Line 170: , p5_a8 JTF_NUMBER_TABLE

166: , p5_a4 JTF_NUMBER_TABLE
167: , p5_a5 JTF_NUMBER_TABLE
168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE
173: );
174: end okl_irv_pvt_w;

Line 172: , p5_a10 JTF_NUMBER_TABLE

168: , p5_a6 JTF_NUMBER_TABLE
169: , p5_a7 JTF_DATE_TABLE
170: , p5_a8 JTF_NUMBER_TABLE
171: , p5_a9 JTF_DATE_TABLE
172: , p5_a10 JTF_NUMBER_TABLE
173: );
174: end okl_irv_pvt_w;