APPS.CS_WORKFLOW_PUB dependencies on CS_INCIDENTS_ALL_B

Line 97: FROM cs_incidents_all_b inc,

93: inc.workflow_process_id,
94: inc.object_version_number,
95: type.workflow,
96: status.close_flag
97: FROM cs_incidents_all_b inc,
98: cs_incident_types type,
99: cs_incident_statuses status
100: WHERE inc.incident_number = p_request_number
101: AND type.incident_type_id = inc.incident_type_id

Line 118: FROM cs_incidents_all_b

114:
115: /*** This cursor is the same as above. rmanabat . 032403 .
116: CURSOR l_ServeReq_NW_csr IS
117: SELECT incident_id, workflow_process_id,object_version_number
118: FROM cs_incidents_all_b
119: WHERE incident_number = p_request_number;
120: ****/
121:
122: --fix for # 1348309

Line 422: We will no longer directly update the cs_incidents_all_b table.

418:
419:
420: /****** Fix for Bug # 1348309 & #1349526
421: The error is b'cos the create_audit API has been modified
422: We will no longer directly update the cs_incidents_all_b table.
423: We will be calling the Service request Update API to do the update.
424: This API will call the create audit API so we do not have to call this either
425:
426: -- Update the workflow process ID of the request

Line 430: UPDATE CS_INCIDENTS_ALL_B

426: -- Update the workflow process ID of the request
427:
428: IF (l_nowait = TRUE) THEN
429:
430: UPDATE CS_INCIDENTS_ALL_B
431: SET workflow_process_id = l_wf_process_id
432: WHERE CURRENT OF l_ServeReq_NW_csr;
433: CLOSE l_ServeReq_NW_csr;
434:

Line 437: UPDATE CS_INCIDENTS_ALL_B

433: CLOSE l_ServeReq_NW_csr;
434:
435: ELSE
436:
437: UPDATE CS_INCIDENTS_ALL_B
438: SET workflow_process_id = l_wf_process_id
439: WHERE incident_number = p_request_number;
440:
441: -- WHERE CURRENT OF l_ServeReq_csr;

Line 464: -- Call the SR update API to update cs_incidents_all_b and to insert

460: p_user_id => p_initiator_user_id );
461: ******/
462: --#1349526
463: --Jul/13/2000
464: -- Call the SR update API to update cs_incidents_all_b and to insert
465: -- into audit tables
466:
467: --dbms_output.put_line('before Update wf_proc_id= ' || l_wf_process_id);
468: --dbms_output.put_line('before Update l_req_id= ' || l_request_id);

Line 540: UPDATE CS_INCIDENTS_ALL_B

536:
537: /**** Replaced Update API above with explicit update ****/
538: /**** rmanabat . 032403 ****/
539:
540: UPDATE CS_INCIDENTS_ALL_B
541: SET workflow_process_id = l_wf_process_id
542: WHERE incident_id = l_request_id;
543:
544:

Line 733: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf

729: l_itemtype VARCHAR2(10); --Bug 6449697
730:
731: CURSOR l_itemtype_csr IS --Bug 6449697
732: Select item_type
733: from cs_incidents_all_b inc, cs_incident_types types, wf_activities wf
734: where inc.incident_number= p_request_number
735: and types.incident_type_id=inc.incident_type_id
736: and wf.name=types.workflow;
737: