DBA Data[Home] [Help]

APPS.FLM_CREATE_PRODUCT_SYNCH dependencies on FLM_TIMEZONE

Line 142: if ( l_date = (flm_timezone.server_to_calendar(l_date)+l_start_time/(24*3600)) ) then

138: --fix bug#3170105
139: --if ( l_date = (trunc(l_date)+l_start_time/(24*3600)) ) then
140: -- l_date := mrp_calendar.prev_work_day(p_org_id,1,trunc(l_date)-1)+l_stop_time/(24*3600);
141: --end if;
142: if ( l_date = (flm_timezone.server_to_calendar(l_date)+l_start_time/(24*3600)) ) then
143: l_date := mrp_calendar.prev_work_day(p_org_id,1,
144: flm_timezone.server_to_calendar(l_date)-1)+l_stop_time/(24*3600);
145: end if;
146: --end of fix bug#3170105

Line 144: flm_timezone.server_to_calendar(l_date)-1)+l_stop_time/(24*3600);

140: -- l_date := mrp_calendar.prev_work_day(p_org_id,1,trunc(l_date)-1)+l_stop_time/(24*3600);
141: --end if;
142: if ( l_date = (flm_timezone.server_to_calendar(l_date)+l_start_time/(24*3600)) ) then
143: l_date := mrp_calendar.prev_work_day(p_org_id,1,
144: flm_timezone.server_to_calendar(l_date)-1)+l_stop_time/(24*3600);
145: end if;
146: --end of fix bug#3170105
147:
148: return (l_date);

Line 586: flm_timezone.init_timezone(arg_org_id);

582:
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

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

Line 589: l_sysdate := flm_timezone.sysdate00_in_server;

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
593: var_build_seq_id := scheds1.build_sequence;