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_PAYGBACT_XMLP_PKG dependencies on HR_REPORTS

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

171:
172: FUNCTION GET_BUDGET(P_BUDGET_ID IN NUMBER) RETURN VARCHAR2 IS
173: X0 VARCHAR2(2000);
174: BEGIN
175: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET(:P_BUDGET_ID); end;');
176: STPROC.BIND_O(X0);
177: STPROC.BIND_I(P_BUDGET_ID);
178: STPROC.EXECUTE;
179: STPROC.RETRIEVE(1

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

184: FUNCTION GET_BUDGET_VERSION(P_BUDGET_ID IN NUMBER
185: ,P_BUDGET_VERSION_ID IN NUMBER) RETURN VARCHAR2 IS
186: X0 VARCHAR2(2000);
187: BEGIN
188: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_BUDGET_VERSION(:P_BUDGET_ID, :P_BUDGET_VERSION_ID); end;');
189: STPROC.BIND_O(X0);
190: STPROC.BIND_I(P_BUDGET_ID);
191: STPROC.BIND_I(P_BUDGET_VERSION_ID);
192: STPROC.EXECUTE;

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

198: PROCEDURE GET_ORGANIZATION(P_ORGANIZATION_ID IN NUMBER
199: ,P_ORG_NAME OUT NOCOPY VARCHAR2
200: ,P_ORG_TYPE OUT NOCOPY VARCHAR2) IS
201: BEGIN
202: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION(:P_ORGANIZATION_ID, :P_ORG_NAME, :P_ORG_TYPE); end;');
203: STPROC.BIND_I(P_ORGANIZATION_ID);
204: STPROC.BIND_O(P_ORG_NAME);
205: STPROC.BIND_O(P_ORG_TYPE);
206: STPROC.EXECUTE;

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

212:
213: FUNCTION GET_JOB(P_JOB_ID IN NUMBER) RETURN VARCHAR2 IS
214: X0 VARCHAR2(2000);
215: BEGIN
216: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_JOB(:P_JOB_ID); end;');
217: STPROC.BIND_O(X0);
218: STPROC.BIND_I(P_JOB_ID);
219: STPROC.EXECUTE;
220: STPROC.RETRIEVE(1

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

224:
225: FUNCTION GET_POSITION(P_POSITION_ID IN NUMBER) RETURN VARCHAR2 IS
226: X0 VARCHAR2(2000);
227: BEGIN
228: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_POSITION(:P_POSITION_ID); end;');
229: STPROC.BIND_O(X0);
230: STPROC.BIND_I(P_POSITION_ID);
231: STPROC.EXECUTE;
232: STPROC.RETRIEVE(1

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

236:
237: FUNCTION GET_GRADE(P_GRADE_ID IN NUMBER) RETURN VARCHAR2 IS
238: X0 VARCHAR2(2000);
239: BEGIN
240: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_GRADE(:P_GRADE_ID); end;');
241: STPROC.BIND_O(X0);
242: STPROC.BIND_I(P_GRADE_ID);
243: STPROC.EXECUTE;
244: STPROC.RETRIEVE(1

Line 254: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID,

250: ,P_ASSIGNMENT_STATUS_TYPE_ID IN NUMBER
251: ,P_LEGISLATION_CODE IN VARCHAR2) RETURN VARCHAR2 IS
252: X0 VARCHAR2(2000);
253: BEGIN
254: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_STATUS(:P_BUSINESS_GROUP_ID, :P_ASSIGNMENT_STATUS_TYPE_ID,
255: :P_LEGISLATION_CODE); end;');
256: STPROC.BIND_O(X0);
257: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
258: STPROC.BIND_I(P_ASSIGNMENT_STATUS_TYPE_ID);

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

265:
266: FUNCTION GET_ABS_TYPE(P_ABS_ATT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
267: X0 VARCHAR2(2000);
268: BEGIN
269: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ABS_TYPE(:P_ABS_ATT_TYPE_ID); end;');
270: STPROC.BIND_O(X0);
271: STPROC.BIND_I(P_ABS_ATT_TYPE_ID);
272: STPROC.EXECUTE;
273: STPROC.RETRIEVE(1

Line 283: /*STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE,

279: ,P_PERIOD_NAME OUT NOCOPY VARCHAR2
280: ,P_START_DATE OUT NOCOPY DATE
281: ,P_END_DATE OUT NOCOPY DATE) IS
282: BEGIN
283: /*STPROC.INIT('begin HR_REPORTS.GET_TIME_PERIOD(:P_TIME_PERIOD_ID, :P_PERIOD_NAME, :P_START_DATE,
284: :P_END_DATE); end;');
285: STPROC.BIND_I(P_TIME_PERIOD_ID);
286: STPROC.BIND_O(P_PERIOD_NAME);
287: STPROC.BIND_O(P_START_DATE);

Line 301: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);

297:
298: FUNCTION GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID IN NUMBER) RETURN VARCHAR2 IS
299: X0 VARCHAR2(2000);
300: BEGIN
301: X0 := HR_REPORTS.GET_BUSINESS_GROUP(P_BUSINESS_GROUP_ID);
302: /*STPROC.BIND_O(X0);
303: STPROC.BIND_I(P_BUSINESS_GROUP_ID);
304: STPROC.EXECUTE;
305: STPROC.RETRIEVE(1

Line 314: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID,

310: FUNCTION COUNT_ORG_SUBORDINATES(P_ORG_STRUCTURE_VERSION_ID IN NUMBER
311: ,P_PARENT_ORGANIZATION_ID IN NUMBER) RETURN NUMBER IS
312: X0 NUMBER;
313: BEGIN
314: /* STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_ORG_SUBORDINATES(:P_ORG_STRUCTURE_VERSION_ID,
315: :P_PARENT_ORGANIZATION_ID); end;');
316: STPROC.BIND_O(X0);
317: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);
318: STPROC.BIND_I(P_PARENT_ORGANIZATION_ID);

Line 329: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID,

325: FUNCTION COUNT_POS_SUBORDINATES(P_POS_STRUCTURE_VERSION_ID IN NUMBER
326: ,P_PARENT_POSITION_ID IN NUMBER) RETURN NUMBER IS
327: X0 NUMBER;
328: BEGIN
329: /*STPROC.INIT('begin :X0 := HR_REPORTS.COUNT_POS_SUBORDINATES(:P_POS_STRUCTURE_VERSION_ID,
330: :P_PARENT_POSITION_ID); end;');
331: STPROC.BIND_O(X0);
332: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
333: STPROC.BIND_I(P_PARENT_POSITION_ID);

Line 347: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID,

343: ,P_ORG_VERSION OUT NOCOPY NUMBER
344: ,P_VERSION_START_DATE OUT NOCOPY DATE
345: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
346: BEGIN
347: /*STPROC.INIT('begin HR_REPORTS.GET_ORGANIZATION_HIERARCHY(:P_ORGANIZATION_STRUCTURE_ID,
348: :P_ORG_STRUCTURE_VERSION_ID, :P_ORG_STRUCTURE_NAME, :P_ORG_VERSION, :P_VERSION_START_DATE,
349: :P_VERSION_END_DATE); end;');
350: STPROC.BIND_I(P_ORGANIZATION_STRUCTURE_ID);
351: STPROC.BIND_I(P_ORG_STRUCTURE_VERSION_ID);

Line 374: /*STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID,

370: ,P_POS_VERSION OUT NOCOPY NUMBER
371: ,P_VERSION_START_DATE OUT NOCOPY DATE
372: ,P_VERSION_END_DATE OUT NOCOPY DATE) IS
373: BEGIN
374: /*STPROC.INIT('begin HR_REPORTS.GET_POSITION_HIERARCHY(:P_POSITION_STRUCTURE_ID, :P_POS_STRUCTURE_VERSION_ID,
375: :P_POS_STRUCTURE_NAME, :P_POS_VERSION, :P_VERSION_START_DATE, :P_VERSION_END_DATE); end;');
376: STPROC.BIND_I(P_POSITION_STRUCTURE_ID);
377: STPROC.BIND_I(P_POS_STRUCTURE_VERSION_ID);
378: STPROC.BIND_O(P_POS_STRUCTURE_NAME);

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

393: FUNCTION GET_LOOKUP_MEANING(P_LOOKUP_TYPE IN VARCHAR2
394: ,P_LOOKUP_CODE IN VARCHAR2) RETURN VARCHAR2 IS
395: X0 VARCHAR2(2000);
396: BEGIN
397: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_LOOKUP_MEANING(:P_LOOKUP_TYPE, :P_LOOKUP_CODE); end;');
398: STPROC.BIND_O(X0);
399: STPROC.BIND_I(P_LOOKUP_TYPE);
400: STPROC.BIND_I(P_LOOKUP_CODE);
401: STPROC.EXECUTE;

Line 415: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID,

411: ,P_NO_OF_ESSENTIAL IN NUMBER
412: ,P_NO_OF_DESIRABLE IN NUMBER) RETURN BOOLEAN IS
413: X0 BOOLEAN;
414: BEGIN
415: /*STPROC.INIT('declare X0rv BOOLEAN; begin X0rv := HR_REPORTS.PERSON_MATCHING_SKILLS(:P_PERSON_ID,
416: :P_JOB_POSITION_ID, :P_JOB_POSITION_TYPE,
417: :P_MATCHING_LEVEL, :P_NO_OF_ESSENTIAL, :P_NO_OF_DESIRABLE); :X0 := sys.diutil.bool_to_int(X0rv); end;');
418: STPROC.BIND_I(P_PERSON_ID);
419: STPROC.BIND_I(P_JOB_POSITION_ID);

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

431: FUNCTION GET_PAYROLL_NAME(P_SESSION_DATE IN DATE
432: ,P_PAYROLL_ID IN NUMBER) RETURN VARCHAR2 IS
433: X0 VARCHAR2(2000);
434: BEGIN
435: /* STPROC.INIT('begin :X0 := HR_REPORTS.GET_PAYROLL_NAME(:P_SESSION_DATE, :P_PAYROLL_ID); end;');
436: STPROC.BIND_O(X0);
437: STPROC.BIND_I(P_SESSION_DATE);
438: STPROC.BIND_I(P_PAYROLL_ID);
439: STPROC.EXECUTE;

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

445: FUNCTION GET_ELEMENT_NAME(P_SESSION_DATE IN DATE
446: ,P_ELEMENT_TYPE_ID IN NUMBER) RETURN VARCHAR2 IS
447: X0 VARCHAR2(2000);
448: BEGIN
449: /*STPROC.INIT('begin :X0 := HR_REPORTS.GET_ELEMENT_NAME(:P_SESSION_DATE, :P_ELEMENT_TYPE_ID); end;');
450: STPROC.BIND_O(X0);
451: STPROC.BIND_I(P_SESSION_DATE);
452: STPROC.BIND_I(P_ELEMENT_TYPE_ID);
453: STPROC.EXECUTE;

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

459: PROCEDURE GEN_PARTIAL_MATCHING_LEXICAL(P_CONCATENATED_SEGMENTS IN VARCHAR2
460: ,P_ID_FLEX_NUM IN NUMBER
461: ,P_MATCHING_LEXICAL IN OUT NOCOPY VARCHAR2) IS
462: BEGIN
463: /* STPROC.INIT('begin HR_REPORTS.GEN_PARTIAL_MATCHING_LEXICAL(:P_CONCATENATED_SEGMENTS, :P_ID_FLEX_NUM, :P_MATCHING_LEXICAL); end;');
464: STPROC.BIND_I(P_CONCATENATED_SEGMENTS);
465: STPROC.BIND_I(P_ID_FLEX_NUM);
466: STPROC.BIND_IO(P_MATCHING_LEXICAL);
467: STPROC.EXECUTE;

Line 506: /* STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS,

502: ,P_VALUE28 OUT NOCOPY VARCHAR2
503: ,P_VALUE29 OUT NOCOPY VARCHAR2
504: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
505: BEGIN
506: /* STPROC.INIT('begin HR_REPORTS.GET_ATTRIBUTES(:P_CONCATENATED_SEGMENTS,
507: :P_NAME, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4, :P_VALUE5,
508: :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11, :P_VALUE12, :P_VALUE13,
509: :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18, :P_VALUE19, :P_VALUE20, :P_VALUE21,
510: :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25, :P_VALUE26, :P_VALUE27, :P_VALUE28, :P_VALUE29,

Line 644: /*STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS,

640: ,P_VALUE28 OUT NOCOPY VARCHAR2
641: ,P_VALUE29 OUT NOCOPY VARCHAR2
642: ,P_VALUE30 OUT NOCOPY VARCHAR2) IS
643: BEGIN
644: /*STPROC.INIT('begin HR_REPORTS.GET_SEGMENTS(:P_CONCATENATED_SEGMENTS,
645: :P_ID_FLEX_NUM, :P_SEGMENTS_USED, :P_VALUE1, :P_VALUE2, :P_VALUE3, :P_VALUE4,
646: :P_VALUE5, :P_VALUE6, :P_VALUE7, :P_VALUE8, :P_VALUE9, :P_VALUE10, :P_VALUE11,
647: :P_VALUE12, :P_VALUE13, :P_VALUE14, :P_VALUE15, :P_VALUE16, :P_VALUE17, :P_VALUE18,
648: :P_VALUE19, :P_VALUE20, :P_VALUE21, :P_VALUE22, :P_VALUE23, :P_VALUE24, :P_VALUE25,

Line 755: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,

751: ,P_TITLE OUT NOCOPY VARCHAR2
752: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
753: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
754: BEGIN
755: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,
756: :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
757: STPROC.BIND_I(P_APPL_SHORT_NAME);
758: STPROC.BIND_I(P_DESC_FLEX_NAME);
759: STPROC.BIND_I(P_TABLE_ALIAS);

Line 779: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,

775: ,P_TITLE OUT NOCOPY VARCHAR2
776: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
777: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
778: BEGIN
779: /*STPROC.INIT('begin HR_REPORTS.GET_DESC_FLEX_CONTEXT(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,
780: :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
781: STPROC.BIND_I(P_APPL_SHORT_NAME);
782: STPROC.BIND_I(P_DESC_FLEX_NAME);
783: STPROC.BIND_I(P_TABLE_ALIAS);

Line 804: /* STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,

800: ,P_TITLE OUT NOCOPY VARCHAR2
801: ,P_LABEL_EXPR OUT NOCOPY VARCHAR2
802: ,P_COLUMN_EXPR OUT NOCOPY VARCHAR2) IS
803: BEGIN
804: /* STPROC.INIT('begin HR_REPORTS.GET_DVLPR_DESC_FLEX(:P_APPL_SHORT_NAME, :P_DESC_FLEX_NAME,
805: :P_DESC_FLEX_CONTEXT, :P_TABLE_ALIAS, :P_TITLE, :P_LABEL_EXPR, :P_COLUMN_EXPR); end;');
806: STPROC.BIND_I(P_APPL_SHORT_NAME);
807: STPROC.BIND_I(P_DESC_FLEX_NAME);
808: STPROC.BIND_I(P_DESC_FLEX_CONTEXT);

Line 826: X0 := HR_REPORTS.GET_PERSON_NAME(P_SESSION_DATE, P_PERSON_ID);

822: FUNCTION GET_PERSON_NAME(P_SESSION_DATE IN DATE
823: ,P_PERSON_ID IN NUMBER) RETURN VARCHAR2 IS
824: X0 VARCHAR2(2000);
825: BEGIN
826: X0 := HR_REPORTS.GET_PERSON_NAME(P_SESSION_DATE, P_PERSON_ID);
827: /*STPROC.BIND_O(X0);
828: STPROC.BIND_I(P_SESSION_DATE);
829: STPROC.BIND_I(P_PERSON_ID);
830: STPROC.EXECUTE;