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 1615: -- insert into iex_score_histories(SCORE_HISTORY_ID

1611: --
1612: -- if (l_scores_tbl is not null) and (l_scores_tbl.count > 0) then
1613: -- IF FND_API.to_Boolean(p_commit)
1614: -- THEN
1615: -- insert into iex_score_histories(SCORE_HISTORY_ID
1616: -- ,SCORE_OBJECT_ID
1617: -- ,SCORE_OBJECT_CODE
1618: -- ,OBJECT_VERSION_NUMBER
1619: -- ,LAST_UPDATE_DATE

Line 1627: -- values(IEX_SCORE_HISTORIES_S.nextval

1623: -- ,CREATED_BY
1624: -- ,SCORE_VALUE
1625: -- ,SCORE_ID
1626: -- ,REQUEST_ID)
1627: -- values(IEX_SCORE_HISTORIES_S.nextval
1628: -- ,l_universe(1)
1629: -- ,l_object_type
1630: -- ,1
1631: -- ,sysdate

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

1935: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: ' || sqlerrm);
1936: END SCORE_CONCUR;
1937:
1938: /*
1939: || Overview: delete rows from IEX_SCORE_HISTORIES to improve performance
1940: ||
1941: || Parameter: p_score_object_code => score_object_code to erase
1942: || p_from_date => remove from this date
1943: || p_to_Date => remove up to this date

Line 1950: || Target Tables: IEX_SCORE_HISTORIES

1946: || all parameters are AND logic on the where clause
1947: ||
1948: || Source Tables:
1949: ||
1950: || Target Tables: IEX_SCORE_HISTORIES
1951: ||
1952: || Creation date: 01/28/03 3:14:PM
1953: ||
1954: || Major Modifications: when who what

Line 2030: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;

2026: l_Count := 0;
2027: i := 0;
2028: j := 0;
2029: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
2030: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
2031: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
2032: vWhereClause := '';
2033: vSelectCount := 'select count(1) from iex_score_histories ';
2034:

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

2027: i := 0;
2028: j := 0;
2029: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
2030: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
2031: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
2032: vWhereClause := '';
2033: vSelectCount := 'select count(1) from iex_score_histories ';
2034:
2035:

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

2029: vStr1 := 'SELECT SCORE_HISTORY_ID ' ;
2030: vStr2 := ' FROM IEX_SCORE_HISTORIES ' ;
2031: v_del_sql := 'DELETE FROM IEX_SCORE_HISTORIES ' ;
2032: vWhereClause := '';
2033: vSelectCount := 'select count(1) from iex_score_histories ';
2034:
2035:
2036: -- IF PG_DEBUG < 10 THEN
2037: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2089: -- Begin - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception
2090: i := i + 1;
2091: l_conditions(i).Col_Name := 'trunc(CREATION_DATE)';
2092: l_conditions(i).Condition := '<>';
2093: l_conditions(i).Value := '(SELECT trunc(MAX(creation_date)) FROM iex_Score_histories)'; -- Andre Fixed here so we use date only
2094: --l_conditions(i).Col_Name := 'CREATION_DATE';
2095: --l_conditions(i).Condition := '<>';
2096: --l_conditions(i).Value := '(SELECT MAX(creation_date) FROM iex_Score_histories)';
2097: -- End - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception

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

2092: l_conditions(i).Condition := '<>';
2093: l_conditions(i).Value := '(SELECT trunc(MAX(creation_date)) FROM iex_Score_histories)'; -- Andre Fixed here so we use date only
2094: --l_conditions(i).Col_Name := 'CREATION_DATE';
2095: --l_conditions(i).Condition := '<>';
2096: --l_conditions(i).Value := '(SELECT MAX(creation_date) FROM iex_Score_histories)';
2097: -- End - Andre Araujo - 03/02/2005 - BUG#4198055 - Did not increase the count, causes not found exception
2098: end if;
2099: -- added for bug 13335079 pnaveenk
2100:

Line 2131: ' FROM IEX_SCORE_HISTORIES ' ||

2127: END IF;
2128:
2129: If NVL(p_truncate,'Y') = 'N' then -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
2130: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SELECT SCORE_HISTORY_ID ' ||
2131: ' FROM IEX_SCORE_HISTORIES ' ||
2132: vPLSQL2);
2133: End if;
2134:
2135: vPLSQL := ' SELECT Count(1), Score_object_code ' ||

Line 2136: ' FROM IEX_SCORE_HISTORIES ' ||

2132: vPLSQL2);
2133: End if;
2134:
2135: vPLSQL := ' SELECT Count(1), Score_object_code ' ||
2136: ' FROM IEX_SCORE_HISTORIES ' ||
2137: 'GROUP BY SCORE_OBJECT_CODE ';
2138:
2139: FND_FILE.PUT_LINE(FND_FILE.LOG, '-------------------------------------------------');
2140: FND_FILE.PUT_LINE(FND_FILE.LOG, ' BEFORE PURGE');

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

2151: v_tot_objects := v_tot_objects + l_count ;
2152: end loop;
2153: close sql_cur;
2154:
2155: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES BEFORE PURGE: ' || v_tot_objects);
2156:
2157: /* do erasing here */
2158: /* Removed by Andre 06/18/2004, we will need to delete in chunks
2159: EXECUTE IMMEDIATE v_del_sql ;

Line 2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => IEX_SCORE_HISTORIES');

2160: */
2161: -- added for bug 13335079
2162: If NVL(p_truncate,'Y') <> 'N' THEN -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
2163:
2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => IEX_SCORE_HISTORIES');
2165:
2166: --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
2167: --EXECUTE IMMEDIATE v_del_sql;
2168:

Line 2166: --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

2162: If NVL(p_truncate,'Y') <> 'N' THEN -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007
2163:
2164: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncating Table => IEX_SCORE_HISTORIES');
2165:
2166: --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
2167: --EXECUTE IMMEDIATE v_del_sql;
2168:
2169:
2170: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_prod);

Line 2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');

2169:
2170: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_prod);
2171:
2172: IEX_DEBUG_PUB.logMessage('Schema:'||l_prod);
2173: IEX_DEBUG_PUB.LogMessage('Truncating IEX_SCORE_HISTORIES');
2174:
2175:
2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',

Line 2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',

2175:
2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',
2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');
2183:

Line 2180: 'IEX_SCORE_HISTORIES' );

2176: ad_ddl.do_ddl( l_prod,
2177: 'IEX',
2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');
2183:
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');

Line 2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');

2178: AD_DDL.TRUNCATE_TABLE,
2179: 'TRUNCATE TABLE IEX_SCORE_HISTORIES',
2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');
2183:
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');
2185: --Start bug 8605501 gnramasa 20th Oct 09
2186: BEGIN

Line 2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');

2180: 'IEX_SCORE_HISTORIES' );
2181:
2182: IEX_DEBUG_PUB.LogMessage('Truncated IEX_SCORE_HISTORIES');
2183:
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');
2185: --Start bug 8605501 gnramasa 20th Oct 09
2186: BEGIN
2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||
2188: 'IEX_SCORE_HISTORIES_S value to 10000');

Line 2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||

2183:
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');
2185: --Start bug 8605501 gnramasa 20th Oct 09
2186: BEGIN
2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||
2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
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' ;

Line 2188: 'IEX_SCORE_HISTORIES_S value to 10000');

2184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Truncated IEX_SCORE_HISTORIES');
2185: --Start bug 8605501 gnramasa 20th Oct 09
2186: BEGIN
2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||
2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
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');

Line 2190: -- EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY -1';

2186: BEGIN
2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||
2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
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;

Line 2191: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY -1' ;

2187: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Table IEX_SCORE_HISTORIES has been truncated, so will reset the Sequence '||
2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
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);

Line 2192: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

2188: 'IEX_SCORE_HISTORIES_S value to 10000');
2189:
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:

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 2195: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Before altering Sequence IEX_SCORE_HISTORIES_S value is: '|| v_num);

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);
2199: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY ' || ((v_num -10000)* -1);

Line 2198: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY '|| ((v_num -10000)* -1);

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);
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');

Line 2199: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY ' || ((v_num -10000)* -1);

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);
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

Line 2200: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

2196:
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');

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 2202: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is: 10000');

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;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';

Line 2204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is already 10000, so no need to change it again');

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;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

Line 2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';

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;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');
2210: END;

Line 2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';

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;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');
2210: END;
2211: --End bug 8605501 gnramasa 20th Oct 09

Line 2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');

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;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');
2210: END;
2211: --End bug 8605501 gnramasa 20th Oct 09
2212:

Line 2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');

2205: end if;
2206: --EXECUTE IMMEDIATE 'ALTER SEQUENCE '||l_prod||'.IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2207: l_sql_stmt := 'ALTER SEQUENCE IEX_SCORE_HISTORIES_S INCREMENT BY 1';
2208: ad_ddl.do_ddl( l_prod, 'IEX', ad_ddl.alter_sequence, l_sql_stmt,'IEX_SCORE_HISTORIES_S');
2209: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Sequence IEX_SCORE_HISTORIES_S value is set to 10000');
2210: END;
2211: --End bug 8605501 gnramasa 20th Oct 09
2212:
2213: Else -- fix a bug 5765878 to truncate table to perform better by Ehuh 2.19.2007

Line 2266: From IEX_SCORE_HISTORIES;

2262: close sql_cur;
2263:
2264: Begin
2265: Select Count(1) into l_total
2266: From IEX_SCORE_HISTORIES;
2267: Exception When NO_DATA_FOUND Then
2268: l_total := 0;
2269: END;
2270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);

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

2266: From IEX_SCORE_HISTORIES;
2267: Exception When NO_DATA_FOUND Then
2268: l_total := 0;
2269: END;
2270: FND_FILE.PUT_LINE(FND_FILE.LOG, 'TOTAL OBJECTS IN IEX_SCORE_HISTORIES AFTER PURGE: ' || l_total);
2271:
2272: -- IF PG_DEBUG < 10 THEN
2273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2274: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));

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

2297:
2298: /*
2299: || Overview: Returns an array of score values for a given objectID/Type
2300: ||
2301: || Parameter: p_object_id object scored in IEX_SCORE_HISTORIES required
2302: || p_object_code object_code in IEX_SCORE_HISTORIES required
2303: || p_from_Date begin date restriction optional
2304: || p_to_date end date restriction optional
2305: || p_scoreID scoreEngineID used to score object optional

Line 2302: || p_object_code object_code in IEX_SCORE_HISTORIES required

2298: /*
2299: || Overview: Returns an array of score values for a given objectID/Type
2300: ||
2301: || Parameter: p_object_id object scored in IEX_SCORE_HISTORIES required
2302: || p_object_code object_code in IEX_SCORE_HISTORIES required
2303: || p_from_Date begin date restriction optional
2304: || p_to_date end date restriction optional
2305: || p_scoreID scoreEngineID used to score object optional
2306: ||

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

2303: || p_from_Date begin date restriction optional
2304: || p_to_date end date restriction optional
2305: || p_scoreID scoreEngineID used to score object optional
2306: ||
2307: || Return value: SCORE_HISTORY_ID -> PK to IEX_SCORE_HISTORIES
2308: || SCORE_ID -> scoreEngine used to calculate score
2309: || SCORE_VALUE -> score of object
2310: || CREATION_DATE -> date object was scored
2311: ||

Line 2312: || Source Tables: IEX_SCORE_HISTORIES

2308: || SCORE_ID -> scoreEngine used to calculate score
2309: || SCORE_VALUE -> score of object
2310: || CREATION_DATE -> date object was scored
2311: ||
2312: || Source Tables: IEX_SCORE_HISTORIES
2313: ||
2314: || Target Tables: NA
2315: ||
2316: || Creation date: 04/22/2003 4:03PM

Line 2360: vstr5 := ' FROM IEX_SCORE_HISTORIES ';

2356: vstr1 := 'SELECT SCORE_HISTORY_ID, ';
2357: vstr2 := ' SCORE_ID, ';
2358: vstr3 := ' SCORE_VALUE, ';
2359: vstr4 := ' CREATION_DATE ';
2360: vstr5 := ' FROM IEX_SCORE_HISTORIES ';
2361:
2362: /* build where clause */
2363: i:= i + 1;
2364: l_conditions(i).Col_Name := 'SCORE_OBJECT_ID';

Line 2409: ' FROM IEX_SCORE_HISTORIES ' ||

2405: 'SELECT SCORE_HISTORY_ID, ' ||
2406: ' SCORE_ID, ' ||
2407: ' SCORE_VALUE, '||
2408: ' CREATION_DATE ' ||
2409: ' FROM IEX_SCORE_HISTORIES ' ||
2410: vPLSQL;
2411: */
2412:
2413: LOOP

Line 2459: || Target Tables: IEX_SCORE_HISTORIES

2455: || Return value:
2456: ||
2457: || Source Tables: None
2458: ||
2459: || Target Tables: IEX_SCORE_HISTORIES
2460: ||
2461: || Creation date: 11/02/2004
2462: ||
2463: || Major Modifications: when who what

Line 2491: -- start fro bug 13335079 pnaveenk added org_id to iex_score_histories

2487: l_request := nvl(FND_GLOBAL.Conc_REQUEST_ID,0);
2488: l_program := FND_GLOBAL.CONC_PROGRAM_ID;
2489: l_prog_appl := FND_GLOBAL.PROG_APPL_ID;
2490:
2491: -- start fro bug 13335079 pnaveenk added org_id to iex_score_histories
2492: l_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
2493:
2494: IF p_scores_tbl.count > 0 THEN -- Do we have records to store?
2495: IF PG_DEBUG < 10 THEN

Line 2506: insert into iex_score_histories(SCORE_HISTORY_ID

2502: from iex_scores
2503: where score_id = p_score_id;
2504:
2505: FORALL n in i..i + p_scores_tbl.count - 1
2506: insert into iex_score_histories(SCORE_HISTORY_ID
2507: ,SCORE_OBJECT_ID
2508: ,SCORE_OBJECT_CODE
2509: ,OBJECT_VERSION_NUMBER
2510: ,LAST_UPDATE_DATE

Line 2522: values(IEX_SCORE_HISTORIES_S.nextval

2518: ,PROGRAM_ID
2519: ,PROGRAM_APPLICATION_ID
2520: ,PROGRAM_UPDATE_DATE
2521: ,ORG_ID)
2522: values(IEX_SCORE_HISTORIES_S.nextval
2523: ,p_objects_tbl(n)
2524: ,l_object_type
2525: ,1
2526: ,sysdate

Line 2575: || Target Tables: IEX_SCORE_HISTORIES

2571: || Return value:
2572: ||
2573: || Source Tables: None
2574: ||
2575: || Target Tables: IEX_SCORE_HISTORIES
2576: ||
2577: || Creation date: 11/02/2004
2578: ||
2579: || Major Modifications: when who what