APPS.CS_SR_CHILD_AUDIT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;

121: WHERE incident_id =p_incident_id ;
122:
123: e_auditing_child_updates EXCEPTION ;
124:
125: l_object_version_number cs_incidents_all_b.object_version_number%TYPE;
126: l_notes CS_SERVICEREQUEST_PVT.notes_table;
127: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
128: l_service_request_rec CS_ServiceRequest_pvt.service_request_rec_type;
129: l_sr_update_out_rec CS_ServiceRequest_pvt.sr_update_out_rec_type;

Line 513: from cs_incidents_all_b

509: CS_ServiceRequest_pvt.initialize_rec(l_service_request_rec);
510: /*
511: select object_version_number
512: into l_object_version_number
513: from cs_incidents_all_b
514: where incident_id =l_incident_id;
515:
516:
517: CS_ServiceRequest_pvt.Update_ServiceRequest(

Line 642: CS_INCIDENTS_ALL_B

638: of audit record from the parameter values otherwise set these
639: cols from service request record.
640: 11/13/07 gasankar Bug 6621820
641: Handled the locking issue when trying to update the
642: CS_INCIDENTS_ALL_B
643: */
644: PROCEDURE CS_SR_AUDIT_CHILD
645: (P_incident_id IN NUMBER,
646: P_updated_entity_code IN VARCHAR2 ,

Line 673: l_service_request_rec CS_INCIDENTS_ALL_B%ROWTYPE;

669: ) IS
670:
671: l_audit_vals_rec CS_ServiceRequest_PVT.sr_audit_rec_type ;
672: l_incident_last_modified_date DATE ;
673: l_service_request_rec CS_INCIDENTS_ALL_B%ROWTYPE;
674: --l_return_status VARCHAR2(30) ;
675:
676: l_status_flag VARCHAR2(1);
677:

Line 684: FROM cs_incidents_all_b

680: PRAGMA EXCEPTION_INIT( SR_Lock_Row, -54 ); --gasankar
681:
682: CURSOR get_sr_date IS
683: SELECT *
684: FROM cs_incidents_all_b
685: WHERE incident_id = p_incident_id
686: FOR UPDATE NOWAIT ;
687:
688: e_create_audit_failed EXCEPTION ;

Line 705: UPDATE cs_incidents_all_b

701: -- CLOSE get_sr_date;
702:
703: IF p_entity_update_date > l_service_request_rec.incident_last_modified_date THEN
704:
705: UPDATE cs_incidents_all_b
706: SET incident_last_modified_date = NVL(p_entity_update_date,sysdate) ,
707: last_update_date = sysdate,
708: last_updated_by = NVL(p_user_id , FND_GLOBAL.user_id)
709: WHERE incident_id = p_incident_id ;