APPS.OKL_PCM_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pcm_pvt.pcm_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_pcm_pvt_w as
2: /* $Header: OKLIPCMS.pls 120.0 2007/10/05 10:22:24 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pcm_pvt.pcm_tbl_type, 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_pcm_pvt_w as
2: /* $Header: OKLIPCMS.pls 120.0 2007/10/05 10:22:24 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pcm_pvt.pcm_tbl_type, 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_NUMBER_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_pcm_pvt_w as
2: /* $Header: OKLIPCMS.pls 120.0 2007/10/05 10:22:24 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pcm_pvt.pcm_tbl_type, 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_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLIPCMS.pls 120.0 2007/10/05 10:22:24 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pcm_pvt.pcm_tbl_type, 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_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

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

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pcm_pvt.pcm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 12: , a9 JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pcm_pvt.pcm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE

Line 14: procedure rosetta_table_copy_out_p2(t okl_pcm_pvt.pcm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pcm_pvt.pcm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a1 out nocopy JTF_NUMBER_TABLE

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

Line 16: , a2 out nocopy JTF_NUMBER_TABLE

12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p2(t okl_pcm_pvt.pcm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_VARCHAR2_TABLE_100
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE

Line 17: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 19: , a5 out nocopy JTF_NUMBER_TABLE

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

Line 21: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 23: , a9 out nocopy JTF_NUMBER_TABLE

19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_DATE_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_DATE_TABLE
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure insert_row(p_api_version NUMBER
27: , p_init_msg_list VARCHAR2

Line 57: , p5_a0 JTF_NUMBER_TABLE

53: , p_init_msg_list VARCHAR2
54: , x_return_status out nocopy VARCHAR2
55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 58: , p5_a1 JTF_NUMBER_TABLE

54: , x_return_status out nocopy VARCHAR2
55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE

Line 59: , p5_a2 JTF_NUMBER_TABLE

55: , x_msg_count out nocopy NUMBER
56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE

Line 60: , p5_a3 JTF_NUMBER_TABLE

56: , x_msg_data out nocopy VARCHAR2
57: , p5_a0 JTF_NUMBER_TABLE
58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE

Line 62: , p5_a5 JTF_NUMBER_TABLE

58: , p5_a1 JTF_NUMBER_TABLE
59: , p5_a2 JTF_NUMBER_TABLE
60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE

Line 64: , p5_a7 JTF_NUMBER_TABLE

60: , p5_a3 JTF_NUMBER_TABLE
61: , p5_a4 JTF_VARCHAR2_TABLE_100
62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 66: , p5_a9 JTF_NUMBER_TABLE

62: , p5_a5 JTF_NUMBER_TABLE
63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 67: , p6_a0 out nocopy JTF_NUMBER_TABLE

63: , p5_a6 JTF_DATE_TABLE
64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , p6_a1 out nocopy JTF_NUMBER_TABLE

64: , p5_a7 JTF_NUMBER_TABLE
65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 69: , p6_a2 out nocopy JTF_NUMBER_TABLE

65: , p5_a8 JTF_DATE_TABLE
66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE

Line 70: , p6_a3 out nocopy JTF_NUMBER_TABLE

66: , p5_a9 JTF_NUMBER_TABLE
67: , p6_a0 out nocopy JTF_NUMBER_TABLE
68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 72: , p6_a5 out nocopy JTF_NUMBER_TABLE

68: , p6_a1 out nocopy JTF_NUMBER_TABLE
69: , p6_a2 out nocopy JTF_NUMBER_TABLE
70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 74: , p6_a7 out nocopy JTF_NUMBER_TABLE

70: , p6_a3 out nocopy JTF_NUMBER_TABLE
71: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: );
78: procedure lock_row(p_api_version NUMBER

Line 76: , p6_a9 out nocopy JTF_NUMBER_TABLE

72: , p6_a5 out nocopy JTF_NUMBER_TABLE
73: , p6_a6 out nocopy JTF_DATE_TABLE
74: , p6_a7 out nocopy JTF_NUMBER_TABLE
75: , p6_a8 out nocopy JTF_DATE_TABLE
76: , p6_a9 out nocopy JTF_NUMBER_TABLE
77: );
78: procedure lock_row(p_api_version NUMBER
79: , p_init_msg_list VARCHAR2
80: , x_return_status out nocopy VARCHAR2

Line 99: , p5_a0 JTF_NUMBER_TABLE

95: , p_init_msg_list VARCHAR2
96: , x_return_status out nocopy VARCHAR2
97: , x_msg_count out nocopy NUMBER
98: , x_msg_data out nocopy VARCHAR2
99: , p5_a0 JTF_NUMBER_TABLE
100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_NUMBER_TABLE
102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 100: , p5_a1 JTF_NUMBER_TABLE

96: , x_return_status out nocopy VARCHAR2
97: , x_msg_count out nocopy NUMBER
98: , x_msg_data out nocopy VARCHAR2
99: , p5_a0 JTF_NUMBER_TABLE
100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_NUMBER_TABLE
102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100
104: , p5_a5 JTF_NUMBER_TABLE

Line 101: , p5_a2 JTF_NUMBER_TABLE

97: , x_msg_count out nocopy NUMBER
98: , x_msg_data out nocopy VARCHAR2
99: , p5_a0 JTF_NUMBER_TABLE
100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_NUMBER_TABLE
102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100
104: , p5_a5 JTF_NUMBER_TABLE
105: , p5_a6 JTF_DATE_TABLE

Line 102: , p5_a3 JTF_NUMBER_TABLE

98: , x_msg_data out nocopy VARCHAR2
99: , p5_a0 JTF_NUMBER_TABLE
100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_NUMBER_TABLE
102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100
104: , p5_a5 JTF_NUMBER_TABLE
105: , p5_a6 JTF_DATE_TABLE
106: , p5_a7 JTF_NUMBER_TABLE

Line 104: , p5_a5 JTF_NUMBER_TABLE

100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_NUMBER_TABLE
102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100
104: , p5_a5 JTF_NUMBER_TABLE
105: , p5_a6 JTF_DATE_TABLE
106: , p5_a7 JTF_NUMBER_TABLE
107: , p5_a8 JTF_DATE_TABLE
108: , p5_a9 JTF_NUMBER_TABLE

Line 106: , p5_a7 JTF_NUMBER_TABLE

102: , p5_a3 JTF_NUMBER_TABLE
103: , p5_a4 JTF_VARCHAR2_TABLE_100
104: , p5_a5 JTF_NUMBER_TABLE
105: , p5_a6 JTF_DATE_TABLE
106: , p5_a7 JTF_NUMBER_TABLE
107: , p5_a8 JTF_DATE_TABLE
108: , p5_a9 JTF_NUMBER_TABLE
109: );
110: procedure update_row(p_api_version NUMBER

Line 108: , p5_a9 JTF_NUMBER_TABLE

104: , p5_a5 JTF_NUMBER_TABLE
105: , p5_a6 JTF_DATE_TABLE
106: , p5_a7 JTF_NUMBER_TABLE
107: , p5_a8 JTF_DATE_TABLE
108: , p5_a9 JTF_NUMBER_TABLE
109: );
110: procedure update_row(p_api_version NUMBER
111: , p_init_msg_list VARCHAR2
112: , x_return_status out nocopy VARCHAR2

Line 141: , p5_a0 JTF_NUMBER_TABLE

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

Line 142: , p5_a1 JTF_NUMBER_TABLE

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

Line 143: , p5_a2 JTF_NUMBER_TABLE

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

Line 144: , p5_a3 JTF_NUMBER_TABLE

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

Line 146: , p5_a5 JTF_NUMBER_TABLE

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

Line 148: , p5_a7 JTF_NUMBER_TABLE

144: , p5_a3 JTF_NUMBER_TABLE
145: , p5_a4 JTF_VARCHAR2_TABLE_100
146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_DATE_TABLE
148: , p5_a7 JTF_NUMBER_TABLE
149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 150: , p5_a9 JTF_NUMBER_TABLE

146: , p5_a5 JTF_NUMBER_TABLE
147: , p5_a6 JTF_DATE_TABLE
148: , p5_a7 JTF_NUMBER_TABLE
149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 151: , p6_a0 out nocopy JTF_NUMBER_TABLE

147: , p5_a6 JTF_DATE_TABLE
148: , p5_a7 JTF_NUMBER_TABLE
149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 152: , p6_a1 out nocopy JTF_NUMBER_TABLE

148: , p5_a7 JTF_NUMBER_TABLE
149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
156: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 153: , p6_a2 out nocopy JTF_NUMBER_TABLE

149: , p5_a8 JTF_DATE_TABLE
150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
156: , p6_a5 out nocopy JTF_NUMBER_TABLE
157: , p6_a6 out nocopy JTF_DATE_TABLE

Line 154: , p6_a3 out nocopy JTF_NUMBER_TABLE

150: , p5_a9 JTF_NUMBER_TABLE
151: , p6_a0 out nocopy JTF_NUMBER_TABLE
152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
156: , p6_a5 out nocopy JTF_NUMBER_TABLE
157: , p6_a6 out nocopy JTF_DATE_TABLE
158: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 156: , p6_a5 out nocopy JTF_NUMBER_TABLE

152: , p6_a1 out nocopy JTF_NUMBER_TABLE
153: , p6_a2 out nocopy JTF_NUMBER_TABLE
154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
156: , p6_a5 out nocopy JTF_NUMBER_TABLE
157: , p6_a6 out nocopy JTF_DATE_TABLE
158: , p6_a7 out nocopy JTF_NUMBER_TABLE
159: , p6_a8 out nocopy JTF_DATE_TABLE
160: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 158: , p6_a7 out nocopy JTF_NUMBER_TABLE

154: , p6_a3 out nocopy JTF_NUMBER_TABLE
155: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
156: , p6_a5 out nocopy JTF_NUMBER_TABLE
157: , p6_a6 out nocopy JTF_DATE_TABLE
158: , p6_a7 out nocopy JTF_NUMBER_TABLE
159: , p6_a8 out nocopy JTF_DATE_TABLE
160: , p6_a9 out nocopy JTF_NUMBER_TABLE
161: );
162: procedure delete_row(p_api_version NUMBER

Line 160: , p6_a9 out nocopy JTF_NUMBER_TABLE

156: , p6_a5 out nocopy JTF_NUMBER_TABLE
157: , p6_a6 out nocopy JTF_DATE_TABLE
158: , p6_a7 out nocopy JTF_NUMBER_TABLE
159: , p6_a8 out nocopy JTF_DATE_TABLE
160: , p6_a9 out nocopy JTF_NUMBER_TABLE
161: );
162: procedure delete_row(p_api_version NUMBER
163: , p_init_msg_list VARCHAR2
164: , x_return_status out nocopy VARCHAR2

Line 183: , p5_a0 JTF_NUMBER_TABLE

179: , p_init_msg_list VARCHAR2
180: , x_return_status out nocopy VARCHAR2
181: , x_msg_count out nocopy NUMBER
182: , x_msg_data out nocopy VARCHAR2
183: , p5_a0 JTF_NUMBER_TABLE
184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_NUMBER_TABLE
186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 184: , p5_a1 JTF_NUMBER_TABLE

180: , x_return_status out nocopy VARCHAR2
181: , x_msg_count out nocopy NUMBER
182: , x_msg_data out nocopy VARCHAR2
183: , p5_a0 JTF_NUMBER_TABLE
184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_NUMBER_TABLE
186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100
188: , p5_a5 JTF_NUMBER_TABLE

Line 185: , p5_a2 JTF_NUMBER_TABLE

181: , x_msg_count out nocopy NUMBER
182: , x_msg_data out nocopy VARCHAR2
183: , p5_a0 JTF_NUMBER_TABLE
184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_NUMBER_TABLE
186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100
188: , p5_a5 JTF_NUMBER_TABLE
189: , p5_a6 JTF_DATE_TABLE

Line 186: , p5_a3 JTF_NUMBER_TABLE

182: , x_msg_data out nocopy VARCHAR2
183: , p5_a0 JTF_NUMBER_TABLE
184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_NUMBER_TABLE
186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100
188: , p5_a5 JTF_NUMBER_TABLE
189: , p5_a6 JTF_DATE_TABLE
190: , p5_a7 JTF_NUMBER_TABLE

Line 188: , p5_a5 JTF_NUMBER_TABLE

184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_NUMBER_TABLE
186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100
188: , p5_a5 JTF_NUMBER_TABLE
189: , p5_a6 JTF_DATE_TABLE
190: , p5_a7 JTF_NUMBER_TABLE
191: , p5_a8 JTF_DATE_TABLE
192: , p5_a9 JTF_NUMBER_TABLE

Line 190: , p5_a7 JTF_NUMBER_TABLE

186: , p5_a3 JTF_NUMBER_TABLE
187: , p5_a4 JTF_VARCHAR2_TABLE_100
188: , p5_a5 JTF_NUMBER_TABLE
189: , p5_a6 JTF_DATE_TABLE
190: , p5_a7 JTF_NUMBER_TABLE
191: , p5_a8 JTF_DATE_TABLE
192: , p5_a9 JTF_NUMBER_TABLE
193: );
194: procedure validate_row(p_api_version NUMBER

Line 192: , p5_a9 JTF_NUMBER_TABLE

188: , p5_a5 JTF_NUMBER_TABLE
189: , p5_a6 JTF_DATE_TABLE
190: , p5_a7 JTF_NUMBER_TABLE
191: , p5_a8 JTF_DATE_TABLE
192: , p5_a9 JTF_NUMBER_TABLE
193: );
194: procedure validate_row(p_api_version NUMBER
195: , p_init_msg_list VARCHAR2
196: , x_return_status out nocopy VARCHAR2

Line 215: , p5_a0 JTF_NUMBER_TABLE

211: , p_init_msg_list VARCHAR2
212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 216: , p5_a1 JTF_NUMBER_TABLE

212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_100
220: , p5_a5 JTF_NUMBER_TABLE

Line 217: , p5_a2 JTF_NUMBER_TABLE

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

Line 218: , p5_a3 JTF_NUMBER_TABLE

214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_100
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE

Line 220: , p5_a5 JTF_NUMBER_TABLE

216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_100
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_DATE_TABLE
224: , p5_a9 JTF_NUMBER_TABLE

Line 222: , p5_a7 JTF_NUMBER_TABLE

218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_VARCHAR2_TABLE_100
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_DATE_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: );
226: end okl_pcm_pvt_w;

Line 224: , p5_a9 JTF_NUMBER_TABLE

220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_DATE_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: );
226: end okl_pcm_pvt_w;