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.OZF_TASK_GROUP_PVT_W dependencies on OZF_TASK_GROUP_PVT

Line 1: package body ozf_task_group_pvt_w as

1: package body ozf_task_group_pvt_w as
2: /* $Header: ozfwttgb.pls 115.0 2003/06/26 05:12:58 mchang noship $ */
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 13: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_group_pvt.task_group_tbl_type, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy ozf_task_group_pvt.task_group_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_DATE_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_NUMBER_TABLE

Line 46: t := ozf_task_group_pvt.task_group_tbl_type();

42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if a0 is not null and a0.count=0 then
46: t := ozf_task_group_pvt.task_group_tbl_type();
47: elsif a0 is not null and a0.count > 0 then
48: if a0.count > 0 then
49: t := ozf_task_group_pvt.task_group_tbl_type();
50: t.extend(a0.count);

Line 49: t := ozf_task_group_pvt.task_group_tbl_type();

45: if a0 is not null and a0.count=0 then
46: t := ozf_task_group_pvt.task_group_tbl_type();
47: elsif a0 is not null and a0.count > 0 then
48: if a0.count > 0 then
49: t := ozf_task_group_pvt.task_group_tbl_type();
50: t.extend(a0.count);
51: indx := a0.first;
52: ddindx := 1;
53: while true loop

Line 92: procedure rosetta_table_copy_out_p1(t ozf_task_group_pvt.task_group_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

88: end loop;
89: end if;
90: end if;
91: end rosetta_table_copy_in_p1;
92: procedure rosetta_table_copy_out_p1(t ozf_task_group_pvt.task_group_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
93: , a1 out nocopy JTF_DATE_TABLE
94: , a2 out nocopy JTF_NUMBER_TABLE
95: , a3 out nocopy JTF_DATE_TABLE
96: , a4 out nocopy JTF_NUMBER_TABLE

Line 286: procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100

282: end if;
283: end if;
284: end rosetta_table_copy_out_p1;
285:
286: procedure rosetta_table_copy_in_p5(t out nocopy ozf_task_group_pvt.ozf_sort_data, a0 JTF_VARCHAR2_TABLE_100
287: , a1 JTF_VARCHAR2_TABLE_100
288: ) as
289: ddindx binary_integer; indx binary_integer;
290: begin

Line 292: t := ozf_task_group_pvt.ozf_sort_data();

288: ) as
289: ddindx binary_integer; indx binary_integer;
290: begin
291: if a0 is not null and a0.count=0 then
292: t := ozf_task_group_pvt.ozf_sort_data();
293: elsif a0 is not null and a0.count > 0 then
294: if a0.count > 0 then
295: t := ozf_task_group_pvt.ozf_sort_data();
296: t.extend(a0.count);

Line 295: t := ozf_task_group_pvt.ozf_sort_data();

291: if a0 is not null and a0.count=0 then
292: t := ozf_task_group_pvt.ozf_sort_data();
293: elsif a0 is not null and a0.count > 0 then
294: if a0.count > 0 then
295: t := ozf_task_group_pvt.ozf_sort_data();
296: t.extend(a0.count);
297: indx := a0.first;
298: ddindx := 1;
299: while true loop

Line 311: procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100

307: end loop;
308: end if;
309: end if;
310: end rosetta_table_copy_in_p5;
311: procedure rosetta_table_copy_out_p5(t ozf_task_group_pvt.ozf_sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
312: , a1 out nocopy JTF_VARCHAR2_TABLE_100
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin

Line 383: ddp_task_group ozf_task_group_pvt.task_group_rec_type;

379: , x_task_template_group_id out nocopy NUMBER
380: )
381:
382: as
383: ddp_task_group ozf_task_group_pvt.task_group_rec_type;
384: ddindx binary_integer; indx binary_integer;
385: begin
386:
387: -- copy data to the local IN or IN-OUT args, if any

Line 427: ozf_task_group_pvt.create_task_group(p_api_version,

423: ddp_task_group.description := p7_a28;
424:
425:
426: -- here's the delegated call to the old PL/SQL routine
427: ozf_task_group_pvt.create_task_group(p_api_version,
428: p_init_msg_list,
429: p_commit,
430: p_validation_level,
431: x_return_status,

Line 488: ddp_task_group ozf_task_group_pvt.task_group_rec_type;

484: , x_object_version_number out nocopy NUMBER
485: )
486:
487: as
488: ddp_task_group ozf_task_group_pvt.task_group_rec_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 532: ozf_task_group_pvt.update_task_group(p_api_version,

528: ddp_task_group.description := p7_a28;
529:
530:
531: -- here's the delegated call to the old PL/SQL routine
532: ozf_task_group_pvt.update_task_group(p_api_version,
533: p_init_msg_list,
534: p_commit,
535: p_validation_level,
536: x_return_status,

Line 606: ddp_sort_data ozf_task_group_pvt.ozf_sort_data;

602:
603: as
604: ddp_start_date_active date;
605: ddp_end_date_active date;
606: ddp_sort_data ozf_task_group_pvt.ozf_sort_data;
607: ddp_request_rec ozf_task_group_pvt.ozf_request_rec_type;
608: ddx_return_rec ozf_task_group_pvt.ozf_return_rec_type;
609: ddx_task_group ozf_task_group_pvt.task_group_tbl_type;
610: ddindx binary_integer; indx binary_integer;

Line 607: ddp_request_rec ozf_task_group_pvt.ozf_request_rec_type;

603: as
604: ddp_start_date_active date;
605: ddp_end_date_active date;
606: ddp_sort_data ozf_task_group_pvt.ozf_sort_data;
607: ddp_request_rec ozf_task_group_pvt.ozf_request_rec_type;
608: ddx_return_rec ozf_task_group_pvt.ozf_return_rec_type;
609: ddx_task_group ozf_task_group_pvt.task_group_tbl_type;
610: ddindx binary_integer; indx binary_integer;
611: begin

Line 608: ddx_return_rec ozf_task_group_pvt.ozf_return_rec_type;

604: ddp_start_date_active date;
605: ddp_end_date_active date;
606: ddp_sort_data ozf_task_group_pvt.ozf_sort_data;
607: ddp_request_rec ozf_task_group_pvt.ozf_request_rec_type;
608: ddx_return_rec ozf_task_group_pvt.ozf_return_rec_type;
609: ddx_task_group ozf_task_group_pvt.task_group_tbl_type;
610: ddindx binary_integer; indx binary_integer;
611: begin
612:

Line 609: ddx_task_group ozf_task_group_pvt.task_group_tbl_type;

605: ddp_end_date_active date;
606: ddp_sort_data ozf_task_group_pvt.ozf_sort_data;
607: ddp_request_rec ozf_task_group_pvt.ozf_request_rec_type;
608: ddx_return_rec ozf_task_group_pvt.ozf_return_rec_type;
609: ddx_task_group ozf_task_group_pvt.task_group_tbl_type;
610: ddindx binary_integer; indx binary_integer;
611: begin
612:
613: -- copy data to the local IN or IN-OUT args, if any

Line 627: ozf_task_group_pvt_w.rosetta_table_copy_in_p5(ddp_sort_data, p11_a0

623: ddp_start_date_active := rosetta_g_miss_date_in_map(p_start_date_active);
624:
625: ddp_end_date_active := rosetta_g_miss_date_in_map(p_end_date_active);
626:
627: ozf_task_group_pvt_w.rosetta_table_copy_in_p5(ddp_sort_data, p11_a0
628: , p11_a1
629: );
630:
631: ddp_request_rec.records_requested := p12_a0;

Line 638: ozf_task_group_pvt.get_task_group(p_api_version,

634:
635:
636:
637: -- here's the delegated call to the old PL/SQL routine
638: ozf_task_group_pvt.get_task_group(p_api_version,
639: p_init_msg_list,
640: p_validation_level,
641: x_return_status,
642: x_msg_data,

Line 672: ozf_task_group_pvt_w.rosetta_table_copy_out_p1(ddx_task_group, p14_a0

668: p13_a0 := ddx_return_rec.returned_record_count;
669: p13_a1 := ddx_return_rec.next_record_position;
670: p13_a2 := ddx_return_rec.total_record_count;
671:
672: ozf_task_group_pvt_w.rosetta_table_copy_out_p1(ddx_task_group, p14_a0
673: , p14_a1
674: , p14_a2
675: , p14_a3
676: , p14_a4

Line 742: ddp_task_group ozf_task_group_pvt.task_group_rec_type;

738: , p6_a28 VARCHAR2
739: )
740:
741: as
742: ddp_task_group ozf_task_group_pvt.task_group_rec_type;
743: ddindx binary_integer; indx binary_integer;
744: begin
745:
746: -- copy data to the local IN or IN-OUT args, if any

Line 784: ozf_task_group_pvt.validate_task_group(p_api_version,

780: ddp_task_group.template_group_name := p6_a27;
781: ddp_task_group.description := p6_a28;
782:
783: -- here's the delegated call to the old PL/SQL routine
784: ozf_task_group_pvt.validate_task_group(p_api_version,
785: p_init_msg_list,
786: p_validation_level,
787: x_return_status,
788: x_msg_count,

Line 835: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;

831: , p2_a28 VARCHAR2
832: )
833:
834: as
835: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;
836: ddindx binary_integer; indx binary_integer;
837: begin
838:
839: -- copy data to the local IN or IN-OUT args, if any

Line 873: ozf_task_group_pvt.check_task_group_items(p_validation_mode,

869: ddp_task_group_rec.template_group_name := p2_a27;
870: ddp_task_group_rec.description := p2_a28;
871:
872: -- here's the delegated call to the old PL/SQL routine
873: ozf_task_group_pvt.check_task_group_items(p_validation_mode,
874: x_return_status,
875: ddp_task_group_rec);
876:
877: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 944: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;

940: , x_return_status out nocopy VARCHAR2
941: )
942:
943: as
944: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;
945: ddp_complete_rec ozf_task_group_pvt.task_group_rec_type;
946: ddindx binary_integer; indx binary_integer;
947: begin
948:

Line 945: ddp_complete_rec ozf_task_group_pvt.task_group_rec_type;

941: )
942:
943: as
944: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;
945: ddp_complete_rec ozf_task_group_pvt.task_group_rec_type;
946: ddindx binary_integer; indx binary_integer;
947: begin
948:
949: -- copy data to the local IN or IN-OUT args, if any

Line 1012: ozf_task_group_pvt.check_task_group_record(ddp_task_group_rec,

1008: ddp_complete_rec.description := p1_a28;
1009:
1010:
1011: -- here's the delegated call to the old PL/SQL routine
1012: ozf_task_group_pvt.check_task_group_record(ddp_task_group_rec,
1013: ddp_complete_rec,
1014: x_return_status);
1015:
1016: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1053: ddx_task_group_rec ozf_task_group_pvt.task_group_rec_type;

1049: , p0_a28 out nocopy VARCHAR2
1050: )
1051:
1052: as
1053: ddx_task_group_rec ozf_task_group_pvt.task_group_rec_type;
1054: ddindx binary_integer; indx binary_integer;
1055: begin
1056:
1057: -- copy data to the local IN or IN-OUT args, if any

Line 1060: ozf_task_group_pvt.init_task_group_rec(ddx_task_group_rec);

1056:
1057: -- copy data to the local IN or IN-OUT args, if any
1058:
1059: -- here's the delegated call to the old PL/SQL routine
1060: ozf_task_group_pvt.init_task_group_rec(ddx_task_group_rec);
1061:
1062: -- copy data back from the local variables to OUT or IN-OUT args, if any
1063: p0_a0 := ddx_task_group_rec.task_template_group_id;
1064: p0_a1 := ddx_task_group_rec.last_update_date;

Line 1155: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;

1151: , p1_a28 out nocopy VARCHAR2
1152: )
1153:
1154: as
1155: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;
1156: ddx_complete_rec ozf_task_group_pvt.task_group_rec_type;
1157: ddindx binary_integer; indx binary_integer;
1158: begin
1159:

Line 1156: ddx_complete_rec ozf_task_group_pvt.task_group_rec_type;

1152: )
1153:
1154: as
1155: ddp_task_group_rec ozf_task_group_pvt.task_group_rec_type;
1156: ddx_complete_rec ozf_task_group_pvt.task_group_rec_type;
1157: ddindx binary_integer; indx binary_integer;
1158: begin
1159:
1160: -- copy data to the local IN or IN-OUT args, if any

Line 1193: ozf_task_group_pvt.complete_task_group_rec(ddp_task_group_rec,

1189: ddp_task_group_rec.description := p0_a28;
1190:
1191:
1192: -- here's the delegated call to the old PL/SQL routine
1193: ozf_task_group_pvt.complete_task_group_rec(ddp_task_group_rec,
1194: ddx_complete_rec);
1195:
1196: -- copy data back from the local variables to OUT or IN-OUT args, if any
1197:

Line 1229: end ozf_task_group_pvt_w;

1225: p1_a27 := ddx_complete_rec.template_group_name;
1226: p1_a28 := ddx_complete_rec.description;
1227: end;
1228:
1229: end ozf_task_group_pvt_w;