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.OKI_DBI_SCM_RSG_API_PVT dependencies on FND_DATE

Line 53: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('End of Manage_Oki_Index at '|| FND_DATE.Date_To_DisplayDt(sysdate));

49: ELSIF (l_api_type = BIS_BIA_RSG_CUSTOM_API_MGMNT.Type_Mv_Threshold) THEN
50: NULL; --MANAGE_MV_THRESHOLD(L_MODE, L_OBJ_NAME);
51: END IF;
52:
53: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('End of Manage_Oki_Index at '|| FND_DATE.Date_To_DisplayDt(sysdate));
54: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('-------------------------');
55: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
56:
57: COMMIT;

Line 91: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));

87:
88: IF (p_mode = 'BEFORE') THEN
89: OKI_DBI_SCM_RSG_API_PVT.Drop_Index(p_obj_name,l_owner, p_retcode);
90: ELSIF (p_mode = 'AFTER') THEN
91: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
92: OKI_DBI_SCM_RSG_API_PVT.Create_Index(p_obj_name, l_owner, p_retcode);
93: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Finished creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
94: END IF;
95:

Line 93: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Finished creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));

89: OKI_DBI_SCM_RSG_API_PVT.Drop_Index(p_obj_name,l_owner, p_retcode);
90: ELSIF (p_mode = 'AFTER') THEN
91: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
92: OKI_DBI_SCM_RSG_API_PVT.Create_Index(p_obj_name, l_owner, p_retcode);
93: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Finished creating the column indexes at '|| FND_DATE.Date_To_DisplayDt(sysdate));
94: END IF;
95:
96: COMMIT;
97: END IF;

Line 156: || FND_DATE.Date_To_DisplayDt(sysdate));

152:
153: -- If all_indexes has index details
154: -- Update oki_dbi_indexes with latest index information
155: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '
156: || FND_DATE.Date_To_DisplayDt(sysdate));
157: MERGE INTO OKI_DBI_INDEXES b
158: USING ( select table_name, index_name from all_indexes
159: where table_name = p_table_name AND OWNER = p_owner ) s
160: ON (b.index_name = s.index_name AND b.table_name = s.table_name)

Line 186: || ', ' || FND_DATE.Date_To_DisplayDt(sysdate));

182: -1);
183:
184: COMMIT;
185: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('FINISHED: Inserting Index definitions into oki_dbi_indexes for - '|| p_table_name
186: || ', ' || FND_DATE.Date_To_DisplayDt(sysdate));
187:
188: -- Once all indexes are stored in oki_dbi_indexes
189: -- drop all the existing indexes of MV from the DB
190: FOR i IN c_idx LOOP

Line 249: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Starting to create index '||i.index_name||' from oki_dbi_indexes at: '|| FND_DATE.Date_To_DisplayDt(sysdate));

245: ELSIF(INSTR(l_mod_create_stmt,'PARALLEL') <= 0) THEN
246: l_mod_create_stmt := l_mod_create_stmt || ' PARALLEL';
247: END IF;
248:
249: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Starting to create index '||i.index_name||' from oki_dbi_indexes at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
250: EXECUTE IMMEDIATE l_mod_create_stmt;
251: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log(' Created index '||i.index_name||' at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
252: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
253:

Line 251: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log(' Created index '||i.index_name||' at: '|| FND_DATE.Date_To_DisplayDt(sysdate));

247: END IF;
248:
249: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Starting to create index '||i.index_name||' from oki_dbi_indexes at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
250: EXECUTE IMMEDIATE l_mod_create_stmt;
251: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log(' Created index '||i.index_name||' at: '|| FND_DATE.Date_To_DisplayDt(sysdate));
252: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
253:
254: EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name||' LOGGING NOPARALLEL';
255:

Line 258: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Indexes created at '||FND_DATE.Date_To_DisplayDt(sysdate));

254: EXECUTE IMMEDIATE 'ALTER INDEX '||i.index_name||' LOGGING NOPARALLEL';
255:
256: END LOOP;
257:
258: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Indexes created at '||FND_DATE.Date_To_DisplayDt(sysdate));
259: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Cleaning the table oki_dbi_indexes for indexes of '||p_table_name);
260:
261: DELETE FROM oki_dbi_indexes
262: WHERE table_name = p_table_name;

Line 306: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Start of Sleep at '|| FND_DATE.Date_To_DisplayDt(sysdate));

302: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Got value for '|| BIS_BIA_RSG_CUSTOM_API_MGMNT.Para_Mv_Refresh_Method|| ': '|| l_mv_refresh_method);
303:
304: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
305: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('-------------------------');
306: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Start of Sleep at '|| FND_DATE.Date_To_DisplayDt(sysdate));
307:
308: IF l_mode = 'BEFORE'
309: THEN
310: dbms_lock.sleep(10);

Line 313: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('End of Sleep at '|| FND_DATE.Date_To_DisplayDt(sysdate));

309: THEN
310: dbms_lock.sleep(10);
311: END IF;
312:
313: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('End of Sleep at '|| FND_DATE.Date_To_DisplayDt(sysdate));
314: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('-------------------------');
315: BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('');
316:
317: COMMIT;