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_BG_PARTNER_MATCHING_PUB dependencies on PV_LEAD_WORKFLOWS

Line 125: SELECT TO_CHAR(PV_LEAD_WORKFLOWS_S.nextval) INTO l_item_key

121: -- If workflowprocess is passed, it will be run.
122: -- If workflowprocess is NOT passed, the selector FUNCTION
123: -- defined in the item type will determine which process to run.
124:
125: SELECT TO_CHAR(PV_LEAD_WORKFLOWS_S.nextval) INTO l_item_key
126: FROM dual;
127:
128: wf_engine.CreateProcess( ItemType => l_Item_Type,
129: ItemKey => l_Item_Key,

Line 354: pv_lead_workflows c

350: FOR x IN (
351: SELECT b.opp_open_status_flag, c.lead_id
352: FROM as_leads_all a,
353: as_statuses_b b,
354: pv_lead_workflows c
355: WHERE a.lead_id = l_lead_id AND
356: a.status = b.status_code AND
357: b.opp_flag = 'Y' AND
358: a.lead_id = c.lead_id (+)

Line 393: -- routings. i.e. there should be no record exists in pv_lead_workflows

389:
390:
391: -- --------------------------------------------------------------------
392: -- Routing/Partner Matching is only allowed if there are no previous
393: -- routings. i.e. there should be no record exists in pv_lead_workflows
394: -- for this opportunity (lead_id).
395: -- In addition, the opportunity must be an "open" opportunity.
396: -- --------------------------------------------------------------------
397: IF (l_open_opportunity_flag AND (NOT l_routing_exist_flag)) THEN

Line 695: FROM pv_lead_workflows

691:
692: CURSOR lc_check ( pc_lead_id NUMBER)
693: IS
694: SELECT 'X' flag
695: FROM pv_lead_workflows
696: WHERE lead_id = pc_lead_id
697: AND latest_routing_flag = 'Y'
698: AND routing_status IN ('ACTIVE','MATCHED','OFFERED');
699:

Line 757: SELECT TO_CHAR(PV_LEAD_WORKFLOWS_S.nextval) INTO l_item_key FROM dual;

753: FETCH lc_check INTO l_flag;
754: CLOSE lc_check;
755:
756: IF l_flag IS NULL THEN
757: SELECT TO_CHAR(PV_LEAD_WORKFLOWS_S.nextval) INTO l_item_key FROM dual;
758:
759: wf_engine.CreateProcess( ItemType => l_Item_Type,
760: ItemKey => l_Item_Key,
761: process => l_Workflow_process);

Line 960: pv_lead_workflows c

956: FOR x IN (
957: SELECT b.opp_open_status_flag, c.lead_id , c.routing_status
958: FROM as_leads_all a,
959: as_statuses_b b,
960: pv_lead_workflows c
961: WHERE a.lead_id = l_lead_id AND a.status = b.status_code AND
962: b.opp_flag = 'Y' AND a.lead_id = c.lead_id (+) and c.latest_routing_flag (+) = 'Y')
963: LOOP
964: -- -----------------------------------------------------------------------

Line 995: -- routings. i.e. there should be no record exists in pv_lead_workflows

991: END LOOP;
992:
993: -- --------------------------------------------------------------------
994: -- Routing/Partner Matching is only allowed if there are no previous
995: -- routings. i.e. there should be no record exists in pv_lead_workflows
996: -- for this opportunity (lead_id).
997: -- In addition, the opportunity must be an "open" opportunity.
998: -- --------------------------------------------------------------------
999: IF (l_open_opportunity_flag AND (NOT l_routing_exist_flag)) THEN