[Home] [Help]
1053:
1054: cursor lc_get_default_cm is
1055: SELECT res.resource_id
1056: FROM jtf_rs_resource_extns res
1057: where resource_id = to_number(fnd_profile.value('PV_DEFAULT_CM'));
1058:
1059: cursor lc_preferred_pt_contact (pc_partner_id number, pc_opportunity_id number) is
1060: select distinct
1061: c.resource_id
1976: pv_assignment_pub.G_PT_ACCESS, 'PT',
1977: pv_assignment_pub.G_PT_ORG_ACCESS, 'PT_ORG',
1978: 'UNKNOWN') into l_temp from dual;
1979:
1980: l_pt_full_access_opp := fnd_profile.value('PV_ALLOW_PT_FULL_OPP_ACCESS');
1981:
1982:
1983: -- ------------------------------------------------------------------------------------------------
1984: -- Remove resource from sales team
2048: IF (l_sales_credit_count = 0) THEN
2049: -- ----------------------------------------------------------------------------
2050: -- Retrieve profile value that deals with non-quota sales credit.
2051: -- ----------------------------------------------------------------------------
2052: l_profile_value := FND_PROFILE.VALUE('PV_REMOVE_NON_QUOTA_SALES_CREDIT');
2053: Debug(' Profile Option value of PV_REMOVE_NON_QUOTA_SALES_CREDIT = ' || l_profile_value);
2054:
2055: FOR x IN lc_get_nonq_sales_credit(p_resource_id, p_lead_id) LOOP
2056: l_non_quota_sc_id := x.sales_credit_id;
2916: 0,
2917: null,
2918: 1,
2919: TO_CHAR(MAX(grp.group_id)),
2920: FND_PROFILE.VALUE_SPECIFIC('ASF_DEFAULT_GROUP_ROLE',
2921: MAX(RES.user_id))) salesgroup_id
2922: FROM JTF_RS_GROUP_MEMBERS mem,
2923: JTF_RS_ROLE_RELATIONS rrel,
2924: JTF_RS_ROLES_B role,
3044: fnd_message.SET_NAME('PV', 'PV_MSG_FRM_CHK_FOR_ERR');
3045: fnd_message.SET_TOKEN('P_ITEM_TYPE' ,p_itemtype);
3046: fnd_message.SET_TOKEN('P_ITEM_KEY' ,p_itemkey);
3047:
3048: if fnd_profile.value('ASF_PROFILE_DEBUG_MSG_ON') = 'Y' then
3049:
3050: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3051: fnd_message.Set_Token('TEXT', l_wf_error_stack);
3052: fnd_msg_pub.Add;