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.PER_PERUSEOC_XMLP_PKG dependencies on HR_GENERAL

Line 570: HR_GENERAL.ASSERT_CONDITION(P_CONDITION); end;');

566: PROCEDURE ASSERT_CONDITION(P_CONDITION IN BOOLEAN) IS
567: BEGIN
568: /*STPROC.INIT('declare P_CONDITION BOOLEAN;
569: begin P_CONDITION := sys.diutil.int_to_bool(:P_CONDITION);
570: HR_GENERAL.ASSERT_CONDITION(P_CONDITION); end;');
571: STPROC.BIND_I(P_CONDITION);
572: STPROC.EXECUTE;*/null;
573: END ASSERT_CONDITION;
574:

Line 578: X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID;

574:
575: FUNCTION GET_BUSINESS_GROUP_ID RETURN NUMBER IS
576: X0 NUMBER;
577: BEGIN
578: X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID;
579: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID; end;');
580: STPROC.BIND_O(X0);
581: STPROC.EXECUTE;
582: STPROC.RETRIEVE(1

Line 579: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID; end;');

575: FUNCTION GET_BUSINESS_GROUP_ID RETURN NUMBER IS
576: X0 NUMBER;
577: BEGIN
578: X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID;
579: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_BUSINESS_GROUP_ID; end;');
580: STPROC.BIND_O(X0);
581: STPROC.EXECUTE;
582: STPROC.RETRIEVE(1
583: ,X0);*/null;

Line 590: /*STPROC.INIT('begin :X0 := HR_GENERAL.CHK_APPLICATION_ID(:P_APPLICATION_ID); end;');

586:
587: FUNCTION CHK_APPLICATION_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
588: X0 VARCHAR2(2000);
589: BEGIN
590: /*STPROC.INIT('begin :X0 := HR_GENERAL.CHK_APPLICATION_ID(:P_APPLICATION_ID); end;');
591: STPROC.BIND_O(X0);
592: STPROC.BIND_I(P_APPLICATION_ID);
593: STPROC.EXECUTE;
594: STPROC.RETRIEVE(1

Line 602: /*STPROC.INIT('begin :X0 := HR_GENERAL.CORE_HR_APP_ID(:P_APPLICATION_ID); end;');

598:
599: FUNCTION CORE_HR_APP_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
600: X0 VARCHAR2(2000);
601: BEGIN
602: /*STPROC.INIT('begin :X0 := HR_GENERAL.CORE_HR_APP_ID(:P_APPLICATION_ID); end;');
603: STPROC.BIND_O(X0);
604: STPROC.BIND_I(P_APPLICATION_ID);
605: STPROC.EXECUTE;
606: STPROC.RETRIEVE(1

Line 614: /*STPROC.INIT('begin :X0 := HR_GENERAL.VERTICAL_APP_ID(:P_APPLICATION_ID); end;');

610:
611: FUNCTION VERTICAL_APP_ID(P_APPLICATION_ID IN NUMBER) RETURN VARCHAR2 IS
612: X0 VARCHAR2(2000);
613: BEGIN
614: /*STPROC.INIT('begin :X0 := HR_GENERAL.VERTICAL_APP_ID(:P_APPLICATION_ID); end;');
615: STPROC.BIND_O(X0);
616: STPROC.BIND_I(P_APPLICATION_ID);
617: STPROC.EXECUTE;
618: STPROC.RETRIEVE(1

Line 626: /* STPROC.INIT('begin :X0 := HR_GENERAL.HRMS_OBJECT(:P_OBJECT_NAME); end;');

622:
623: FUNCTION HRMS_OBJECT(P_OBJECT_NAME IN VARCHAR2) RETURN VARCHAR2 IS
624: X0 VARCHAR2(2000);
625: BEGIN
626: /* STPROC.INIT('begin :X0 := HR_GENERAL.HRMS_OBJECT(:P_OBJECT_NAME); end;');
627: STPROC.BIND_O(X0);
628: STPROC.BIND_I(P_OBJECT_NAME);
629: STPROC.EXECUTE;
630: STPROC.RETRIEVE(1

Line 638: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_APPLICATION_SHORT_NAME(:P_APPLICATION_ID); end;');

634:
635: FUNCTION GET_APPLICATION_SHORT_NAME(P_APPLICATION_ID IN VARCHAR2) RETURN VARCHAR2 IS
636: X0 VARCHAR2(2000);
637: BEGIN
638: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_APPLICATION_SHORT_NAME(:P_APPLICATION_ID); end;');
639: STPROC.BIND_O(X0);
640: STPROC.BIND_I(P_APPLICATION_ID);
641: STPROC.EXECUTE;
642: STPROC.RETRIEVE(1

Line 650: /*STPROC.INIT('begin :X0 := HR_GENERAL.EFFECTIVE_DATE; end;');

646:
647: FUNCTION EFFECTIVE_DATE RETURN DATE IS
648: X0 DATE;
649: BEGIN
650: /*STPROC.INIT('begin :X0 := HR_GENERAL.EFFECTIVE_DATE; end;');
651: STPROC.BIND_O(X0);
652: STPROC.EXECUTE;
653: STPROC.RETRIEVE(1
654: ,X0);*/null;

Line 661: /*STPROC.INIT('begin :X0 := HR_GENERAL.START_OF_TIME; end;');

657:
658: FUNCTION START_OF_TIME RETURN DATE IS
659: X0 DATE;
660: BEGIN
661: /*STPROC.INIT('begin :X0 := HR_GENERAL.START_OF_TIME; end;');
662: STPROC.BIND_O(X0);
663: STPROC.EXECUTE;
664: STPROC.RETRIEVE(1
665: ,X0);*/null;

Line 672: /*STPROC.INIT('begin :X0 := HR_GENERAL.END_OF_TIME; end;');

668:
669: FUNCTION END_OF_TIME RETURN DATE IS
670: X0 DATE;
671: BEGIN
672: /*STPROC.INIT('begin :X0 := HR_GENERAL.END_OF_TIME; end;');
673: STPROC.BIND_O(X0);
674: STPROC.EXECUTE;
675: STPROC.RETRIEVE(1
676: ,X0);*/null;

Line 683: /*STPROC.INIT('begin :X0 := HR_GENERAL.PAY_VALUE; end;');

679:
680: FUNCTION PAY_VALUE RETURN VARCHAR2 IS
681: X0 VARCHAR2(2000);
682: BEGIN
683: /*STPROC.INIT('begin :X0 := HR_GENERAL.PAY_VALUE; end;');
684: STPROC.BIND_O(X0);
685: STPROC.EXECUTE;
686: STPROC.RETRIEVE(1
687: ,X0);*/null;

Line 694: /*STPROC.INIT('begin :X0 := HR_GENERAL.MONEY_UNIT; end;');

690:
691: FUNCTION MONEY_UNIT RETURN VARCHAR2 IS
692: X0 VARCHAR2(2000);
693: BEGIN
694: /*STPROC.INIT('begin :X0 := HR_GENERAL.MONEY_UNIT; end;');
695: STPROC.BIND_O(X0);
696: STPROC.EXECUTE;
697: STPROC.RETRIEVE(1
698: ,X0);*/null;

Line 705: /*STPROC.INIT('begin :X0 := HR_GENERAL.DEFAULT_CURRENCY_CODE(:P_LEGISLATION_CODE); end;');

701:
702: FUNCTION DEFAULT_CURRENCY_CODE(P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
703: X0 VARCHAR2(2000);
704: BEGIN
705: /*STPROC.INIT('begin :X0 := HR_GENERAL.DEFAULT_CURRENCY_CODE(:P_LEGISLATION_CODE); end;');
706: STPROC.BIND_O(X0);
707: STPROC.BIND_I(P_LEGISLATION_CODE);
708: STPROC.EXECUTE;
709: STPROC.RETRIEVE(1

Line 717: /*STPROC.INIT('begin :X0 := HR_GENERAL.DEFAULT_CURRENCY_CODE(:P_BUSINESS_GROUP_ID); end;');

713:
714: FUNCTION DEFAULT_CURRENCY_CODE(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
715: X0 VARCHAR2(2000);
716: BEGIN
717: /*STPROC.INIT('begin :X0 := HR_GENERAL.DEFAULT_CURRENCY_CODE(:P_BUSINESS_GROUP_ID); end;');
718: STPROC.BIND_O(X0);
719: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
720: STPROC.EXECUTE;
721: STPROC.RETRIEVE(1

Line 733: X0rv := HR_GENERAL.LOCATION_VALID(:P_LOCATION_ID, :P_DATE, X0P_ERROR_IF_INVALID);

729: X0 BOOLEAN;
730: BEGIN
731: /*STPROC.INIT('declare X0rv BOOLEAN; X0P_ERROR_IF_INVALID BOOLEAN;
732: begin X0P_ERROR_IF_INVALID := sys.diutil.int_to_bool(:P_ERROR_IF_INVALID);
733: X0rv := HR_GENERAL.LOCATION_VALID(:P_LOCATION_ID, :P_DATE, X0P_ERROR_IF_INVALID);
734: :X0 := sys.diutil.bool_to_int(X0rv); end;');
735: STPROC.BIND_I(P_ERROR_IF_INVALID);
736: STPROC.BIND_I(P_LOCATION_ID);
737: STPROC.BIND_I(P_DATE);

Line 749: /* STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_LOOKUP(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');

745: FUNCTION DECODE_LOOKUP(P_LOOKUP_TYPE IN VARCHAR2
746: ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
747: X0 VARCHAR2(2000);
748: BEGIN
749: /* STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_LOOKUP(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
750: STPROC.BIND_O(X0);
751: STPROC.BIND_I(P_LOOKUP_TYPE);
752: STPROC.BIND_I(P_LOOKUP_CODE);
753: STPROC.EXECUTE;

Line 762: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_GRADE(:P_GRADE_ID); end;');

758:
759: FUNCTION DECODE_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2 IS
760: X0 VARCHAR2(2000);
761: BEGIN
762: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_GRADE(:P_GRADE_ID); end;');
763: STPROC.BIND_O(X0);
764: STPROC.BIND_I(P_GRADE_ID);
765: STPROC.EXECUTE;
766: STPROC.RETRIEVE(1

Line 774: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_PAYROLL(:P_PAYROLL_ID); end;');

770:
771: FUNCTION DECODE_PAYROLL(P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2 IS
772: X0 VARCHAR2(2000);
773: BEGIN
774: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_PAYROLL(:P_PAYROLL_ID); end;');
775: STPROC.BIND_O(X0);
776: STPROC.BIND_I(P_PAYROLL_ID);
777: STPROC.EXECUTE;
778: STPROC.RETRIEVE(1

Line 787: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_SALARY(:P_PAY_BASIS_ID, :P_ASSIGNMENT_ID); end;');

783: FUNCTION GET_SALARY(P_PAY_BASIS_ID IN NUMBER
784: ,P_ASSIGNMENT_ID IN NUMBER) RETURN VARCHAR2 IS
785: X0 VARCHAR2(2000);
786: BEGIN
787: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_SALARY(:P_PAY_BASIS_ID, :P_ASSIGNMENT_ID); end;');
788: STPROC.BIND_O(X0);
789: STPROC.BIND_I(P_PAY_BASIS_ID);
790: STPROC.BIND_I(P_ASSIGNMENT_ID);
791: STPROC.EXECUTE;

Line 800: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_JOB(:P_JOB_ID); end;');

796:
797: FUNCTION DECODE_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2 IS
798: X0 VARCHAR2(2000);
799: BEGIN
800: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_JOB(:P_JOB_ID); end;');
801: STPROC.BIND_O(X0);
802: STPROC.BIND_I(P_JOB_ID);
803: STPROC.EXECUTE;
804: STPROC.RETRIEVE(1

Line 812: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_POSITION(:P_POSITION_ID); end;');

808:
809: FUNCTION DECODE_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2 IS
810: X0 VARCHAR2(2000);
811: BEGIN
812: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_POSITION(:P_POSITION_ID); end;');
813: STPROC.BIND_O(X0);
814: STPROC.BIND_I(P_POSITION_ID);
815: STPROC.EXECUTE;
816: STPROC.RETRIEVE(1

Line 824: /* STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_LOCATION(:P_LOCATION_ID); end;');

820:
821: FUNCTION DECODE_LOCATION(P_LOCATION_ID IN NUMBER) RETURN VARCHAR2 IS
822: X0 VARCHAR2(2000);
823: BEGIN
824: /* STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_LOCATION(:P_LOCATION_ID); end;');
825: STPROC.BIND_O(X0);
826: STPROC.BIND_I(P_LOCATION_ID);
827: STPROC.EXECUTE;
828: STPROC.RETRIEVE(1

Line 836: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_PAY_BASIS(:P_PAY_BASIS_ID); end;');

832:
833: FUNCTION DECODE_PAY_BASIS(P_PAY_BASIS_ID IN NUMBER) RETURN VARCHAR2 IS
834: X0 VARCHAR2(2000);
835: BEGIN
836: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_PAY_BASIS(:P_PAY_BASIS_ID); end;');
837: STPROC.BIND_O(X0);
838: STPROC.BIND_I(P_PAY_BASIS_ID);
839: STPROC.EXECUTE;
840: STPROC.RETRIEVE(1

Line 849: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_ASS_STATUS_TYPE(:P_ASSIGNMENT_STATUS_TYPE_ID, :P_BUSINESS_GROUP_ID); end;');

845: FUNCTION DECODE_ASS_STATUS_TYPE(P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
846: ,P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
847: X0 VARCHAR2(2000);
848: BEGIN
849: /*STPROC.INIT('begin :X0 := HR_GENERAL.DECODE_ASS_STATUS_TYPE(:P_ASSIGNMENT_STATUS_TYPE_ID, :P_BUSINESS_GROUP_ID); end;');
850: STPROC.BIND_O(X0);
851: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);
852: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
853: STPROC.EXECUTE;

Line 862: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_WORK_PHONE(:P_PERSON_ID); end;');

858:
859: FUNCTION GET_WORK_PHONE(P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
860: X0 VARCHAR2(2000);
861: BEGIN
862: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_WORK_PHONE(:P_PERSON_ID); end;');
863: STPROC.BIND_O(X0);
864: STPROC.BIND_I(P_PERSON_ID);
865: STPROC.EXECUTE;
866: STPROC.RETRIEVE(1

Line 874: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_HOME_PHONE(:P_PERSON_ID); end;');

870:
871: FUNCTION GET_HOME_PHONE(P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
872: X0 VARCHAR2(2000);
873: BEGIN
874: /*STPROC.INIT('begin :X0 := HR_GENERAL.GET_HOME_PHONE(:P_PERSON_ID); end;');
875: STPROC.BIND_O(X0);
876: STPROC.BIND_I(P_PERSON_ID);
877: STPROC.EXECUTE;
878: STPROC.RETRIEVE(1

Line 897: HR_GENERAL.INIT_FORMS(:P_BUSINESS_GROUP_ID, :P_SHORT_NAME, :P_BG_NAME,

893: ,P_ENABLE_HR_TRACE IN BOOLEAN) IS
894: BEGIN
895: /*STPROC.INIT('declare P_ENABLE_HR_TRACE BOOLEAN;
896: begin P_ENABLE_HR_TRACE := sys.diutil.int_to_bool(:P_ENABLE_HR_TRACE);
897: HR_GENERAL.INIT_FORMS(:P_BUSINESS_GROUP_ID, :P_SHORT_NAME, :P_BG_NAME,
898: :P_BG_CURRENCY_CODE, :P_LEGISLATION_CODE, :P_SESSION_DATE, :P_SES_YESTERDAY,
899: :P_START_OF_TIME, :P_END_OF_TIME, :P_SYS_DATE, P_ENABLE_HR_TRACE); end;');
900: STPROC.BIND_I(P_ENABLE_HR_TRACE);
901: STPROC.BIND_I(P_BUSINESS_GROUP_ID);

Line 935: /*STPROC.INIT('begin :X0 := HR_GENERAL.CHK_GEOCODES_INSTALLED; end;');

931:
932: FUNCTION CHK_GEOCODES_INSTALLED RETURN VARCHAR2 IS
933: X0 VARCHAR2(2000);
934: BEGIN
935: /*STPROC.INIT('begin :X0 := HR_GENERAL.CHK_GEOCODES_INSTALLED; end;');
936: STPROC.BIND_O(X0);
937: STPROC.EXECUTE;
938: STPROC.RETRIEVE(1
939: ,X0);*/null;