APPS.PSP_PSPLSODL_XMLP_PKG dependencies on PSP_GENERAL

Line 22: X_SOB NUMBER := TO_NUMBER(PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID'));

18: END CF_ORGANIZATION_NAMEFORMULA;
19:
20: FUNCTION CF_GL_ACCOUNTFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
21: RET_VAL VARCHAR2(1000);
22: X_SOB NUMBER := TO_NUMBER(PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID'));
23: BEGIN
24: IF GL_CODE_COMBINATION_ID IS NULL THEN
25: RETURN NULL;
26: END IF;

Line 27: RET_VAL := PSP_GENERAL.GET_GL_DESCRIPTION(X_SOB

23: BEGIN
24: IF GL_CODE_COMBINATION_ID IS NULL THEN
25: RETURN NULL;
26: END IF;
27: RET_VAL := PSP_GENERAL.GET_GL_DESCRIPTION(X_SOB
28: ,GL_CODE_COMBINATION_ID);
29: RETURN RET_VAL;
30: END CF_GL_ACCOUNTFORMULA;
31:

Line 248: V_NUMBER_WORKING_DAYS := PSP_GENERAL.BUSINESS_DAYS(SCHEDULE_BEGIN_DATE

244: FUNCTION CF_NUMBER_WORKING_DAYSFORMULA(SCHEDULE_BEGIN_DATE IN DATE
245: ,SCHEDULE_END_DATE IN DATE) RETURN NUMBER IS
246: V_NUMBER_WORKING_DAYS NUMBER;
247: BEGIN
248: V_NUMBER_WORKING_DAYS := PSP_GENERAL.BUSINESS_DAYS(SCHEDULE_BEGIN_DATE
249: ,SCHEDULE_END_DATE);
250: RETURN V_NUMBER_WORKING_DAYS;
251: END CF_NUMBER_WORKING_DAYSFORMULA;
252:

Line 425: /* STPROC.INIT('begin PSP_GENERAL.GET_ANNUAL_SALARY(:P_ASSIGNMENT_ID, :P_SESSION_DATE, :P_ANNUAL_SALARY); end;');

421: PROCEDURE GET_ANNUAL_SALARY(P_ASSIGNMENT_ID IN NUMBER
422: ,P_SESSION_DATE IN DATE
423: ,P_ANNUAL_SALARY OUT NOCOPY NUMBER) IS
424: BEGIN
425: /* STPROC.INIT('begin PSP_GENERAL.GET_ANNUAL_SALARY(:P_ASSIGNMENT_ID, :P_SESSION_DATE, :P_ANNUAL_SALARY); end;');
426: STPROC.BIND_I(P_ASSIGNMENT_ID);
427: STPROC.BIND_I(P_SESSION_DATE);
428: STPROC.BIND_O(P_ANNUAL_SALARY);
429: STPROC.EXECUTE;

Line 439: /* STPROC.INIT('begin PSP_GENERAL.GET_GL_CCID(:P_PAYROLL_ID, :P_SET_OF_BOOKS_ID, :P_COST_KEYFLEX_ID, :X_GL_CCID); end;');

435: ,P_SET_OF_BOOKS_ID IN NUMBER
436: ,P_COST_KEYFLEX_ID IN NUMBER
437: ,X_GL_CCID OUT NOCOPY NUMBER) IS
438: BEGIN
439: /* STPROC.INIT('begin PSP_GENERAL.GET_GL_CCID(:P_PAYROLL_ID, :P_SET_OF_BOOKS_ID, :P_COST_KEYFLEX_ID, :X_GL_CCID); end;');
440: STPROC.BIND_I(P_PAYROLL_ID);
441: STPROC.BIND_I(P_SET_OF_BOOKS_ID);
442: STPROC.BIND_I(P_COST_KEYFLEX_ID);
443: STPROC.BIND_O(X_GL_CCID);

Line 453: /*STPROC.INIT('begin :X0 := PSP_GENERAL.BUSINESS_DAYS(:LOW_DATE, :HIGH_DATE); end;');

449: FUNCTION BUSINESS_DAYS(LOW_DATE IN DATE
450: ,HIGH_DATE IN DATE) RETURN NUMBER IS
451: X0 NUMBER;
452: BEGIN
453: /*STPROC.INIT('begin :X0 := PSP_GENERAL.BUSINESS_DAYS(:LOW_DATE, :HIGH_DATE); end;');
454: STPROC.BIND_O(X0);
455: STPROC.BIND_I(LOW_DATE);
456: STPROC.BIND_I(HIGH_DATE);
457: STPROC.EXECUTE;

Line 466: /* STPROC.INIT('begin :X0 := PSP_GENERAL.GET_GL_DESCRIPTION(:A_CODE_COMBINATION_ID); end;');

462:
463: FUNCTION GET_GL_DESCRIPTION(A_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
464: X0 VARCHAR2(2000);
465: BEGIN
466: /* STPROC.INIT('begin :X0 := PSP_GENERAL.GET_GL_DESCRIPTION(:A_CODE_COMBINATION_ID); end;');
467: STPROC.BIND_O(X0);
468: STPROC.BIND_I(A_CODE_COMBINATION_ID);
469: STPROC.EXECUTE;
470: STPROC.RETRIEVE(1