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

Line 77: , p_load_to in varchar2 default fnd_date.date_to_canonical(sysdate)

73:
74: procedure setup
75: ( errbuf in out nocopy varchar2
76: , retcode in out nocopy varchar2
77: , p_load_to in varchar2 default fnd_date.date_to_canonical(sysdate)
78: , p_force in varchar2 default 'N'
79: ) as
80:
81: l_exception exception;

Line 160: l_collect_to_date := fnd_date.canonical_to_date(p_load_to);

156: if p_load_to is null then
157: l_error_message := 'p_load_to is a required parameter';
158: raise l_exception;
159: end if;
160: l_collect_to_date := fnd_date.canonical_to_date(p_load_to);
161: if l_collect_to_date > sysdate then
162: l_error_message := 'p_load_to must less than or equal to ' ||
163: fnd_date.date_to_displaydt(sysdate);
164: raise l_exception;

Line 163: fnd_date.date_to_displaydt(sysdate);

159: end if;
160: l_collect_to_date := fnd_date.canonical_to_date(p_load_to);
161: if l_collect_to_date > sysdate then
162: l_error_message := 'p_load_to must less than or equal to ' ||
163: fnd_date.date_to_displaydt(sysdate);
164: raise l_exception;
165: end if;
166:
167: -- @@@@@@@@ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Line 283: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

279: , g_login_id
280: );
281:
282: bis_collection_utilities.log('Starting new Initial Load');
283: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
284: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
285:
286: else
287:

Line 284: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

280: );
281:
282: bis_collection_utilities.log('Starting new Initial Load');
283: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
284: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
285:
286: else
287:
288: bis_collection_utilities.log('Resuming previous incomplete Initial Load');

Line 289: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

285:
286: else
287:
288: bis_collection_utilities.log('Resuming previous incomplete Initial Load');
289: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
290: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
291:
292: end if;
293:

Line 290: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

286: else
287:
288: bis_collection_utilities.log('Resuming previous incomplete Initial Load');
289: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
290: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
291:
292: end if;
293:
294: commit;

Line 391: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

387: raise l_exception;
388: end if;
389:
390: bis_collection_utilities.log('Starting Activity Initial Load');
391: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
392: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
393:
394: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ACTIVITY_SUM_F');
395:

Line 392: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

388: end if;
389:
390: bis_collection_utilities.log('Starting Activity Initial Load');
391: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
392: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
393:
394: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_ACTIVITY_SUM_F');
395:
396: if biv_dbi_collection_util.truncate_table

Line 620: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

616: raise l_exception;
617: end if;
618:
619: bis_collection_utilities.log('Starting Closed Initial Load');
620: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
621: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
622:
623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');
624:

Line 621: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

617: end if;
618:
619: bis_collection_utilities.log('Starting Closed Initial Load');
620: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
621: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
622:
623: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_CLOSED_SUM_F');
624:
625: if biv_dbi_collection_util.truncate_table

Line 889: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

885: raise l_exception;
886: end if;
887:
888: bis_collection_utilities.log('Starting Backlog Initial Load');
889: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
890: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
891:
892: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_BACKLOG_SUM_F');
893:

Line 890: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

886: end if;
887:
888: bis_collection_utilities.log('Starting Backlog Initial Load');
889: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
890: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
891:
892: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_BACKLOG_SUM_F');
893:
894: if biv_dbi_collection_util.truncate_table

Line 1402: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);

1398: raise l_exception;
1399: end if;
1400:
1401: bis_collection_utilities.log('Starting Resolution Initial Load');
1402: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:

Line 1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);

1399: end if;
1400:
1401: bis_collection_utilities.log('Starting Resolution Initial Load');
1402: bis_collection_utilities.log('From ' || fnd_date.date_to_displaydt(l_collect_from_date),1);
1403: bis_collection_utilities.log('To ' || fnd_date.date_to_displaydt(l_collect_to_date),1);
1404:
1405: bis_collection_utilities.log('Truncating table '||l_biv_schema||'.'||'BIV_DBI_RESOLUTION_SUM_F');
1406:
1407: if biv_dbi_collection_util.truncate_table