DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on FND_PROFILE

Line 509: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN

505: END IF;
506: x_ReturnStatus := fnd_api.g_ret_sts_success ;
507: fnd_file.put_line(FND_FILE.LOG,'Time Zone Conversions');
508:
509: IF(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
510:
511: HZ_TIMEZONE_PUB.Get_Time(
512: p_api_version => 1.0,
513: p_init_msg_list => 'F',

Line 514: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

510:
511: HZ_TIMEZONE_PUB.Get_Time(
512: p_api_version => 1.0,
513: p_init_msg_list => 'F',
514: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
515: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
516: p_source_day_time => fnd_date.canonical_to_date(p_from_start_date) ,
517: x_dest_day_time => x_from_start_date ,
518: x_return_status => l_return_status,

Line 515: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

511: HZ_TIMEZONE_PUB.Get_Time(
512: p_api_version => 1.0,
513: p_init_msg_list => 'F',
514: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
515: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
516: p_source_day_time => fnd_date.canonical_to_date(p_from_start_date) ,
517: x_dest_day_time => x_from_start_date ,
518: x_return_status => l_return_status,
519: x_msg_count => l_msg_count,

Line 525: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

521:
522: HZ_TIMEZONE_PUB.Get_Time(
523: p_api_version => 1.0,
524: p_init_msg_list => 'F',
525: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
526: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
527: p_source_day_time => fnd_date.canonical_to_date(p_to_start_date) ,
528: x_dest_day_time => x_to_start_date ,
529: x_return_status => l_return_status,

Line 526: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

522: HZ_TIMEZONE_PUB.Get_Time(
523: p_api_version => 1.0,
524: p_init_msg_list => 'F',
525: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
526: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
527: p_source_day_time => fnd_date.canonical_to_date(p_to_start_date) ,
528: x_dest_day_time => x_to_start_date ,
529: x_return_status => l_return_status,
530: x_msg_count => l_msg_count,

Line 536: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

532:
533: HZ_TIMEZONE_PUB.Get_Time(
534: p_api_version => 1.0,
535: p_init_msg_list => 'F',
536: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
537: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
538: p_source_day_time => fnd_date.canonical_to_date(p_from_release_date) ,
539: x_dest_day_time => x_from_release_date ,
540: x_return_status => l_return_status,

Line 537: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

533: HZ_TIMEZONE_PUB.Get_Time(
534: p_api_version => 1.0,
535: p_init_msg_list => 'F',
536: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
537: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
538: p_source_day_time => fnd_date.canonical_to_date(p_from_release_date) ,
539: x_dest_day_time => x_from_release_date ,
540: x_return_status => l_return_status,
541: x_msg_count => l_msg_count,

Line 547: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

543:
544: HZ_TIMEZONE_PUB.Get_Time(
545: p_api_version => 1.0,
546: p_init_msg_list => 'F',
547: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
548: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
549: p_source_day_time => fnd_date.canonical_to_date(p_to_release_date) ,
550: x_dest_day_time => x_to_release_date ,
551: x_return_status => l_return_status,

Line 548: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

544: HZ_TIMEZONE_PUB.Get_Time(
545: p_api_version => 1.0,
546: p_init_msg_list => 'F',
547: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
548: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
549: p_source_day_time => fnd_date.canonical_to_date(p_to_release_date) ,
550: x_dest_day_time => x_to_release_date ,
551: x_return_status => l_return_status,
552: x_msg_count => l_msg_count,

Line 558: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

554:
555: HZ_TIMEZONE_PUB.Get_Time(
556: p_api_version => 1.0,
557: p_init_msg_list => 'F',
558: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
559: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
560: p_source_day_time => fnd_date.canonical_to_date(p_from_completion_date) ,
561: x_dest_day_time => x_from_completion_date ,
562: x_return_status => l_return_status,

Line 559: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

555: HZ_TIMEZONE_PUB.Get_Time(
556: p_api_version => 1.0,
557: p_init_msg_list => 'F',
558: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
559: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
560: p_source_day_time => fnd_date.canonical_to_date(p_from_completion_date) ,
561: x_dest_day_time => x_from_completion_date ,
562: x_return_status => l_return_status,
563: x_msg_count => l_msg_count,

Line 569: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

565:
566: HZ_TIMEZONE_PUB.Get_Time(
567: p_api_version => 1.0,
568: p_init_msg_list => 'F',
569: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
570: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
571: p_source_day_time => fnd_date.canonical_to_date(p_to_completion_date) ,
572: x_dest_day_time => x_to_completion_date ,
573: x_return_status => l_return_status,

Line 570: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

566: HZ_TIMEZONE_PUB.Get_Time(
567: p_api_version => 1.0,
568: p_init_msg_list => 'F',
569: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
570: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
571: p_source_day_time => fnd_date.canonical_to_date(p_to_completion_date) ,
572: x_dest_day_time => x_to_completion_date ,
573: x_return_status => l_return_status,
574: x_msg_count => l_msg_count,

Line 580: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),

576: /* Bug 10032341: actual close date is already converted to server timezone before being passed to wip_close api*/
577: /* HZ_TIMEZONE_PUB.Get_Time(
578: p_api_version => 1.0,
579: p_init_msg_list => 'F',
580: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
581: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
582: p_source_day_time => fnd_date.canonical_to_date(p_act_close_date) ,
583: x_dest_day_time => x_act_close_date ,
584: x_return_status => l_return_status,

Line 581: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),

577: /* HZ_TIMEZONE_PUB.Get_Time(
578: p_api_version => 1.0,
579: p_init_msg_list => 'F',
580: p_source_tz_id => to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID')),
581: p_dest_tz_id => to_number(fnd_profile.value_specific('SERVER_TIMEZONE_ID')),
582: p_source_day_time => fnd_date.canonical_to_date(p_act_close_date) ,
583: x_dest_day_time => x_act_close_date ,
584: x_return_status => l_return_status,
585: x_msg_count => l_msg_count,

Line 1760: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');

1756:
1757: x_ReturnStatus := fnd_api.g_ret_sts_success;
1758: SORT_BY_JOB := 1 ;
1759: l_report_type := p_report_type ;
1760: l_precision_profile := fnd_profile.value('REPORT_QUANTITY_PRECISION');
1761:
1762: IF ( l_precision_profile = NULL ) then
1763: l_precision_profile := 2;
1764: END IF ;