APPS.AMS_LIST_RUNNING_TOTAL_PVT dependencies on FND_PROFILE

Line 71: IF NVL(FND_PROFILE.VALUE('AMS_ENABLE_RECALC_AND_PREVIEW'), 'N') = 'Y'

67: select owner from sys.all_tables
68: where table_name = c_view_name;
69:
70: BEGIN
71: IF NVL(FND_PROFILE.VALUE('AMS_ENABLE_RECALC_AND_PREVIEW'), 'N') = 'Y'
72: THEN
73: l_request_id := FND_REQUEST.SUBMIT_REQUEST(
74: application => 'AMS',
75: program => 'AMSGMVTP',

Line 641: l_sample_size := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_SIZE');

637: fetch c_total_attributes into l_total_attributes;
638: close c_total_attributes;
639:
640: --Get values from profiles
641: l_sample_size := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_SIZE');
642: -- batoleti Bug# 4684584 the 'AMS_LIST_QT_SAMPLE_PCT' is considered only when taking the sample records.
643: -- in other cases, the sample_pct should be zero.
644: l_sample_pct := 0;
645:

Line 650: l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');

646: Ams_Utility_Pvt.Write_Conc_log('Profile Value of AMS_LIST_QT_SAMPLE_SIZE : '|| to_char(l_sample_size));
647: Ams_Utility_Pvt.Write_Conc_log('Profile Value of AMS_LIST_QT_SAMPLE_PCT : '|| to_char(l_sample_pct));
648:
649: if l_master_total_records > l_sample_size then
650: l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');
651: l_sample := 'Y';
652: l_sample_records := round((l_master_total_records * l_sample_pct)/100);
653: -- l_sample_pct := 30;
654: -- l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');

Line 654: -- l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');

650: l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');
651: l_sample := 'Y';
652: l_sample_records := round((l_master_total_records * l_sample_pct)/100);
653: -- l_sample_pct := 30;
654: -- l_sample_pct := FND_PROFILE.VALUE('AMS_LIST_QT_SAMPLE_PCT');
655: -- Ams_Utility_Pvt.Write_Conc_log('Sampling percentage = '||l_sample_pct);
656: -- Ams_Utility_Pvt.Write_Conc_log('Sampling size = '||l_sample_size);
657: else
658: l_sample := 'N';

Line 803: l_number_of_days := FND_PROFILE.VALUE('AMS_ORDER_LOOK_BACK_PRD_DAYS');

799: -- Construct The Where Clause
800: -- --------------------------
801: -- --------------------------------------------------------
802:
803: l_number_of_days := FND_PROFILE.VALUE('AMS_ORDER_LOOK_BACK_PRD_DAYS');
804: Ams_Utility_Pvt.Write_Conc_log('Profile value for Orders look back period: '||l_number_of_days);
805: Ams_Utility_Pvt.Write_Conc_log('Start: Construct The Where Clause ');
806: l_total_attributes := 0;
807: open c_tot_attributes_alias;