114: FII_UTIL.start_timer();
115: END IF;
116:
117:
118: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
119:
120: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
121: --to reset different sysdate so that we can test for snapshot tables.
122: if g_test_sysdate is NULL THEN
120: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
121: --to reset different sysdate so that we can test for snapshot tables.
122: if g_test_sysdate is NULL THEN
123: SELECT trunc(CURRENT_DATE_ID) INTO l_this_date
124: FROM BIS_SYSTEM_DATE;
125: ELSE
126: l_this_date := g_test_sysdate;
127: end if;
128:
450: FII_UTIL.start_timer();
451: END IF;
452:
453:
454: g_phase := 'Populate l_this_date FROM BIS_SYSTEM_DATE';
455:
456: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
457: --to reset different sysdate so that we can test for snapshot tables.
458: if g_test_sysdate is NULL THEN
456: --We use a un-shipped profile option FII_TEST_SYSDATE ("FII: Test Sysdate")
457: --to reset different sysdate so that we can test for snapshot tables.
458: if g_test_sysdate is NULL THEN
459: SELECT trunc(CURRENT_DATE_ID) INTO l_this_date
460: FROM BIS_SYSTEM_DATE;
461: ELSE
462: l_this_date := g_test_sysdate;
463: end if;
464: