DBA Data[Home] [Help]

APPS.OKL_EC_UPTAKE_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 22: , a3 JTF_VARCHAR2_TABLE_200

18:
19: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_200
23: , a4 JTF_VARCHAR2_TABLE_2000
24: , a5 JTF_DATE_TABLE
25: , a6 JTF_DATE_TABLE
26: , a7 JTF_NUMBER_TABLE

Line 23: , a4 JTF_VARCHAR2_TABLE_2000

19: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_200
23: , a4 JTF_VARCHAR2_TABLE_2000
24: , a5 JTF_DATE_TABLE
25: , a6 JTF_DATE_TABLE
26: , a7 JTF_NUMBER_TABLE
27: , a8 JTF_VARCHAR2_TABLE_100

Line 34: , a3 out nocopy JTF_VARCHAR2_TABLE_200

30: );
31: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
36: , a5 out nocopy JTF_DATE_TABLE
37: , a6 out nocopy JTF_DATE_TABLE
38: , a7 out nocopy JTF_NUMBER_TABLE

Line 35: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

31: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
36: , a5 out nocopy JTF_DATE_TABLE
37: , a6 out nocopy JTF_DATE_TABLE
38: , a7 out nocopy JTF_NUMBER_TABLE
39: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a4 JTF_VARCHAR2_TABLE_2000

44: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_VARCHAR2_TABLE_300
48: , a4 JTF_VARCHAR2_TABLE_2000
49: , a5 JTF_VARCHAR2_TABLE_100
50: , a6 JTF_DATE_TABLE
51: , a7 JTF_DATE_TABLE
52: , a8 JTF_NUMBER_TABLE

Line 61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

57: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_VARCHAR2_TABLE_300
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , a5 out nocopy JTF_VARCHAR2_TABLE_100
63: , a6 out nocopy JTF_DATE_TABLE
64: , a7 out nocopy JTF_DATE_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE

Line 72: , a1 JTF_VARCHAR2_TABLE_200

68: , a11 out nocopy JTF_VARCHAR2_TABLE_300
69: );
70:
71: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_VARCHAR2_TABLE_200
73: , a2 JTF_VARCHAR2_TABLE_200
74: , a3 JTF_NUMBER_TABLE
75: , a4 JTF_VARCHAR2_TABLE_2000
76: , a5 JTF_VARCHAR2_TABLE_100

Line 73: , a2 JTF_VARCHAR2_TABLE_200

69: );
70:
71: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_VARCHAR2_TABLE_200
73: , a2 JTF_VARCHAR2_TABLE_200
74: , a3 JTF_NUMBER_TABLE
75: , a4 JTF_VARCHAR2_TABLE_2000
76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_VARCHAR2_TABLE_200

Line 75: , a4 JTF_VARCHAR2_TABLE_2000

71: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_VARCHAR2_TABLE_200
73: , a2 JTF_VARCHAR2_TABLE_200
74: , a3 JTF_NUMBER_TABLE
75: , a4 JTF_VARCHAR2_TABLE_2000
76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_VARCHAR2_TABLE_200
78: , a7 JTF_VARCHAR2_TABLE_4000
79: );

Line 77: , a6 JTF_VARCHAR2_TABLE_200

73: , a2 JTF_VARCHAR2_TABLE_200
74: , a3 JTF_NUMBER_TABLE
75: , a4 JTF_VARCHAR2_TABLE_2000
76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_VARCHAR2_TABLE_200
78: , a7 JTF_VARCHAR2_TABLE_4000
79: );
80: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 81: , a1 out nocopy JTF_VARCHAR2_TABLE_200

77: , a6 JTF_VARCHAR2_TABLE_200
78: , a7 JTF_VARCHAR2_TABLE_4000
79: );
80: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 82: , a2 out nocopy JTF_VARCHAR2_TABLE_200

78: , a7 JTF_VARCHAR2_TABLE_4000
79: );
80: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

80: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_200
87: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
88: );

Line 86: , a6 out nocopy JTF_VARCHAR2_TABLE_200

82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
85: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a6 out nocopy JTF_VARCHAR2_TABLE_200
87: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
88: );
89:
90: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE

Line 91: , a1 JTF_VARCHAR2_TABLE_200

87: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
88: );
89:
90: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
91: , a1 JTF_VARCHAR2_TABLE_200
92: , a2 JTF_DATE_TABLE
93: , a3 JTF_DATE_TABLE
94: );
95: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 96: , a1 out nocopy JTF_VARCHAR2_TABLE_200

92: , a2 JTF_DATE_TABLE
93: , a3 JTF_DATE_TABLE
94: );
95: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_200
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_DATE_TABLE
99: );
100:

Line 108: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200

104: , p_target_type VARCHAR2
105: , p4_a0 out nocopy JTF_NUMBER_TABLE
106: , p4_a1 out nocopy JTF_NUMBER_TABLE
107: , p4_a2 out nocopy JTF_NUMBER_TABLE
108: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
109: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
110: , p4_a5 out nocopy JTF_DATE_TABLE
111: , p4_a6 out nocopy JTF_DATE_TABLE
112: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 109: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

105: , p4_a0 out nocopy JTF_NUMBER_TABLE
106: , p4_a1 out nocopy JTF_NUMBER_TABLE
107: , p4_a2 out nocopy JTF_NUMBER_TABLE
108: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_200
109: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
110: , p4_a5 out nocopy JTF_DATE_TABLE
111: , p4_a6 out nocopy JTF_DATE_TABLE
112: , p4_a7 out nocopy JTF_NUMBER_TABLE
113: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

124: , p4_a0 out nocopy JTF_NUMBER_TABLE
125: , p4_a1 out nocopy JTF_NUMBER_TABLE
126: , p4_a2 out nocopy JTF_NUMBER_TABLE
127: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_300
128: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
129: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
130: , p4_a6 out nocopy JTF_DATE_TABLE
131: , p4_a7 out nocopy JTF_DATE_TABLE
132: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 158: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200

154: , p_item_categories_table JTF_NUMBER_TABLE
155: , p15_a0 out nocopy JTF_NUMBER_TABLE
156: , p15_a1 out nocopy JTF_NUMBER_TABLE
157: , p15_a2 out nocopy JTF_NUMBER_TABLE
158: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
159: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
160: , p15_a5 out nocopy JTF_DATE_TABLE
161: , p15_a6 out nocopy JTF_DATE_TABLE
162: , p15_a7 out nocopy JTF_NUMBER_TABLE

Line 159: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000

155: , p15_a0 out nocopy JTF_NUMBER_TABLE
156: , p15_a1 out nocopy JTF_NUMBER_TABLE
157: , p15_a2 out nocopy JTF_NUMBER_TABLE
158: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_200
159: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
160: , p15_a5 out nocopy JTF_DATE_TABLE
161: , p15_a6 out nocopy JTF_DATE_TABLE
162: , p15_a7 out nocopy JTF_NUMBER_TABLE
163: , p15_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000

185: , p15_a0 out nocopy JTF_NUMBER_TABLE
186: , p15_a1 out nocopy JTF_NUMBER_TABLE
187: , p15_a2 out nocopy JTF_NUMBER_TABLE
188: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_300
189: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_2000
190: , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
191: , p15_a6 out nocopy JTF_DATE_TABLE
192: , p15_a7 out nocopy JTF_DATE_TABLE
193: , p15_a8 out nocopy JTF_NUMBER_TABLE

Line 206: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200

202: , p_init_msg_list VARCHAR2
203: , p_target_id NUMBER
204: , p_target_type VARCHAR2
205: , p4_a0 out nocopy JTF_NUMBER_TABLE
206: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
207: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
208: , p4_a3 out nocopy JTF_NUMBER_TABLE
209: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
210: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 207: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200

203: , p_target_id NUMBER
204: , p_target_type VARCHAR2
205: , p4_a0 out nocopy JTF_NUMBER_TABLE
206: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
207: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
208: , p4_a3 out nocopy JTF_NUMBER_TABLE
209: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
210: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 209: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000

205: , p4_a0 out nocopy JTF_NUMBER_TABLE
206: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_200
207: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
208: , p4_a3 out nocopy JTF_NUMBER_TABLE
209: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
210: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200
212: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_4000
213: , x_return_status out nocopy VARCHAR2

Line 211: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200

207: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_200
208: , p4_a3 out nocopy JTF_NUMBER_TABLE
209: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_2000
210: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
211: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_200
212: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_4000
213: , x_return_status out nocopy VARCHAR2
214: , x_msg_count out nocopy NUMBER
215: , x_msg_data out nocopy VARCHAR2

Line 232: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200

228: , p_trade_in_value NUMBER
229: , p_item_table JTF_NUMBER_TABLE
230: , p_item_categories_table JTF_NUMBER_TABLE
231: , p14_a0 out nocopy JTF_NUMBER_TABLE
232: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_200
233: , p14_a2 out nocopy JTF_DATE_TABLE
234: , p14_a3 out nocopy JTF_DATE_TABLE
235: , x_return_status out nocopy VARCHAR2
236: , x_msg_count out nocopy NUMBER