APPS.OKL_CGR_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_cgr_pvt_w as
2: /* $Header: OKLICGRS.pls 120.1 2005/07/08 10:19:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_cgr_pvt_w as
2: /* $Header: OKLICGRS.pls 120.1 2005/07/08 10:19:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLICGRS.pls 120.1 2005/07/08 10:19:02 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_cgr_pvt.cgr_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_200
14: , a2 out nocopy JTF_NUMBER_TABLE

Line 12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_200
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_DATE_TABLE

Line 14: , a2 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_200
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_DATE_TABLE

Line 15: , a3 out nocopy JTF_NUMBER_TABLE

11: );
12: procedure rosetta_table_copy_out_p2(t okl_cgr_pvt.cgr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_200
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_DATE_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE

Line 17: , a5 out nocopy JTF_NUMBER_TABLE

13: , a1 out nocopy JTF_VARCHAR2_TABLE_200
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_DATE_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:

Line 19: , a7 out nocopy JTF_NUMBER_TABLE

15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_DATE_TABLE
17: , a5 out nocopy JTF_NUMBER_TABLE
18: , a6 out nocopy JTF_DATE_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 JTF_NUMBER_TABLE

18: , a6 out nocopy JTF_DATE_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );
21:
22: procedure rosetta_table_copy_in_p5(t out nocopy okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_2000

Line 27: , a5 JTF_NUMBER_TABLE

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE

Line 29: , a7 JTF_NUMBER_TABLE

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_2000
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 31: , a9 JTF_NUMBER_TABLE

27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_DATE_TABLE
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_DATE_TABLE
31: , a9 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p5(t okl_cgr_pvt.okl_context_groups_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 38: , a5 out nocopy JTF_NUMBER_TABLE

34: , a1 out nocopy JTF_VARCHAR2_TABLE_100
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_DATE_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE

Line 40: , a7 out nocopy JTF_NUMBER_TABLE

36: , a3 out nocopy JTF_VARCHAR2_TABLE_100
37: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_DATE_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE
43: );
44:

Line 42: , a9 out nocopy JTF_NUMBER_TABLE

38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_DATE_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_DATE_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
46: , a1 JTF_NUMBER_TABLE

Line 45: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE

41: , a8 out nocopy JTF_DATE_TABLE
42: , a9 out nocopy JTF_NUMBER_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
46: , a1 JTF_NUMBER_TABLE
47: , a2 JTF_VARCHAR2_TABLE_100
48: , a3 JTF_VARCHAR2_TABLE_200
49: , a4 JTF_VARCHAR2_TABLE_2000

Line 46: , a1 JTF_NUMBER_TABLE

42: , a9 out nocopy JTF_NUMBER_TABLE
43: );
44:
45: procedure rosetta_table_copy_in_p8(t out nocopy okl_cgr_pvt.cgrv_tbl_type, a0 JTF_NUMBER_TABLE
46: , a1 JTF_NUMBER_TABLE
47: , a2 JTF_VARCHAR2_TABLE_100
48: , a3 JTF_VARCHAR2_TABLE_200
49: , a4 JTF_VARCHAR2_TABLE_2000
50: , a5 JTF_NUMBER_TABLE

Line 50: , a5 JTF_NUMBER_TABLE

46: , a1 JTF_NUMBER_TABLE
47: , a2 JTF_VARCHAR2_TABLE_100
48: , a3 JTF_VARCHAR2_TABLE_200
49: , a4 JTF_VARCHAR2_TABLE_2000
50: , a5 JTF_NUMBER_TABLE
51: , a6 JTF_DATE_TABLE
52: , a7 JTF_NUMBER_TABLE
53: , a8 JTF_DATE_TABLE
54: , a9 JTF_NUMBER_TABLE

Line 52: , a7 JTF_NUMBER_TABLE

48: , a3 JTF_VARCHAR2_TABLE_200
49: , a4 JTF_VARCHAR2_TABLE_2000
50: , a5 JTF_NUMBER_TABLE
51: , a6 JTF_DATE_TABLE
52: , a7 JTF_NUMBER_TABLE
53: , a8 JTF_DATE_TABLE
54: , a9 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 54: , a9 JTF_NUMBER_TABLE

50: , a5 JTF_NUMBER_TABLE
51: , a6 JTF_DATE_TABLE
52: , a7 JTF_NUMBER_TABLE
53: , a8 JTF_DATE_TABLE
54: , a9 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

52: , a7 JTF_NUMBER_TABLE
53: , a8 JTF_DATE_TABLE
54: , a9 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 57: , a1 out nocopy JTF_NUMBER_TABLE

53: , a8 JTF_DATE_TABLE
54: , a9 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p8(t okl_cgr_pvt.cgrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a5 out nocopy JTF_NUMBER_TABLE

Line 61: , a5 out nocopy JTF_NUMBER_TABLE

57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_100
59: , a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_DATE_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE

Line 63: , a7 out nocopy JTF_NUMBER_TABLE

59: , a3 out nocopy JTF_VARCHAR2_TABLE_200
60: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_DATE_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: );
67:

Line 65: , a9 out nocopy JTF_NUMBER_TABLE

61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_DATE_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_DATE_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure insert_row(p_api_version NUMBER
69: , p_init_msg_list 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_VARCHAR2_TABLE_100
102: , p5_a3 JTF_VARCHAR2_TABLE_200
103: , p5_a4 JTF_VARCHAR2_TABLE_2000

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_VARCHAR2_TABLE_100
102: , p5_a3 JTF_VARCHAR2_TABLE_200
103: , p5_a4 JTF_VARCHAR2_TABLE_2000
104: , p5_a5 JTF_NUMBER_TABLE

Line 104: , p5_a5 JTF_NUMBER_TABLE

100: , p5_a1 JTF_NUMBER_TABLE
101: , p5_a2 JTF_VARCHAR2_TABLE_100
102: , p5_a3 JTF_VARCHAR2_TABLE_200
103: , p5_a4 JTF_VARCHAR2_TABLE_2000
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_VARCHAR2_TABLE_200
103: , p5_a4 JTF_VARCHAR2_TABLE_2000
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: , p6_a0 out nocopy JTF_NUMBER_TABLE
110: , p6_a1 out nocopy JTF_NUMBER_TABLE

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: , p6_a0 out nocopy JTF_NUMBER_TABLE
110: , p6_a1 out nocopy JTF_NUMBER_TABLE
111: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 109: , p6_a0 out nocopy 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: , p6_a0 out nocopy JTF_NUMBER_TABLE
110: , p6_a1 out nocopy JTF_NUMBER_TABLE
111: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 110: , p6_a1 out nocopy JTF_NUMBER_TABLE

106: , p5_a7 JTF_NUMBER_TABLE
107: , p5_a8 JTF_DATE_TABLE
108: , p5_a9 JTF_NUMBER_TABLE
109: , p6_a0 out nocopy JTF_NUMBER_TABLE
110: , p6_a1 out nocopy JTF_NUMBER_TABLE
111: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 114: , p6_a5 out nocopy JTF_NUMBER_TABLE

110: , p6_a1 out nocopy JTF_NUMBER_TABLE
111: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , p6_a5 out nocopy JTF_NUMBER_TABLE
115: , p6_a6 out nocopy JTF_DATE_TABLE
116: , p6_a7 out nocopy JTF_NUMBER_TABLE
117: , p6_a8 out nocopy JTF_DATE_TABLE
118: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 116: , p6_a7 out nocopy JTF_NUMBER_TABLE

112: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
113: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
114: , p6_a5 out nocopy JTF_NUMBER_TABLE
115: , p6_a6 out nocopy JTF_DATE_TABLE
116: , p6_a7 out nocopy JTF_NUMBER_TABLE
117: , p6_a8 out nocopy JTF_DATE_TABLE
118: , p6_a9 out nocopy JTF_NUMBER_TABLE
119: );
120: procedure lock_row(p_api_version NUMBER

Line 118: , p6_a9 out nocopy JTF_NUMBER_TABLE

114: , p6_a5 out nocopy JTF_NUMBER_TABLE
115: , p6_a6 out nocopy JTF_DATE_TABLE
116: , p6_a7 out nocopy JTF_NUMBER_TABLE
117: , p6_a8 out nocopy JTF_DATE_TABLE
118: , p6_a9 out nocopy JTF_NUMBER_TABLE
119: );
120: procedure lock_row(p_api_version NUMBER
121: , p_init_msg_list VARCHAR2
122: , 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_VARCHAR2_TABLE_100
144: , p5_a3 JTF_VARCHAR2_TABLE_200
145: , p5_a4 JTF_VARCHAR2_TABLE_2000

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_VARCHAR2_TABLE_100
144: , p5_a3 JTF_VARCHAR2_TABLE_200
145: , p5_a4 JTF_VARCHAR2_TABLE_2000
146: , p5_a5 JTF_NUMBER_TABLE

Line 146: , p5_a5 JTF_NUMBER_TABLE

142: , p5_a1 JTF_NUMBER_TABLE
143: , p5_a2 JTF_VARCHAR2_TABLE_100
144: , p5_a3 JTF_VARCHAR2_TABLE_200
145: , p5_a4 JTF_VARCHAR2_TABLE_2000
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_VARCHAR2_TABLE_200
145: , p5_a4 JTF_VARCHAR2_TABLE_2000
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: );
152: procedure update_row(p_api_version NUMBER

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: );
152: procedure update_row(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2
154: , 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_VARCHAR2_TABLE_100
186: , p5_a3 JTF_VARCHAR2_TABLE_200
187: , p5_a4 JTF_VARCHAR2_TABLE_2000

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_VARCHAR2_TABLE_100
186: , p5_a3 JTF_VARCHAR2_TABLE_200
187: , p5_a4 JTF_VARCHAR2_TABLE_2000
188: , p5_a5 JTF_NUMBER_TABLE

Line 188: , p5_a5 JTF_NUMBER_TABLE

184: , p5_a1 JTF_NUMBER_TABLE
185: , p5_a2 JTF_VARCHAR2_TABLE_100
186: , p5_a3 JTF_VARCHAR2_TABLE_200
187: , p5_a4 JTF_VARCHAR2_TABLE_2000
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_VARCHAR2_TABLE_200
187: , p5_a4 JTF_VARCHAR2_TABLE_2000
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: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE

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: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 193: , p6_a0 out nocopy 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: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 194: , p6_a1 out nocopy JTF_NUMBER_TABLE

190: , p5_a7 JTF_NUMBER_TABLE
191: , p5_a8 JTF_DATE_TABLE
192: , p5_a9 JTF_NUMBER_TABLE
193: , p6_a0 out nocopy JTF_NUMBER_TABLE
194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 198: , p6_a5 out nocopy JTF_NUMBER_TABLE

194: , p6_a1 out nocopy JTF_NUMBER_TABLE
195: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p6_a5 out nocopy JTF_NUMBER_TABLE
199: , p6_a6 out nocopy JTF_DATE_TABLE
200: , p6_a7 out nocopy JTF_NUMBER_TABLE
201: , p6_a8 out nocopy JTF_DATE_TABLE
202: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 200: , p6_a7 out nocopy JTF_NUMBER_TABLE

196: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p6_a5 out nocopy JTF_NUMBER_TABLE
199: , p6_a6 out nocopy JTF_DATE_TABLE
200: , p6_a7 out nocopy JTF_NUMBER_TABLE
201: , p6_a8 out nocopy JTF_DATE_TABLE
202: , p6_a9 out nocopy JTF_NUMBER_TABLE
203: );
204: procedure delete_row(p_api_version NUMBER

Line 202: , p6_a9 out nocopy JTF_NUMBER_TABLE

198: , p6_a5 out nocopy JTF_NUMBER_TABLE
199: , p6_a6 out nocopy JTF_DATE_TABLE
200: , p6_a7 out nocopy JTF_NUMBER_TABLE
201: , p6_a8 out nocopy JTF_DATE_TABLE
202: , p6_a9 out nocopy JTF_NUMBER_TABLE
203: );
204: procedure delete_row(p_api_version NUMBER
205: , p_init_msg_list VARCHAR2
206: , x_return_status out nocopy VARCHAR2

Line 225: , p5_a0 JTF_NUMBER_TABLE

221: , p_init_msg_list VARCHAR2
222: , x_return_status out nocopy VARCHAR2
223: , x_msg_count out nocopy NUMBER
224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_200
229: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 226: , p5_a1 JTF_NUMBER_TABLE

222: , x_return_status out nocopy VARCHAR2
223: , x_msg_count out nocopy NUMBER
224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_200
229: , p5_a4 JTF_VARCHAR2_TABLE_2000
230: , p5_a5 JTF_NUMBER_TABLE

Line 230: , p5_a5 JTF_NUMBER_TABLE

226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_200
229: , p5_a4 JTF_VARCHAR2_TABLE_2000
230: , p5_a5 JTF_NUMBER_TABLE
231: , p5_a6 JTF_DATE_TABLE
232: , p5_a7 JTF_NUMBER_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE

Line 232: , p5_a7 JTF_NUMBER_TABLE

228: , p5_a3 JTF_VARCHAR2_TABLE_200
229: , p5_a4 JTF_VARCHAR2_TABLE_2000
230: , p5_a5 JTF_NUMBER_TABLE
231: , p5_a6 JTF_DATE_TABLE
232: , p5_a7 JTF_NUMBER_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE
235: );
236: procedure validate_row(p_api_version NUMBER

Line 234: , p5_a9 JTF_NUMBER_TABLE

230: , p5_a5 JTF_NUMBER_TABLE
231: , p5_a6 JTF_DATE_TABLE
232: , p5_a7 JTF_NUMBER_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE
235: );
236: procedure validate_row(p_api_version NUMBER
237: , p_init_msg_list VARCHAR2
238: , x_return_status out nocopy VARCHAR2

Line 257: , p5_a0 JTF_NUMBER_TABLE

253: , p_init_msg_list VARCHAR2
254: , x_return_status out nocopy VARCHAR2
255: , x_msg_count out nocopy NUMBER
256: , x_msg_data out nocopy VARCHAR2
257: , p5_a0 JTF_NUMBER_TABLE
258: , p5_a1 JTF_NUMBER_TABLE
259: , p5_a2 JTF_VARCHAR2_TABLE_100
260: , p5_a3 JTF_VARCHAR2_TABLE_200
261: , p5_a4 JTF_VARCHAR2_TABLE_2000

Line 258: , p5_a1 JTF_NUMBER_TABLE

254: , x_return_status out nocopy VARCHAR2
255: , x_msg_count out nocopy NUMBER
256: , x_msg_data out nocopy VARCHAR2
257: , p5_a0 JTF_NUMBER_TABLE
258: , p5_a1 JTF_NUMBER_TABLE
259: , p5_a2 JTF_VARCHAR2_TABLE_100
260: , p5_a3 JTF_VARCHAR2_TABLE_200
261: , p5_a4 JTF_VARCHAR2_TABLE_2000
262: , p5_a5 JTF_NUMBER_TABLE

Line 262: , p5_a5 JTF_NUMBER_TABLE

258: , p5_a1 JTF_NUMBER_TABLE
259: , p5_a2 JTF_VARCHAR2_TABLE_100
260: , p5_a3 JTF_VARCHAR2_TABLE_200
261: , p5_a4 JTF_VARCHAR2_TABLE_2000
262: , p5_a5 JTF_NUMBER_TABLE
263: , p5_a6 JTF_DATE_TABLE
264: , p5_a7 JTF_NUMBER_TABLE
265: , p5_a8 JTF_DATE_TABLE
266: , p5_a9 JTF_NUMBER_TABLE

Line 264: , p5_a7 JTF_NUMBER_TABLE

260: , p5_a3 JTF_VARCHAR2_TABLE_200
261: , p5_a4 JTF_VARCHAR2_TABLE_2000
262: , p5_a5 JTF_NUMBER_TABLE
263: , p5_a6 JTF_DATE_TABLE
264: , p5_a7 JTF_NUMBER_TABLE
265: , p5_a8 JTF_DATE_TABLE
266: , p5_a9 JTF_NUMBER_TABLE
267: );
268: end okl_cgr_pvt_w;

Line 266: , p5_a9 JTF_NUMBER_TABLE

262: , p5_a5 JTF_NUMBER_TABLE
263: , p5_a6 JTF_DATE_TABLE
264: , p5_a7 JTF_NUMBER_TABLE
265: , p5_a8 JTF_DATE_TABLE
266: , p5_a9 JTF_NUMBER_TABLE
267: );
268: end okl_cgr_pvt_w;