DBA Data[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on FND_PROFILE

Line 576: FROM fnd_profile_option_values fpov1,

572: --Bugfix:4681253
573: /*select decode(nvl(fpov1.profile_option_value,'N'),
574: 'N', lc.displayed_field)
575: INTO l_batch_name
576: FROM fnd_profile_option_values fpov1,
577: fnd_profile_options fpo1,
578: ap_lookup_codes lc
579: WHERE fpov1.profile_option_id = fpo1.profile_option_id
580: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'

Line 577: fnd_profile_options fpo1,

573: /*select decode(nvl(fpov1.profile_option_value,'N'),
574: 'N', lc.displayed_field)
575: INTO l_batch_name
576: FROM fnd_profile_option_values fpov1,
577: fnd_profile_options fpo1,
578: ap_lookup_codes lc
579: WHERE fpov1.profile_option_id = fpo1.profile_option_id
580: AND fpo1.profile_option_name ='AP_USE_INV_BATCH_CONTROLS'
581: AND fpov1.level_id = 10004

Line 588: l_use_batch_controls := fnd_profile.value('AP_USE_INV_BATCH_CONTROLS');

584: AND rownum = 1;*/
585: --End of commenting code for bug#6926296
586:
587: --Added the below code for bug#6926296
588: l_use_batch_controls := fnd_profile.value('AP_USE_INV_BATCH_CONTROLS');
589: if nvl(l_use_batch_controls,'N') = 'N' then
590: select lc.displayed_field
591: into l_batch_name
592: from ap_lookup_codes lc

Line 6538: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);

6534: END IF;
6535: RAISE Import_Retro_Adj_failure;
6536: END IF;
6537: --
6538: FND_PROFILE.GET('UNIQUE:SEQ_NUMBERS',l_seq_num_profile);
6539: IF ((l_orig_invoices_valid = 'N') and (l_seq_num_profile = 'A')) THEN
6540: --Insert rejections
6541: IF (AP_IMPORT_UTILITIES_PKG.insert_rejections
6542: ('AP_INVOICES_INTERFACE',