DBA Data[Home] [Help]

APPS.IBE_MSITE_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p7(t out nocopy ibe_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out nocopy ibe_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 27: , a5 JTF_VARCHAR2_TABLE_100

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

Line 55: procedure rosetta_table_copy_out_p7(t ibe_msite_grp.msite_currencies_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

51: end loop;
52: end if;
53: end if;
54: end rosetta_table_copy_in_p7;
55: procedure rosetta_table_copy_out_p7(t ibe_msite_grp.msite_currencies_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_NUMBER_TABLE

Line 60: , a5 out nocopy JTF_VARCHAR2_TABLE_100

56: , a1 out nocopy JTF_NUMBER_TABLE
57: , a2 out nocopy JTF_NUMBER_TABLE
58: , a3 out nocopy JTF_NUMBER_TABLE
59: , a4 out nocopy JTF_NUMBER_TABLE
60: , a5 out nocopy JTF_VARCHAR2_TABLE_100
61: , a6 out nocopy JTF_NUMBER_TABLE
62: , a7 out nocopy JTF_NUMBER_TABLE
63: ) as
64: ddindx binary_integer; indx binary_integer;

Line 67: a0 := JTF_VARCHAR2_TABLE_100();

63: ) as
64: ddindx binary_integer; indx binary_integer;
65: begin
66: if t is null or t.count = 0 then
67: a0 := JTF_VARCHAR2_TABLE_100();
68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_NUMBER_TABLE();

Line 72: a5 := JTF_VARCHAR2_TABLE_100();

68: a1 := JTF_NUMBER_TABLE();
69: a2 := JTF_NUMBER_TABLE();
70: a3 := JTF_NUMBER_TABLE();
71: a4 := JTF_NUMBER_TABLE();
72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_VARCHAR2_TABLE_100();

Line 76: a0 := JTF_VARCHAR2_TABLE_100();

72: a5 := JTF_VARCHAR2_TABLE_100();
73: a6 := JTF_NUMBER_TABLE();
74: a7 := JTF_NUMBER_TABLE();
75: else
76: a0 := JTF_VARCHAR2_TABLE_100();
77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_NUMBER_TABLE();

Line 81: a5 := JTF_VARCHAR2_TABLE_100();

77: a1 := JTF_NUMBER_TABLE();
78: a2 := JTF_NUMBER_TABLE();
79: a3 := JTF_NUMBER_TABLE();
80: a4 := JTF_NUMBER_TABLE();
81: a5 := JTF_VARCHAR2_TABLE_100();
82: a6 := JTF_NUMBER_TABLE();
83: a7 := JTF_NUMBER_TABLE();
84: if t.count > 0 then
85: a0.extend(t.count);

Line 114: procedure rosetta_table_copy_in_p8(t out nocopy ibe_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100

110: end if;
111: end if;
112: end rosetta_table_copy_out_p7;
113:
114: procedure rosetta_table_copy_in_p8(t out nocopy ibe_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: ) as
118: ddindx binary_integer; indx binary_integer;

Line 115: , a1 JTF_VARCHAR2_TABLE_100

111: end if;
112: end rosetta_table_copy_out_p7;
113:
114: procedure rosetta_table_copy_in_p8(t out nocopy ibe_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin

Line 116: , a2 JTF_VARCHAR2_TABLE_100

112: end rosetta_table_copy_out_p7;
113:
114: procedure rosetta_table_copy_in_p8(t out nocopy ibe_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
115: , a1 JTF_VARCHAR2_TABLE_100
116: , a2 JTF_VARCHAR2_TABLE_100
117: ) as
118: ddindx binary_integer; indx binary_integer;
119: begin
120: if a0 is not null and a0.count > 0 then

Line 137: procedure rosetta_table_copy_out_p8(t ibe_msite_grp.msite_languages_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

133: end loop;
134: end if;
135: end if;
136: end rosetta_table_copy_in_p8;
137: procedure rosetta_table_copy_out_p8(t ibe_msite_grp.msite_languages_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
138: , a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , a2 out nocopy JTF_VARCHAR2_TABLE_100
140: ) as
141: ddindx binary_integer; indx binary_integer;

Line 138: , a1 out nocopy JTF_VARCHAR2_TABLE_100

134: end if;
135: end if;
136: end rosetta_table_copy_in_p8;
137: procedure rosetta_table_copy_out_p8(t ibe_msite_grp.msite_languages_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
138: , a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , a2 out nocopy JTF_VARCHAR2_TABLE_100
140: ) as
141: ddindx binary_integer; indx binary_integer;
142: begin

Line 139: , a2 out nocopy JTF_VARCHAR2_TABLE_100

135: end if;
136: end rosetta_table_copy_in_p8;
137: procedure rosetta_table_copy_out_p8(t ibe_msite_grp.msite_languages_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
138: , a1 out nocopy JTF_VARCHAR2_TABLE_100
139: , a2 out nocopy JTF_VARCHAR2_TABLE_100
140: ) as
141: ddindx binary_integer; indx binary_integer;
142: begin
143: if t is null or t.count = 0 then

Line 144: a0 := JTF_VARCHAR2_TABLE_100();

140: ) as
141: ddindx binary_integer; indx binary_integer;
142: begin
143: if t is null or t.count = 0 then
144: a0 := JTF_VARCHAR2_TABLE_100();
145: a1 := JTF_VARCHAR2_TABLE_100();
146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();

Line 145: a1 := JTF_VARCHAR2_TABLE_100();

141: ddindx binary_integer; indx binary_integer;
142: begin
143: if t is null or t.count = 0 then
144: a0 := JTF_VARCHAR2_TABLE_100();
145: a1 := JTF_VARCHAR2_TABLE_100();
146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();
149: a1 := JTF_VARCHAR2_TABLE_100();

Line 146: a2 := JTF_VARCHAR2_TABLE_100();

142: begin
143: if t is null or t.count = 0 then
144: a0 := JTF_VARCHAR2_TABLE_100();
145: a1 := JTF_VARCHAR2_TABLE_100();
146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();

Line 148: a0 := JTF_VARCHAR2_TABLE_100();

144: a0 := JTF_VARCHAR2_TABLE_100();
145: a1 := JTF_VARCHAR2_TABLE_100();
146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: if t.count > 0 then
152: a0.extend(t.count);

Line 149: a1 := JTF_VARCHAR2_TABLE_100();

145: a1 := JTF_VARCHAR2_TABLE_100();
146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: if t.count > 0 then
152: a0.extend(t.count);
153: a1.extend(t.count);

Line 150: a2 := JTF_VARCHAR2_TABLE_100();

146: a2 := JTF_VARCHAR2_TABLE_100();
147: else
148: a0 := JTF_VARCHAR2_TABLE_100();
149: a1 := JTF_VARCHAR2_TABLE_100();
150: a2 := JTF_VARCHAR2_TABLE_100();
151: if t.count > 0 then
152: a0.extend(t.count);
153: a1.extend(t.count);
154: a2.extend(t.count);

Line 172: , a1 JTF_VARCHAR2_TABLE_100

168: end if;
169: end rosetta_table_copy_out_p8;
170:
171: procedure rosetta_table_copy_in_p9(t out nocopy ibe_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE
172: , a1 JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if a0 is not null and a0.count > 0 then

Line 193: , a1 out nocopy JTF_VARCHAR2_TABLE_100

189: end if;
190: end if;
191: end rosetta_table_copy_in_p9;
192: procedure rosetta_table_copy_out_p9(t ibe_msite_grp.msite_orgids_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
193: , a1 out nocopy JTF_VARCHAR2_TABLE_100
194: ) as
195: ddindx binary_integer; indx binary_integer;
196: begin
197: if t is null or t.count = 0 then

Line 199: a1 := JTF_VARCHAR2_TABLE_100();

195: ddindx binary_integer; indx binary_integer;
196: begin
197: if t is null or t.count = 0 then
198: a0 := JTF_NUMBER_TABLE();
199: a1 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then

Line 202: a1 := JTF_VARCHAR2_TABLE_100();

198: a0 := JTF_NUMBER_TABLE();
199: a1 := JTF_VARCHAR2_TABLE_100();
200: else
201: a0 := JTF_NUMBER_TABLE();
202: a1 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);
205: a1.extend(t.count);
206: ddindx := t.first;

Line 599: , p7_a0 JTF_VARCHAR2_TABLE_100

595: , x_return_status out nocopy VARCHAR2
596: , x_msg_count out nocopy NUMBER
597: , x_msg_data out nocopy VARCHAR2
598: , p_msite_id NUMBER
599: , p7_a0 JTF_VARCHAR2_TABLE_100
600: , p7_a1 JTF_VARCHAR2_TABLE_100
601: , p7_a2 JTF_VARCHAR2_TABLE_100
602: )
603:

Line 600: , p7_a1 JTF_VARCHAR2_TABLE_100

596: , x_msg_count out nocopy NUMBER
597: , x_msg_data out nocopy VARCHAR2
598: , p_msite_id NUMBER
599: , p7_a0 JTF_VARCHAR2_TABLE_100
600: , p7_a1 JTF_VARCHAR2_TABLE_100
601: , p7_a2 JTF_VARCHAR2_TABLE_100
602: )
603:
604: as

Line 601: , p7_a2 JTF_VARCHAR2_TABLE_100

597: , x_msg_data out nocopy VARCHAR2
598: , p_msite_id NUMBER
599: , p7_a0 JTF_VARCHAR2_TABLE_100
600: , p7_a1 JTF_VARCHAR2_TABLE_100
601: , p7_a2 JTF_VARCHAR2_TABLE_100
602: )
603:
604: as
605: ddp_msite_languages_tbl ibe_msite_grp.msite_languages_tbl_type;

Line 649: , p7_a0 JTF_VARCHAR2_TABLE_100

645: , x_return_status out nocopy VARCHAR2
646: , x_msg_count out nocopy NUMBER
647: , x_msg_data out nocopy VARCHAR2
648: , p_msite_id NUMBER
649: , p7_a0 JTF_VARCHAR2_TABLE_100
650: , p7_a1 JTF_NUMBER_TABLE
651: , p7_a2 JTF_NUMBER_TABLE
652: , p7_a3 JTF_NUMBER_TABLE
653: , p7_a4 JTF_NUMBER_TABLE

Line 654: , p7_a5 JTF_VARCHAR2_TABLE_100

650: , p7_a1 JTF_NUMBER_TABLE
651: , p7_a2 JTF_NUMBER_TABLE
652: , p7_a3 JTF_NUMBER_TABLE
653: , p7_a4 JTF_NUMBER_TABLE
654: , p7_a5 JTF_VARCHAR2_TABLE_100
655: , p7_a6 JTF_NUMBER_TABLE
656: , p7_a7 JTF_NUMBER_TABLE
657: )
658:

Line 710: , p7_a1 JTF_VARCHAR2_TABLE_100

706: , x_msg_count out nocopy NUMBER
707: , x_msg_data out nocopy VARCHAR2
708: , p_msite_id NUMBER
709: , p7_a0 JTF_NUMBER_TABLE
710: , p7_a1 JTF_VARCHAR2_TABLE_100
711: )
712:
713: as
714: ddp_msite_orgids_tbl ibe_msite_grp.msite_orgids_tbl_type;