[Home] [Help]
49: pc_itemKey varchar2,
50: pc_notify_type varchar2,
51: pc_assign_status varchar2) is
52: select distinct usr.user_name
53: from pv_lead_assignments aa, pv_party_notifications bb, fnd_user usr
54: where bb.wf_item_key = pc_itemKey
55: and bb.wf_item_type = pc_itemType
56: and bb.notification_type = pc_notify_type
57: and bb.lead_assignment_id = aa.lead_assignment_id
1027: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031: -- Insert into table PV_PARTY_NOTIFICATIONS. Populate data with the
1032: -- following values. Extend the table for the number of channel managers
1033:
1034: l_new_resource_count := l_rs_details_tbl.count;
1035:
1664: decode(pn.notification_type, 'MATCHED_TO', 'CM', 'PT') user_type,
1665: decode(pn.notification_type, 'MATCHED_TO', 0, pa.partner_id) partner_id
1666: FROM pv_lead_workflows pw,
1667: pv_lead_assignments pa,
1668: pv_party_notifications pn,
1669: jtf_rs_resource_extns extn,
1670: as_accesses_all asac,
1671: fnd_user fu
1672: WHERE pw.wf_item_type = pa.wf_item_type
1703: and sysdate between js.start_date_active and nvl(js.end_date_active,sysdate)
1704: AND sysdate between fu.start_date and nvl(fu.end_date,sysdate)
1705: AND NOT EXISTS
1706: (SELECT 1
1707: FROM pv_lead_assignments pl, pv_party_notifications pv
1708: WHERE pl.lead_assignment_id = pv.lead_assignment_id
1709: AND pv.resource_id = ac.salesforce_id
1710: and pv.user_id <> pw.created_by
1711: AND pl.wf_item_type = pw.wf_item_type