DBA Data[Home] [Help]

APPS.OKL_LA_TRADEIN_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: ) as

Line 23: , a1 JTF_NUMBER_TABLE

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p6(t out nocopy okl_la_tradein_pvt.tradein_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_NUMBER_TABLE
26: ) as
27: ddindx binary_integer; indx binary_integer;
28: begin
29: if a0 is not null and a0.count > 0 then

Line 47: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

43: end loop;
44: end if;
45: end if;
46: end rosetta_table_copy_in_p6;
47: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as

Line 48: , a1 out nocopy JTF_NUMBER_TABLE

44: end if;
45: end if;
46: end rosetta_table_copy_in_p6;
47: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;

Line 50: , a3 out nocopy JTF_NUMBER_TABLE

46: end rosetta_table_copy_in_p6;
47: procedure rosetta_table_copy_out_p6(t okl_la_tradein_pvt.tradein_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_VARCHAR2_TABLE_200
50: , a3 out nocopy JTF_NUMBER_TABLE
51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then

Line 55: a0 := JTF_NUMBER_TABLE();

51: ) as
52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_200();
58: a3 := JTF_NUMBER_TABLE();
59: else

Line 56: a1 := JTF_NUMBER_TABLE();

52: ddindx binary_integer; indx binary_integer;
53: begin
54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_200();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();

Line 58: a3 := JTF_NUMBER_TABLE();

54: if t is null or t.count = 0 then
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_200();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_200();

Line 60: a0 := JTF_NUMBER_TABLE();

56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_200();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_200();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then

Line 61: a1 := JTF_NUMBER_TABLE();

57: a2 := JTF_VARCHAR2_TABLE_200();
58: a3 := JTF_NUMBER_TABLE();
59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_200();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);

Line 63: a3 := JTF_NUMBER_TABLE();

59: else
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_VARCHAR2_TABLE_200();
63: a3 := JTF_NUMBER_TABLE();
64: if t.count > 0 then
65: a0.extend(t.count);
66: a1.extend(t.count);
67: a2.extend(t.count);

Line 86: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE

82: end if;
83: end if;
84: end rosetta_table_copy_out_p6;
85:
86: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_100
89: ) as
90: ddindx binary_integer; indx binary_integer;

Line 87: , a1 JTF_NUMBER_TABLE

83: end if;
84: end rosetta_table_copy_out_p6;
85:
86: procedure rosetta_table_copy_in_p8(t out nocopy okl_la_tradein_pvt.asset_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_100
89: ) as
90: ddindx binary_integer; indx binary_integer;
91: begin

Line 109: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

105: end loop;
106: end if;
107: end if;
108: end rosetta_table_copy_in_p8;
109: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: ) as
113: ddindx binary_integer; indx binary_integer;

Line 110: , a1 out nocopy JTF_NUMBER_TABLE

106: end if;
107: end if;
108: end rosetta_table_copy_in_p8;
109: procedure rosetta_table_copy_out_p8(t okl_la_tradein_pvt.asset_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_100
112: ) as
113: ddindx binary_integer; indx binary_integer;
114: begin

Line 116: a0 := JTF_NUMBER_TABLE();

112: ) as
113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: else
120: a0 := JTF_NUMBER_TABLE();

Line 117: a1 := JTF_NUMBER_TABLE();

113: ddindx binary_integer; indx binary_integer;
114: begin
115: if t is null or t.count = 0 then
116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();

Line 120: a0 := JTF_NUMBER_TABLE();

116: a0 := JTF_NUMBER_TABLE();
117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: if t.count > 0 then
124: a0.extend(t.count);

Line 121: a1 := JTF_NUMBER_TABLE();

117: a1 := JTF_NUMBER_TABLE();
118: a2 := JTF_VARCHAR2_TABLE_100();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: if t.count > 0 then
124: a0.extend(t.count);
125: a1.extend(t.count);

Line 208: , p6_a0 JTF_NUMBER_TABLE

204: , x_return_status out nocopy VARCHAR2
205: , x_msg_count out nocopy NUMBER
206: , x_msg_data out nocopy VARCHAR2
207: , p_chr_id NUMBER
208: , p6_a0 JTF_NUMBER_TABLE
209: , p6_a1 JTF_NUMBER_TABLE
210: , p6_a2 JTF_VARCHAR2_TABLE_200
211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 209: , p6_a1 JTF_NUMBER_TABLE

205: , x_msg_count out nocopy NUMBER
206: , x_msg_data out nocopy VARCHAR2
207: , p_chr_id NUMBER
208: , p6_a0 JTF_NUMBER_TABLE
209: , p6_a1 JTF_NUMBER_TABLE
210: , p6_a2 JTF_VARCHAR2_TABLE_200
211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE
213: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 211: , p6_a3 JTF_NUMBER_TABLE

207: , p_chr_id NUMBER
208: , p6_a0 JTF_NUMBER_TABLE
209: , p6_a1 JTF_NUMBER_TABLE
210: , p6_a2 JTF_VARCHAR2_TABLE_200
211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE
213: , p7_a1 out nocopy JTF_NUMBER_TABLE
214: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
215: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 212: , p7_a0 out nocopy JTF_NUMBER_TABLE

208: , p6_a0 JTF_NUMBER_TABLE
209: , p6_a1 JTF_NUMBER_TABLE
210: , p6_a2 JTF_VARCHAR2_TABLE_200
211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE
213: , p7_a1 out nocopy JTF_NUMBER_TABLE
214: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
215: , p7_a3 out nocopy JTF_NUMBER_TABLE
216: )

Line 213: , p7_a1 out nocopy JTF_NUMBER_TABLE

209: , p6_a1 JTF_NUMBER_TABLE
210: , p6_a2 JTF_VARCHAR2_TABLE_200
211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE
213: , p7_a1 out nocopy JTF_NUMBER_TABLE
214: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
215: , p7_a3 out nocopy JTF_NUMBER_TABLE
216: )
217:

Line 215: , p7_a3 out nocopy JTF_NUMBER_TABLE

211: , p6_a3 JTF_NUMBER_TABLE
212: , p7_a0 out nocopy JTF_NUMBER_TABLE
213: , p7_a1 out nocopy JTF_NUMBER_TABLE
214: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
215: , p7_a3 out nocopy JTF_NUMBER_TABLE
216: )
217:
218: as
219: ddp_tradein_tbl okl_la_tradein_pvt.tradein_tbl_type;

Line 328: , p6_a0 JTF_NUMBER_TABLE

324: , x_return_status out nocopy VARCHAR2
325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p_chr_id NUMBER
328: , p6_a0 JTF_NUMBER_TABLE
329: , p6_a1 JTF_NUMBER_TABLE
330: , p6_a2 JTF_VARCHAR2_TABLE_200
331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 329: , p6_a1 JTF_NUMBER_TABLE

325: , x_msg_count out nocopy NUMBER
326: , x_msg_data out nocopy VARCHAR2
327: , p_chr_id NUMBER
328: , p6_a0 JTF_NUMBER_TABLE
329: , p6_a1 JTF_NUMBER_TABLE
330: , p6_a2 JTF_VARCHAR2_TABLE_200
331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE
333: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 331: , p6_a3 JTF_NUMBER_TABLE

327: , p_chr_id NUMBER
328: , p6_a0 JTF_NUMBER_TABLE
329: , p6_a1 JTF_NUMBER_TABLE
330: , p6_a2 JTF_VARCHAR2_TABLE_200
331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE
333: , p7_a1 out nocopy JTF_NUMBER_TABLE
334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
335: , p7_a3 out nocopy JTF_NUMBER_TABLE

Line 332: , p7_a0 out nocopy JTF_NUMBER_TABLE

328: , p6_a0 JTF_NUMBER_TABLE
329: , p6_a1 JTF_NUMBER_TABLE
330: , p6_a2 JTF_VARCHAR2_TABLE_200
331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE
333: , p7_a1 out nocopy JTF_NUMBER_TABLE
334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
335: , p7_a3 out nocopy JTF_NUMBER_TABLE
336: )

Line 333: , p7_a1 out nocopy JTF_NUMBER_TABLE

329: , p6_a1 JTF_NUMBER_TABLE
330: , p6_a2 JTF_VARCHAR2_TABLE_200
331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE
333: , p7_a1 out nocopy JTF_NUMBER_TABLE
334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
335: , p7_a3 out nocopy JTF_NUMBER_TABLE
336: )
337:

Line 335: , p7_a3 out nocopy JTF_NUMBER_TABLE

331: , p6_a3 JTF_NUMBER_TABLE
332: , p7_a0 out nocopy JTF_NUMBER_TABLE
333: , p7_a1 out nocopy JTF_NUMBER_TABLE
334: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_200
335: , p7_a3 out nocopy JTF_NUMBER_TABLE
336: )
337:
338: as
339: ddp_tradein_tbl okl_la_tradein_pvt.tradein_tbl_type;