DBA Data[Home] [Help]

APPS.PSP_PSPDAREG_XMLP_PKG dependencies on PSP_GENERAL

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

15: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
16: L_POETA_NEW VARCHAR2(2000);
17: BEGIN
18: IF GLCCID_NEW IS NOT NULL THEN
19: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)
20: ,L_CHART_OF_ACCTS);
21: GL_FLEX_VALUES := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
22: ,KEY_FLEX_CODE => 'GL#'
23: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)

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

76: L_ORG_NAME HR_ALL_ORGANIZATION_UNITS_TL.NAME%TYPE;
77: L_POETA_OLD VARCHAR2(2000);
78: BEGIN
79: IF GLCCID_OLD IS NOT NULL THEN
80: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(TO_NUMBER(P_SET_OF_BOOKS_ID)
81: ,L_CHART_OF_ACCTS);
82: GL_FLEX_VALUES := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
83: ,KEY_FLEX_CODE => 'GL#'
84: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)

Line 237: V_SOB_ID := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');

233:
234: FUNCTION CF_SOB_IDFORMULA RETURN CHAR IS
235: V_SOB_ID NUMBER;
236: BEGIN
237: V_SOB_ID := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
238: RETURN (TO_CHAR(V_SOB_ID));
239: END CF_SOB_IDFORMULA;
240:
241: FUNCTION CF_SOB_ID2FORMULA RETURN CHAR IS

Line 244: V_SOB_ID := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');

240:
241: FUNCTION CF_SOB_ID2FORMULA RETURN CHAR IS
242: V_SOB_ID NUMBER;
243: BEGIN
244: V_SOB_ID := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
245: RETURN (TO_CHAR(V_SOB_ID));
246: END CF_SOB_ID2FORMULA;
247:
248: FUNCTION CF_ADJUSTMENT_BYFORMULA(ADJUSTMENT_BY IN VARCHAR2) RETURN CHAR IS