[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| update_request_resolution |
| |
| DESCRIPTION |
| To update the resolution of a service request (=Incident) |
| |
| NOTES |
| Error handling is not yet implemented!!! |
| |
| DEPENDENCIES |
| |
| HISTORY |
| 18-JAN-2001 M. Raap Created. |
| |
| 11-JUN-2001 P. Giri edited for an extra ) at line 269 |
| 30-AUG-2004 pgiri Added parameters for spares to use this API |
| API update_request_resolution |
| |
| 23-oct-2004 pgiri Added new parameter to update_request_resolution |
| |
+===========================================================================*/
PROCEDURE update_request_resolution
( p_incident_id IN NUMBER
, p_resolution_code IN VARCHAR2
, P_RESOLUTION_SUMMARY IN VARCHAR2
, p_problem_code IN varchar2
, p_cust_po_number IN varchar2
, p_commit IN Boolean
, p_init_msg_list IN BOOLEAN
, X_RETURN_STATUS OUT NOCOPY VARCHAR2
, X_MSG_COUNT OUT NOCOPY INTEGER
, X_MSG_DATA OUT NOCOPY VARCHAR2
, p_object_version_number IN NUMBER default null
)
IS
l_return_status VARCHAR2(10);
L_LAST_UPDATE_PROGRAM_CODE VARCHAR2(30);
select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;
select INCIDENT_TYPE_ID,
incident_number,
LAST_UPDATE_PROGRAM_CODE
from cs_incidents_all_b where incident_id = v_incident_id;
L_LAST_UPDATE_PROGRAM_CODE:= r_incident_type_id.LAST_UPDATE_PROGRAM_CODE;
lr_service_request_rec.last_update_program_code :=L_LAST_UPDATE_PROGRAM_CODE;
cs_servicerequest_pub.update_servicerequest
(
p_api_version => 3.0 ,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_request_id => p_incident_id,
p_request_number => null,--l_incident_number,
p_audit_comments => NULL,
p_object_version_number => l_object_version_number,
p_resp_appl_id => NULL,
p_resp_id => NULL,
p_last_updated_by => l_user_id ,
p_last_update_login => NULL,
p_last_update_date => sysdate ,
p_service_request_rec => lr_service_request_rec,
p_notes => lt_notes_tab,
p_contacts => lt_contacts_tab,
p_called_by_workflow => FND_API.G_FALSE,
p_workflow_process_id => NULL,
x_workflow_process_id => l_workflow_process_id,
x_interaction_id => l_interaction_id
);
END update_request_resolution;
SELECT ci_all_b.incident_date incident_date -- bug # 4337147
, ci_all_b.incident_severity_id incident_severity_id
, ci_all_b.contract_service_id contract_service_id
, cit.business_process_id business_process_id
, ci_all_b.contract_number contract_number
FROM cs_incidents_all_b ci_all_b
, cs_incident_types cit
WHERE ci_all_b.incident_type_id = cit.incident_type_id
AND ci_all_b.incident_id = b_incident_id;
SELECT BPL.Id
FROM OKS_K_Lines_B KSL,
OKC_K_LINES_B BPL
WHERE KSL.Cle_ID = v_contract_service_id
AND BPL.Cle_ID = KSL.COVERAGE_ID
AND BPL.Lse_Id IN (3,16,21)
AND EXISTS (SELECT 'x'
FROM OKC_K_Items BIT
WHERE BIT.Cle_id = BPL.Id
AND Object1_Id1 = v_business_process_id
AND Jtot_Object1_Code = 'OKX_BUSIPROC');
Select a.id
from okc_k_lines_b a
where a.lse_id in (3,16,21)
and exists (select 'x'
from okc_k_items
where cle_id = a.id and
object1_id1 = v_business_process_id and
jtot_object1_code = 'OKX_BUSIPROC')
connect by a.cle_id = prior(a.id)
start with a.id = v_contract_service_id;
SELECT billing_type, name, to_char(txn_group_id)
from OKS_ENT_BILL_TYPES_V
where txn_group_id = b_contract_service_id;
SELECT covered_amount, covered_percent
from OKS_ENT_BILL_TYPES_V
where txn_group_id = b_contract_service_id
and billing_type = b_billing_type;
| update_request_flex |
| |
| DESCRIPTION |
| Wrapper on update_servicerequest for updating task fled field |
| |
| DEPENDENCIES |
| |
| HISTORY |
| 20-Apr-2005 hgotur Created |
| |
+===========================================================================*/
PROCEDURE update_request_flex
( p_incident_id IN NUMBER
, p_attribute_1 IN VARCHAR2
, p_attribute_2 IN VARCHAR2
, p_attribute_3 IN VARCHAR2
, p_attribute_4 IN VARCHAR2
, p_attribute_5 IN VARCHAR2
, p_attribute_6 IN VARCHAR2
, p_attribute_7 IN VARCHAR2
, p_attribute_8 IN VARCHAR2
, p_attribute_9 IN VARCHAR2
, p_attribute_10 IN VARCHAR2
, p_attribute_11 IN VARCHAR2
, p_attribute_12 IN VARCHAR2
, p_attribute_13 IN VARCHAR2
, p_attribute_14 IN VARCHAR2
, p_attribute_15 IN VARCHAR2
, p_context IN VARCHAR2
, X_RETURN_STATUS OUT NOCOPY VARCHAR2
, X_MSG_COUNT OUT NOCOPY INTEGER
, X_MSG_DATA OUT NOCOPY VARCHAR2
)
IS
l_return_status VARCHAR2(10);
L_LAST_UPDATE_PROGRAM_CODE VARCHAR2(30);
select object_version_number from cs_incidents_all_vl where incident_id = v_incident_id;
select INCIDENT_TYPE_ID,
incident_number,
LAST_UPDATE_PROGRAM_CODE
from cs_incidents_all_b where incident_id = v_incident_id;
L_LAST_UPDATE_PROGRAM_CODE:= r_incident_type_id.LAST_UPDATE_PROGRAM_CODE;
lr_service_request_rec.last_update_program_code :=L_LAST_UPDATE_PROGRAM_CODE;
cs_servicerequest_pub.update_servicerequest
(
p_api_version => 3.0 ,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_TRUE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_request_id => p_incident_id,
p_request_number => null,--l_incident_number,
p_audit_comments => NULL,
p_object_version_number => l_object_version_number,
p_resp_appl_id => NULL,
p_resp_id => NULL,
p_last_updated_by => l_user_id ,
p_last_update_login => NULL,
p_last_update_date => sysdate ,
p_service_request_rec => lr_service_request_rec,
p_notes => lt_notes_tab,
p_contacts => lt_contacts_tab,
p_called_by_workflow => FND_API.G_FALSE,
p_workflow_process_id => NULL,
x_workflow_process_id => l_workflow_process_id,
x_interaction_id => l_interaction_id
);
END update_request_flex;