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_QUERY_PUB_W dependencies on JTF_PERZ_QUERY_PUB

Line 1: package body jtf_perz_query_pub_w as

1: package body jtf_perz_query_pub_w as
2: /* $Header: jtfzwpqb.pls 120.2 2005/11/02 23:48:52 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_query_pub.query_parameter_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_query_pub.query_parameter_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 53: procedure rosetta_table_copy_out_p1(t jtf_perz_query_pub.query_parameter_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 107: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE

103: end if;
104: end if;
105: end rosetta_table_copy_out_p1;
106:
107: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_out_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_NUMBER_TABLE
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_VARCHAR2_TABLE_100

Line 138: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

134: end loop;
135: end if;
136: end if;
137: end rosetta_table_copy_in_p4;
138: procedure rosetta_table_copy_out_p4(t jtf_perz_query_pub.query_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
139: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
140: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
141: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
142: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 192: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE

188: end if;
189: end if;
190: end rosetta_table_copy_out_p4;
191:
192: procedure rosetta_table_copy_in_p6(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_query_pub.query_order_by_tbl_type, a0 JTF_NUMBER_TABLE
193: , a1 JTF_NUMBER_TABLE
194: , a2 JTF_VARCHAR2_TABLE_100
195: , a3 JTF_VARCHAR2_TABLE_100
196: , a4 JTF_NUMBER_TABLE

Line 219: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

215: end loop;
216: end if;
217: end if;
218: end rosetta_table_copy_in_p6;
219: procedure rosetta_table_copy_out_p6(t jtf_perz_query_pub.query_order_by_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
221: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
222: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 308: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;

304: )
305:
306: as
307: ddp_profile_attrib jtf_perz_profile_pub.profile_attrib_tbl_type;
308: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
309: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
310: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
311: ddindx binary_integer; indx binary_integer;
312: begin

Line 309: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;

305:
306: as
307: ddp_profile_attrib jtf_perz_profile_pub.profile_attrib_tbl_type;
308: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
309: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
310: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
311: ddindx binary_integer; indx binary_integer;
312: begin
313:

Line 310: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;

306: as
307: ddp_profile_attrib jtf_perz_profile_pub.profile_attrib_tbl_type;
308: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
309: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
310: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
311: ddindx binary_integer; indx binary_integer;
312: begin
313:
314: -- copy data to the local IN or IN-OUT args, if any

Line 334: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p13_a0

330:
331:
332:
333:
334: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p13_a0
335: , p13_a1
336: , p13_a2
337: , p13_a3
338: , p13_a4

Line 343: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p14_a0

339: , p13_a5
340: , p13_a6
341: );
342:
343: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p14_a0
344: , p14_a1
345: , p14_a2
346: , p14_a3
347: , p14_a4

Line 364: jtf_perz_query_pub.save_perz_query(p_api_version_number,

360:
361:
362:
363: -- here's the delegated call to the old PL/SQL routine
364: jtf_perz_query_pub.save_perz_query(p_api_version_number,
365: p_init_msg_list,
366: p_commit,
367: p_application_id,
368: p_profile_id,

Line 445: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;

441: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
442: )
443:
444: as
445: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
446: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
447: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
448: ddindx binary_integer; indx binary_integer;
449: begin

Line 446: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;

442: )
443:
444: as
445: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
446: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
447: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:

Line 447: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;

443:
444: as
445: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
446: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
447: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
448: ddindx binary_integer; indx binary_integer;
449: begin
450:
451: -- copy data to the local IN or IN-OUT args, if any

Line 463: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p11_a0

459:
460:
461:
462:
463: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p11_a0
464: , p11_a1
465: , p11_a2
466: , p11_a3
467: , p11_a4

Line 472: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p12_a0

468: , p11_a5
469: , p11_a6
470: );
471:
472: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p12_a0
473: , p12_a1
474: , p12_a2
475: , p12_a3
476: , p12_a4

Line 493: jtf_perz_query_pub.create_perz_query(p_api_version_number,

489:
490:
491:
492: -- here's the delegated call to the old PL/SQL routine
493: jtf_perz_query_pub.create_perz_query(p_api_version_number,
494: p_init_msg_list,
495: p_commit,
496: p_application_id,
497: p_profile_id,

Line 571: ddx_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;

567: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
568: )
569:
570: as
571: ddx_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
572: ddx_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
573: ddx_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
574: ddindx binary_integer; indx binary_integer;
575: begin

Line 572: ddx_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;

568: )
569:
570: as
571: ddx_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
572: ddx_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
573: ddx_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
574: ddindx binary_integer; indx binary_integer;
575: begin
576:

Line 573: ddx_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;

569:
570: as
571: ddx_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
572: ddx_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
573: ddx_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
574: ddindx binary_integer; indx binary_integer;
575: begin
576:
577: -- copy data to the local IN or IN-OUT args, if any

Line 598: jtf_perz_query_pub.get_perz_query(p_api_version_number,

594:
595:
596:
597: -- here's the delegated call to the old PL/SQL routine
598: jtf_perz_query_pub.get_perz_query(p_api_version_number,
599: p_init_msg_list,
600: p_application_id,
601: p_profile_id,
602: p_profile_name,

Line 632: jtf_perz_query_pub_w.rosetta_table_copy_out_p1(ddx_query_param_tbl, p13_a0

628:
629:
630:
631:
632: jtf_perz_query_pub_w.rosetta_table_copy_out_p1(ddx_query_param_tbl, p13_a0
633: , p13_a1
634: , p13_a2
635: , p13_a3
636: , p13_a4

Line 641: jtf_perz_query_pub_w.rosetta_table_copy_out_p6(ddx_query_order_by_tbl, p14_a0

637: , p13_a5
638: , p13_a6
639: );
640:
641: jtf_perz_query_pub_w.rosetta_table_copy_out_p6(ddx_query_order_by_tbl, p14_a0
642: , p14_a1
643: , p14_a2
644: , p14_a3
645: , p14_a4

Line 682: ddx_query_out_tbl jtf_perz_query_pub.query_out_tbl_type;

678: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
679: )
680:
681: as
682: ddx_query_out_tbl jtf_perz_query_pub.query_out_tbl_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:
686: -- copy data to the local IN or IN-OUT args, if any

Line 700: jtf_perz_query_pub.get_perz_query_summary(p_api_version_number,

696:
697:
698:
699: -- here's the delegated call to the old PL/SQL routine
700: jtf_perz_query_pub.get_perz_query_summary(p_api_version_number,
701: p_init_msg_list,
702: p_application_id,
703: p_profile_id,
704: p_profile_name,

Line 722: jtf_perz_query_pub_w.rosetta_table_copy_out_p4(ddx_query_out_tbl, p8_a0

718:
719:
720:
721:
722: jtf_perz_query_pub_w.rosetta_table_copy_out_p4(ddx_query_out_tbl, p8_a0
723: , p8_a1
724: , p8_a2
725: , p8_a3
726: , p8_a4

Line 772: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;

768: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
769: )
770:
771: as
772: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
773: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
774: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
775: ddindx binary_integer; indx binary_integer;
776: begin

Line 773: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;

769: )
770:
771: as
772: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
773: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
774: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
775: ddindx binary_integer; indx binary_integer;
776: begin
777:

Line 774: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;

770:
771: as
772: ddp_query_param_tbl jtf_perz_query_pub.query_parameter_tbl_type;
773: ddp_query_order_by_tbl jtf_perz_query_pub.query_order_by_tbl_type;
774: ddp_query_raw_sql_rec jtf_perz_query_pub.query_raw_sql_rec_type;
775: ddindx binary_integer; indx binary_integer;
776: begin
777:
778: -- copy data to the local IN or IN-OUT args, if any

Line 789: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p10_a0

785:
786:
787:
788:
789: jtf_perz_query_pub_w.rosetta_table_copy_in_p1(ddp_query_param_tbl, p10_a0
790: , p10_a1
791: , p10_a2
792: , p10_a3
793: , p10_a4

Line 798: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p11_a0

794: , p10_a5
795: , p10_a6
796: );
797:
798: jtf_perz_query_pub_w.rosetta_table_copy_in_p6(ddp_query_order_by_tbl, p11_a0
799: , p11_a1
800: , p11_a2
801: , p11_a3
802: , p11_a4

Line 819: jtf_perz_query_pub.update_perz_query(p_api_version_number,

815:
816:
817:
818: -- here's the delegated call to the old PL/SQL routine
819: jtf_perz_query_pub.update_perz_query(p_api_version_number,
820: p_init_msg_list,
821: p_commit,
822: p_application_id,
823: p_profile_id,

Line 856: end jtf_perz_query_pub_w;

852:
853:
854: end;
855:
856: end jtf_perz_query_pub_w;