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_PERZ_DATA_PUB_W dependencies on JTF_PERZ_DATA_PUB

Line 1: package body jtf_perz_data_pub_w as

1: package body jtf_perz_data_pub_w as
2: /* $Header: jtfzwpdb.pls 120.2 2005/11/02 23:47:32 skothe 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_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_tbl_type, a0 JTF_NUMBER_TABLE

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_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_300

Line 51: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
53: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
54: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
55: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 100: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_out_tbl_type, a0 JTF_NUMBER_TABLE

96: end if;
97: end if;
98: end rosetta_table_copy_out_p1;
99:
100: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_out_tbl_type, a0 JTF_NUMBER_TABLE
101: , a1 JTF_NUMBER_TABLE
102: , a2 JTF_NUMBER_TABLE
103: , a3 JTF_VARCHAR2_TABLE_200
104: , a4 JTF_VARCHAR2_TABLE_100

Line 129: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p4;
129: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
130: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
131: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
132: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
133: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 207: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;

203: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
204: )
205: as
206: ddp_profile_attrib jtf_perz_profile_pub.profile_attrib_tbl_type;
207: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;
208: ddindx binary_integer; indx binary_integer;
209: begin
210:
211: -- copy data to the local IN or IN-OUT args, if any

Line 230: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p12_a0

226:
227:
228:
229:
230: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p12_a0
231: , p12_a1
232: , p12_a2
233: , p12_a3
234: , p12_a4

Line 243: jtf_perz_data_pub.save_perz_data(p_api_version_number,

239:
240:
241:
242: -- here's the delegated call to the old PL/SQL routine
243: jtf_perz_data_pub.save_perz_data(p_api_version_number,
244: p_init_msg_list,
245: p_commit,
246: p_application_id,
247: p_profile_id,

Line 302: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;

298: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
299: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
300: )
301: as
302: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;
303: ddindx binary_integer; indx binary_integer;
304: begin
305:
306: -- copy data to the local IN or IN-OUT args, if any

Line 317: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p10_a0

313:
314:
315:
316:
317: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p10_a0
318: , p10_a1
319: , p10_a2
320: , p10_a3
321: , p10_a4

Line 330: jtf_perz_data_pub.create_perz_data(p_api_version_number,

326:
327:
328:
329: -- here's the delegated call to the old PL/SQL routine
330: jtf_perz_data_pub.create_perz_data(p_api_version_number,
331: p_init_msg_list,
332: p_commit,
333: p_application_id,
334: p_profile_id,

Line 386: ddx_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;

382: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
383: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
384: )
385: as
386: ddx_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;
387: ddindx binary_integer; indx binary_integer;
388: begin
389:
390: -- copy data to the local IN or IN-OUT args, if any

Line 408: jtf_perz_data_pub.get_perz_data(p_api_version_number,

404:
405:
406:
407: -- here's the delegated call to the old PL/SQL routine
408: jtf_perz_data_pub.get_perz_data(p_api_version_number,
409: p_init_msg_list,
410: p_application_id,
411: p_profile_id,
412: p_profile_name,

Line 438: jtf_perz_data_pub_w.rosetta_table_copy_out_p1(ddx_data_attrib_tbl, p12_a0

434:
435:
436:
437:
438: jtf_perz_data_pub_w.rosetta_table_copy_out_p1(ddx_data_attrib_tbl, p12_a0
439: , p12_a1
440: , p12_a2
441: , p12_a3
442: , p12_a4

Line 469: ddx_data_out_tbl jtf_perz_data_pub.data_out_tbl_type;

465: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
466: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
467: )
468: as
469: ddx_data_out_tbl jtf_perz_data_pub.data_out_tbl_type;
470: ddindx binary_integer; indx binary_integer;
471: begin
472:
473: -- copy data to the local IN or IN-OUT args, if any

Line 487: jtf_perz_data_pub.get_perz_data_summary(p_api_version_number,

483:
484:
485:
486: -- here's the delegated call to the old PL/SQL routine
487: jtf_perz_data_pub.get_perz_data_summary(p_api_version_number,
488: p_init_msg_list,
489: p_application_id,
490: p_profile_id,
491: p_profile_name,

Line 509: jtf_perz_data_pub_w.rosetta_table_copy_out_p4(ddx_data_out_tbl, p8_a0

505:
506:
507:
508:
509: jtf_perz_data_pub_w.rosetta_table_copy_out_p4(ddx_data_out_tbl, p8_a0
510: , p8_a1
511: , p8_a2
512: , p8_a3
513: , p8_a4

Line 542: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;

538: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
539: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
540: )
541: as
542: ddp_data_attrib_tbl jtf_perz_data_pub.data_attrib_tbl_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 556: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p9_a0

552:
553:
554:
555:
556: jtf_perz_data_pub_w.rosetta_table_copy_in_p1(ddp_data_attrib_tbl, p9_a0
557: , p9_a1
558: , p9_a2
559: , p9_a3
560: , p9_a4

Line 569: jtf_perz_data_pub.update_perz_data(p_api_version_number,

565:
566:
567:
568: -- here's the delegated call to the old PL/SQL routine
569: jtf_perz_data_pub.update_perz_data(p_api_version_number,
570: p_init_msg_list,
571: p_commit,
572: p_application_id,
573: p_profile_id,

Line 600: end jtf_perz_data_pub_w;

596:
597:
598: end;
599:
600: end jtf_perz_data_pub_w;