DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on DUAL

Line 426: --Select IEX_DEL_WF_S.NEXTVAL INTO l_bridge FROM Dual;

422: -- Api body
423: --
424: --- Begin - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
425: --Commented by schekuri for bug#6373998 by schekuri on 31-Aug-2007
426: --Select IEX_DEL_WF_S.NEXTVAL INTO l_bridge FROM Dual;
427: --- End - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
428:
429: l_bridge := l_del_buff_bridge; --Added by schekuri for bug#6373998 by schekuri on 31-Aug-2007
430: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge id ' || l_bridge);

Line 577: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

573: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
574: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
575: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
576: -- END IF;
577: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
578: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
579: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);
580: -- END IF;
581: -- Execute Immediate vSql

Line 851: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007

847: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
848: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
849:
850:
851: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007
852: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');
853: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
854: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');
855: END IF;

Line 2169: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';

2165: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2166: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2167: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2168: END IF;
2169: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
2170: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2171: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);
2172: END IF;
2173: Execute Immediate vSql