DBA Data[Home] [Help]

APPS.ISC_DEPOT_BACKLOG_ETL_PKG dependencies on FND_PROFILE

Line 200: l_org := fnd_profile.value_specific

196: /* Get the site level value for Service: Inventory Validation Organization */
197: if l_master_org is null then
198:
199: l_stmt_id := 10;
200: l_org := fnd_profile.value_specific
201: ( name => 'CS_INV_VALIDATION_ORG'
202: , user_id => -1
203: , responsibility_id => -1
204: , application_id => -1

Line 213: from fnd_profile_options_vl

209:
210: l_stmt_id := 20;
211: select user_profile_option_name
212: into l_profile_name
213: from fnd_profile_options_vl
214: where profile_option_name = 'CS_INV_VALIDATION_ORG';
215:
216: fnd_message.set_name( 'ISC', 'ISC_DEPOT_MISSING_INV_VAL_ORG' );
217: fnd_message.set_token( 'ISC_DEPOT_PROFILE_NAME', l_profile_name );