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.IBE_ATTACHMENT_GRP_W dependencies on IBE_ATTACHMENT_GRP

Line 1: package body ibe_attachment_grp_w as

1: package body ibe_attachment_grp_w as
2: /* $Header: IBEGRATB.pls 115.2 2002/12/18 07:06:58 schak 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 ibe_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy ibe_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 129: procedure rosetta_table_copy_out_p1(t ibe_attachment_grp.attachment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 373: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE

369: end if;
370: end if;
371: end rosetta_table_copy_out_p1;
372:
373: procedure rosetta_table_copy_in_p3(t out nocopy ibe_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_VARCHAR2_TABLE_300
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_VARCHAR2_TABLE_100
377: ) as

Line 398: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

394: end loop;
395: end if;
396: end if;
397: end rosetta_table_copy_in_p3;
398: procedure rosetta_table_copy_out_p3(t ibe_attachment_grp.ath_id_ver_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
399: , a1 out nocopy JTF_VARCHAR2_TABLE_300
400: , a2 out nocopy JTF_NUMBER_TABLE
401: , a3 out nocopy JTF_VARCHAR2_TABLE_100
402: ) as

Line 437: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as

433: end if;
434: end if;
435: end rosetta_table_copy_out_p3;
436:
437: procedure rosetta_table_copy_in_p4(t out nocopy ibe_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as
438: ddindx binary_integer; indx binary_integer;
439: begin
440: if a0 is null then
441: t := null;

Line 443: t := ibe_attachment_grp.number_table();

439: begin
440: if a0 is null then
441: t := null;
442: elsif a0.count = 0 then
443: t := ibe_attachment_grp.number_table();
444: else
445: if a0.count > 0 then
446: t := ibe_attachment_grp.number_table();
447: t.extend(a0.count);

Line 446: t := ibe_attachment_grp.number_table();

442: elsif a0.count = 0 then
443: t := ibe_attachment_grp.number_table();
444: else
445: if a0.count > 0 then
446: t := ibe_attachment_grp.number_table();
447: t.extend(a0.count);
448: indx := a0.first;
449: ddindx := 1;
450: while true loop

Line 461: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE) as

457: end loop;
458: end if;
459: end if;
460: end rosetta_table_copy_in_p4;
461: procedure rosetta_table_copy_out_p4(t ibe_attachment_grp.number_table, a0 out nocopy JTF_NUMBER_TABLE) as
462: ddindx binary_integer; indx binary_integer;
463: begin
464: if t is null then
465: a0 := null;

Line 486: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

482: end if;
483: end if;
484: end rosetta_table_copy_out_p4;
485:
486: procedure rosetta_table_copy_in_p5(t out nocopy ibe_attachment_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
487: ddindx binary_integer; indx binary_integer;
488: begin
489: if a0 is null then
490: t := null;

Line 492: t := ibe_attachment_grp.varchar2_table_300();

488: begin
489: if a0 is null then
490: t := null;
491: elsif a0.count = 0 then
492: t := ibe_attachment_grp.varchar2_table_300();
493: else
494: if a0.count > 0 then
495: t := ibe_attachment_grp.varchar2_table_300();
496: t.extend(a0.count);

Line 495: t := ibe_attachment_grp.varchar2_table_300();

491: elsif a0.count = 0 then
492: t := ibe_attachment_grp.varchar2_table_300();
493: else
494: if a0.count > 0 then
495: t := ibe_attachment_grp.varchar2_table_300();
496: t.extend(a0.count);
497: indx := a0.first;
498: ddindx := 1;
499: while true loop

Line 510: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300) as

506: end loop;
507: end if;
508: end if;
509: end rosetta_table_copy_in_p5;
510: procedure rosetta_table_copy_out_p5(t ibe_attachment_grp.varchar2_table_300, a0 out nocopy JTF_VARCHAR2_TABLE_300) as
511: ddindx binary_integer; indx binary_integer;
512: begin
513: if t is null then
514: a0 := null;

Line 535: procedure rosetta_table_copy_in_p6(t out nocopy ibe_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as

531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p6(t out nocopy ibe_attachment_grp.varchar2_table_20, a0 JTF_VARCHAR2_TABLE_100) as
536: ddindx binary_integer; indx binary_integer;
537: begin
538: if a0 is null then
539: t := null;

Line 541: t := ibe_attachment_grp.varchar2_table_20();

537: begin
538: if a0 is null then
539: t := null;
540: elsif a0.count = 0 then
541: t := ibe_attachment_grp.varchar2_table_20();
542: else
543: if a0.count > 0 then
544: t := ibe_attachment_grp.varchar2_table_20();
545: t.extend(a0.count);

Line 544: t := ibe_attachment_grp.varchar2_table_20();

540: elsif a0.count = 0 then
541: t := ibe_attachment_grp.varchar2_table_20();
542: else
543: if a0.count > 0 then
544: t := ibe_attachment_grp.varchar2_table_20();
545: t.extend(a0.count);
546: indx := a0.first;
547: ddindx := 1;
548: while true loop

Line 559: procedure rosetta_table_copy_out_p6(t ibe_attachment_grp.varchar2_table_20, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

555: end loop;
556: end if;
557: end if;
558: end rosetta_table_copy_in_p6;
559: procedure rosetta_table_copy_out_p6(t ibe_attachment_grp.varchar2_table_20, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
560: ddindx binary_integer; indx binary_integer;
561: begin
562: if t is null then
563: a0 := null;

Line 605: ddx_ath_id_tbl ibe_attachment_grp.number_table;

601: , x_version_tbl out nocopy JTF_NUMBER_TABLE
602: )
603:
604: as
605: ddx_ath_id_tbl ibe_attachment_grp.number_table;
606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;

Line 606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;

602: )
603:
604: as
605: ddx_ath_id_tbl ibe_attachment_grp.number_table;
606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;

Line 607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;

603:
604: as
605: ddx_ath_id_tbl ibe_attachment_grp.number_table;
606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;

Line 608: ddx_file_id_tbl ibe_attachment_grp.number_table;

604: as
605: ddx_ath_id_tbl ibe_attachment_grp.number_table;
606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;
612: ddx_version_tbl ibe_attachment_grp.number_table;

Line 609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;

605: ddx_ath_id_tbl ibe_attachment_grp.number_table;
606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;
612: ddx_version_tbl ibe_attachment_grp.number_table;
613: ddindx binary_integer; indx binary_integer;

Line 610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;

606: ddx_dlv_id_tbl ibe_attachment_grp.number_table;
607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;
612: ddx_version_tbl ibe_attachment_grp.number_table;
613: ddindx binary_integer; indx binary_integer;
614: begin

Line 611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;

607: ddx_file_name_tbl ibe_attachment_grp.varchar2_table_300;
608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;
612: ddx_version_tbl ibe_attachment_grp.number_table;
613: ddindx binary_integer; indx binary_integer;
614: begin
615:

Line 612: ddx_version_tbl ibe_attachment_grp.number_table;

608: ddx_file_id_tbl ibe_attachment_grp.number_table;
609: ddx_file_ext_tbl ibe_attachment_grp.varchar2_table_20;
610: ddx_dsp_width_tbl ibe_attachment_grp.number_table;
611: ddx_dsp_height_tbl ibe_attachment_grp.number_table;
612: ddx_version_tbl ibe_attachment_grp.number_table;
613: ddindx binary_integer; indx binary_integer;
614: begin
615:
616: -- copy data to the local IN or IN-OUT args, if any

Line 636: ibe_attachment_grp.list_attachment(p_api_version,

632:
633:
634:
635: -- here's the delegated call to the old PL/SQL routine
636: ibe_attachment_grp.list_attachment(p_api_version,
637: p_init_msg_list,
638: x_return_status,
639: x_msg_count,
640: x_msg_data,

Line 666: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);

662:
663:
664:
665:
666: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
667:
668: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
669:
670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);

Line 668: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);

664:
665:
666: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
667:
668: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
669:
670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
671:
672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);

Line 670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);

666: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_ath_id_tbl, x_ath_id_tbl);
667:
668: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
669:
670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
671:
672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
673:
674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);

Line 672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);

668: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dlv_id_tbl, x_dlv_id_tbl);
669:
670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
671:
672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
673:
674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
675:
676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);

Line 674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);

670: ibe_attachment_grp_w.rosetta_table_copy_out_p5(ddx_file_name_tbl, x_file_name_tbl);
671:
672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
673:
674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
675:
676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
677:
678: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);

Line 676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);

672: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_file_id_tbl, x_file_id_tbl);
673:
674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
675:
676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
677:
678: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
679:
680: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);

Line 678: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);

674: ibe_attachment_grp_w.rosetta_table_copy_out_p6(ddx_file_ext_tbl, x_file_ext_tbl);
675:
676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
677:
678: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
679:
680: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);
681: end;
682:

Line 680: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);

676: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_width_tbl, x_dsp_width_tbl);
677:
678: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_dsp_height_tbl, x_dsp_height_tbl);
679:
680: ibe_attachment_grp_w.rosetta_table_copy_out_p4(ddx_version_tbl, x_version_tbl);
681: end;
682:
683: procedure save_attachment(p_api_version NUMBER
684: , p_init_msg_list VARCHAR2

Line 737: ddp_attachment_rec ibe_attachment_grp.attachment_rec_type;

733: , p6_a44 in out nocopy VARCHAR2
734: )
735:
736: as
737: ddp_attachment_rec ibe_attachment_grp.attachment_rec_type;
738: ddindx binary_integer; indx binary_integer;
739: begin
740:
741: -- copy data to the local IN or IN-OUT args, if any

Line 795: ibe_attachment_grp.save_attachment(p_api_version,

791: ddp_attachment_rec.attachment_sub_type := p6_a43;
792: ddp_attachment_rec.secured_flag := p6_a44;
793:
794: -- here's the delegated call to the old PL/SQL routine
795: ibe_attachment_grp.save_attachment(p_api_version,
796: p_init_msg_list,
797: p_commit,
798: x_return_status,
799: x_msg_count,

Line 911: ddp_attachment_tbl ibe_attachment_grp.attachment_tbl_type;

907: , p6_a44 in out nocopy JTF_VARCHAR2_TABLE_100
908: )
909:
910: as
911: ddp_attachment_tbl ibe_attachment_grp.attachment_tbl_type;
912: ddindx binary_integer; indx binary_integer;
913: begin
914:
915: -- copy data to the local IN or IN-OUT args, if any

Line 922: ibe_attachment_grp_w.rosetta_table_copy_in_p1(ddp_attachment_tbl, p6_a0

918:
919:
920:
921:
922: ibe_attachment_grp_w.rosetta_table_copy_in_p1(ddp_attachment_tbl, p6_a0
923: , p6_a1
924: , p6_a2
925: , p6_a3
926: , p6_a4

Line 970: ibe_attachment_grp.save_attachment(p_api_version,

966: , p6_a44
967: );
968:
969: -- here's the delegated call to the old PL/SQL routine
970: ibe_attachment_grp.save_attachment(p_api_version,
971: p_init_msg_list,
972: p_commit,
973: x_return_status,
974: x_msg_count,

Line 985: ibe_attachment_grp_w.rosetta_table_copy_out_p1(ddp_attachment_tbl, p6_a0

981:
982:
983:
984:
985: ibe_attachment_grp_w.rosetta_table_copy_out_p1(ddp_attachment_tbl, p6_a0
986: , p6_a1
987: , p6_a2
988: , p6_a3
989: , p6_a4

Line 1046: ddp_ath_id_ver_tbl ibe_attachment_grp.ath_id_ver_tbl_type;

1042: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1043: )
1044:
1045: as
1046: ddp_ath_id_ver_tbl ibe_attachment_grp.ath_id_ver_tbl_type;
1047: ddindx binary_integer; indx binary_integer;
1048: begin
1049:
1050: -- copy data to the local IN or IN-OUT args, if any

Line 1057: ibe_attachment_grp_w.rosetta_table_copy_in_p3(ddp_ath_id_ver_tbl, p6_a0

1053:
1054:
1055:
1056:
1057: ibe_attachment_grp_w.rosetta_table_copy_in_p3(ddp_ath_id_ver_tbl, p6_a0
1058: , p6_a1
1059: , p6_a2
1060: , p6_a3
1061: );

Line 1064: ibe_attachment_grp.delete_attachment(p_api_version,

1060: , p6_a3
1061: );
1062:
1063: -- here's the delegated call to the old PL/SQL routine
1064: ibe_attachment_grp.delete_attachment(p_api_version,
1065: p_init_msg_list,
1066: p_commit,
1067: x_return_status,
1068: x_msg_count,

Line 1079: ibe_attachment_grp_w.rosetta_table_copy_out_p3(ddp_ath_id_ver_tbl, p6_a0

1075:
1076:
1077:
1078:
1079: ibe_attachment_grp_w.rosetta_table_copy_out_p3(ddp_ath_id_ver_tbl, p6_a0
1080: , p6_a1
1081: , p6_a2
1082: , p6_a3
1083: );

Line 1086: end ibe_attachment_grp_w;

1082: , p6_a3
1083: );
1084: end;
1085:
1086: end ibe_attachment_grp_w;