APPS.PV_ASSIGNMENT_PVT dependencies on FND_PROFILE

Line 1680: --l_server_timezone_id := fnd_profile.value('AMS_SYSTEM_TIMEZONE_ID');

1676: fnd_msg_pub.Add;
1677: END IF;
1678:
1679:
1680: --l_server_timezone_id := fnd_profile.value('AMS_SYSTEM_TIMEZONE_ID');
1681: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1682:
1683:
1684:

Line 1681: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');

1677: END IF;
1678:
1679:
1680: --l_server_timezone_id := fnd_profile.value('AMS_SYSTEM_TIMEZONE_ID');
1681: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
1682:
1683:
1684:
1685: select UPGRADE_TZ_ID into l_GMT_timezone_id

Line 1701: 'select nvl(max(timeout_period), fnd_profile.value(:bv1))*60 ' ||

1697: -- If the address is not provided, it will retrieve the timeout from
1698: -- a default profile value (PV_DEFAULT_PT_TIMEOUT or PV_DEFAULT_CM_TIMEOUT).
1699: -- -----------------------------------------------------------------------
1700: l_query :=
1701: 'select nvl(max(timeout_period), fnd_profile.value(:bv1))*60 ' ||
1702: 'from pv_country_timeouts pr ' ||
1703: 'where pr.timeout_type = :1 ' ||
1704: 'and pr.country_code in ';
1705:

Line 2874: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');

2870: itemkey => p_itemkey,
2871: aname => pv_workflow_pub.g_wf_attr_address_id,
2872: avalue => p_attrib_values_rec.address_id);
2873:
2874: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
2875: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
2876:
2877: -- Setting CM Respond URL Attribute
2878: wf_engine.SetItemAttrText ( itemtype => p_itemType,

Line 2875: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');

2871: aname => pv_workflow_pub.g_wf_attr_address_id,
2872: avalue => p_attrib_values_rec.address_id);
2873:
2874: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
2875: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
2876:
2877: -- Setting CM Respond URL Attribute
2878: wf_engine.SetItemAttrText ( itemtype => p_itemType,
2879: itemkey => p_itemKey,

Line 2950: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), pv_workflow_pub.g_wf_lkup_yes);

2946: itemkey => p_itemKey,
2947: aname => pv_workflow_pub.g_wf_attr_assignment_type,
2948: avalue => p_attrib_values_rec.assignment_type);
2949:
2950: l_email_enabled := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), pv_workflow_pub.g_wf_lkup_yes);
2951:
2952: wf_engine.SetItemAttrText ( itemtype => p_itemType,
2953: itemkey => p_itemKey,
2954: aname => pv_workflow_pub.g_wf_attr_email_enabled,

Line 3604: l_email_enabled_flag := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), pv_workflow_pub.g_wf_lkup_yes);

3600: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => p_itemtype,
3601: itemkey => p_itemkey,
3602: aname => pv_workflow_pub.g_wf_attr_opportunity_id);
3603:
3604: l_email_enabled_flag := nvl(fnd_profile.value('PV_EMAIL_NOTIFICATION_FLAG'), pv_workflow_pub.g_wf_lkup_yes);
3605:
3606: l_rank := wf_engine.GetItemAttrNumber( itemtype => p_itemtype,
3607: itemkey => p_itemkey,
3608: aname => pv_workflow_pub.g_wf_attr_current_serial_rank);

Line 3737: l_profile_flag := nvl(fnd_profile.value_specific(name => 'PV_' || p_route_stage || '_NOTIFY_FLAG',

3733: end if;
3734:
3735: end if;
3736:
3737: l_profile_flag := nvl(fnd_profile.value_specific(name => 'PV_' || p_route_stage || '_NOTIFY_FLAG',
3738: user_id => l_user_id), 'Y');
3739:
3740: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3741: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 4228: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');

4224: itemkey => l_itemkey,
4225: aname => pv_workflow_pub.g_wf_attr_assignment_type,
4226: avalue => p_attrib_values_rec.assignment_type);
4227:
4228: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
4229: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
4230:
4231: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
4232: itemkey => l_itemkey,

Line 4229: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');

4225: aname => pv_workflow_pub.g_wf_attr_assignment_type,
4226: avalue => p_attrib_values_rec.assignment_type);
4227:
4228: l_vendor_respond_url := fnd_profile.value('PV_WORKFLOW_RESPOND_SELF_SERVICE_URL');
4229: l_pt_respond_url := fnd_profile.value('PV_WORKFLOW_ISTORE_URL');
4230:
4231: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
4232: itemkey => l_itemkey,
4233: aname => pv_workflow_pub.g_wf_attr_cm_respond_url,