[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
997: FND_MESSAGE.set_name('PV', 'PV_EMPTY_ROLE');
998: FND_MSG_PUB.add;
999: RAISE FND_API.g_exc_unexpected_error;
1000: ELSE
1001: -- Insert into table PV_LEAD_ASSIGNMENTS with STATUS to PT_CREATED.
1002: -- Populate data with the following values.
1003: l_assignment_rec.lead_id := l_lead_id;
1004: l_assignment_rec.partner_id := p_party_relation_id;
1005: l_assignment_rec.source_type := l_source_type;
1663: SELECT pn.user_id, pn.resource_id, fu.user_name ,
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
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
1766: cursor lc_get_pt_org_name(pc_item_type varchar2, pc_item_key varchar2) is
1767: select pt.party_name, pvas.partner_id
1768: from hz_parties pt,
1769: pv_partner_profiles pvpp,
1770: pv_lead_assignments pvas
1771: where pvas.wf_item_type = pc_item_type
1772: and pvas.wf_item_key = pc_item_key
1773: and pvas.partner_id = pvpp.partner_id
1774: and pvpp.partner_party_id = pt.party_id;