DBA Data[Home] [Help]

APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on FND_DATE

Line 587: l_start_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_start_date));

583: g_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
584:
585: --fix bug#3170105
586: flm_timezone.init_timezone(arg_org_id);
587: l_start_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_start_date));
588: l_end_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_end_date))+1-1/(24*60*60);
589: l_sysdate := flm_timezone.sysdate00_in_server;
590: --end of fix bug#3170105
591:

Line 588: l_end_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_end_date))+1-1/(24*60*60);

584:
585: --fix bug#3170105
586: flm_timezone.init_timezone(arg_org_id);
587: l_start_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_start_date));
588: l_end_date := flm_timezone.client_to_server(fnd_date.canonical_to_date(arg_end_date))+1-1/(24*60*60);
589: l_sysdate := flm_timezone.sysdate00_in_server;
590: --end of fix bug#3170105
591:
592: FOR scheds1 IN scheds(l_start_date, l_end_date, l_sysdate) LOOP --fix bug#3170105