[Home] [Help]
206: IS
207: l_api_name CONSTANT VARCHAR2(30) := 'Create_assignment_log_row';
208: l_api_version_number CONSTANT NUMBER := 1.0;
209:
210: CURSOR C2 IS SELECT PV_ASSIGNMENT_LOGS_S.nextval FROM sys.dual;
211: l_assignment_log_id number;
212:
213: BEGIN
214:
244: OPEN C2;
245: FETCH C2 INTO l_assignment_log_id;
246: CLOSE C2;
247:
248: INSERT into pv_assignment_logs (
249: ASSIGNMENT_ID,
250: LAST_UPDATE_DATE,
251: LAST_UPDATED_BY,
252: CREATION_DATE,
711: AND a.user_id = fnd_global.user_id
712: AND a.notification_type= pv_assignment_pub.g_notify_type_matched_to;
713:
714: /*SELECT notification_type
715: FROM pv_party_notifications a, pv_assignment_logs c
716: WHERE a.user_id = c.created_by
717: AND a.wf_item_key = c.wf_item_key
718: AND a.wf_item_key = pc_wf_item_key
719: AND a.wf_item_type = pc_wf_item_type;
1010: THEN
1011:
1012: -- When Opportunity is withdrawn by SalesRep the record does not
1013: -- make into pv_party_notifications. Only CM and PT will be in Party Notifications
1014: -- Hence retrieving the Salesrep withdraw from pv_assignment_logs
1015:
1016: OPEN lc_get_notify_type(l_wf_item_type, l_wf_item_key);
1017: FETCH lc_get_notify_type INTO l_notification_type;
1018: CLOSE lc_get_notify_type;
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')
2482: and not exists (select 1 from pv_assignment_logs aa
2483: where aa.lead_assignment_id = b.lead_assignment_id
2484: and aa.to_lead_status = 'ACTIVE');
2485:
2486: cursor lc_get_abandon_pt (pc_workflow_id number) is
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')
2493: and not exists (select 1 from pv_assignment_logs aa
2494: where aa.lead_assignment_id = b.lead_assignment_id
2495: and aa.to_lead_status = 'ABANDONED');
2496:
2497: