4: BEGIN
5: DECLARE
6: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7: BEGIN
8: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
9: P_STAT_DATE_FROM_T := TO_CHAR(P_STAT_DATE_FROM,fnd_global.nls_date_format);
10: P_STAT_DATE_TO_T := TO_CHAR(P_STAT_DATE_TO,fnd_global.nls_date_format);
11: INIT_SECURITY;
12: IF (P_TEST_LAYOUT = 'Y') THEN
5: DECLARE
6: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7: BEGIN
8: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
9: P_STAT_DATE_FROM_T := TO_CHAR(P_STAT_DATE_FROM,fnd_global.nls_date_format);
10: P_STAT_DATE_TO_T := TO_CHAR(P_STAT_DATE_TO,fnd_global.nls_date_format);
11: INIT_SECURITY;
12: IF (P_TEST_LAYOUT = 'Y') THEN
13: RAISE NO_DATA_FOUND;
6: L_MESSAGE FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
7: BEGIN
8: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
9: P_STAT_DATE_FROM_T := TO_CHAR(P_STAT_DATE_FROM,fnd_global.nls_date_format);
10: P_STAT_DATE_TO_T := TO_CHAR(P_STAT_DATE_TO,fnd_global.nls_date_format);
11: INIT_SECURITY;
12: IF (P_TEST_LAYOUT = 'Y') THEN
13: RAISE NO_DATA_FOUND;
14: END IF;
224:
225: FUNCTION C_DATEFORMATFORMULA(C_DATEFORMAT IN VARCHAR2) RETURN VARCHAR2 IS
226: BEGIN
227: -- RETURN (C_DATEFORMAT);
228: RETURN (fnd_global.nls_date_format);
229: END C_DATEFORMATFORMULA;
230:
231: FUNCTION C_ALL_TRANSLATION_P RETURN VARCHAR2 IS
232: BEGIN