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.JTA_SYNC_TASK_W dependencies on JTA_SYNC_TASK

Line 1: package body jta_sync_task_w as

1: package body jta_sync_task_w as
2: /* $Header: jtavstwb.pls 120.2 2006/04/27 01:11 deeprao 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 16: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p3(t out nocopy jta_sync_task.task_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_DATE_TABLE
20: , a4 JTF_NUMBER_TABLE

Line 115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE

111: end loop;
112: end if;
113: end if;
114: end rosetta_table_copy_in_p3;
115: procedure rosetta_table_copy_out_p3(t jta_sync_task.task_tbl, a0 out nocopy JTF_NUMBER_TABLE
116: , a1 out nocopy JTF_NUMBER_TABLE
117: , a2 out nocopy JTF_NUMBER_TABLE
118: , a3 out nocopy JTF_DATE_TABLE
119: , a4 out nocopy JTF_NUMBER_TABLE

Line 339: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE

335: end if;
336: end if;
337: end rosetta_table_copy_out_p3;
338:
339: procedure rosetta_table_copy_in_p4(t out nocopy jta_sync_task.exclusion_tbl, a0 JTF_NUMBER_TABLE
340: , a1 JTF_DATE_TABLE
341: ) as
342: ddindx binary_integer; indx binary_integer;
343: begin

Line 360: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p4;
360: procedure rosetta_table_copy_out_p4(t jta_sync_task.exclusion_tbl, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_DATE_TABLE
362: ) as
363: ddindx binary_integer; indx binary_integer;
364: begin

Line 411: jta_sync_task.get_count(p_request_type,

407:
408:
409:
410: -- here's the delegated call to the old PL/SQL routine
411: jta_sync_task.get_count(p_request_type,
412: ddp_syncanchor,
413: x_total,
414: x_totalnew,
415: x_totalmodified,

Line 475: ddx_data jta_sync_task.task_tbl;

471: )
472:
473: as
474: ddp_syncanchor date;
475: ddx_data jta_sync_task.task_tbl;
476: ddx_exclusion_data jta_sync_task.exclusion_tbl;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:

Line 476: ddx_exclusion_data jta_sync_task.exclusion_tbl;

472:
473: as
474: ddp_syncanchor date;
475: ddx_data jta_sync_task.task_tbl;
476: ddx_exclusion_data jta_sync_task.exclusion_tbl;
477: ddindx binary_integer; indx binary_integer;
478: begin
479:
480: -- copy data to the local IN or IN-OUT args, if any

Line 487: jta_sync_task.get_list(p_request_type,

483:
484:
485:
486: -- here's the delegated call to the old PL/SQL routine
487: jta_sync_task.get_list(p_request_type,
488: ddp_syncanchor,
489: ddx_data,
490: ddx_exclusion_data);
491:

Line 495: jta_sync_task_w.rosetta_table_copy_out_p3(ddx_data, p2_a0

491:
492: -- copy data back from the local variables to OUT or IN-OUT args, if any
493:
494:
495: jta_sync_task_w.rosetta_table_copy_out_p3(ddx_data, p2_a0
496: , p2_a1
497: , p2_a2
498: , p2_a3
499: , p2_a4

Line 538: jta_sync_task_w.rosetta_table_copy_out_p4(ddx_exclusion_data, p3_a0

534: , p2_a39
535: , p2_a40
536: );
537:
538: jta_sync_task_w.rosetta_table_copy_out_p4(ddx_exclusion_data, p3_a0
539: , p3_a1
540: );
541: end;
542:

Line 588: ddx_results jta_sync_task.task_tbl;

584: , p1_a40 in out nocopy JTF_NUMBER_TABLE
585: )
586:
587: as
588: ddx_results jta_sync_task.task_tbl;
589: ddindx binary_integer; indx binary_integer;
590: begin
591:
592: -- copy data to the local IN or IN-OUT args, if any

Line 594: jta_sync_task_w.rosetta_table_copy_in_p3(ddx_results, p1_a0

590: begin
591:
592: -- copy data to the local IN or IN-OUT args, if any
593:
594: jta_sync_task_w.rosetta_table_copy_in_p3(ddx_results, p1_a0
595: , p1_a1
596: , p1_a2
597: , p1_a3
598: , p1_a4

Line 638: jta_sync_task.create_ids(p_num_req,

634: , p1_a40
635: );
636:
637: -- here's the delegated call to the old PL/SQL routine
638: jta_sync_task.create_ids(p_num_req,
639: ddx_results);
640:
641: -- copy data back from the local variables to OUT or IN-OUT args, if any
642:

Line 643: jta_sync_task_w.rosetta_table_copy_out_p3(ddx_results, p1_a0

639: ddx_results);
640:
641: -- copy data back from the local variables to OUT or IN-OUT args, if any
642:
643: jta_sync_task_w.rosetta_table_copy_out_p3(ddx_results, p1_a0
644: , p1_a1
645: , p1_a2
646: , p1_a3
647: , p1_a4

Line 733: ddp_tasks jta_sync_task.task_tbl;

729: , p1_a1 JTF_DATE_TABLE
730: )
731:
732: as
733: ddp_tasks jta_sync_task.task_tbl;
734: ddp_exclusions jta_sync_task.exclusion_tbl;
735: ddindx binary_integer; indx binary_integer;
736: begin
737:

Line 734: ddp_exclusions jta_sync_task.exclusion_tbl;

730: )
731:
732: as
733: ddp_tasks jta_sync_task.task_tbl;
734: ddp_exclusions jta_sync_task.exclusion_tbl;
735: ddindx binary_integer; indx binary_integer;
736: begin
737:
738: -- copy data to the local IN or IN-OUT args, if any

Line 739: jta_sync_task_w.rosetta_table_copy_in_p3(ddp_tasks, p0_a0

735: ddindx binary_integer; indx binary_integer;
736: begin
737:
738: -- copy data to the local IN or IN-OUT args, if any
739: jta_sync_task_w.rosetta_table_copy_in_p3(ddp_tasks, p0_a0
740: , p0_a1
741: , p0_a2
742: , p0_a3
743: , p0_a4

Line 782: jta_sync_task_w.rosetta_table_copy_in_p4(ddp_exclusions, p1_a0

778: , p0_a39
779: , p0_a40
780: );
781:
782: jta_sync_task_w.rosetta_table_copy_in_p4(ddp_exclusions, p1_a0
783: , p1_a1
784: );
785:
786: -- here's the delegated call to the old PL/SQL routine

Line 787: jta_sync_task.update_data(ddp_tasks,

783: , p1_a1
784: );
785:
786: -- here's the delegated call to the old PL/SQL routine
787: jta_sync_task.update_data(ddp_tasks,
788: ddp_exclusions);
789:
790: -- copy data back from the local variables to OUT or IN-OUT args, if any
791: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0

Line 791: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0

787: jta_sync_task.update_data(ddp_tasks,
788: ddp_exclusions);
789:
790: -- copy data back from the local variables to OUT or IN-OUT args, if any
791: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0
792: , p0_a1
793: , p0_a2
794: , p0_a3
795: , p0_a4

Line 880: ddp_tasks jta_sync_task.task_tbl;

876: , p0_a40 in out nocopy JTF_NUMBER_TABLE
877: )
878:
879: as
880: ddp_tasks jta_sync_task.task_tbl;
881: ddindx binary_integer; indx binary_integer;
882: begin
883:
884: -- copy data to the local IN or IN-OUT args, if any

Line 885: jta_sync_task_w.rosetta_table_copy_in_p3(ddp_tasks, p0_a0

881: ddindx binary_integer; indx binary_integer;
882: begin
883:
884: -- copy data to the local IN or IN-OUT args, if any
885: jta_sync_task_w.rosetta_table_copy_in_p3(ddp_tasks, p0_a0
886: , p0_a1
887: , p0_a2
888: , p0_a3
889: , p0_a4

Line 929: jta_sync_task.delete_data(ddp_tasks);

925: , p0_a40
926: );
927:
928: -- here's the delegated call to the old PL/SQL routine
929: jta_sync_task.delete_data(ddp_tasks);
930:
931: -- copy data back from the local variables to OUT or IN-OUT args, if any
932: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0
933: , p0_a1

Line 932: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0

928: -- here's the delegated call to the old PL/SQL routine
929: jta_sync_task.delete_data(ddp_tasks);
930:
931: -- copy data back from the local variables to OUT or IN-OUT args, if any
932: jta_sync_task_w.rosetta_table_copy_out_p3(ddp_tasks, p0_a0
933: , p0_a1
934: , p0_a2
935: , p0_a3
936: , p0_a4

Line 976: end jta_sync_task_w;

972: , p0_a40
973: );
974: end;
975:
976: end jta_sync_task_w;