DBA Data[Home] [Help]

APPS.PSP_PSPENCSC_XMLP_PKG dependencies on PSP_GENERAL

Line 122: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');

118: END CF_ORG_NAMEFORMULA;
119:
120: FUNCTION CF_GL_DESCFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
121: V_GL_CODE VARCHAR2(255);
122: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
123: BEGIN
124: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
125: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB
126: ,GL_CODE_COMBINATION_ID);

Line 125: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB

121: V_GL_CODE VARCHAR2(255);
122: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
123: BEGIN
124: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
125: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB
126: ,GL_CODE_COMBINATION_ID);
127: RETURN (V_GL_CODE);
128: END IF;
129: RETURN NULL;

Line 218: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');

214: ,CF_TASK_NUMBER IN VARCHAR2
215: ,CF_ORG_NAME IN VARCHAR2
216: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
217: L_SUSPENSE_ORG_ACCOUNT VARCHAR2(2000);
218: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
219: V_RETCODE NUMBER;
220: L_CHART_OF_ACCTS VARCHAR2(20);
221: BEGIN
222: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN

Line 223: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(V_SOB

219: V_RETCODE NUMBER;
220: L_CHART_OF_ACCTS VARCHAR2(20);
221: BEGIN
222: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
223: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(V_SOB
224: ,L_CHART_OF_ACCTS);
225: L_SUSPENSE_ORG_ACCOUNT := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
226: ,KEY_FLEX_CODE => 'GL#'
227: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)