eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ASSIGNMENT_PVT dependencies on PV_LEAD_WORKFLOWS

Line 699: FROM pv_lead_assignments a, pv_lead_workflows b

695: b.lead_workflow_id,
696: b.routing_type,
697: b.latest_routing_flag,
698: b.bypass_cm_ok_flag
699: FROM pv_lead_assignments a, pv_lead_workflows b
700: WHERE a.lead_assignment_id = pc_lead_assignment_id
701: AND a.wf_item_type = b.wf_item_type
702: AND a.wf_item_key = b.wf_item_key;
703:

Line 728: pv_lead_workflows PV_LEAD_WF,

724: from hz_relationships EMP_TO_ORG,
725: hz_relationships ORG_TO_VEND,
726: hz_organization_profiles HZOP,
727: pv_lead_assignments PV_ASSIGN,
728: pv_lead_workflows PV_LEAD_WF,
729: jtf_rs_resource_extns LEAD_SOURCE,
730: pv_enty_attr_values PEAV
731: where PV_ASSIGN.lead_assignment_id = pc_lead_assignment_id
732: and PV_ASSIGN.wf_item_type = PV_LEAD_WF.wf_item_type

Line 1166: FROM pv_lead_workflows

1162: CURSOR lc_get_routing_status ( pc_itemtype VARCHAR2
1163: , pc_itemkey VARCHAR2 )
1164: IS
1165: SELECT routing_status
1166: FROM pv_lead_workflows
1167: WHERE wf_item_type = pc_itemtype
1168: AND wf_item_key = pc_itemkey;
1169:
1170: -- lc_get_reject_accesses + lc_get_reject_accesses_pt

Line 1883: update pv_lead_workflows set matched_due_date = l_due_date,

1879:
1880:
1881: IF p_timeoutType = pv_assignment_pub.g_matched_timeout THEN
1882:
1883: update pv_lead_workflows set matched_due_date = l_due_date,
1884: object_version_number = object_version_number + 1
1885: where wf_item_type = p_itemtype
1886: and wf_item_key = p_itemkey;
1887:

Line 1901: update pv_lead_workflows set offered_due_date = l_due_date,

1897:
1898:
1899: ELSIF p_timeoutType = pv_assignment_pub.g_offered_timeout THEN
1900:
1901: update pv_lead_workflows set offered_due_date = l_due_date,
1902: object_version_number = object_version_number + 1
1903: where wf_item_type = p_itemtype
1904: and wf_item_key = p_itemkey;
1905:

Line 2458: from pv_lead_workflows

2454: lead_id,
2455: lead_workflow_id,
2456: routing_status,
2457: routing_type
2458: from pv_lead_workflows
2459: where wf_item_type = pc_itemtype
2460: and wf_item_key = pc_itemkey;
2461:
2462:

Line 2465: from pv_lead_workflows a, pv_lead_assignments b

2461:
2462:
2463: cursor lc_get_offered_pt (pc_workflow_id number) is
2464: select b.lead_assignment_id,b.partner_id
2465: from pv_lead_workflows a, pv_lead_assignments b
2466: where a.lead_workflow_id = pc_workflow_id
2467: and a.wf_item_type = b.wf_item_type
2468: and a.wf_item_key = b.wf_item_key
2469: and b.status in ('CM_APPROVED','CM_TIMEOUT','CM_BYPASSED','CM_APP_FOR_PT');

Line 2477: from pv_lead_workflows a, pv_lead_assignments b

2473: -- and this api is called each time. we do not want to log
2474: -- duplicate logs
2475: cursor lc_get_active_pt (pc_workflow_id number) is
2476: select b.lead_assignment_id,b.partner_id
2477: from pv_lead_workflows a, pv_lead_assignments b
2478: where a.lead_workflow_id = pc_workflow_id
2479: and a.wf_item_type = b.wf_item_type
2480: and a.wf_item_key = b.wf_item_key
2481: and b.status in ('PT_APPROVED','CM_APP_FOR_PT')

Line 2488: from pv_lead_workflows a, pv_lead_assignments b

2484: and aa.to_lead_status = 'ACTIVE');
2485:
2486: cursor lc_get_abandon_pt (pc_workflow_id number) is
2487: select b.lead_assignment_id,b.partner_id
2488: from pv_lead_workflows a, pv_lead_assignments b
2489: where a.lead_workflow_id = pc_workflow_id
2490: and a.wf_item_type = b.wf_item_type
2491: and a.wf_item_key = b.wf_item_key
2492: and b.status in ('PT_ABANDONED')

Line 2622: update pv_lead_workflows

2618: END LOOP;
2619:
2620: end if;
2621:
2622: update pv_lead_workflows
2623: set routing_status = p_routing_stage,
2624: wf_status = l_wf_status,
2625: object_version_number = object_version_number + 1,
2626: last_update_date = sysdate,

Line 3208: update pv_lead_workflows

3204: END IF;
3205:
3206: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3207:
3208: update pv_lead_workflows
3209: set latest_routing_flag = decode(wf_item_key, p_itemkey, 'Y', 'N'),
3210: object_version_number = object_version_number + 1
3211: where lead_id = p_entity_id
3212: and entity = p_entity

Line 3486: FROM pv_lead_assignments pa, pv_party_notifications pn, pv_lead_workflows pw, fnd_user usr

3482: is
3483: SELECT pn.user_id, pn.resource_id, usr.user_name,
3484: decode(pn.notification_type, 'MATCHED_TO', 'CM', 'PT') user_type,
3485: decode(pc_ignore_pt_flag, 'Y', 0, pa.partner_id) partner_id, pa.status
3486: FROM pv_lead_assignments pa, pv_party_notifications pn, pv_lead_workflows pw, fnd_user usr
3487: WHERE
3488: ((pn.notification_type = 'MATCHED_TO' and 'Y' = pc_notify_cm_flag)
3489: or (pn.notification_type = 'OFFERED_TO' and 'Y' = pc_notify_pt_flag))
3490: and pw.lead_id = pc_lead_id

Line 3503: pv_lead_workflows pw, pv_lead_assignments pl

3499: SELECT js.user_id, js.resource_id, fu.user_name,
3500: decode(pw.created_by - js.user_id,0,'AM','OT') user_type,
3501: decode(pc_ignore_pt_flag, 'Y', 0, pl.partner_id) partner_id, pl.status
3502: FROM as_accesses_all ac, jtf_rs_resource_extns js, fnd_user fu,
3503: pv_lead_workflows pw, pv_lead_assignments pl
3504: WHERE (('Y' = pc_notify_ot_flag and pw.created_by <> js.user_id)
3505: or ('Y' = pc_notify_am_flag and pw.created_by = js.user_id))
3506: AND ac.lead_id = pc_lead_id
3507: and ac.lead_id = pw.lead_id

Line 4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;

4175:
4176: -- Initialize API return status to success
4177: x_return_status := FND_API.G_RET_STS_SUCCESS;
4178:
4179: select pv_lead_workflows_s.nextval into l_itemkey from dual;
4180:
4181:
4182: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
4183: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');