DBA Data[Home] [Help]

APPS.OKL_AM_RECYCLE_TRMNT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200

Line 24: , a2 JTF_VARCHAR2_TABLE_200

20: end;
21:
22: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_DATE_TABLE

Line 26: , a4 JTF_VARCHAR2_TABLE_200

22: procedure rosetta_table_copy_in_p13(t out nocopy okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_DATE_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 27: , a5 JTF_VARCHAR2_TABLE_200

23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: , a6 JTF_DATE_TABLE
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 54: , a1 out nocopy JTF_VARCHAR2_TABLE_200

50: end if;
51: end if;
52: end rosetta_table_copy_in_p13;
53: procedure rosetta_table_copy_out_p13(t okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_VARCHAR2_TABLE_200
55: , a2 out nocopy JTF_VARCHAR2_TABLE_200
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_200
58: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 55: , a2 out nocopy JTF_VARCHAR2_TABLE_200

51: end if;
52: end rosetta_table_copy_in_p13;
53: procedure rosetta_table_copy_out_p13(t okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_VARCHAR2_TABLE_200
55: , a2 out nocopy JTF_VARCHAR2_TABLE_200
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_200
58: , a5 out nocopy JTF_VARCHAR2_TABLE_200
59: , a6 out nocopy JTF_DATE_TABLE

Line 57: , a4 out nocopy JTF_VARCHAR2_TABLE_200

53: procedure rosetta_table_copy_out_p13(t okl_am_recycle_trmnt_pvt.recy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_VARCHAR2_TABLE_200
55: , a2 out nocopy JTF_VARCHAR2_TABLE_200
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_200
58: , a5 out nocopy JTF_VARCHAR2_TABLE_200
59: , a6 out nocopy JTF_DATE_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;

Line 58: , a5 out nocopy JTF_VARCHAR2_TABLE_200

54: , a1 out nocopy JTF_VARCHAR2_TABLE_200
55: , a2 out nocopy JTF_VARCHAR2_TABLE_200
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_VARCHAR2_TABLE_200
58: , a5 out nocopy JTF_VARCHAR2_TABLE_200
59: , a6 out nocopy JTF_DATE_TABLE
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin

Line 65: a1 := JTF_VARCHAR2_TABLE_200();

61: ddindx binary_integer; indx binary_integer;
62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();

Line 66: a2 := JTF_VARCHAR2_TABLE_200();

62: begin
63: if t is null or t.count = 0 then
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: a6 := JTF_DATE_TABLE();

Line 68: a4 := JTF_VARCHAR2_TABLE_200();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: a6 := JTF_DATE_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();

Line 69: a5 := JTF_VARCHAR2_TABLE_200();

65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_VARCHAR2_TABLE_200();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: a5 := JTF_VARCHAR2_TABLE_200();
70: a6 := JTF_DATE_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_VARCHAR2_TABLE_200();

Line 73: a1 := JTF_VARCHAR2_TABLE_200();

69: a5 := JTF_VARCHAR2_TABLE_200();
70: a6 := JTF_DATE_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_VARCHAR2_TABLE_200();
74: a2 := JTF_VARCHAR2_TABLE_200();
75: a3 := JTF_NUMBER_TABLE();
76: a4 := JTF_VARCHAR2_TABLE_200();
77: a5 := JTF_VARCHAR2_TABLE_200();

Line 74: a2 := JTF_VARCHAR2_TABLE_200();

70: a6 := JTF_DATE_TABLE();
71: else
72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_VARCHAR2_TABLE_200();
74: a2 := JTF_VARCHAR2_TABLE_200();
75: a3 := JTF_NUMBER_TABLE();
76: a4 := JTF_VARCHAR2_TABLE_200();
77: a5 := JTF_VARCHAR2_TABLE_200();
78: a6 := JTF_DATE_TABLE();

Line 76: a4 := JTF_VARCHAR2_TABLE_200();

72: a0 := JTF_NUMBER_TABLE();
73: a1 := JTF_VARCHAR2_TABLE_200();
74: a2 := JTF_VARCHAR2_TABLE_200();
75: a3 := JTF_NUMBER_TABLE();
76: a4 := JTF_VARCHAR2_TABLE_200();
77: a5 := JTF_VARCHAR2_TABLE_200();
78: a6 := JTF_DATE_TABLE();
79: if t.count > 0 then
80: a0.extend(t.count);

Line 77: a5 := JTF_VARCHAR2_TABLE_200();

73: a1 := JTF_VARCHAR2_TABLE_200();
74: a2 := JTF_VARCHAR2_TABLE_200();
75: a3 := JTF_NUMBER_TABLE();
76: a4 := JTF_VARCHAR2_TABLE_200();
77: a5 := JTF_VARCHAR2_TABLE_200();
78: a6 := JTF_DATE_TABLE();
79: if t.count > 0 then
80: a0.extend(t.count);
81: a1.extend(t.count);

Line 180: , p5_a1 JTF_VARCHAR2_TABLE_200

176: , x_return_status out nocopy VARCHAR2
177: , x_msg_count out nocopy NUMBER
178: , x_msg_data out nocopy VARCHAR2
179: , p5_a0 JTF_NUMBER_TABLE
180: , p5_a1 JTF_VARCHAR2_TABLE_200
181: , p5_a2 JTF_VARCHAR2_TABLE_200
182: , p5_a3 JTF_NUMBER_TABLE
183: , p5_a4 JTF_VARCHAR2_TABLE_200
184: , p5_a5 JTF_VARCHAR2_TABLE_200

Line 181: , p5_a2 JTF_VARCHAR2_TABLE_200

177: , x_msg_count out nocopy NUMBER
178: , x_msg_data out nocopy VARCHAR2
179: , p5_a0 JTF_NUMBER_TABLE
180: , p5_a1 JTF_VARCHAR2_TABLE_200
181: , p5_a2 JTF_VARCHAR2_TABLE_200
182: , p5_a3 JTF_NUMBER_TABLE
183: , p5_a4 JTF_VARCHAR2_TABLE_200
184: , p5_a5 JTF_VARCHAR2_TABLE_200
185: , p5_a6 JTF_DATE_TABLE

Line 183: , p5_a4 JTF_VARCHAR2_TABLE_200

179: , p5_a0 JTF_NUMBER_TABLE
180: , p5_a1 JTF_VARCHAR2_TABLE_200
181: , p5_a2 JTF_VARCHAR2_TABLE_200
182: , p5_a3 JTF_NUMBER_TABLE
183: , p5_a4 JTF_VARCHAR2_TABLE_200
184: , p5_a5 JTF_VARCHAR2_TABLE_200
185: , p5_a6 JTF_DATE_TABLE
186: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 184: , p5_a5 JTF_VARCHAR2_TABLE_200

180: , p5_a1 JTF_VARCHAR2_TABLE_200
181: , p5_a2 JTF_VARCHAR2_TABLE_200
182: , p5_a3 JTF_NUMBER_TABLE
183: , p5_a4 JTF_VARCHAR2_TABLE_200
184: , p5_a5 JTF_VARCHAR2_TABLE_200
185: , p5_a6 JTF_DATE_TABLE
186: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

183: , p5_a4 JTF_VARCHAR2_TABLE_200
184: , p5_a5 JTF_VARCHAR2_TABLE_200
185: , p5_a6 JTF_DATE_TABLE
186: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , p6_a3 out nocopy JTF_NUMBER_TABLE
190: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
191: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

184: , p5_a5 JTF_VARCHAR2_TABLE_200
185: , p5_a6 JTF_DATE_TABLE
186: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , p6_a3 out nocopy JTF_NUMBER_TABLE
190: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
191: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
192: , p6_a6 out nocopy JTF_DATE_TABLE

Line 190: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200

186: , p6_a0 out nocopy JTF_NUMBER_TABLE
187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , p6_a3 out nocopy JTF_NUMBER_TABLE
190: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
191: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
192: , p6_a6 out nocopy JTF_DATE_TABLE
193: )
194:

Line 191: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200

187: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
188: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
189: , p6_a3 out nocopy JTF_NUMBER_TABLE
190: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
191: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
192: , p6_a6 out nocopy JTF_DATE_TABLE
193: )
194:
195: as