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.PAY_PAYRP940_XMLP_PKG dependencies on HR_REPORTS

Line 8: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);

4: BEGIN
5: -- HR_STANDARD.EVENT('BEFORE REPORT');
6: C_GAZ_START_DATE := TO_DATE('01-01-' || P_TAX_YEAR
7: ,'DD-MM-YYYY');
8: C_BUSINESS_GROUP_NAME := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
9: IF P_TAX_UNIT_ID IS NOT NULL THEN
10: C_TAX_UNIT := HR_US_REPORTS.GET_ORG_NAME(P_TAX_UNIT_ID
11: ,P_BUSINESS_GROUP_ID);
12: END IF;

Line 693: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');

689:
690: FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2 IS
691: X0 VARCHAR2(2000);
692: BEGIN
693: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
694: STPROC.BIND_O(X0);
695: STPROC.BIND_I(P_BUDGET_ID);
696: STPROC.EXECUTE;
697: STPROC.RETRIEVE(1

Line 706: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');

702: FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
703: ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2 IS
704: X0 VARCHAR2(2000);
705: BEGIN
706: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
707: STPROC.BIND_O(X0);
708: STPROC.BIND_I(P_BUDGET_ID);
709: STPROC.BIND_I(P_BUDGET_VERSION_ID);
710: STPROC.EXECUTE;

Line 720: /* STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');

716: PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
717: ,P_ORG_NAME OUT NOCOPY VARCHAR2
718: ,P_ORG_TYPE OUT NOCOPY VARCHAR2) IS
719: BEGIN
720: /* STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');
721: STPROC.BIND_I(P_ORGANIZATION_ID);
722: STPROC.BIND_O(P_ORG_NAME);
723: STPROC.BIND_O(P_ORG_TYPE);
724: STPROC.EXECUTE;

Line 735: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');

731:
732: FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2 IS
733: X0 VARCHAR2(2000);
734: BEGIN
735: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
736: STPROC.BIND_O(X0);
737: STPROC.BIND_I(P_JOB_ID);
738: STPROC.EXECUTE;
739: STPROC.RETRIEVE(1

Line 747: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');

743:
744: FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2 IS
745: X0 VARCHAR2(2000);
746: BEGIN
747: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
748: STPROC.BIND_O(X0);
749: STPROC.BIND_I(P_POSITION_ID);
750: STPROC.EXECUTE;
751: STPROC.RETRIEVE(1

Line 759: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');

755:
756: FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2 IS
757: X0 VARCHAR2(2000);
758: BEGIN
759: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
760: STPROC.BIND_O(X0);
761: STPROC.BIND_I(P_GRADE_ID);
762: STPROC.EXECUTE;
763: STPROC.RETRIEVE(1

Line 773: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');

769: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
770: ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
771: X0 VARCHAR2(2000);
772: BEGIN
773: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID, :P_LEGISLATION_CODE); end;');
774: STPROC.BIND_O(X0);
775: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
776: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);
777: STPROC.BIND_I(P_LEGISLATION_CODE);

Line 787: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');

783:
784: FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
785: X0 VARCHAR2(2000);
786: BEGIN
787: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
788: STPROC.BIND_O(X0);
789: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
790: STPROC.EXECUTE;
791: STPROC.RETRIEVE(1

Line 801: /* STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');

797: ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
798: ,P_START_DATE OUT NOCOPY DATE
799: ,P_END_DATE OUT NOCOPY DATE) IS
800: BEGIN
801: /* STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE, :P_END_DATE); end;');
802: STPROC.BIND_I(P_TIME_PERIOD_ID);
803: STPROC.BIND_O(P_PERIOD_NAME);
804: STPROC.BIND_O(P_START_DATE);
805: STPROC.BIND_O(P_END_DATE);

Line 819: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');

815:
816: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
817: X0 VARCHAR2(2000);
818: BEGIN
819: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUSINESS_GROUP(:P_BUSINESS_GROUP_ID); end;');
820: STPROC.BIND_O(X0);
821: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
822: STPROC.EXECUTE;
823: STPROC.RETRIEVE(1

Line 832: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');

828: FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
829: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
830: X0 NUMBER;
831: BEGIN
832: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID, :P_PARENT_ORGANIZATION_ID); end;');
833: STPROC.BIND_O(X0);
834: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
835: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);
836: STPROC.EXECUTE;

Line 846: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');

842: FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
843: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
844: X0 NUMBER;
845: BEGIN
846: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID, :P_PARENT_POSITION_ID); end;');
847: STPROC.BIND_O(X0);
848: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
849: STPROC.BIND_I(P_PARENT_POSITION_ID);
850: STPROC.EXECUTE;

Line 863: /* STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID, :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');

859: ,P_ORG_VERSION OUT NOCOPY NUMBER
860: ,P_VERSION_START_DATE OUT NOCOPY DATE
861: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
862: BEGIN
863: /* STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID, :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
864: STPROC.BIND_I(P_ORGANIZATION_STRUCTURE_ID);
865: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
866: STPROC.BIND_O(P_ORG_STRUCTURE_NAME);
867: STPROC.BIND_O(P_ORG_VERSION);

Line 888: /* STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME, :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');

884: ,P_POS_VERSION OUT NOCOPY NUMBER
885: ,P_VERSION_START_DATE OUT NOCOPY DATE
886: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
887: BEGIN
888: /* STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID, :P_POS_STRUCTURE_NAME, :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
889: STPROC.BIND_I(P_POSITION_STRUCTURE_ID);
890: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
891: STPROC.BIND_O(P_POS_STRUCTURE_NAME);
892: STPROC.BIND_O(P_POS_VERSION);

Line 910: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');

906: FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
907: ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
908: X0 VARCHAR2(2000);
909: BEGIN
910: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
911: STPROC.BIND_O(X0);
912: STPROC.BIND_I(P_LOOKUP_TYPE);
913: STPROC.BIND_I(P_LOOKUP_CODE);
914: STPROC.EXECUTE;

Line 928: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');

924: ,P_NO_OF_ESSENTIAL IN NUMBER
925: ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN IS
926: X0 BOOLEAN;
927: BEGIN
928: /* STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID, :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE, :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
929: STPROC.BIND_I(P_PERSON_ID);
930: STPROC.BIND_I(P_JOB_POSITION_ID);
931: STPROC.BIND_I(P_JOB_POSITION_TYPE);
932: STPROC.BIND_I(P_MATCHING_LEVEL);

Line 946: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');

942: FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
943: ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2 IS
944: X0 VARCHAR2(2000);
945: BEGIN
946: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');
947: STPROC.BIND_O(X0);
948: STPROC.BIND_I(P_SESSION_DATE);
949: STPROC.BIND_I(P_PAYROLL_ID);
950: STPROC.EXECUTE;

Line 960: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');

956: FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
957: ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
958: X0 VARCHAR2(2000);
959: BEGIN
960: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');
961: STPROC.BIND_O(X0);
962: STPROC.BIND_I(P_SESSION_DATE);
963: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
964: STPROC.EXECUTE;

Line 974: /* STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');

970: PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
971: ,P_ID_FLEX_NUM IN NUMBER
972: ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2) IS
973: BEGIN
974: /* STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');
975: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
976: STPROC.BIND_I(P_ID_FLEX_NUM);
977: STPROC.BIND_IO(P_MATCHING_LEXICAL);
978: STPROC.EXECUTE;

Line 1017: /* STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6,

1013: ,P_VALUE28 OUT NOCOPY VARCHAR2
1014: ,P_VALUE29 OUT NOCOPY VARCHAR2
1015: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1016: BEGIN
1017: /* STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS, :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5, :P_VALUE6,
1018: :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13, :P_VALUE14, :P_VALUE15, :P_VALUE16,
1019: :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1020: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
1021: STPROC.BIND_I(P_NAME);

Line 1152: /* STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5,

1148: ,P_VALUE28 OUT NOCOPY VARCHAR2
1149: ,P_VALUE29 OUT NOCOPY VARCHAR2
1150: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
1151: BEGIN
1152: /* STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5,
1153: :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13, :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19,
1154: :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29, :P_VALUE30); end;');
1155: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
1156: STPROC.BIND_I(P_ID_FLEX_NUM);

Line 1260: /* STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');

1256: ,P_TITLE OUT NOCOPY VARCHAR2
1257: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1258: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1259: BEGIN
1260: /* STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1261: STPROC.BIND_I(P_APPL_SHORT_NAME);
1262: STPROC.BIND_I(P_DESC_FLEX_NAME);
1263: STPROC.BIND_I(P_TABLE_ALIAS);
1264: STPROC.BIND_O(P_TITLE);

Line 1283: /* STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');

1279: ,P_TITLE OUT NOCOPY VARCHAR2
1280: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1281: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1282: BEGIN
1283: /* STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1284: STPROC.BIND_I(P_APPL_SHORT_NAME);
1285: STPROC.BIND_I(P_DESC_FLEX_NAME);
1286: STPROC.BIND_I(P_TABLE_ALIAS);
1287: STPROC.BIND_O(P_TITLE);

Line 1307: /* STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');

1303: ,P_TITLE OUT NOCOPY VARCHAR2
1304: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
1305: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
1306: BEGIN
1307: /* STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME, :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
1308: STPROC.BIND_I(P_APPL_SHORT_NAME);
1309: STPROC.BIND_I(P_DESC_FLEX_NAME);
1310: STPROC.BIND_I(P_DESC_FLEX_CONTEXT);
1311: STPROC.BIND_I(P_TABLE_ALIAS);

Line 1328: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');

1324: FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
1325: ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
1326: X0 VARCHAR2(2000);
1327: BEGIN
1328: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_PERSON_NAME(:P_SESSION_DATE, :P_PERSON_ID); end;');
1329: STPROC.BIND_O(X0);
1330: STPROC.BIND_I(P_SESSION_DATE);
1331: STPROC.BIND_I(P_PERSON_ID);
1332: STPROC.EXECUTE;