1: package okl_cgm_pvt_w as
2: /* $Header: OKLICGMS.pls 120.1 2005/07/08 10:18:48 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgm_pvt.cgm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_cgm_pvt_w as
2: /* $Header: OKLICGMS.pls 120.1 2005/07/08 10:18:48 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgm_pvt.cgm_tbl_type, 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_DATE_TABLE
1: package okl_cgm_pvt_w as
2: /* $Header: OKLICGMS.pls 120.1 2005/07/08 10:18:48 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgm_pvt.cgm_tbl_type, 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_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLICGMS.pls 120.1 2005/07/08 10:18:48 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgm_pvt.cgm_tbl_type, 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_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgm_pvt.cgm_tbl_type, 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_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
12: );
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
13: procedure rosetta_table_copy_out_p2(t okl_cgm_pvt.cgm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_DATE_TABLE
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_NUMBER_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
22: );
23:
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
30: , a6 JTF_NUMBER_TABLE
23:
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
24: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgm_pvt.cgmv_tbl_type, a0 JTF_NUMBER_TABLE
25: , a1 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
26: , a2 JTF_NUMBER_TABLE
27: , a3 JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28: , a4 JTF_NUMBER_TABLE
29: , a5 JTF_DATE_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
30: , a6 JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
31: , a7 JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
32: , a8 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_DATE_TABLE
34: procedure rosetta_table_copy_out_p5(t okl_cgm_pvt.cgmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_NUMBER_TABLE
43: );
44:
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_DATE_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_DATE_TABLE
42: , a8 out nocopy JTF_NUMBER_TABLE
43: );
44:
45: procedure insert_row(p_api_version NUMBER
46: , p_init_msg_list VARCHAR2
70: , p_init_msg_list VARCHAR2
71: , x_return_status out nocopy VARCHAR2
72: , x_msg_count out nocopy NUMBER
73: , x_msg_data out nocopy VARCHAR2
74: , p5_a0 JTF_NUMBER_TABLE
75: , p5_a1 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
71: , x_return_status out nocopy VARCHAR2
72: , x_msg_count out nocopy NUMBER
73: , x_msg_data out nocopy VARCHAR2
74: , p5_a0 JTF_NUMBER_TABLE
75: , p5_a1 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
72: , x_msg_count out nocopy NUMBER
73: , x_msg_data out nocopy VARCHAR2
74: , p5_a0 JTF_NUMBER_TABLE
75: , p5_a1 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
73: , x_msg_data out nocopy VARCHAR2
74: , p5_a0 JTF_NUMBER_TABLE
75: , p5_a1 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
74: , p5_a0 JTF_NUMBER_TABLE
75: , p5_a1 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
76: , p5_a2 JTF_NUMBER_TABLE
77: , p5_a3 JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
78: , p5_a4 JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
79: , p5_a5 JTF_DATE_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
80: , p5_a6 JTF_NUMBER_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
81: , p5_a7 JTF_DATE_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
89: , p6_a6 out nocopy JTF_NUMBER_TABLE
82: , p5_a8 JTF_NUMBER_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
89: , p6_a6 out nocopy JTF_NUMBER_TABLE
90: , p6_a7 out nocopy JTF_DATE_TABLE
83: , p6_a0 out nocopy JTF_NUMBER_TABLE
84: , p6_a1 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
89: , p6_a6 out nocopy JTF_NUMBER_TABLE
90: , p6_a7 out nocopy JTF_DATE_TABLE
91: , p6_a8 out nocopy JTF_NUMBER_TABLE
85: , p6_a2 out nocopy JTF_NUMBER_TABLE
86: , p6_a3 out nocopy JTF_NUMBER_TABLE
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
89: , p6_a6 out nocopy JTF_NUMBER_TABLE
90: , p6_a7 out nocopy JTF_DATE_TABLE
91: , p6_a8 out nocopy JTF_NUMBER_TABLE
92: );
93: procedure lock_row(p_api_version NUMBER
87: , p6_a4 out nocopy JTF_NUMBER_TABLE
88: , p6_a5 out nocopy JTF_DATE_TABLE
89: , p6_a6 out nocopy JTF_NUMBER_TABLE
90: , p6_a7 out nocopy JTF_DATE_TABLE
91: , p6_a8 out nocopy JTF_NUMBER_TABLE
92: );
93: procedure lock_row(p_api_version NUMBER
94: , p_init_msg_list VARCHAR2
95: , x_return_status out nocopy VARCHAR2
109: , p_init_msg_list VARCHAR2
110: , x_return_status out nocopy VARCHAR2
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
110: , x_return_status out nocopy VARCHAR2
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
111: , x_msg_count out nocopy NUMBER
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
112: , x_msg_data out nocopy VARCHAR2
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
113: , p5_a0 JTF_NUMBER_TABLE
114: , p5_a1 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_NUMBER_TABLE
115: , p5_a2 JTF_NUMBER_TABLE
116: , p5_a3 JTF_NUMBER_TABLE
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_NUMBER_TABLE
122: );
123: procedure update_row(p_api_version NUMBER
117: , p5_a4 JTF_NUMBER_TABLE
118: , p5_a5 JTF_DATE_TABLE
119: , p5_a6 JTF_NUMBER_TABLE
120: , p5_a7 JTF_DATE_TABLE
121: , p5_a8 JTF_NUMBER_TABLE
122: );
123: procedure update_row(p_api_version NUMBER
124: , p_init_msg_list VARCHAR2
125: , x_return_status out nocopy VARCHAR2
148: , p_init_msg_list VARCHAR2
149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
156: , p5_a4 JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
157: , p5_a5 JTF_DATE_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
159: , p5_a7 JTF_DATE_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
167: , p6_a6 out nocopy JTF_NUMBER_TABLE
160: , p5_a8 JTF_NUMBER_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
167: , p6_a6 out nocopy JTF_NUMBER_TABLE
168: , p6_a7 out nocopy JTF_DATE_TABLE
161: , p6_a0 out nocopy JTF_NUMBER_TABLE
162: , p6_a1 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
167: , p6_a6 out nocopy JTF_NUMBER_TABLE
168: , p6_a7 out nocopy JTF_DATE_TABLE
169: , p6_a8 out nocopy JTF_NUMBER_TABLE
163: , p6_a2 out nocopy JTF_NUMBER_TABLE
164: , p6_a3 out nocopy JTF_NUMBER_TABLE
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
167: , p6_a6 out nocopy JTF_NUMBER_TABLE
168: , p6_a7 out nocopy JTF_DATE_TABLE
169: , p6_a8 out nocopy JTF_NUMBER_TABLE
170: );
171: procedure delete_row(p_api_version NUMBER
165: , p6_a4 out nocopy JTF_NUMBER_TABLE
166: , p6_a5 out nocopy JTF_DATE_TABLE
167: , p6_a6 out nocopy JTF_NUMBER_TABLE
168: , p6_a7 out nocopy JTF_DATE_TABLE
169: , p6_a8 out nocopy JTF_NUMBER_TABLE
170: );
171: procedure delete_row(p_api_version NUMBER
172: , p_init_msg_list VARCHAR2
173: , x_return_status out nocopy VARCHAR2
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_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_NUMBER_TABLE
196: , p5_a5 JTF_DATE_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_NUMBER_TABLE
196: , p5_a5 JTF_DATE_TABLE
197: , p5_a6 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_NUMBER_TABLE
196: , p5_a5 JTF_DATE_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_DATE_TABLE
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_NUMBER_TABLE
196: , p5_a5 JTF_DATE_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_DATE_TABLE
199: , p5_a8 JTF_NUMBER_TABLE
193: , p5_a2 JTF_NUMBER_TABLE
194: , p5_a3 JTF_NUMBER_TABLE
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_DATE_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_DATE_TABLE
199: , p5_a8 JTF_NUMBER_TABLE
200: );
201: procedure validate_row(p_api_version NUMBER
195: , p5_a4 JTF_NUMBER_TABLE
196: , p5_a5 JTF_DATE_TABLE
197: , p5_a6 JTF_NUMBER_TABLE
198: , p5_a7 JTF_DATE_TABLE
199: , p5_a8 JTF_NUMBER_TABLE
200: );
201: procedure validate_row(p_api_version NUMBER
202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
217: , p_init_msg_list VARCHAR2
218: , x_return_status out nocopy VARCHAR2
219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
218: , x_return_status out nocopy VARCHAR2
219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
219: , x_msg_count out nocopy NUMBER
220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
220: , x_msg_data out nocopy VARCHAR2
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
228: , p5_a7 JTF_DATE_TABLE
221: , p5_a0 JTF_NUMBER_TABLE
222: , p5_a1 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
228: , p5_a7 JTF_DATE_TABLE
229: , p5_a8 JTF_NUMBER_TABLE
223: , p5_a2 JTF_NUMBER_TABLE
224: , p5_a3 JTF_NUMBER_TABLE
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
228: , p5_a7 JTF_DATE_TABLE
229: , p5_a8 JTF_NUMBER_TABLE
230: );
231: end okl_cgm_pvt_w;
225: , p5_a4 JTF_NUMBER_TABLE
226: , p5_a5 JTF_DATE_TABLE
227: , p5_a6 JTF_NUMBER_TABLE
228: , p5_a7 JTF_DATE_TABLE
229: , p5_a8 JTF_NUMBER_TABLE
230: );
231: end okl_cgm_pvt_w;