[Home] [Help]
272: SELECT INC.INCIDENT_ID,
273: INC.INCIDENT_NUMBER,
274: INC.INCIDENT_DATE,
275: TYPE.NAME INCIDENT_TYPE
276: FROM cs_incidents_all_b INC,
277: CS_INCIDENT_TYPES_TL TYPE
278: WHERE INC.INCIDENT_NUMBER = l_request_number
279: AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID(+)
280: AND TYPE.LANGUAGE(+) = userenv('LANG');
897: END;
898:
899: SELECT org_id, object_version_number, incident_id
900: INTO l_org_id, l_object_version_number, l_request_id
901: FROM CS_INCIDENTS_ALL_B
902: WHERE incident_number = l_request_number;
903:
904: -- For 11i, replace person_id with resource_id
905: -- l_new_owner_id is the resource_id
1180: l_return_status := FND_API.G_RET_STS_SUCCESS;
1181:
1182: select object_version_number,incident_id
1183: INTO l_object_version_number,l_request_id
1184: from cs_incidents_all_b
1185: where incident_number = l_request_number;
1186:
1187: -- dbms_output.put_line('object version ' || l_object_version_number );
1188:
1216: l_login_id := NULL;
1217: END;
1218:
1219: SELECT org_id INTO l_org_id
1220: FROM CS_INCIDENTS_ALL_B
1221: WHERE incident_number = l_request_number;
1222:
1223: -- Update the status. Note that the status ID of 2 is a seeded
1224: -- status that corresponds to 'CLOSED'; we use the ID instead of
1225: -- hardcoded value of 'CLOSED' due to translation issues
1226:
1227: --Fix for Bug 1528813
1228: -- Change API call to Update_ServiceRequest since it updates status too
1229: -- Get the object version number from cs_incidents_all_b
1230:
1231:
1232: /*
1233: CS_ServiceRequest_PUB.Update_Status (
2580: act.incident_id,
2581: act.action_num,
2582: act.workflow_process_id)
2583: INTO l_incident_id,l_wf_id,l_wf_active
2584: FROM CS_INCIDENT_ACTIONS ACT, CS_INCIDENTS_ALL_B INC
2585: WHERE inc.incident_id = act.incident_id
2586: AND inc.incident_number = p_incident_number
2587: AND act.action_num = p_action_number ;
2588: