141: INTO L_ELEMENT_NAME,L_DUMMY;
142: CLOSE ELEMENT_NAME_CUR;
143: IF (P_SORT_BY = 'O') THEN
144: IF (SORT_OPTION22 IS NOT NULL) THEN
145: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(P_SET_OF_BOOKS_ID
146: ,L_CHART_OF_ACCTS);
147: CP_SORT_DESCRIPTION2 := FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
148: ,KEY_FLEX_CODE => 'GL#'
149: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)
148: ,KEY_FLEX_CODE => 'GL#'
149: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)
150: ,COMBINATION_ID => SORT_OPTION22);
151: ELSE
152: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_PROJECT_NUMBER(SORT_OPTION23) || ' ' || PSP_GENERAL.GET_TASK_NUMBER(SORT_OPTION24) || ' ' || PSP_GENERAL.GET_AWARD_NUMBER(SORT_OPTION25)
153: || ' ' || PSP_GENERAL.GET_ORG_NAME(SORT_OPTION26) || ' ' || SORT_OPTION27;
154: END IF;
155: ELSE
156: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_ORG_NAME(SORT_OPTION21);
149: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)
150: ,COMBINATION_ID => SORT_OPTION22);
151: ELSE
152: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_PROJECT_NUMBER(SORT_OPTION23) || ' ' || PSP_GENERAL.GET_TASK_NUMBER(SORT_OPTION24) || ' ' || PSP_GENERAL.GET_AWARD_NUMBER(SORT_OPTION25)
153: || ' ' || PSP_GENERAL.GET_ORG_NAME(SORT_OPTION26) || ' ' || SORT_OPTION27;
154: END IF;
155: ELSE
156: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_ORG_NAME(SORT_OPTION21);
157: END IF;
152: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_PROJECT_NUMBER(SORT_OPTION23) || ' ' || PSP_GENERAL.GET_TASK_NUMBER(SORT_OPTION24) || ' ' || PSP_GENERAL.GET_AWARD_NUMBER(SORT_OPTION25)
153: || ' ' || PSP_GENERAL.GET_ORG_NAME(SORT_OPTION26) || ' ' || SORT_OPTION27;
154: END IF;
155: ELSE
156: CP_SORT_DESCRIPTION2 := PSP_GENERAL.GET_ORG_NAME(SORT_OPTION21);
157: END IF;
158: RETURN L_ELEMENT_NAME;
159: END CF_ELEMENT_NAMEFORMULA;
160:
168: V_RETCODE NUMBER;
169: L_CHART_OF_ACCTS VARCHAR2(20);
170: BEGIN
171: IF (P_SORT_BY = 'O') THEN
172: RETURN PSP_GENERAL.GET_ORG_NAME(SORT_OPTION11);
173: ELSE
174: IF (SORT_OPTION12 IS NOT NULL) THEN
175: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(P_SET_OF_BOOKS_ID
176: ,L_CHART_OF_ACCTS);
171: IF (P_SORT_BY = 'O') THEN
172: RETURN PSP_GENERAL.GET_ORG_NAME(SORT_OPTION11);
173: ELSE
174: IF (SORT_OPTION12 IS NOT NULL) THEN
175: V_RETCODE := PSP_GENERAL.FIND_CHART_OF_ACCTS(P_SET_OF_BOOKS_ID
176: ,L_CHART_OF_ACCTS);
177: RETURN FND_FLEX_EXT.GET_SEGS(APPLICATION_SHORT_NAME => 'SQLGL'
178: ,KEY_FLEX_CODE => 'GL#'
179: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)
178: ,KEY_FLEX_CODE => 'GL#'
179: ,STRUCTURE_NUMBER => TO_NUMBER(L_CHART_OF_ACCTS)
180: ,COMBINATION_ID => SORT_OPTION12);
181: ELSE
182: RETURN PSP_GENERAL.GET_PROJECT_NUMBER(SORT_OPTION13) || ' ' || PSP_GENERAL.GET_TASK_NUMBER(SORT_OPTION14) || ' ' || PSP_GENERAL.GET_AWARD_NUMBER(SORT_OPTION15) || ' ' || PSP_GENERAL.GET_ORG_NAME(SORT_OPTION16) || ' ' || SORT_OPTION17;
183: END IF;
184: END IF;
185: END CF_SORT_DESCRIPTION1FORMULA;
186: