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_MSITE_GRP_W dependencies on JTF_MSITE_GRP

Line 1: package body jtf_msite_grp_w as

1: package body jtf_msite_grp_w as
2: /* $Header: JTFGRMSB.pls 115.9 2004/07/09 18:50:52 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_p7(t out jtf_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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_p7(t out jtf_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 51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p7;
51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
52: , a1 out JTF_NUMBER_TABLE
53: , a2 out JTF_NUMBER_TABLE
54: , a3 out JTF_NUMBER_TABLE
55: , a4 out JTF_NUMBER_TABLE

Line 100: procedure rosetta_table_copy_in_p8(t out jtf_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100

96: end if;
97: end if;
98: end rosetta_table_copy_out_p7;
99:
100: procedure rosetta_table_copy_in_p8(t out jtf_msite_grp.msite_languages_tbl_type, a0 JTF_VARCHAR2_TABLE_100
101: , a1 JTF_VARCHAR2_TABLE_100
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin

Line 121: procedure rosetta_table_copy_out_p8(t jtf_msite_grp.msite_languages_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

117: end loop;
118: end if;
119: end if;
120: end rosetta_table_copy_in_p8;
121: procedure rosetta_table_copy_out_p8(t jtf_msite_grp.msite_languages_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
122: , a1 out JTF_VARCHAR2_TABLE_100
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin

Line 150: procedure rosetta_table_copy_in_p9(t out jtf_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE

146: end if;
147: end if;
148: end rosetta_table_copy_out_p8;
149:
150: procedure rosetta_table_copy_in_p9(t out jtf_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_VARCHAR2_TABLE_100
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin

Line 171: procedure rosetta_table_copy_out_p9(t jtf_msite_grp.msite_orgids_tbl_type, a0 out JTF_NUMBER_TABLE

167: end loop;
168: end if;
169: end if;
170: end rosetta_table_copy_in_p9;
171: procedure rosetta_table_copy_out_p9(t jtf_msite_grp.msite_orgids_tbl_type, a0 out JTF_NUMBER_TABLE
172: , a1 out JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin

Line 200: procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE

196: end if;
197: end if;
198: end rosetta_table_copy_out_p9;
199:
200: procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin

Line 221: procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE

217: end loop;
218: end if;
219: end if;
220: end rosetta_table_copy_in_p10;
221: procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE
222: , a1 out JTF_NUMBER_TABLE
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin

Line 250: procedure rosetta_table_copy_in_p11(t out jtf_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE) as

246: end if;
247: end if;
248: end rosetta_table_copy_out_p10;
249:
250: procedure rosetta_table_copy_in_p11(t out jtf_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE) as
251: ddindx binary_integer; indx binary_integer;
252: begin
253: if a0 is not null and a0.count > 0 then
254: if a0.count > 0 then

Line 268: procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE) as

264: end loop;
265: end if;
266: end if;
267: end rosetta_table_copy_in_p11;
268: procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();

Line 301: ddp_msite_id_tbl jtf_msite_grp.msite_delete_tbl_type;

297: , p6_a0 JTF_NUMBER_TABLE
298: , p6_a1 JTF_NUMBER_TABLE
299: )
300: as
301: ddp_msite_id_tbl jtf_msite_grp.msite_delete_tbl_type;
302: ddindx binary_integer; indx binary_integer;
303: begin
304:
305: -- copy data to the local IN or IN-OUT args, if any

Line 312: jtf_msite_grp_w.rosetta_table_copy_in_p10(ddp_msite_id_tbl, p6_a0

308:
309:
310:
311:
312: jtf_msite_grp_w.rosetta_table_copy_in_p10(ddp_msite_id_tbl, p6_a0
313: , p6_a1
314: );
315:
316: -- here's the delegated call to the old PL/SQL routine

Line 317: jtf_msite_grp.delete_msite(p_api_version,

313: , p6_a1
314: );
315:
316: -- here's the delegated call to the old PL/SQL routine
317: jtf_msite_grp.delete_msite(p_api_version,
318: p_init_msg_list,
319: p_commit,
320: x_return_status,
321: x_msg_count,

Line 360: ddp_msite_rec jtf_msite_grp.msite_rec_type;

356: , p6_a16 in out VARCHAR2
357: , p6_a17 in out NUMBER
358: )
359: as
360: ddp_msite_rec jtf_msite_grp.msite_rec_type;
361: ddindx binary_integer; indx binary_integer;
362: begin
363:
364: -- copy data to the local IN or IN-OUT args, if any

Line 391: jtf_msite_grp.save_msite(p_api_version,

387: ddp_msite_rec.url := p6_a16;
388: ddp_msite_rec.theme_id := rosetta_g_miss_num_map(p6_a17);
389:
390: -- here's the delegated call to the old PL/SQL routine
391: jtf_msite_grp.save_msite(p_api_version,
392: p_init_msg_list,
393: p_commit,
394: x_return_status,
395: x_msg_count,

Line 437: ddp_msite_languages_tbl jtf_msite_grp.msite_languages_tbl_type;

433: , p7_a0 JTF_VARCHAR2_TABLE_100
434: , p7_a1 JTF_VARCHAR2_TABLE_100
435: )
436: as
437: ddp_msite_languages_tbl jtf_msite_grp.msite_languages_tbl_type;
438: ddindx binary_integer; indx binary_integer;
439: begin
440:
441: -- copy data to the local IN or IN-OUT args, if any

Line 449: jtf_msite_grp_w.rosetta_table_copy_in_p8(ddp_msite_languages_tbl, p7_a0

445:
446:
447:
448:
449: jtf_msite_grp_w.rosetta_table_copy_in_p8(ddp_msite_languages_tbl, p7_a0
450: , p7_a1
451: );
452:
453: -- here's the delegated call to the old PL/SQL routine

Line 454: jtf_msite_grp.save_msite_languages(p_api_version,

450: , p7_a1
451: );
452:
453: -- here's the delegated call to the old PL/SQL routine
454: jtf_msite_grp.save_msite_languages(p_api_version,
455: p_init_msg_list,
456: p_commit,
457: x_return_status,
458: x_msg_count,

Line 488: ddp_msite_currencies_tbl jtf_msite_grp.msite_currencies_tbl_type;

484: , p7_a4 JTF_NUMBER_TABLE
485: , p7_a5 JTF_VARCHAR2_TABLE_100
486: )
487: as
488: ddp_msite_currencies_tbl jtf_msite_grp.msite_currencies_tbl_type;
489: ddindx binary_integer; indx binary_integer;
490: begin
491:
492: -- copy data to the local IN or IN-OUT args, if any

Line 500: jtf_msite_grp_w.rosetta_table_copy_in_p7(ddp_msite_currencies_tbl, p7_a0

496:
497:
498:
499:
500: jtf_msite_grp_w.rosetta_table_copy_in_p7(ddp_msite_currencies_tbl, p7_a0
501: , p7_a1
502: , p7_a2
503: , p7_a3
504: , p7_a4

Line 509: jtf_msite_grp.save_msite_currencies(p_api_version,

505: , p7_a5
506: );
507:
508: -- here's the delegated call to the old PL/SQL routine
509: jtf_msite_grp.save_msite_currencies(p_api_version,
510: p_init_msg_list,
511: p_commit,
512: x_return_status,
513: x_msg_count,

Line 539: ddp_msite_orgids_tbl jtf_msite_grp.msite_orgids_tbl_type;

535: , p7_a0 JTF_NUMBER_TABLE
536: , p7_a1 JTF_VARCHAR2_TABLE_100
537: )
538: as
539: ddp_msite_orgids_tbl jtf_msite_grp.msite_orgids_tbl_type;
540: ddindx binary_integer; indx binary_integer;
541: begin
542:
543: -- copy data to the local IN or IN-OUT args, if any

Line 551: jtf_msite_grp_w.rosetta_table_copy_in_p9(ddp_msite_orgids_tbl, p7_a0

547:
548:
549:
550:
551: jtf_msite_grp_w.rosetta_table_copy_in_p9(ddp_msite_orgids_tbl, p7_a0
552: , p7_a1
553: );
554:
555: -- here's the delegated call to the old PL/SQL routine

Line 556: jtf_msite_grp.save_msite_orgids(p_api_version,

552: , p7_a1
553: );
554:
555: -- here's the delegated call to the old PL/SQL routine
556: jtf_msite_grp.save_msite_orgids(p_api_version,
557: p_init_msg_list,
558: p_commit,
559: x_return_status,
560: x_msg_count,

Line 678: jtf_msite_grp.insert_row(x_rowid,

674:
675:
676:
677: -- here's the delegated call to the old PL/SQL routine
678: jtf_msite_grp.insert_row(x_rowid,
679: x_msite_id,
680: x_attribute_category,
681: x_attribute1,
682: x_attribute2,

Line 856: jtf_msite_grp.lock_row(x_msite_id,

852:
853:
854:
855: -- here's the delegated call to the old PL/SQL routine
856: jtf_msite_grp.lock_row(x_msite_id,
857: x_attribute_category,
858: x_attribute1,
859: x_attribute2,
860: x_attribute3,

Line 1030: jtf_msite_grp.update_row(x_msite_id,

1026:
1027:
1028:
1029: -- here's the delegated call to the old PL/SQL routine
1030: jtf_msite_grp.update_row(x_msite_id,
1031: x_attribute_category,
1032: x_attribute1,
1033: x_attribute2,
1034: x_attribute3,

Line 1204: jtf_msite_grp.load_row(x_msite_id,

1200:
1201:
1202:
1203: -- here's the delegated call to the old PL/SQL routine
1204: jtf_msite_grp.load_row(x_msite_id,
1205: x_owner,
1206: x_attribute_category,
1207: x_attribute1,
1208: x_attribute2,

Line 1285: end jtf_msite_grp_w;

1281:
1282:
1283: end;
1284:
1285: end jtf_msite_grp_w;