DBA Data[Home] [Help]

APPS.JA_JAINARE1_XMLP_PKG dependencies on FND_CONCURRENT_PROGRAMS

Line 304: CURSOR C_ENABLE_TRACE(CP_APP_SHORT_NAME IN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,CP_CON_PROGRAM_NAME IN FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_NAME%TYPE) IS

300: ,0);
301: END CF_FUNC_TAX_AMOUNTFORMULA;
302:
303: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
304: CURSOR C_ENABLE_TRACE(CP_APP_SHORT_NAME IN FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE,CP_CON_PROGRAM_NAME IN FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_NAME%TYPE) IS
305: SELECT
306: NVL(ENABLE_TRACE
307: ,'N'),
308: A.CONCURRENT_PROGRAM_ID

Line 310: FND_CONCURRENT_PROGRAMS A,

306: NVL(ENABLE_TRACE
307: ,'N'),
308: A.CONCURRENT_PROGRAM_ID
309: FROM
310: FND_CONCURRENT_PROGRAMS A,
311: FND_APPLICATION B
312: WHERE B.APPLICATION_SHORT_NAME = CP_APP_SHORT_NAME
313: AND B.APPLICATION_ID = A.APPLICATION_ID
314: AND A.CONCURRENT_PROGRAM_NAME = CP_CON_PROGRAM_NAME;

Line 330: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;

326: SELECT
327: NAME
328: FROM
329: V$DATABASE;
330: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
331: AUDSID NUMBER := USERENV('SESSIONID');
332: SID NUMBER;
333: SERIAL NUMBER;
334: SPID VARCHAR2(9);

Line 336: LN_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;

332: SID NUMBER;
333: SERIAL NUMBER;
334: SPID VARCHAR2(9);
335: NAME1 VARCHAR2(25);
336: LN_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
337: BEGIN
338: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
339: /*SRW.USER_EXIT('FND SRWINIT')*/NULL;
340: /*SRW.MESSAGE(1275