APPS.IBE_PHYSICALMAP_GRP_W dependencies on IBE_PHYSICALMAP_GRP

Line 1: package body ibe_physicalmap_grp_w as

1: package body ibe_physicalmap_grp_w as
2: /* $Header: IBEGRPSB.pls 115.4 2002/12/18 07:09:16 schak ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p0(t out nocopy ibe_physicalmap_grp.language_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out nocopy ibe_physicalmap_grp.language_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is null then
26: t := null;

Line 28: t := ibe_physicalmap_grp.language_code_tbl_type();

24: begin
25: if a0 is null then
26: t := null;
27: elsif a0.count = 0 then
28: t := ibe_physicalmap_grp.language_code_tbl_type();
29: else
30: if a0.count > 0 then
31: t := ibe_physicalmap_grp.language_code_tbl_type();
32: t.extend(a0.count);

Line 31: t := ibe_physicalmap_grp.language_code_tbl_type();

27: elsif a0.count = 0 then
28: t := ibe_physicalmap_grp.language_code_tbl_type();
29: else
30: if a0.count > 0 then
31: t := ibe_physicalmap_grp.language_code_tbl_type();
32: t.extend(a0.count);
33: indx := a0.first;
34: ddindx := 1;
35: while true loop

Line 46: procedure rosetta_table_copy_out_p0(t ibe_physicalmap_grp.language_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

42: end loop;
43: end if;
44: end if;
45: end rosetta_table_copy_in_p0;
46: procedure rosetta_table_copy_out_p0(t ibe_physicalmap_grp.language_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
47: ddindx binary_integer; indx binary_integer;
48: begin
49: if t is null then
50: a0 := null;

Line 71: procedure rosetta_table_copy_in_p2(t out nocopy ibe_physicalmap_grp.msite_lang_tbl_type, a0 JTF_NUMBER_TABLE

67: end if;
68: end if;
69: end rosetta_table_copy_out_p0;
70:
71: procedure rosetta_table_copy_in_p2(t out nocopy ibe_physicalmap_grp.msite_lang_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_NUMBER_TABLE
73: ) as
74: ddindx binary_integer; indx binary_integer;
75: begin

Line 92: procedure rosetta_table_copy_out_p2(t ibe_physicalmap_grp.msite_lang_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p2;
92: procedure rosetta_table_copy_out_p2(t ibe_physicalmap_grp.msite_lang_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_NUMBER_TABLE
94: ) as
95: ddindx binary_integer; indx binary_integer;
96: begin

Line 121: procedure rosetta_table_copy_in_p3(t out nocopy ibe_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 JTF_NUMBER_TABLE) as

117: end if;
118: end if;
119: end rosetta_table_copy_out_p2;
120:
121: procedure rosetta_table_copy_in_p3(t out nocopy ibe_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 JTF_NUMBER_TABLE) as
122: ddindx binary_integer; indx binary_integer;
123: begin
124: if a0 is not null and a0.count > 0 then
125: if a0.count > 0 then

Line 139: procedure rosetta_table_copy_out_p3(t ibe_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

135: end loop;
136: end if;
137: end if;
138: end rosetta_table_copy_in_p3;
139: procedure rosetta_table_copy_out_p3(t ibe_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
140: ddindx binary_integer; indx binary_integer;
141: begin
142: if t is null or t.count = 0 then
143: a0 := JTF_NUMBER_TABLE();

Line 162: procedure rosetta_table_copy_in_p4(t out nocopy ibe_physicalmap_grp.msite_id_tbl_type, a0 JTF_NUMBER_TABLE) as

158: end if;
159: end if;
160: end rosetta_table_copy_out_p3;
161:
162: procedure rosetta_table_copy_in_p4(t out nocopy ibe_physicalmap_grp.msite_id_tbl_type, a0 JTF_NUMBER_TABLE) as
163: ddindx binary_integer; indx binary_integer;
164: begin
165: if a0 is not null and a0.count > 0 then
166: if a0.count > 0 then

Line 180: procedure rosetta_table_copy_out_p4(t ibe_physicalmap_grp.msite_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

176: end loop;
177: end if;
178: end if;
179: end rosetta_table_copy_in_p4;
180: procedure rosetta_table_copy_out_p4(t ibe_physicalmap_grp.msite_id_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
181: ddindx binary_integer; indx binary_integer;
182: begin
183: if t is null or t.count = 0 then
184: a0 := JTF_NUMBER_TABLE();

Line 215: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;

211: , p_language_code_tbl JTF_VARCHAR2_TABLE_100
212: )
213:
214: as
215: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;
216: ddindx binary_integer; indx binary_integer;
217: begin
218:
219: -- copy data to the local IN or IN-OUT args, if any

Line 228: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

224:
225:
226:
227:
228: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
229:
230: -- here's the delegated call to the old PL/SQL routine
231: ibe_physicalmap_grp.save_physicalmap(p_api_version,
232: p_init_msg_list,

Line 231: ibe_physicalmap_grp.save_physicalmap(p_api_version,

227:
228: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
229:
230: -- here's the delegated call to the old PL/SQL routine
231: ibe_physicalmap_grp.save_physicalmap(p_api_version,
232: p_init_msg_list,
233: p_commit,
234: x_return_status,
235: x_msg_count,

Line 265: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;

261: , p_language_code_tbl JTF_VARCHAR2_TABLE_100
262: )
263:
264: as
265: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;
266: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:

Line 266: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;

262: )
263:
264: as
265: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;
266: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;
267: ddindx binary_integer; indx binary_integer;
268: begin
269:
270: -- copy data to the local IN or IN-OUT args, if any

Line 278: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p7_a0

274:
275:
276:
277:
278: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p7_a0
279: , p7_a1
280: );
281:
282: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

Line 282: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

278: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p7_a0
279: , p7_a1
280: );
281:
282: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
283:
284: -- here's the delegated call to the old PL/SQL routine
285: ibe_physicalmap_grp.save_physicalmap(p_api_version,
286: p_init_msg_list,

Line 285: ibe_physicalmap_grp.save_physicalmap(p_api_version,

281:
282: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
283:
284: -- here's the delegated call to the old PL/SQL routine
285: ibe_physicalmap_grp.save_physicalmap(p_api_version,
286: p_init_msg_list,
287: p_commit,
288: x_return_status,
289: x_msg_count,

Line 316: ddp_lgl_phys_map_id_tbl ibe_physicalmap_grp.lgl_phys_map_id_tbl_type;

312: , p_lgl_phys_map_id_tbl JTF_NUMBER_TABLE
313: )
314:
315: as
316: ddp_lgl_phys_map_id_tbl ibe_physicalmap_grp.lgl_phys_map_id_tbl_type;
317: ddindx binary_integer; indx binary_integer;
318: begin
319:
320: -- copy data to the local IN or IN-OUT args, if any

Line 327: ibe_physicalmap_grp_w.rosetta_table_copy_in_p3(ddp_lgl_phys_map_id_tbl, p_lgl_phys_map_id_tbl);

323:
324:
325:
326:
327: ibe_physicalmap_grp_w.rosetta_table_copy_in_p3(ddp_lgl_phys_map_id_tbl, p_lgl_phys_map_id_tbl);
328:
329: -- here's the delegated call to the old PL/SQL routine
330: ibe_physicalmap_grp.delete_physicalmap(p_api_version,
331: p_init_msg_list,

Line 330: ibe_physicalmap_grp.delete_physicalmap(p_api_version,

326:
327: ibe_physicalmap_grp_w.rosetta_table_copy_in_p3(ddp_lgl_phys_map_id_tbl, p_lgl_phys_map_id_tbl);
328:
329: -- here's the delegated call to the old PL/SQL routine
330: ibe_physicalmap_grp.delete_physicalmap(p_api_version,
331: p_init_msg_list,
332: p_commit,
333: x_return_status,
334: x_msg_count,

Line 358: ddp_msite_id_tbl ibe_physicalmap_grp.msite_id_tbl_type;

354: , p_msite_id_tbl JTF_NUMBER_TABLE
355: )
356:
357: as
358: ddp_msite_id_tbl ibe_physicalmap_grp.msite_id_tbl_type;
359: ddindx binary_integer; indx binary_integer;
360: begin
361:
362: -- copy data to the local IN or IN-OUT args, if any

Line 370: ibe_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);

366:
367:
368:
369:
370: ibe_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);
371:
372: -- here's the delegated call to the old PL/SQL routine
373: ibe_physicalmap_grp.delete_attachment_msite(p_api_version,
374: p_init_msg_list,

Line 373: ibe_physicalmap_grp.delete_attachment_msite(p_api_version,

369:
370: ibe_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);
371:
372: -- here's the delegated call to the old PL/SQL routine
373: ibe_physicalmap_grp.delete_attachment_msite(p_api_version,
374: p_init_msg_list,
375: p_commit,
376: x_return_status,
377: x_msg_count,

Line 407: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;

403: , p_language_code_tbl JTF_VARCHAR2_TABLE_100
404: )
405:
406: as
407: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;
408: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;
409: ddindx binary_integer; indx binary_integer;
410: begin
411:

Line 408: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;

404: )
405:
406: as
407: ddp_msite_lang_tbl ibe_physicalmap_grp.msite_lang_tbl_type;
408: ddp_language_code_tbl ibe_physicalmap_grp.language_code_tbl_type;
409: ddindx binary_integer; indx binary_integer;
410: begin
411:
412: -- copy data to the local IN or IN-OUT args, if any

Line 422: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p9_a0

418:
419:
420:
421:
422: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p9_a0
423: , p9_a1
424: );
425:
426: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

Line 426: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

422: ibe_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p9_a0
423: , p9_a1
424: );
425:
426: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
427:
428: -- here's the delegated call to the old PL/SQL routine
429: ibe_physicalmap_grp.save_physicalmap(p_api_version,
430: p_init_msg_list,

Line 429: ibe_physicalmap_grp.save_physicalmap(p_api_version,

425:
426: ibe_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);
427:
428: -- here's the delegated call to the old PL/SQL routine
429: ibe_physicalmap_grp.save_physicalmap(p_api_version,
430: p_init_msg_list,
431: p_commit,
432: x_return_status,
433: x_msg_count,

Line 454: end ibe_physicalmap_grp_w;

450:
451:
452: end;
453:
454: end ibe_physicalmap_grp_w;