APPS.PV_BENFT_STATUS_CHANGE dependencies on FND_PROFILE

Line 1275: l_partner_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');

1271: l_notes_varchar := l_notes;
1272: end if;
1273:
1274:
1275: l_partner_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
1276: l_partner_url := substr(l_partner_url,1,instr(l_partner_url,'/',1,3)-1); -- just get the http://:
1277:
1278: if p_itemtype = 'PVREFFRL' then
1279:

Line 1605: if fnd_profile.value('PV_COPY_OWNER_ON_NOTIFICATION') = 'Y' then

1601: l_role_list := substr(l_role_list,2);
1602:
1603: elsif p_user_role = 'LEAD_OWNER' then
1604:
1605: if fnd_profile.value('PV_COPY_OWNER_ON_NOTIFICATION') = 'Y' then
1606:
1607: for l_row in lc_get_lead_owner(pc_entity_id => p_entity_id) loop
1608: l_role_list := l_role_list || ',' || l_row.user_name;
1609: end loop;

Line 1616: if fnd_profile.value('PV_COPY_OWNER_ON_NOTIFICATION') = 'Y' then

1612: end if;
1613:
1614: elsif p_user_role = 'OPPTY_SLSTEAM_INT' then
1615:
1616: if fnd_profile.value('PV_COPY_OWNER_ON_NOTIFICATION') = 'Y' then
1617:
1618: for l_row in lc_get_oppty_slsteam(pc_entity_id => p_entity_id) loop
1619: l_role_list := l_role_list || ',' || l_row.user_name;
1620: end loop;