[Home] [Help]
183:
184: cursor lc_get_lead_workflow_id (pc_item_key varchar2)
185: is
186: select lead_workflow_id
187: from pv_lead_workflows
188: where wf_item_type = 'PVASGNMT'
189: and wf_item_key = pc_item_key;
190:
191: -- Start : Rivendell changes
1284: l_rs_details_tbl pv_assign_util_pvt.resource_details_tbl_type := pv_assign_util_pvt.resource_details_tbl_type();
1285: l_pt_response_tbl g_varchar_table_type := g_varchar_table_type();
1286:
1287: cursor lc_get_assignment_type (pc_lead_id number, pc_entity varchar2) is
1288: select routing_type from pv_lead_workflows
1289: where lead_id = pc_lead_id and entity = pc_entity and latest_routing_flag = 'Y';
1290:
1291: cursor lc_get_assignment (pc_lead_id number,
1292: pc_username varchar2) is
1302: , c.resource_id
1303: , c.decision_maker_flag
1304: , c.notification_type
1305: , c.user_id
1306: from pv_lead_workflows a, pv_lead_assignments b, pv_party_notifications c, fnd_user usr
1307: where a.lead_id = pc_lead_id
1308: and a.wf_status = g_wf_status_open
1309: and a.wf_item_type = b.wf_item_type
1310: and a.wf_item_key = b.wf_item_key
1937: is
1938: select a.wf_item_type, a.wf_item_key, a.routing_status, a.wf_status,
1939: b.lead_assignment_id, b.status, b.assign_sequence,
1940: c.rowid, c.resource_id, c.decision_maker_flag, c.user_id
1941: from pv_lead_workflows a, pv_lead_assignments b, pv_party_notifications c, fnd_user usr
1942: where a.lead_id = pc_lead_id
1943: and a.entity = pc_entity
1944: and a.wf_item_type = b.wf_item_type
1945: and a.wf_item_key = b.wf_item_key
2814: b.lead_number,
2815: b.description,
2816: b.total_amount||' '||b.currency_code,
2817: c.party_name
2818: from pv_lead_workflows a
2819: , as_leads_all b
2820: , hz_parties c
2821: where a.lead_id = pc_lead_id
2822: and b.customer_id = c.party_id
2828: cursor lc_get_assignment (pc_lead_id number
2829: , pc_entity varchar2)
2830: is
2831: select b.lead_assignment_id, b.assign_sequence, b.status
2832: from pv_lead_workflows a, pv_lead_assignments b
2833: where a.lead_id = pc_lead_id and a.latest_routing_flag = 'Y' and a.entity = pc_entity
2834: and a.wf_item_type = b.wf_item_type
2835: and a.wf_item_key = b.wf_item_key;
2836:
2861: IS
2862: SELECT extn.category
2863: , extn.source_id
2864: , pwf.created_by
2865: FROM pv_lead_workflows pwf
2866: , jtf_rs_resource_extns extn
2867: WHERE pwf.created_by = extn.user_id
2868: AND pwf.entity = 'OPPORTUNITY'
2869: AND pwf.latest_routing_flag = 'Y'
3504: IS
3505: SELECT extn.category
3506: , extn.source_id
3507: , pwf.created_by
3508: FROM pv_lead_workflows pwf
3509: , jtf_rs_resource_extns extn
3510: WHERE pwf.created_by = extn.user_id
3511: AND pwf.entity = 'OPPORTUNITY'
3512: AND pwf.latest_routing_flag = 'Y'