DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on FND_DATE

Line 308: TRUNC(FND_DATE.canonical_to_date(l_process_upto_date)) + (86399/86400);

304:
305: CLOSE process_upto_date_cur;
306:
307: x_process_upto_date :=
308: TRUNC(FND_DATE.canonical_to_date(l_process_upto_date)) + (86399/86400);
309:
310: RETURN x_process_upto_date;
311:
312: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1173: TRUNC(FND_DATE.canonical_to_date(p_process_upto_date));

1169: -- Run options 1 - Start
1170: -- Check process upto date is within the range
1171: IF p_run_options = 1 THEN
1172: l_process_upto_date :=
1173: TRUNC(FND_DATE.canonical_to_date(p_process_upto_date));
1174: FND_FILE.put_line
1175: ( FND_FILE.log
1176: , 'Process Upto Date:' || l_process_upto_date
1177: );

Line 1431: x_end_date := TRUNC(FND_DATE.canonical_to_date(l_end_date)) + (86399/86400);

1427:
1428: x_start_date := TO_DATE(l_start_date,'YYYY/MM/DD HH24:MI:SS');
1429:
1430: -- set to 23:59:59 to retrieve all the records
1431: x_end_date := TRUNC(FND_DATE.canonical_to_date(l_end_date)) + (86399/86400);
1432:
1433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1434: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1435: ,G_MODULE_HEAD || l_routine || '.end'