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_ATTACHMENT_GRP_W dependencies on JTF_ATTACHMENT_GRP

Line 1: package body jtf_attachment_grp_w as

1: package body jtf_attachment_grp_w as
2: /* $Header: JTFGRATB.pls 115.8 2004/07/09 18:50:20 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_p1(t out jtf_attachment_grp.attachment_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 jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE

123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p1;
127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100

Line 366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE

362: end if;
363: end if;
364: end rosetta_table_copy_out_p1;
365:
366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_VARCHAR2_TABLE_300
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_VARCHAR2_TABLE_100
370: ) as

Line 391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE

387: end loop;
388: end if;
389: end if;
390: end rosetta_table_copy_in_p3;
391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
392: , a1 out JTF_VARCHAR2_TABLE_300
393: , a2 out JTF_NUMBER_TABLE
394: , a3 out JTF_VARCHAR2_TABLE_100
395: ) as

Line 430: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as

426: end if;
427: end if;
428: end rosetta_table_copy_out_p3;
429:
430: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as
431: ddindx binary_integer; indx binary_integer;
432: begin
433: if a0 is null then
434: t := null;

Line 436: t := jtf_attachment_grp.number_table();

432: begin
433: if a0 is null then
434: t := null;
435: elsif a0.count = 0 then
436: t := jtf_attachment_grp.number_table();
437: else
438: if a0.count > 0 then
439: t := jtf_attachment_grp.number_table();
440: t.extend(a0.count);

Line 439: t := jtf_attachment_grp.number_table();

435: elsif a0.count = 0 then
436: t := jtf_attachment_grp.number_table();
437: else
438: if a0.count > 0 then
439: t := jtf_attachment_grp.number_table();
440: t.extend(a0.count);
441: indx := a0.first;
442: ddindx := 1;
443: while true loop

Line 454: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE) as

450: end loop;
451: end if;
452: end if;
453: end rosetta_table_copy_in_p4;
454: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if t is null then
458: a0 := null;

Line 479: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

475: end if;
476: end if;
477: end rosetta_table_copy_out_p4;
478:
479: procedure rosetta_table_copy_in_p5(t out jtf_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
480: ddindx binary_integer; indx binary_integer;
481: begin
482: if a0 is null then
483: t := null;

Line 485: t := jtf_attachment_grp.varchar2_table_300();

481: begin
482: if a0 is null then
483: t := null;
484: elsif a0.count = 0 then
485: t := jtf_attachment_grp.varchar2_table_300();
486: else
487: if a0.count > 0 then
488: t := jtf_attachment_grp.varchar2_table_300();
489: t.extend(a0.count);

Line 488: t := jtf_attachment_grp.varchar2_table_300();

484: elsif a0.count = 0 then
485: t := jtf_attachment_grp.varchar2_table_300();
486: else
487: if a0.count > 0 then
488: t := jtf_attachment_grp.varchar2_table_300();
489: t.extend(a0.count);
490: indx := a0.first;
491: ddindx := 1;
492: while true loop

Line 503: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as

499: end loop;
500: end if;
501: end if;
502: end rosetta_table_copy_in_p5;
503: procedure rosetta_table_copy_out_p5(t jtf_attachment_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as
504: ddindx binary_integer; indx binary_integer;
505: begin
506: if t is null then
507: a0 := null;

Line 528: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as

524: end if;
525: end if;
526: end rosetta_table_copy_out_p5;
527:
528: procedure rosetta_table_copy_in_p6(t out jtf_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as
529: ddindx binary_integer; indx binary_integer;
530: begin
531: if a0 is null then
532: t := null;

Line 534: t := jtf_attachment_grp.varchar2_table_20();

530: begin
531: if a0 is null then
532: t := null;
533: elsif a0.count = 0 then
534: t := jtf_attachment_grp.varchar2_table_20();
535: else
536: if a0.count > 0 then
537: t := jtf_attachment_grp.varchar2_table_20();
538: t.extend(a0.count);

Line 537: t := jtf_attachment_grp.varchar2_table_20();

533: elsif a0.count = 0 then
534: t := jtf_attachment_grp.varchar2_table_20();
535: else
536: if a0.count > 0 then
537: t := jtf_attachment_grp.varchar2_table_20();
538: t.extend(a0.count);
539: indx := a0.first;
540: ddindx := 1;
541: while true loop

Line 552: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100) as

548: end loop;
549: end if;
550: end if;
551: end rosetta_table_copy_in_p6;
552: procedure rosetta_table_copy_out_p6(t jtf_attachment_grp.varchar2_table_20, a0 out JTF_VARCHAR2_TABLE_100) as
553: ddindx binary_integer; indx binary_integer;
554: begin
555: if t is null then
556: a0 := null;

Line 597: ddx_ath_id_tbl jtf_attachment_grp.number_table;

593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE
595: )
596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;

Line 598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;

594: , x_version_tbl out JTF_NUMBER_TABLE
595: )
596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;

Line 599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;

595: )
596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;

Line 600: ddx_file_id_tbl jtf_attachment_grp.number_table;

596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;
604: ddx_version_tbl jtf_attachment_grp.number_table;

Line 601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;

597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;
604: ddx_version_tbl jtf_attachment_grp.number_table;
605: ddindx binary_integer; indx binary_integer;

Line 602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;

598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;
599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;
604: ddx_version_tbl jtf_attachment_grp.number_table;
605: ddindx binary_integer; indx binary_integer;
606: begin

Line 603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;

599: ddx_file_name_tbl jtf_attachment_grp.varchar2_table_300;
600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;
604: ddx_version_tbl jtf_attachment_grp.number_table;
605: ddindx binary_integer; indx binary_integer;
606: begin
607:

Line 604: ddx_version_tbl jtf_attachment_grp.number_table;

600: ddx_file_id_tbl jtf_attachment_grp.number_table;
601: ddx_file_ext_tbl jtf_attachment_grp.varchar2_table_20;
602: ddx_dsp_width_tbl jtf_attachment_grp.number_table;
603: ddx_dsp_height_tbl jtf_attachment_grp.number_table;
604: ddx_version_tbl jtf_attachment_grp.number_table;
605: ddindx binary_integer; indx binary_integer;
606: begin
607:
608: -- copy data to the local IN or IN-OUT args, if any

Line 628: jtf_attachment_grp.list_attachment(p_api_version,

624:
625:
626:
627: -- here's the delegated call to the old PL/SQL routine
628: jtf_attachment_grp.list_attachment(p_api_version,
629: p_init_msg_list,
630: x_return_status,
631: x_msg_count,
632: x_msg_data,

Line 658: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);

654:
655:
656:
657:
658: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
659:
660: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
661:
662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);

Line 660: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);

656:
657:
658: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
659:
660: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
661:
662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
663:
664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);

Line 662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);

658: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
659:
660: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
661:
662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
663:
664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
665:
666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);

Line 664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);

660: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
661:
662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
663:
664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
665:
666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
667:
668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);

Line 666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);

662: jtf_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
663:
664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
665:
666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
667:
668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
669:
670: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);

Line 668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);

664: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
665:
666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
667:
668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
669:
670: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
671:
672: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);

Line 670: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);

666: jtf_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
667:
668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
669:
670: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
671:
672: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);
673: end;
674:

Line 672: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);

668: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
669:
670: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
671:
672: jtf_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);
673: end;
674:
675: procedure save_attachment(p_api_version NUMBER
676: , p_init_msg_list VARCHAR2

Line 727: ddp_attachment_rec jtf_attachment_grp.attachment_rec_type;

723: , p6_a42 in out VARCHAR2
724: , p6_a43 in out VARCHAR2
725: )
726: as
727: ddp_attachment_rec jtf_attachment_grp.attachment_rec_type;
728: ddindx binary_integer; indx binary_integer;
729: begin
730:
731: -- copy data to the local IN or IN-OUT args, if any

Line 784: jtf_attachment_grp.save_attachment(p_api_version,

780: ddp_attachment_rec.alternate_text := p6_a42;
781: ddp_attachment_rec.attachment_sub_type := p6_a43;
782:
783: -- here's the delegated call to the old PL/SQL routine
784: jtf_attachment_grp.save_attachment(p_api_version,
785: p_init_msg_list,
786: p_commit,
787: x_return_status,
788: x_msg_count,

Line 897: ddp_attachment_tbl jtf_attachment_grp.attachment_tbl_type;

893: , p6_a42 in out JTF_VARCHAR2_TABLE_1000
894: , p6_a43 in out JTF_VARCHAR2_TABLE_100
895: )
896: as
897: ddp_attachment_tbl jtf_attachment_grp.attachment_tbl_type;
898: ddindx binary_integer; indx binary_integer;
899: begin
900:
901: -- copy data to the local IN or IN-OUT args, if any

Line 908: jtf_attachment_grp_w.rosetta_table_copy_in_p1(ddp_attachment_tbl, p6_a0

904:
905:
906:
907:
908: jtf_attachment_grp_w.rosetta_table_copy_in_p1(ddp_attachment_tbl, p6_a0
909: , p6_a1
910: , p6_a2
911: , p6_a3
912: , p6_a4

Line 955: jtf_attachment_grp.save_attachment(p_api_version,

951: , p6_a43
952: );
953:
954: -- here's the delegated call to the old PL/SQL routine
955: jtf_attachment_grp.save_attachment(p_api_version,
956: p_init_msg_list,
957: p_commit,
958: x_return_status,
959: x_msg_count,

Line 970: jtf_attachment_grp_w.rosetta_table_copy_out_p1(ddp_attachment_tbl, p6_a0

966:
967:
968:
969:
970: jtf_attachment_grp_w.rosetta_table_copy_out_p1(ddp_attachment_tbl, p6_a0
971: , p6_a1
972: , p6_a2
973: , p6_a3
974: , p6_a4

Line 1029: ddp_ath_id_ver_tbl jtf_attachment_grp.ath_id_ver_tbl_type;

1025: , p6_a2 in out JTF_NUMBER_TABLE
1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1027: )
1028: as
1029: ddp_ath_id_ver_tbl jtf_attachment_grp.ath_id_ver_tbl_type;
1030: ddindx binary_integer; indx binary_integer;
1031: begin
1032:
1033: -- copy data to the local IN or IN-OUT args, if any

Line 1040: jtf_attachment_grp_w.rosetta_table_copy_in_p3(ddp_ath_id_ver_tbl, p6_a0

1036:
1037:
1038:
1039:
1040: jtf_attachment_grp_w.rosetta_table_copy_in_p3(ddp_ath_id_ver_tbl, p6_a0
1041: , p6_a1
1042: , p6_a2
1043: , p6_a3
1044: );

Line 1047: jtf_attachment_grp.delete_attachment(p_api_version,

1043: , p6_a3
1044: );
1045:
1046: -- here's the delegated call to the old PL/SQL routine
1047: jtf_attachment_grp.delete_attachment(p_api_version,
1048: p_init_msg_list,
1049: p_commit,
1050: x_return_status,
1051: x_msg_count,

Line 1062: jtf_attachment_grp_w.rosetta_table_copy_out_p3(ddp_ath_id_ver_tbl, p6_a0

1058:
1059:
1060:
1061:
1062: jtf_attachment_grp_w.rosetta_table_copy_out_p3(ddp_ath_id_ver_tbl, p6_a0
1063: , p6_a1
1064: , p6_a2
1065: , p6_a3
1066: );

Line 1069: end jtf_attachment_grp_w;

1065: , p6_a3
1066: );
1067: end;
1068:
1069: end jtf_attachment_grp_w;