DBA Data[Home] [Help]

APPS.IBE_BI_STR_MIG_PVT dependencies on FND_PROFILE

Line 678: to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) org_id

674: CURSOR c_unique_orgs is
675: SELECT org_id
676: FROM
677: (SELECT distinct msite_id,
678: to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) org_id
679: FROM ibe_msite_resps_b)
680: WHERE org_id IS NOT NULL
681: GROUP BY org_id
682: HAVING count(*) = 1;

Line 686: WHERE to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) = c_org_id;

682: HAVING count(*) = 1;
683:
684: CURSOR c_msite_org(c_org_id NUMBER) IS
685: SELECT i.msite_id FROM ibe_msite_resps_b i
686: WHERE to_number(fnd_profile.value_specific('ORG_ID', -99999, responsibility_id, application_id)) = c_org_id;
687:
688: BEGIN
689:
690: printLog('Procedure find_org_minisite_hits : Start');

Line 762: l_msite_prof_check := FND_PROFILE.VALUE_SPECIFIC('IBE_USE_MINISITE_PRICELIST',null,null,671);

758: -- Need to be updating based on PRICE_LIST_ID mapping in iStore New Merchant UI,
759: -- ONLY if the profile "IBE: Use Price list associated with Specialty Store" is
760: -- enabled at the "iStore" application level.
761:
762: l_msite_prof_check := FND_PROFILE.VALUE_SPECIFIC('IBE_USE_MINISITE_PRICELIST',null,null,671);
763:
764: IF l_msite_prof_check = 'Y' THEN
765:
766: FOR crec in c_get_priclist(p_party_type) LOOP