APPS.XLA_MO_REPORTING_API dependencies on FND_PRODUCT_GROUPS

Line 421: l_multi_org_enabled fnd_product_groups.multi_org_flag%TYPE;

417:
418: l_count NUMBER := 0;
419: l_pred VARCHAR2(2000) DEFAULT NULL;
420: l_pred_type VARCHAR2(30) DEFAULT 'EXISTS';
421: l_multi_org_enabled fnd_product_groups.multi_org_flag%TYPE;
422:
423: l_sob_type VARCHAR2(1);
424: l_reporting_entity_id NUMBER(15);
425:

Line 441: FROM fnd_product_groups

437: END IF;
438:
439: SELECT nvl(multi_org_flag, 'N')
440: INTO l_multi_org_enabled
441: FROM fnd_product_groups
442: WHERE product_group_id = 1;
443:
444: IF (l_multi_org_enabled = 'Y' AND p_use_nvl = 'N') THEN
445: l_use_nvl := 'N';

Line 453: 'nvl(fnd_product_groups.multi_org_flag,''N'')='||l_multi_org_enabled||

449:
450: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
452: 'xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.use_nvl',
453: 'nvl(fnd_product_groups.multi_org_flag,''N'')='||l_multi_org_enabled||
454: ',l_use_nvl='||l_use_nvl);
455: END IF;
456:
457: -- Validate_Reporting_Level( p_reporting_level );