APPS.PSP_PSPRCDLS_XMLP_PKG dependencies on PSP_GENERAL

Line 133: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)

129: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
130: L_POETA VARCHAR2(360);
131: BEGIN
132: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
133: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)
134: ,L_CHART_OF_ACCTS);
135: GL_FLEX_VALUES := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
136: ,KEY_FLEX_CODE => 'GL#'
137: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)

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

579: PROCEDURE GET_ANNUAL_SALARY(P_ASSIGNMENT_ID IN NUMBER
580: ,P_SESSION_DATE IN DATE
581: ,P_ANNUAL_SALARY OUT NOCOPY NUMBER) IS
582: BEGIN
583: /* STPROC.INIT('begin PSP_GENERAL.GET_ANNUAL_SALARY(:P_ASSIGNMENT_ID, :P_SESSION_DATE, :P_ANNUAL_SALARY); end;');
584: STPROC.BIND_I(P_ASSIGNMENT_ID);
585: STPROC.BIND_I(P_SESSION_DATE);
586: STPROC.BIND_O(P_ANNUAL_SALARY);
587: STPROC.EXECUTE;

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

593: ,P_SET_OF_BOOKS_ID IN NUMBER
594: ,P_COST_KEYFLEX_ID IN NUMBER
595: ,X_GL_CCID OUT NOCOPY NUMBER) IS
596: BEGIN
597: /* STPROC.INIT('begin PSP_GENERAL.GET_GL_CCID(:P_PAYROLL_ID, :P_SET_OF_BOOKS_ID, :P_COST_KEYFLEX_ID, :X_GL_CCID); end;');
598: STPROC.BIND_I(P_PAYROLL_ID);
599: STPROC.BIND_I(P_SET_OF_BOOKS_ID);
600: STPROC.BIND_I(P_COST_KEYFLEX_ID);
601: STPROC.BIND_O(X_GL_CCID);

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

607: FUNCTION BUSINESS_DAYS(LOW_DATE IN DATE
608: ,HIGH_DATE IN DATE) RETURN NUMBER IS
609: X0 NUMBER;
610: BEGIN
611: /* STPROC.INIT('begin :X0 := PSP_GENERAL.BUSINESS_DAYS(:LOW_DATE, :HIGH_DATE); end;');
612: STPROC.BIND_O(X0);
613: STPROC.BIND_I(LOW_DATE);
614: STPROC.BIND_I(HIGH_DATE);
615: STPROC.EXECUTE;

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

620:
621: FUNCTION GET_GL_DESCRIPTION(A_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
622: X0 VARCHAR2(2000);
623: BEGIN
624: /* STPROC.INIT('begin :X0 := PSP_GENERAL.GET_GL_DESCRIPTION(:A_CODE_COMBINATION_ID); end;');
625: STPROC.BIND_O(X0);
626: STPROC.BIND_I(A_CODE_COMBINATION_ID);
627: STPROC.EXECUTE;
628: STPROC.RETRIEVE(1