[Home] [Help]
10: p_note_status varchar2,
11: p_note varchar2,
12: p_vrsn_no number,
13: p_error out nocopy varchar2) as
14: l_service_request_rec CS_ServiceRequest_PVT.service_request_rec_type;
15: l_owner_id number;
16: l_return_status VARCHAR2(1);
17: l_msg_count NUMBER ;
18: l_msg_data VARCHAR2(2000);
21: l_request_number VARCHAR2(64);
22: l_interaction_id NUMBER;
23: l_object_version_number NUMBER;
24:
25: l_notes CS_SERVICEREQUEST_PVT.notes_table;
26: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
27:
28: l_last_update_date date;
29:
22: l_interaction_id NUMBER;
23: l_object_version_number NUMBER;
24:
25: l_notes CS_SERVICEREQUEST_PVT.notes_table;
26: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
27:
28: l_last_update_date date;
29:
30: l_itemkey VARCHAR2(240);
39: l_owner_id := p_owner_id;
40: if (p_owner_id = 0) then l_owner_id := null;
41: end if;
42: biv_core_pkg.biv_debug('before init rec','SR_UPDT');
43: CS_ServiceRequest_PVT.initialize_rec(l_service_request_rec);
44: l_request_id := p_sr_id ;
45: /* when update jsp passed version number, delete this
46: statement */
47: if (p_vrsn_no is null) then
68: l_notes(1).note_detail := p_note ;
69: end if;
70:
71: biv_core_pkg.biv_debug('before update SR','SR_UPDT');
72: CS_ServiceRequest_PVT.Update_ServiceRequest
73: (p_api_version => 3.0,
74: p_validation_level => fnd_api.g_valid_level_full,
75: p_commit => fnd_api.g_true,
76: p_init_msg_list => fnd_api.g_true,