APPS.XLA_MO_REPORTING_API dependencies on FND_PROFILE

Line 237: l_top_reporting_level fnd_profile_option_values.profile_option_value%TYPE;

233: --
234: PROCEDURE Validate_Reporting_Level
235: ( p_reporting_level IN VARCHAR2 )
236: IS
237: l_top_reporting_level fnd_profile_option_values.profile_option_value%TYPE;
238:
239: CURSOR l_check_reporting_level
240: ( x_reporting_level IN VARCHAR2
241: , x_top_reporting_level IN VARCHAR2

Line 261: l_top_reporting_level := fnd_profile.value('XLA_MO_TOP_REPORTING_LEVEL');

257: 'Calling PL/SQL procedure XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL:'||
258: ' p_reporting_level=>'||p_reporting_level);
259: END IF;
260:
261: l_top_reporting_level := fnd_profile.value('XLA_MO_TOP_REPORTING_LEVEL');
262:
263: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
265: 'xla.plsql.XLA_MO_REPORTING_API.VALIDATE_REPORTING_LEVEL.config',

Line 323: AND DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')

319: /* Commented out NOCOPY the code below, since it does not work for reporting set
320: of books. Intead, making a call to validate_reporting_level to make sure
321: that p_reporting_level value is within the allowed value for profile option
322: value for MO: Top Reporting Level.
323: AND DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')
324: , '1000', set_of_books_id
325: , '2000', legal_entity_id
326: , '3000', operating_unit_id) =
327: ( SELECT DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')

Line 327: ( SELECT DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')

323: AND DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')
324: , '1000', set_of_books_id
325: , '2000', legal_entity_id
326: , '3000', operating_unit_id) =
327: ( SELECT DECODE( fnd_profile.value_wnps('XLA_MO_TOP_REPORTING_LEVEL')
328: , '1000', TO_NUMBER(org_information3)
329: , '2000', TO_NUMBER(org_information2)
330: , '3000', organization_id )
331: FROM hr_organization_information

Line 332: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')

328: , '1000', TO_NUMBER(org_information3)
329: , '2000', TO_NUMBER(org_information2)
330: , '3000', organization_id )
331: FROM hr_organization_information
332: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')
333: AND org_information_context = 'Operating Unit Information'
334: )
335: */
336: AND entity_id = x_reporting_entity_id;