DBA Data[Home] [Help]

APPS.CST_PERIODIC_ABSORPTION_PROC dependencies on FND_DATE

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

284:
285: CLOSE process_upto_date_cur;
286:
287: x_process_upto_date :=
288: TRUNC(FND_DATE.canonical_to_date(l_process_upto_date)) + (86399/86400);
289:
290: RETURN x_process_upto_date;
291:
292: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

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

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

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