DBA Data[Home] [Help]

APPS.JA_JAIN23D_XMLP_PKG dependencies on V$DATABASE

Line 409: V$DATABASE;

405: SELECT
406: NVL(NAME
407: ,'')
408: FROM
409: V$DATABASE;
410: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
411: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
412: V_SID V$SESSION.SID%TYPE;
413: V_SERIAL V$SESSION.SERIAL#%TYPE;

Line 415: V_NAME V$DATABASE.NAME%TYPE;

411: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
412: V_SID V$SESSION.SID%TYPE;
413: V_SERIAL V$SESSION.SERIAL#%TYPE;
414: V_SPID V$PROCESS.SPID%TYPE;
415: V_NAME V$DATABASE.NAME%TYPE;
416: BEGIN
417: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
418: CP_TRN_FROM_DATE := TO_CHAR(P_TRN_FROM_DATE,'DD-MON-YYYY');
419: CP_TRN_TO_DATE := TO_CHAR(P_TRN_TO_DATE,'DD-MON-YYYY');