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.IGI_IGIRRTRH_XMLP_PKG dependencies on STANDARD

Line 395: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.GET_NEXT_WORD(:LIST, :VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

391: /* FUNCTION GET_NEXT_WORD(LIST IN OUT NOCOPY VARCHAR2
392: ,VALUE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
393: X0 BOOLEAN;
394: BEGIN
395: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.GET_NEXT_WORD(:LIST, :VALUE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
396: STPROC.BIND_IO(LIST);
397: STPROC.BIND_IO(VALUE);
398: STPROC.BIND_O(X0);
399: STPROC.EXECUTE;

Line 412: X0 := ARP_STANDARD.CEIL(D);

408:
409: FUNCTION CEIL(D IN DATE) RETURN DATE IS
410: X0 DATE;
411: BEGIN
412: X0 := ARP_STANDARD.CEIL(D);
413: STPROC.INIT('begin :X0 := ARP_STANDARD.CEIL(:D); end;');
414: STPROC.BIND_O(X0);
415: STPROC.BIND_I(D);
416: STPROC.EXECUTE;

Line 413: STPROC.INIT('begin :X0 := ARP_STANDARD.CEIL(:D); end;');

409: FUNCTION CEIL(D IN DATE) RETURN DATE IS
410: X0 DATE;
411: BEGIN
412: X0 := ARP_STANDARD.CEIL(D);
413: STPROC.INIT('begin :X0 := ARP_STANDARD.CEIL(:D); end;');
414: STPROC.BIND_O(X0);
415: STPROC.BIND_I(D);
416: STPROC.EXECUTE;
417: STPROC.RETRIEVE(1

Line 425: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.EVEN(:N); :X0 := sys.diutil.bool_to_int(X0rv); end;');

421:
422: FUNCTION EVEN(N IN NUMBER) RETURN BOOLEAN IS
423: X0 BOOLEAN;
424: BEGIN
425: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.EVEN(:N); :X0 := sys.diutil.bool_to_int(X0rv); end;');
426: STPROC.BIND_I(N);
427: STPROC.BIND_O(X0);
428: STPROC.EXECUTE;
429: STPROC.RETRIEVE(2

Line 437: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.ODD(:N); :X0 := sys.diutil.bool_to_int(X0rv); end;');

433:
434: FUNCTION ODD(N IN NUMBER) RETURN BOOLEAN IS
435: X0 BOOLEAN;
436: BEGIN
437: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.ODD(:N); :X0 := sys.diutil.bool_to_int(X0rv); end;');
438: STPROC.BIND_I(N);
439: STPROC.BIND_O(X0);
440: STPROC.EXECUTE;
441: STPROC.RETRIEVE(2

Line 450: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.CHECK_FLAG(:OPTIONS, :FLAG); :X0 := sys.diutil.bool_to_int(X0rv); end;');

446: FUNCTION CHECK_FLAG(OPTIONS IN NUMBER
447: ,FLAG IN NUMBER) RETURN BOOLEAN IS
448: X0 BOOLEAN;
449: BEGIN
450: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.CHECK_FLAG(:OPTIONS, :FLAG); :X0 := sys.diutil.bool_to_int(X0rv); end;');
451: STPROC.BIND_I(OPTIONS);
452: STPROC.BIND_I(FLAG);
453: STPROC.BIND_O(X0);
454: STPROC.EXECUTE;

Line 463: STPROC.INIT('begin ARP_STANDARD.CLEAR_FLAG(:OPTIONS, :FLAG); end;');

459:
460: PROCEDURE CLEAR_FLAG(OPTIONS IN OUT NOCOPY NUMBER
461: ,FLAG IN NUMBER) IS
462: BEGIN
463: STPROC.INIT('begin ARP_STANDARD.CLEAR_FLAG(:OPTIONS, :FLAG); end;');
464: STPROC.BIND_IO(OPTIONS);
465: STPROC.BIND_I(FLAG);
466: STPROC.EXECUTE;
467: STPROC.RETRIEVE(1

Line 474: STPROC.INIT('begin ARP_STANDARD.SET_FLAG(:OPTIONS, :FLAG); end;');

470:
471: PROCEDURE SET_FLAG(OPTIONS IN OUT NOCOPY NUMBER
472: ,FLAG IN NUMBER) IS
473: BEGIN
474: STPROC.INIT('begin ARP_STANDARD.SET_FLAG(:OPTIONS, :FLAG); end;');
475: STPROC.BIND_IO(OPTIONS);
476: STPROC.BIND_I(FLAG);
477: STPROC.EXECUTE;
478: STPROC.RETRIEVE(1

Line 486: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS);

482: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER) RETURN VARCHAR2 IS
483: X0 VARCHAR2(2000);
484: BEGIN
485:
486: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS);
487: /*
488: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS); end;');
489: STPROC.BIND_O(X0);
490: STPROC.BIND_I(MD_OPTIONS);

Line 488: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS); end;');

484: BEGIN
485:
486: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS);
487: /*
488: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS); end;');
489: STPROC.BIND_O(X0);
490: STPROC.BIND_I(MD_OPTIONS);
491: STPROC.EXECUTE;
492: STPROC.RETRIEVE(1

Line 501: X0 := ARP_STANDARD.FND_MESSAGE;

497:
498: FUNCTION FND_MESSAGE RETURN VARCHAR2 IS
499: X0 VARCHAR2(2000);
500: BEGIN
501: X0 := ARP_STANDARD.FND_MESSAGE;
502: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE; end;');
503: STPROC.BIND_O(X0);
504: STPROC.EXECUTE;
505: STPROC.RETRIEVE(1

Line 502: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE; end;');

498: FUNCTION FND_MESSAGE RETURN VARCHAR2 IS
499: X0 VARCHAR2(2000);
500: BEGIN
501: X0 := ARP_STANDARD.FND_MESSAGE;
502: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE; end;');
503: STPROC.BIND_O(X0);
504: STPROC.EXECUTE;
505: STPROC.RETRIEVE(1
506: ,X0);*/

Line 513: X0 := ARP_STANDARD.PREVIOUS_MESSAGE(MD_OPTIONS);

509:
510: FUNCTION PREVIOUS_MESSAGE(MD_OPTIONS IN NUMBER) RETURN VARCHAR2 IS
511: X0 VARCHAR2(2000);
512: BEGIN
513: X0 := ARP_STANDARD.PREVIOUS_MESSAGE(MD_OPTIONS);
514: /* STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE(:MD_OPTIONS); end;');
515: STPROC.BIND_O(X0);
516: STPROC.BIND_I(MD_OPTIONS);
517: STPROC.EXECUTE;

Line 514: /* STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE(:MD_OPTIONS); end;');

510: FUNCTION PREVIOUS_MESSAGE(MD_OPTIONS IN NUMBER) RETURN VARCHAR2 IS
511: X0 VARCHAR2(2000);
512: BEGIN
513: X0 := ARP_STANDARD.PREVIOUS_MESSAGE(MD_OPTIONS);
514: /* STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE(:MD_OPTIONS); end;');
515: STPROC.BIND_O(X0);
516: STPROC.BIND_I(MD_OPTIONS);
517: STPROC.EXECUTE;
518: STPROC.RETRIEVE(1

Line 526: X0 := ARP_STANDARD.PREVIOUS_MESSAGE;

522:
523: FUNCTION PREVIOUS_MESSAGE RETURN VARCHAR2 IS
524: X0 VARCHAR2(2000);
525: BEGIN
526: X0 := ARP_STANDARD.PREVIOUS_MESSAGE;
527: /*
528: STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE; end;');
529: STPROC.BIND_O(X0);
530: STPROC.EXECUTE;

Line 528: STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE; end;');

524: X0 VARCHAR2(2000);
525: BEGIN
526: X0 := ARP_STANDARD.PREVIOUS_MESSAGE;
527: /*
528: STPROC.INIT('begin :X0 := ARP_STANDARD.PREVIOUS_MESSAGE; end;');
529: STPROC.BIND_O(X0);
530: STPROC.EXECUTE;
531: STPROC.RETRIEVE(1
532: ,X0); */

Line 539: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME); end;');

535:
536: FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2) RETURN VARCHAR2 IS
537: X0 VARCHAR2(2000);
538: BEGIN
539: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME); end;');
540: STPROC.BIND_O(X0);
541: STPROC.BIND_I(MSG_NAME);
542: STPROC.EXECUTE;
543: STPROC.RETRIEVE(1

Line 545: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME);

541: STPROC.BIND_I(MSG_NAME);
542: STPROC.EXECUTE;
543: STPROC.RETRIEVE(1
544: ,X0);*/
545: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME);
546: RETURN X0;
547: END FND_MESSAGE;
548:
549: FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2

Line 554: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1);

550: ,T1 IN VARCHAR2
551: ,V1 IN VARCHAR2) RETURN VARCHAR2 IS
552: X0 VARCHAR2(2000);
553: BEGIN
554: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1);
555: /*
556: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1); end;');
557: STPROC.BIND_O(X0);
558: STPROC.BIND_I(MSG_NAME);

Line 556: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1); end;');

552: X0 VARCHAR2(2000);
553: BEGIN
554: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1);
555: /*
556: STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1); end;');
557: STPROC.BIND_O(X0);
558: STPROC.BIND_I(MSG_NAME);
559: STPROC.BIND_I(T1);
560: STPROC.BIND_I(V1);

Line 575: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2); end;');

571: ,T2 IN VARCHAR2
572: ,V2 IN VARCHAR2) RETURN VARCHAR2 IS
573: X0 VARCHAR2(2000);
574: BEGIN
575: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2); end;');
576: STPROC.BIND_O(X0);
577: STPROC.BIND_I(MSG_NAME);
578: STPROC.BIND_I(T1);
579: STPROC.BIND_I(V1);

Line 585: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2);

581: STPROC.BIND_I(V2);
582: STPROC.EXECUTE;
583: STPROC.RETRIEVE(1
584: ,X0);*/
585: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2);
586: RETURN X0;
587: END FND_MESSAGE;
588:
589: FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2

Line 598: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');

594: ,T3 IN VARCHAR2
595: ,V3 IN VARCHAR2) RETURN VARCHAR2 IS
596: X0 VARCHAR2(2000);
597: BEGIN
598: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');
599: STPROC.BIND_O(X0);
600: STPROC.BIND_I(MSG_NAME);
601: STPROC.BIND_I(T1);
602: STPROC.BIND_I(V1);

Line 610: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2, T3, V3);

606: STPROC.BIND_I(V3);
607: STPROC.EXECUTE;
608: STPROC.RETRIEVE(1
609: ,X0);*/
610: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2, T3, V3);
611: RETURN X0;
612: END FND_MESSAGE;
613:
614: FUNCTION FND_MESSAGE(MSG_NAME IN VARCHAR2

Line 625: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');

621: ,T4 IN VARCHAR2
622: ,V4 IN VARCHAR2) RETURN VARCHAR2 IS
623: X0 VARCHAR2(2000);
624: BEGIN
625: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');
626: STPROC.BIND_O(X0);
627: STPROC.BIND_I(MSG_NAME);
628: STPROC.BIND_I(T1);
629: STPROC.BIND_I(V1);

Line 639: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2, T3, V3, T4, V4);

635: STPROC.BIND_I(V4);
636: STPROC.EXECUTE;
637: STPROC.RETRIEVE(1
638: ,X0);*/
639: X0 := ARP_STANDARD.FND_MESSAGE(MSG_NAME, T1, V1, T2, V2, T3, V3, T4, V4);
640: RETURN X0;
641: END FND_MESSAGE;
642:
643: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER

Line 647: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME); end;');

643: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER
644: ,MSG_NAME IN VARCHAR2) RETURN VARCHAR2 IS
645: X0 VARCHAR2(2000);
646: BEGIN
647: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME); end;');
648: STPROC.BIND_O(X0);
649: STPROC.BIND_I(MD_OPTIONS);
650: STPROC.BIND_I(MSG_NAME);
651: STPROC.EXECUTE;

Line 654: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME);

650: STPROC.BIND_I(MSG_NAME);
651: STPROC.EXECUTE;
652: STPROC.RETRIEVE(1
653: ,X0);*/
654: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME);
655: RETURN X0;
656: END FND_MESSAGE;
657:
658: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER

Line 664: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1); end;');

660: ,T1 IN VARCHAR2
661: ,V1 IN VARCHAR2) RETURN VARCHAR2 IS
662: X0 VARCHAR2(2000);
663: BEGIN
664: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1); end;');
665: STPROC.BIND_O(X0);
666: STPROC.BIND_I(MD_OPTIONS);
667: STPROC.BIND_I(MSG_NAME);
668: STPROC.BIND_I(T1);

Line 673: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1);

669: STPROC.BIND_I(V1);
670: STPROC.EXECUTE;
671: STPROC.RETRIEVE(1
672: ,X0);*/
673: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1);
674: RETURN X0;
675: END FND_MESSAGE;
676:
677: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER

Line 685: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2); end;');

681: ,T2 IN VARCHAR2
682: ,V2 IN VARCHAR2) RETURN VARCHAR2 IS
683: X0 VARCHAR2(2000);
684: BEGIN
685: /*STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2); end;');
686: STPROC.BIND_O(X0);
687: STPROC.BIND_I(MD_OPTIONS);
688: STPROC.BIND_I(MSG_NAME);
689: STPROC.BIND_I(T1);

Line 696: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1, T2, V2);

692: STPROC.BIND_I(V2);
693: STPROC.EXECUTE;
694: STPROC.RETRIEVE(1
695: ,X0);*/
696: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1, T2, V2);
697: RETURN X0;
698: END FND_MESSAGE;
699:
700: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER

Line 710: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');

706: ,T3 IN VARCHAR2
707: ,V3 IN VARCHAR2) RETURN VARCHAR2 IS
708: X0 VARCHAR2(2000);
709: BEGIN
710: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');
711: STPROC.BIND_O(X0);
712: STPROC.BIND_I(MD_OPTIONS);
713: STPROC.BIND_I(MSG_NAME);
714: STPROC.BIND_I(T1);

Line 723: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1,T2, V2, T3, V3);

719: STPROC.BIND_I(V3);
720: STPROC.EXECUTE;
721: STPROC.RETRIEVE(1
722: ,X0);*/
723: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1,T2, V2, T3, V3);
724: RETURN X0;
725: END FND_MESSAGE;
726:
727: FUNCTION FND_MESSAGE(MD_OPTIONS IN NUMBER

Line 739: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');

735: ,T4 IN VARCHAR2
736: ,V4 IN VARCHAR2) RETURN VARCHAR2 IS
737: X0 VARCHAR2(2000);
738: BEGIN
739: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');
740: STPROC.BIND_O(X0);
741: STPROC.BIND_I(MD_OPTIONS);
742: STPROC.BIND_I(MSG_NAME);
743: STPROC.BIND_I(T1);

Line 754: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1, T2, V2, T3, V3, T4, V4);

750: STPROC.BIND_I(V4);
751: STPROC.EXECUTE;
752: STPROC.RETRIEVE(1
753: ,X0);*/
754: X0 := ARP_STANDARD.FND_MESSAGE(MD_OPTIONS, MSG_NAME, T1, V1, T2, V2, T3, V3, T4, V4);
755: RETURN X0;
756: END FND_MESSAGE;
757:
758: FUNCTION FUNCTIONAL_AMOUNT(AMOUNT IN NUMBER

Line 765: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FUNCTIONAL_AMOUNT(:AMOUNT, :CURRENCY_CODE, :EXCHANGE_RATE, :PRECISION, :MIN_ACC_UNIT); end;');

761: ,PRECISION IN NUMBER
762: ,MIN_ACC_UNIT IN NUMBER) RETURN NUMBER IS
763: X0 NUMBER;
764: BEGIN
765: /* STPROC.INIT('begin :X0 := ARP_STANDARD.FUNCTIONAL_AMOUNT(:AMOUNT, :CURRENCY_CODE, :EXCHANGE_RATE, :PRECISION, :MIN_ACC_UNIT); end;');
766: STPROC.BIND_O(X0);
767: STPROC.BIND_I(AMOUNT);
768: STPROC.BIND_I(CURRENCY_CODE);
769: STPROC.BIND_I(EXCHANGE_RATE);

Line 775: X0 := ARP_STANDARD.FUNCTIONAL_AMOUNT(AMOUNT, CURRENCY_CODE, EXCHANGE_RATE, PRECISION, MIN_ACC_UNIT);

771: STPROC.BIND_I(MIN_ACC_UNIT);
772: STPROC.EXECUTE;
773: STPROC.RETRIEVE(1
774: ,X0);*/
775: X0 := ARP_STANDARD.FUNCTIONAL_AMOUNT(AMOUNT, CURRENCY_CODE, EXCHANGE_RATE, PRECISION, MIN_ACC_UNIT);
776: RETURN X0;
777: END FUNCTIONAL_AMOUNT;
778:
779: /* FUNCTION GL_DATE_RANGE_OPEN(PSTART_DATE IN VARCHAR2

Line 783: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.GL_DATE_RANGE_OPEN(:PSTART_DATE, :PEND_DATE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

779: /* FUNCTION GL_DATE_RANGE_OPEN(PSTART_DATE IN VARCHAR2
780: ,PEND_DATE IN VARCHAR2) RETURN BOOLEAN IS
781: X0 BOOLEAN;
782: BEGIN
783: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.GL_DATE_RANGE_OPEN(:PSTART_DATE, :PEND_DATE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
784: STPROC.BIND_I(PSTART_DATE);
785: STPROC.BIND_I(PEND_DATE);
786: STPROC.BIND_O(X0);
787: STPROC.EXECUTE;

Line 797: STPROC.INIT('begin :X0 := ARP_STANDARD.AR_LOOKUP(:LOOKUP_TYPE, :LOOKUP_CODE); end;');

793: FUNCTION AR_LOOKUP(LOOKUP_TYPE IN VARCHAR2
794: ,LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
795: X0 VARCHAR2(2000);
796: BEGIN
797: STPROC.INIT('begin :X0 := ARP_STANDARD.AR_LOOKUP(:LOOKUP_TYPE, :LOOKUP_CODE); end;');
798: STPROC.BIND_O(X0);
799: STPROC.BIND_I(LOOKUP_TYPE);
800: STPROC.BIND_I(LOOKUP_CODE);
801: STPROC.EXECUTE;

Line 810: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_NUMBER; end;');

806:
807: FUNCTION MD_MSG_NUMBER RETURN NUMBER IS
808: X0 NUMBER;
809: BEGIN
810: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_NUMBER; end;');
811: STPROC.BIND_O(X0);
812: STPROC.EXECUTE;
813: STPROC.RETRIEVE(1
814: ,X0);

Line 821: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_TEXT; end;');

817:
818: FUNCTION MD_MSG_TEXT RETURN NUMBER IS
819: X0 NUMBER;
820: BEGIN
821: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_TEXT; end;');
822: STPROC.BIND_O(X0);
823: STPROC.EXECUTE;
824: STPROC.RETRIEVE(1
825: ,X0);

Line 832: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_NAME; end;');

828:
829: FUNCTION MD_MSG_NAME RETURN NUMBER IS
830: X0 NUMBER;
831: BEGIN
832: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_NAME; end;');
833: STPROC.BIND_O(X0);
834: STPROC.EXECUTE;
835: STPROC.RETRIEVE(1
836: ,X0);

Line 843: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_TOKENS; end;');

839:
840: FUNCTION MD_MSG_TOKENS RETURN NUMBER IS
841: X0 NUMBER;
842: BEGIN
843: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_TOKENS; end;');
844: STPROC.BIND_O(X0);
845: STPROC.EXECUTE;
846: STPROC.RETRIEVE(1
847: ,X0);

Line 854: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_EXPLANATION; end;');

850:
851: FUNCTION MD_MSG_EXPLANATION RETURN NUMBER IS
852: X0 NUMBER;
853: BEGIN
854: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_EXPLANATION; end;');
855: STPROC.BIND_O(X0);
856: STPROC.EXECUTE;
857: STPROC.RETRIEVE(1
858: ,X0);

Line 865: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_FIND_NUMBER; end;');

861:
862: FUNCTION MD_MSG_FIND_NUMBER RETURN NUMBER IS
863: X0 NUMBER;
864: BEGIN
865: STPROC.INIT('begin :X0 := ARP_STANDARD.MD_MSG_FIND_NUMBER; end;');
866: STPROC.BIND_O(X0);
867: STPROC.EXECUTE;
868: STPROC.RETRIEVE(1
869: ,X0);

Line 883: STPROC.INIT('begin ARP_STANDARD.GL_PERIOD_INFO(:GL_DATE, :PERIOD_NAME, :START_DATE, :END_DATE, :CLOSING_STATUS, :PERIOD_TYPE, :PERIOD_YEAR, :PERIOD_NUM, :QUARTER_NUM); end;');

879: ,PERIOD_YEAR OUT NOCOPY NUMBER
880: ,PERIOD_NUM OUT NOCOPY NUMBER
881: ,QUARTER_NUM OUT NOCOPY NUMBER) IS
882: BEGIN
883: STPROC.INIT('begin ARP_STANDARD.GL_PERIOD_INFO(:GL_DATE, :PERIOD_NAME, :START_DATE, :END_DATE, :CLOSING_STATUS, :PERIOD_TYPE, :PERIOD_YEAR, :PERIOD_NUM, :QUARTER_NUM); end;');
884: STPROC.BIND_I(GL_DATE);
885: STPROC.BIND_O(PERIOD_NAME);
886: STPROC.BIND_O(START_DATE);
887: STPROC.BIND_O(END_DATE);

Line 915: STPROC.INIT('begin :X0 := ARP_STANDARD.GL_PERIOD_NAME(:GL_DATE); end;');

911:
912: FUNCTION GL_PERIOD_NAME(GL_DATE IN DATE) RETURN VARCHAR2 IS
913: X0 VARCHAR2(2000);
914: BEGIN
915: STPROC.INIT('begin :X0 := ARP_STANDARD.GL_PERIOD_NAME(:GL_DATE); end;');
916: STPROC.BIND_O(X0);
917: STPROC.BIND_I(GL_DATE);
918: STPROC.EXECUTE;
919: STPROC.RETRIEVE(1

Line 937: X0rv := ARP_STANDARD.IS_GL_DATE_VALID(:P_GL_DATE, :P_TRX_DATE, :P_VALIDATION_DATE1,

933: X0 BOOLEAN;
934: BEGIN
935: STPROC.INIT('declare X0rv BOOLEAN; X0P_CHECK_PERIOD_STATUS BOOLEAN;
936: begin X0P_CHECK_PERIOD_STATUS := sys.diutil.int_to_bool(:P_CHECK_PERIOD_STATUS);
937: X0rv := ARP_STANDARD.IS_GL_DATE_VALID(:P_GL_DATE, :P_TRX_DATE, :P_VALIDATION_DATE1,
938: :P_VALIDATION_DATE2, :P_VALIDATION_DATE3, :P_ALLOW_NOT_OPEN_FLAG, :P_SET_OF_BOOKS_ID, :P_APPLICATION_ID, X0P_CHECK_PERIOD_STATUS);
939: :X0 := sys.diutil.bool_to_int(X0rv); end;');
940: STPROC.BIND_I(P_CHECK_PERIOD_STATUS);
941: STPROC.BIND_I(P_GL_DATE);

Line 973: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.VALIDATE_AND_DEFAULT_GL_DATE(:GL_DATE, :TRX_DATE, :VALIDATION_DATE1, :VALIDATION_DATE2,

969: ,DEFAULTING_RULE_USED OUT NOCOPY VARCHAR2
970: ,ERROR_MESSAGE OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
971: X0 BOOLEAN;
972: BEGIN
973: STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := ARP_STANDARD.VALIDATE_AND_DEFAULT_GL_DATE(:GL_DATE, :TRX_DATE, :VALIDATION_DATE1, :VALIDATION_DATE2,
974: :VALIDATION_DATE3, :DEFAULT_DATE1, :DEFAULT_DATE2, :DEFAULT_DATE3, :P_ALLOW_NOT_OPEN_FLAG, :P_INVOICING_RULE_ID, :P_SET_OF_BOOKS_ID, :P_APPLICATION_ID, :DEFAULT_GL_DATE, :DEFAULTING_RULE_USED, :ERROR_MESSAGE);
975: :X0 := sys.diutil.bool_to_int(X0rv); end;');
976: STPROC.BIND_I(GL_DATE);
977: STPROC.BIND_I(TRX_DATE);

Line 1006: STPROC.INIT('begin ARP_STANDARD.DEBUG(:LINE); end;');

1002: END VALIDATE_AND_DEFAULT_GL_DATE;
1003:
1004: PROCEDURE DEBUG(LINE IN VARCHAR2) IS
1005: BEGIN
1006: STPROC.INIT('begin ARP_STANDARD.DEBUG(:LINE); end;');
1007: STPROC.BIND_I(LINE);
1008: STPROC.EXECUTE;
1009: END DEBUG;
1010:

Line 1013: STPROC.INIT('begin ARP_STANDARD.ENABLE_DEBUG; end;');

1009: END DEBUG;
1010:
1011: PROCEDURE ENABLE_DEBUG IS
1012: BEGIN
1013: STPROC.INIT('begin ARP_STANDARD.ENABLE_DEBUG; end;');
1014: STPROC.EXECUTE;
1015: END ENABLE_DEBUG;
1016:
1017: PROCEDURE ENABLE_DEBUG(BUFFER_SIZE IN NUMBER) IS

Line 1019: STPROC.INIT('begin ARP_STANDARD.ENABLE_DEBUG(:BUFFER_SIZE); end;');

1015: END ENABLE_DEBUG;
1016:
1017: PROCEDURE ENABLE_DEBUG(BUFFER_SIZE IN NUMBER) IS
1018: BEGIN
1019: STPROC.INIT('begin ARP_STANDARD.ENABLE_DEBUG(:BUFFER_SIZE); end;');
1020: STPROC.BIND_I(BUFFER_SIZE);
1021: STPROC.EXECUTE;
1022: END ENABLE_DEBUG;
1023:

Line 1026: STPROC.INIT('begin ARP_STANDARD.DISABLE_DEBUG; end;');

1022: END ENABLE_DEBUG;
1023:
1024: PROCEDURE DISABLE_DEBUG IS
1025: BEGIN
1026: STPROC.INIT('begin ARP_STANDARD.DISABLE_DEBUG; end;');
1027: STPROC.EXECUTE;
1028: END DISABLE_DEBUG;
1029:
1030: PROCEDURE SET_WHO_INFORMATION(USER_ID IN NUMBER

Line 1036: STPROC.INIT('begin ARP_STANDARD.SET_WHO_INFORMATION(:USER_ID, :REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, :LAST_UPDATE_LOGIN); end;');

1032: ,PROGRAM_APPLICATION_ID IN NUMBER
1033: ,PROGRAM_ID IN NUMBER
1034: ,LAST_UPDATE_LOGIN IN NUMBER) IS
1035: BEGIN
1036: STPROC.INIT('begin ARP_STANDARD.SET_WHO_INFORMATION(:USER_ID, :REQUEST_ID, :PROGRAM_APPLICATION_ID, :PROGRAM_ID, :LAST_UPDATE_LOGIN); end;');
1037: STPROC.BIND_I(USER_ID);
1038: STPROC.BIND_I(REQUEST_ID);
1039: STPROC.BIND_I(PROGRAM_APPLICATION_ID);
1040: STPROC.BIND_I(PROGRAM_ID);

Line 1048: STPROC.INIT('begin ARP_STANDARD.SET_APPLICATION_INFORMATION(:APPL_ID, :LANGUAGE_ID); end;');

1044:
1045: PROCEDURE SET_APPLICATION_INFORMATION(APPL_ID IN NUMBER
1046: ,LANGUAGE_ID IN NUMBER) IS
1047: BEGIN
1048: STPROC.INIT('begin ARP_STANDARD.SET_APPLICATION_INFORMATION(:APPL_ID, :LANGUAGE_ID); end;');
1049: STPROC.BIND_I(APPL_ID);
1050: STPROC.BIND_I(LANGUAGE_ID);
1051: STPROC.EXECUTE;
1052: END SET_APPLICATION_INFORMATION;*/

Line 1056: ARP_STANDARD.FND_MESSAGE;

1052: END SET_APPLICATION_INFORMATION;*/
1053:
1054: PROCEDURE FND_MESSAGE IS
1055: BEGIN
1056: ARP_STANDARD.FND_MESSAGE;
1057: /*
1058: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE; end;');
1059: STPROC.EXECUTE;*/
1060: END FND_MESSAGE;

Line 1058: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE; end;');

1054: PROCEDURE FND_MESSAGE IS
1055: BEGIN
1056: ARP_STANDARD.FND_MESSAGE;
1057: /*
1058: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE; end;');
1059: STPROC.EXECUTE;*/
1060: END FND_MESSAGE;
1061:
1062: /* PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2) IS

Line 1064: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME); end;');

1060: END FND_MESSAGE;
1061:
1062: /* PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2) IS
1063: BEGIN
1064: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME); end;');
1065: STPROC.BIND_I(MSG_NAME);
1066: STPROC.EXECUTE;
1067: END FND_MESSAGE;
1068:

Line 1073: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1); end;');

1069: PROCEDURE FND_MESSAGE(MSG_NAME IN VARCHAR2
1070: ,T1 IN VARCHAR2
1071: ,V1 IN VARCHAR2) IS
1072: BEGIN
1073: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1); end;');
1074: STPROC.BIND_I(MSG_NAME);
1075: STPROC.BIND_I(T1);
1076: STPROC.BIND_I(V1);
1077: STPROC.EXECUTE;

Line 1086: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2); end;');

1082: ,V1 IN VARCHAR2
1083: ,T2 IN VARCHAR2
1084: ,V2 IN VARCHAR2) IS
1085: BEGIN
1086: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2); end;');
1087: STPROC.BIND_I(MSG_NAME);
1088: STPROC.BIND_I(T1);
1089: STPROC.BIND_I(V1);
1090: STPROC.BIND_I(T2);

Line 1103: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');

1099: ,V2 IN VARCHAR2
1100: ,T3 IN VARCHAR2
1101: ,V3 IN VARCHAR2) IS
1102: BEGIN
1103: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');
1104: STPROC.BIND_I(MSG_NAME);
1105: STPROC.BIND_I(T1);
1106: STPROC.BIND_I(V1);
1107: STPROC.BIND_I(T2);

Line 1124: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');

1120: ,V3 IN VARCHAR2
1121: ,T4 IN VARCHAR2
1122: ,V4 IN VARCHAR2) IS
1123: BEGIN
1124: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');
1125: STPROC.BIND_I(MSG_NAME);
1126: STPROC.BIND_I(T1);
1127: STPROC.BIND_I(V1);
1128: STPROC.BIND_I(T2);

Line 1139: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS); end;');

1135: END FND_MESSAGE;
1136:
1137: PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER) IS
1138: BEGIN
1139: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS); end;');
1140: STPROC.BIND_I(MD_OPTIONS);
1141: STPROC.EXECUTE;
1142: END FND_MESSAGE;
1143:

Line 1147: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME); end;');

1143:
1144: PROCEDURE FND_MESSAGE(MD_OPTIONS IN NUMBER
1145: ,MSG_NAME IN VARCHAR2) IS
1146: BEGIN
1147: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME); end;');
1148: STPROC.BIND_I(MD_OPTIONS);
1149: STPROC.BIND_I(MSG_NAME);
1150: STPROC.EXECUTE;
1151: END FND_MESSAGE;

Line 1158: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1); end;');

1154: ,MSG_NAME IN VARCHAR2
1155: ,T1 IN VARCHAR2
1156: ,V1 IN VARCHAR2) IS
1157: BEGIN
1158: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1); end;');
1159: STPROC.BIND_I(MD_OPTIONS);
1160: STPROC.BIND_I(MSG_NAME);
1161: STPROC.BIND_I(T1);
1162: STPROC.BIND_I(V1);

Line 1173: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2); end;');

1169: ,V1 IN VARCHAR2
1170: ,T2 IN VARCHAR2
1171: ,V2 IN VARCHAR2) IS
1172: BEGIN
1173: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2); end;');
1174: STPROC.BIND_I(MD_OPTIONS);
1175: STPROC.BIND_I(MSG_NAME);
1176: STPROC.BIND_I(T1);
1177: STPROC.BIND_I(V1);

Line 1192: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');

1188: ,V2 IN VARCHAR2
1189: ,T3 IN VARCHAR2
1190: ,V3 IN VARCHAR2) IS
1191: BEGIN
1192: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3); end;');
1193: STPROC.BIND_I(MD_OPTIONS);
1194: STPROC.BIND_I(MSG_NAME);
1195: STPROC.BIND_I(T1);
1196: STPROC.BIND_I(V1);

Line 1215: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');

1211: ,V3 IN VARCHAR2
1212: ,T4 IN VARCHAR2
1213: ,V4 IN VARCHAR2) IS
1214: BEGIN
1215: STPROC.INIT('begin ARP_STANDARD.FND_MESSAGE(:MD_OPTIONS, :MSG_NAME, :T1, :V1, :T2, :V2, :T3, :V3, :T4, :V4); end;');
1216: STPROC.BIND_I(MD_OPTIONS);
1217: STPROC.BIND_I(MSG_NAME);
1218: STPROC.BIND_I(T1);
1219: STPROC.BIND_I(V1);

Line 1236: STPROC.INIT('begin ARP_STANDARD.GL_ACTIVITY(:P_PERIOD_FROM, :P_PERIOD_TO, :P_CODE_COMBINATION_ID, :P_SET_OF_BOOKS_ID, :P_PERIOD_NET_DR, :P_PERIOD_NET_CR); end;');

1232: ,P_SET_OF_BOOKS_ID IN NUMBER
1233: ,P_PERIOD_NET_DR OUT NOCOPY NUMBER
1234: ,P_PERIOD_NET_CR OUT NOCOPY NUMBER) IS
1235: BEGIN
1236: STPROC.INIT('begin ARP_STANDARD.GL_ACTIVITY(:P_PERIOD_FROM, :P_PERIOD_TO, :P_CODE_COMBINATION_ID, :P_SET_OF_BOOKS_ID, :P_PERIOD_NET_DR, :P_PERIOD_NET_CR); end;');
1237: STPROC.BIND_I(P_PERIOD_FROM);
1238: STPROC.BIND_I(P_PERIOD_TO);
1239: STPROC.BIND_I(P_CODE_COMBINATION_ID);
1240: STPROC.BIND_I(P_SET_OF_BOOKS_ID);

Line 1258: begin P_CHK_APPLIED_CM := sys.diutil.int_to_bool(:P_CHK_APPLIED_CM); ARP_STANDARD.FIND_PREVIOUS_TRX_LINE_ID(:P_CUSTOMER_TRX_LINE_ID, :P_TAX_LINE_NUMBER,

1254: ,P_TAX_CUSTOMER_TRX_LINE_ID OUT NOCOPY NUMBER
1255: ,P_CHK_APPLIED_CM IN BOOLEAN) IS
1256: BEGIN
1257: STPROC.INIT('declare P_CHK_APPLIED_CM BOOLEAN;
1258: begin P_CHK_APPLIED_CM := sys.diutil.int_to_bool(:P_CHK_APPLIED_CM); ARP_STANDARD.FIND_PREVIOUS_TRX_LINE_ID(:P_CUSTOMER_TRX_LINE_ID, :P_TAX_LINE_NUMBER,
1259: :P_VAT_TAX_ID, :P_TAX_CUSTOMER_TRX_ID, :P_TAX_CUSTOMER_TRX_LINE_ID, P_CHK_APPLIED_CM);
1260: end;');
1261: STPROC.BIND_I(P_CHK_APPLIED_CM);
1262: STPROC.BIND_I(P_CUSTOMER_TRX_LINE_ID);