DBA Data[Home] [Help]

APPS.PSP_PSPENCDU_XMLP_PKG dependencies on PSP_GENERAL

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

93: END CF_ORG_NAMEFORMULA;
94:
95: FUNCTION CF_GL_DESCFORMULA(GL_CODE_COMBINATION_ID IN NUMBER) RETURN VARCHAR2 IS
96: V_GL_CODE VARCHAR2(255);
97: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
98: BEGIN
99: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
100: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB
101: ,GL_CODE_COMBINATION_ID);

Line 100: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB

96: V_GL_CODE VARCHAR2(255);
97: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
98: BEGIN
99: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
100: V_GL_CODE := PSP_GENERAL.GET_GL_DESCRIPTION(V_SOB
101: ,GL_CODE_COMBINATION_ID);
102: RETURN (V_GL_CODE);
103: END IF;
104: RETURN NULL;

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

189: ,CF_TASK_NUMBER IN VARCHAR2
190: ,CF_ORG_NAME IN VARCHAR2
191: ,EXPENDITURE_TYPE IN VARCHAR2) RETURN CHAR IS
192: L_SUSPENSE_ORG_ACCOUNT VARCHAR2(2000);
193: V_SOB NUMBER := PSP_GENERAL.GET_SPECIFIC_PROFILE('GL_SET_OF_BKS_ID');
194: V_RETCODE NUMBER;
195: L_CHART_OF_ACCTS VARCHAR2(20);
196: BEGIN
197: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN

Line 198: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(V_SOB

194: V_RETCODE NUMBER;
195: L_CHART_OF_ACCTS VARCHAR2(20);
196: BEGIN
197: IF GL_CODE_COMBINATION_ID IS NOT NULL THEN
198: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(V_SOB
199: ,L_CHART_OF_ACCTS);
200: L_SUSPENSE_ORG_ACCOUNT := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
201: ,KEY_FLEX_CODE => 'GL#'
202: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)