eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_SCORE_NEW_PVT dependencies on DUAL

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

535: -- Api body
536: --
537: --- Begin - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
538: --Commented by schekuri for bug#6373998 by schekuri on 31-Aug-2007
539: --Select IEX_DEL_WF_S.NEXTVAL INTO l_bridge FROM Dual;
540: --- End - Andre Araujo - 11/02/2004 - New storage mode, this one respects the commit size - TAR 4040621.994
541:
542: l_bridge := l_del_buff_bridge; --Added by schekuri for bug#6373998 by schekuri on 31-Aug-2007
543: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge id ' || l_bridge);

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

767: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
768: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: FORMULA');
769: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: l_new_value=' || l_new_value);
770: -- END IF;
771: -- vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
772: -- IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
773: -- IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScores: vSql=' || vSql);
774: -- END IF;
775: -- Execute Immediate vSql

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

1251: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'tempres-->'||tempResult);
1252: --End Bug 8933776 30-Nov-2009 barathsr
1253:
1254:
1255: Select IEX_DEL_WF_S.NEXTVAL INTO l_del_buff_bridge FROM Dual; --Added by schekuri for bug#6373998 on 31-Aug-2007
1256: FND_FILE.PUT_LINE(FND_FILE.LOG,'Using bridge ' || l_del_buff_bridge || ' one for each scoring engine');
1257: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1258: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: got bridge id ' || l_del_buff_bridge || ' once for each scoring engine');
1259: END IF;

Line 1726: from dual;

1722: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1723: END IF;
1724: select TO_CHAR(sysdate,'YYYY-MM-DD')
1725: into l_sysdate
1726: from dual;
1727: -- Begin bug 6128024
1728: begin
1729: select security_profile_name into l_pf_name from per_security_profiles
1730: where security_profile_id = l_pf_value;

Line 2194: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL +1 FROM DUAL' into v_num;

2190: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY -1';
2191: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY -1' ;
2192: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2193:
2194: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL +1 FROM DUAL' into v_num;
2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before altering Sequence IEX_SCORE_HISTORIES_S value is: '|| v_num);
2196:
2197: if v_num <> 10000 then
2198: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY '|| ((v_num -10000)* -1);

Line 2201: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL FROM DUAL' into v_num;

2197: if v_num <> 10000 then
2198: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY '|| ((v_num -10000)* -1);
2199: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY ' || ((v_num -10000)* -1);
2200: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2201: EXECUTE IMMEDIATE 'select IEX_SCORE_HISTORIES_S.NEXTVAL FROM DUAL' into v_num;
2202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is: 10000');
2203: else
2204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is already 10000, so no need to change it again');
2205: end if;

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

2901: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2902: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: FORMULA');
2903: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: l_new_value=' || l_new_value);
2904: END IF;
2905: vSql := 'SELECT ' || l_new_value || ' FROM DUAL';
2906: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2907: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: vSql=' || vSql);
2908: END IF;
2909: Execute Immediate vSql