APPS.FND_MO_REPORTING_API dependencies on FND_PROFILE

Line 376: l_top_reporting_level fnd_profile_option_values.profile_option_value%TYPE;

372: PROCEDURE Validate_Reporting_Level
373: ( p_reporting_level IN VARCHAR2 )
374: IS
375:
376: l_top_reporting_level fnd_profile_option_values.profile_option_value%TYPE;
377:
378: CURSOR l_check_reporting_level
379: ( x_reporting_level IN VARCHAR2
380: , x_top_reporting_level IN VARCHAR2

Line 394: l_top_reporting_level := fnd_profile.value('FND_MO_TOP_REPORTING_LEVEL');

390: l_dummy NUMBER;
391:
392: BEGIN
393:
394: l_top_reporting_level := fnd_profile.value('FND_MO_TOP_REPORTING_LEVEL');
395:
396: OPEN l_check_reporting_level( p_reporting_level, l_top_reporting_level);
397: FETCH l_check_reporting_level INTO l_dummy;
398:

Line 438: AND DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')

434: IS
435: SELECT 1
436: FROM FND_MO_REPORTING_ENTITIES_V
437: WHERE reporting_level = p_reporting_level
438: AND DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
439: , '1000', ledger_id
440: , '3000', operating_unit_id) =
441: ( SELECT DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
442: , '1000', TO_NUMBER(org_information3)

Line 441: ( SELECT DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')

437: WHERE reporting_level = p_reporting_level
438: AND DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
439: , '1000', ledger_id
440: , '3000', operating_unit_id) =
441: ( SELECT DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
442: , '1000', TO_NUMBER(org_information3)
443: , '3000', organization_id )
444: FROM hr_organization_information
445: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')

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

441: ( SELECT DECODE( fnd_profile.value_wnps('FND_MO_TOP_REPORTING_LEVEL')
442: , '1000', TO_NUMBER(org_information3)
443: , '3000', organization_id )
444: FROM hr_organization_information
445: WHERE organization_id = fnd_profile.value_wnps('ORG_ID')
446: AND org_information_context = 'Operating Unit Information'
447: )
448: AND entity_id = x_reporting_entity_id;
449: