eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PHYSICALMAP_GRP_W dependencies on JTF_PHYSICALMAP_GRP

Line 1: package body jtf_physicalmap_grp_w as

1: package body jtf_physicalmap_grp_w as
2: /* $Header: JTFGRPSB.pls 115.6 2004/07/09 18:50:59 applrt 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 jtf_physicalmap_grp.language_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p0(t out jtf_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 := jtf_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 := jtf_physicalmap_grp.language_code_tbl_type();
29: else
30: if a0.count > 0 then
31: t := jtf_physicalmap_grp.language_code_tbl_type();
32: t.extend(a0.count);

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

27: elsif a0.count = 0 then
28: t := jtf_physicalmap_grp.language_code_tbl_type();
29: else
30: if a0.count > 0 then
31: t := jtf_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 jtf_physicalmap_grp.language_code_tbl_type, a0 out 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 jtf_physicalmap_grp.language_code_tbl_type, a0 out 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 jtf_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 jtf_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 jtf_physicalmap_grp.msite_lang_tbl_type, a0 out 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 jtf_physicalmap_grp.msite_lang_tbl_type, a0 out JTF_NUMBER_TABLE
93: , a1 out JTF_NUMBER_TABLE
94: ) as
95: ddindx binary_integer; indx binary_integer;
96: begin

Line 121: procedure rosetta_table_copy_in_p3(t out jtf_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 jtf_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 jtf_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 out 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 jtf_physicalmap_grp.lgl_phys_map_id_tbl_type, a0 out 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 jtf_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 jtf_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 jtf_physicalmap_grp.msite_id_tbl_type, a0 out 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 jtf_physicalmap_grp.msite_id_tbl_type, a0 out 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 214: ddp_language_code_tbl jtf_physicalmap_grp.language_code_tbl_type;

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

Line 227: jtf_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

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

Line 230: jtf_physicalmap_grp.save_physicalmap(p_api_version,

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

Line 263: ddp_msite_lang_tbl jtf_physicalmap_grp.msite_lang_tbl_type;

259: , p7_a1 JTF_NUMBER_TABLE
260: , p_language_code_tbl JTF_VARCHAR2_TABLE_100
261: )
262: as
263: ddp_msite_lang_tbl jtf_physicalmap_grp.msite_lang_tbl_type;
264: ddp_language_code_tbl jtf_physicalmap_grp.language_code_tbl_type;
265: ddindx binary_integer; indx binary_integer;
266: begin
267:

Line 264: ddp_language_code_tbl jtf_physicalmap_grp.language_code_tbl_type;

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

Line 276: jtf_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p7_a0

272:
273:
274:
275:
276: jtf_physicalmap_grp_w.rosetta_table_copy_in_p2(ddp_msite_lang_tbl, p7_a0
277: , p7_a1
278: );
279:
280: jtf_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

Line 280: jtf_physicalmap_grp_w.rosetta_table_copy_in_p0(ddp_language_code_tbl, p_language_code_tbl);

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

Line 283: jtf_physicalmap_grp.save_physicalmap(p_api_version,

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

Line 313: ddp_lgl_phys_map_id_tbl jtf_physicalmap_grp.lgl_phys_map_id_tbl_type;

309: , x_msg_data out VARCHAR2
310: , p_lgl_phys_map_id_tbl JTF_NUMBER_TABLE
311: )
312: as
313: ddp_lgl_phys_map_id_tbl jtf_physicalmap_grp.lgl_phys_map_id_tbl_type;
314: ddindx binary_integer; indx binary_integer;
315: begin
316:
317: -- copy data to the local IN or IN-OUT args, if any

Line 324: jtf_physicalmap_grp_w.rosetta_table_copy_in_p3(ddp_lgl_phys_map_id_tbl, p_lgl_phys_map_id_tbl);

320:
321:
322:
323:
324: jtf_physicalmap_grp_w.rosetta_table_copy_in_p3(ddp_lgl_phys_map_id_tbl, p_lgl_phys_map_id_tbl);
325:
326: -- here's the delegated call to the old PL/SQL routine
327: jtf_physicalmap_grp.delete_physicalmap(p_api_version,
328: p_init_msg_list,

Line 327: jtf_physicalmap_grp.delete_physicalmap(p_api_version,

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

Line 354: ddp_msite_id_tbl jtf_physicalmap_grp.msite_id_tbl_type;

350: , p_attachment_id NUMBER
351: , p_msite_id_tbl JTF_NUMBER_TABLE
352: )
353: as
354: ddp_msite_id_tbl jtf_physicalmap_grp.msite_id_tbl_type;
355: ddindx binary_integer; indx binary_integer;
356: begin
357:
358: -- copy data to the local IN or IN-OUT args, if any

Line 366: jtf_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);

362:
363:
364:
365:
366: jtf_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);
367:
368: -- here's the delegated call to the old PL/SQL routine
369: jtf_physicalmap_grp.delete_attachment_msite(p_api_version,
370: p_init_msg_list,

Line 369: jtf_physicalmap_grp.delete_attachment_msite(p_api_version,

365:
366: jtf_physicalmap_grp_w.rosetta_table_copy_in_p4(ddp_msite_id_tbl, p_msite_id_tbl);
367:
368: -- here's the delegated call to the old PL/SQL routine
369: jtf_physicalmap_grp.delete_attachment_msite(p_api_version,
370: p_init_msg_list,
371: p_commit,
372: x_return_status,
373: x_msg_count,

Line 388: end jtf_physicalmap_grp_w;

384:
385:
386: end;
387:
388: end jtf_physicalmap_grp_w;