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 IEX_SCORE_HISTORIES

Line 1145: -- insert into iex_score_histories(SCORE_HISTORY_ID

1141: --
1142: -- if (l_scores_tbl is not null) and (l_scores_tbl.count > 0) then
1143: -- IF FND_API.to_Boolean(p_commit)
1144: -- THEN
1145: -- insert into iex_score_histories(SCORE_HISTORY_ID
1146: -- ,SCORE_OBJECT_ID
1147: -- ,SCORE_OBJECT_CODE
1148: -- ,OBJECT_VERSION_NUMBER
1149: -- ,LAST_UPDATE_DATE

Line 1157: -- values(IEX_SCORE_HISTORIES_S.nextval

1153: -- ,CREATED_BY
1154: -- ,SCORE_VALUE
1155: -- ,SCORE_ID
1156: -- ,REQUEST_ID)
1157: -- values(IEX_SCORE_HISTORIES_S.nextval
1158: -- ,l_universe(1)
1159: -- ,l_object_type
1160: -- ,1
1161: -- ,sysdate

Line 1327: || Overview: delete rows from IEX_SCORE_HISTORIES to improve performance

1323: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1324: END SCORE_CONCUR;
1325:
1326: /*
1327: || Overview: delete rows from IEX_SCORE_HISTORIES to improve performance
1328: ||
1329: || Parameter: p_score_object_code => score_object_code to erase
1330: || p_from_date => remove from this date
1331: || p_to_Date => remove up to this date

Line 1338: || Target Tables: IEX_SCORE_HISTORIES

1334: || all parameters are AND logic on the where clause
1335: ||
1336: || Source Tables:
1337: ||
1338: || Target Tables: IEX_SCORE_HISTORIES
1339: ||
1340: || Creation date: 01/28/03 3:14:PM
1341: ||
1342: || Major Modifications: when who what

Line 1411: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;

1407: l_Count := 0;
1408: i := 0;
1409: j := 0;
1410: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
1411: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
1412: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
1413: vWhereClause := '';
1414: vSelectCount := 'select count(1) from iex_score_histories ';
1415:

Line 1412: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;

1408: i := 0;
1409: j := 0;
1410: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
1411: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
1412: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
1413: vWhereClause := '';
1414: vSelectCount := 'select count(1) from iex_score_histories ';
1415:
1416:

Line 1414: vSelectCount := 'select count(1) from iex_score_histories ';

1410: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
1411: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
1412: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
1413: vWhereClause := '';
1414: vSelectCount := 'select count(1) from iex_score_histories ';
1415:
1416:
1417: -- IF PG_DEBUG < 10 THEN
1418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1474: l_conditions(i).Value := '(SELECT trunc(MAX(creation_date)) FROM iex_Score_histories)'; -- Andre Fixed here so we use date only

1470: -- Begin - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception
1471: i := i + 1;
1472: l_conditions(i).Col_Name := 'trunc(CREATION_DATE)';
1473: l_conditions(i).Condition := '<>';
1474: l_conditions(i).Value := '(SELECT trunc(MAX(creation_date)) FROM iex_Score_histories)'; -- Andre Fixed here so we use date only
1475: --l_conditions(i).Col_Name := 'CREATION_DATE';
1476: --l_conditions(i).Condition := '<>';
1477: --l_conditions(i).Value := '(SELECT MAX(creation_date) FROM iex_Score_histories)';
1478: -- End - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception

Line 1477: --l_conditions(i).Value := '(SELECT MAX(creation_date) FROM iex_Score_histories)';

1473: l_conditions(i).Condition := '<>';
1474: l_conditions(i).Value := '(SELECT trunc(MAX(creation_date)) FROM iex_Score_histories)'; -- Andre Fixed here so we use date only
1475: --l_conditions(i).Col_Name := 'CREATION_DATE';
1476: --l_conditions(i).Condition := '<>';
1477: --l_conditions(i).Value := '(SELECT MAX(creation_date) FROM iex_Score_histories)';
1478: -- End - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception
1479: end if;
1480:
1481: -- Added by Surya

Line 1503: ' FROM IEX_SCORE_HISTORIES ' ||

1499: END IF;
1500:
1501: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1502: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SELECT SCORE_HISTORY_ID ' ||
1503: ' FROM IEX_SCORE_HISTORIES ' ||
1504: vPLSQL2);
1505: End if;
1506:
1507: vPLSQL := ' SELECT Count(1), Score_object_code ' ||

Line 1508: ' FROM IEX_SCORE_HISTORIES ' ||

1504: vPLSQL2);
1505: End if;
1506:
1507: vPLSQL := ' SELECT Count(1), Score_object_code ' ||
1508: ' FROM IEX_SCORE_HISTORIES ' ||
1509: 'GROUP BY SCORE_OBJECT_CODE ';
1510:
1511: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
1512: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');

Line 1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES BEFORE PURGE: ' || v_tot_objects);

1523: v_tot_objects := v_tot_objects + l_count ;
1524: end loop;
1525: close sql_cur;
1526:
1527: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES BEFORE PURGE: ' || v_tot_objects);
1528:
1529: /* do erasing here */
1530: /* Removed by Andre 06/18/2004, we will need to delete in chunks
1531: EXECUTE IMMEDIATE v_del_sql ;

Line 1536: v_del_sql := 'truncate table '||l_prod||'.IEX_SCORE_HISTORIES'; -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007

1532: */
1533:
1534: If NVL(p_truncate,'Y') <> 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1535: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => '|| p_truncate);
1536: v_del_sql := 'truncate table '||l_prod||'.IEX_SCORE_HISTORIES'; -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1537: EXECUTE IMMEDIATE v_del_sql;
1538: Else -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
1539:
1540: if l_conditions.COUNT >= 1 then

Line 1591: From IEX_SCORE_HISTORIES;

1587: close sql_cur;
1588:
1589: Begin
1590: Select Count(1) into l_total
1591: From IEX_SCORE_HISTORIES;
1592: Exception When NO_DATA_FOUND Then
1593: l_total := 0;
1594: END;
1595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);

Line 1595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);

1591: From IEX_SCORE_HISTORIES;
1592: Exception When NO_DATA_FOUND Then
1593: l_total := 0;
1594: END;
1595: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);
1596:
1597: -- IF PG_DEBUG < 10 THEN
1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

Line 1626: || Parameter: p_object_id object scored in IEX_SCORE_HISTORIES required

1622:
1623: /*
1624: || Overview: Returns an array of score values for a given objectID/Type
1625: ||
1626: || Parameter: p_object_id object scored in IEX_SCORE_HISTORIES required
1627: || p_object_code object_code in IEX_SCORE_HISTORIES required
1628: || p_from_Date begin date restriction optional
1629: || p_to_date end date restriction optional
1630: || p_scoreID scoreEngineID used to score object optional

Line 1627: || p_object_code object_code in IEX_SCORE_HISTORIES required

1623: /*
1624: || Overview: Returns an array of score values for a given objectID/Type
1625: ||
1626: || Parameter: p_object_id object scored in IEX_SCORE_HISTORIES required
1627: || p_object_code object_code in IEX_SCORE_HISTORIES required
1628: || p_from_Date begin date restriction optional
1629: || p_to_date end date restriction optional
1630: || p_scoreID scoreEngineID used to score object optional
1631: ||

Line 1632: || Return value: SCORE_HISTORY_ID -> PK to IEX_SCORE_HISTORIES

1628: || p_from_Date begin date restriction optional
1629: || p_to_date end date restriction optional
1630: || p_scoreID scoreEngineID used to score object optional
1631: ||
1632: || Return value: SCORE_HISTORY_ID -> PK to IEX_SCORE_HISTORIES
1633: || SCORE_ID -> scoreEngine used to calculate score
1634: || SCORE_VALUE -> score of object
1635: || CREATION_DATE -> date object was scored
1636: ||

Line 1637: || Source Tables: IEX_SCORE_HISTORIES

1633: || SCORE_ID -> scoreEngine used to calculate score
1634: || SCORE_VALUE -> score of object
1635: || CREATION_DATE -> date object was scored
1636: ||
1637: || Source Tables: IEX_SCORE_HISTORIES
1638: ||
1639: || Target Tables: NA
1640: ||
1641: || Creation date: 04/22/2003 4:03PM

Line 1685: vstr5 := ' FROM IEX_SCORE_HISTORIES ';

1681: vstr1 := 'SELECT SCORE_HISTORY_ID, ';
1682: vstr2 := ' SCORE_ID, ';
1683: vstr3 := ' SCORE_VALUE, ';
1684: vstr4 := ' CREATION_DATE ';
1685: vstr5 := ' FROM IEX_SCORE_HISTORIES ';
1686:
1687: /* build where clause */
1688: i:= i + 1;
1689: l_conditions(i).Col_Name := 'SCORE_OBJECT_ID';

Line 1734: ' FROM IEX_SCORE_HISTORIES ' ||

1730: 'SELECT SCORE_HISTORY_ID, ' ||
1731: ' SCORE_ID, ' ||
1732: ' SCORE_VALUE, '||
1733: ' CREATION_DATE ' ||
1734: ' FROM IEX_SCORE_HISTORIES ' ||
1735: vPLSQL;
1736: */
1737:
1738: LOOP

Line 1784: || Target Tables: IEX_SCORE_HISTORIES

1780: || Return value:
1781: ||
1782: || Source Tables: None
1783: ||
1784: || Target Tables: IEX_SCORE_HISTORIES
1785: ||
1786: || Creation date: 11/02/2004
1787: ||
1788: || Major Modifications: when who what

Line 1827: insert into iex_score_histories(SCORE_HISTORY_ID

1823: from iex_scores
1824: where score_id = p_score_id;
1825:
1826: FORALL n in i..i + p_scores_tbl.count - 1
1827: insert into iex_score_histories(SCORE_HISTORY_ID
1828: ,SCORE_OBJECT_ID
1829: ,SCORE_OBJECT_CODE
1830: ,OBJECT_VERSION_NUMBER
1831: ,LAST_UPDATE_DATE

Line 1842: values(IEX_SCORE_HISTORIES_S.nextval

1838: ,REQUEST_ID
1839: ,PROGRAM_ID
1840: ,PROGRAM_APPLICATION_ID
1841: ,PROGRAM_UPDATE_DATE)
1842: values(IEX_SCORE_HISTORIES_S.nextval
1843: ,p_objects_tbl(n)
1844: ,l_object_type
1845: ,1
1846: ,sysdate

Line 1894: || Target Tables: IEX_SCORE_HISTORIES

1890: || Return value:
1891: ||
1892: || Source Tables: None
1893: ||
1894: || Target Tables: IEX_SCORE_HISTORIES
1895: ||
1896: || Creation date: 11/02/2004
1897: ||
1898: || Major Modifications: when who what