[Home] [Help]
720: END IF;
721:
722: x_return_status := FND_API.G_RET_STS_SUCCESS ;
723:
724: select pv_lead_workflows_s.nextval into l_Lead_Workflow_ID from sys.dual;
725:
726: insert into pv_lead_workflows(
727: LEAD_WORKFLOW_ID,
728: LAST_UPDATE_DATE,
722: x_return_status := FND_API.G_RET_STS_SUCCESS ;
723:
724: select pv_lead_workflows_s.nextval into l_Lead_Workflow_ID from sys.dual;
725:
726: insert into pv_lead_workflows(
727: LEAD_WORKFLOW_ID,
728: LAST_UPDATE_DATE,
729: LAST_UPDATED_BY,
730: CREATION_DATE,
770: x_itemkey := to_char(l_lead_workflow_id);
771:
772: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
773: fnd_message.SET_NAME('PV', 'PV_DEBUG_MESSAGE');
774: fnd_message.Set_token('TEXT', 'Row created in pv_lead_workflows ');
775: fnd_msg_pub.Add;
776: END IF;
777:
778: IF p_workflow_rec.routing_status = PV_ASSIGNMENT_PUB.g_r_status_failed_auto THEN
1701: and lead_id = pc_lead_id;
1702:
1703: cursor lc_get_am_and_owner (pc_lead_id number) is
1704: select am.resource_id, owner.resource_id
1705: from pv_lead_workflows wf, jtf_rs_resource_extns am, as_leads_all ld, jtf_rs_resource_extns owner
1706: where wf.lead_id = pc_lead_id
1707: and wf.entity = 'OPPORTUNITY'
1708: and wf.latest_routing_flag = 'Y'
1709: and wf.created_by = am.user_id
1735:
1736: cursor lc_get_pt_access(pc_lead_id number)
1737: is
1738: SELECT pn.resource_id
1739: FROM pv_lead_workflows pw, pv_lead_assignments pa,
1740: pv_party_notifications pn
1741: WHERE pw.wf_item_key = pa.wf_item_key
1742: AND pa.lead_assignment_id = pn.lead_assignment_id
1743: AND pw.latest_routing_flag = 'Y'
2798: begin
2799:
2800: select wl.wf_item_type, wl.wf_item_key, wl.routing_status, wl.wf_status
2801: into x_itemType, x_itemKey, x_routing_status, x_wf_status
2802: from pv_lead_workflows wl
2803: where wl.lead_id = p_lead_id
2804: and wl.entity = p_entity
2805: and wl.latest_routing_flag = 'Y';
2806: