3853: p_email_rec in iem_rt_preproc_emails%rowtype,
3854: x_status out NOCOPY varchar2,
3855: x_out_text out NOCOPY varchar2) IS
3856:
3857: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
3858: l_request_id NUMBER;
3859: l_object_version_number NUMBER;
3860: l_request_number VARCHAR2(64);
3861: l_sr_number number;
5979: l_api_name VARCHAR2(255):='ADVANCED_SR_PROCESSING';
5980: --l_api_version_number NUMBER:=1.0;
5981: l_cs_version_number NUMBER:=4.0;
5982:
5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
5984: p_notes CS_ServiceRequest_PUB.notes_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5980: --l_api_version_number NUMBER:=1.0;
5981: l_cs_version_number NUMBER:=4.0;
5982:
5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
5984: p_notes CS_ServiceRequest_PUB.notes_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5981: l_cs_version_number NUMBER:=4.0;
5982:
5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
5984: p_notes CS_ServiceRequest_PUB.notes_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5989: l_notes CS_ServiceRequest_PUB.notes_table;
5982:
5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
5984: p_notes CS_ServiceRequest_PUB.notes_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5989: l_notes CS_ServiceRequest_PUB.notes_table;
5990: l_contacts CS_ServiceRequest_PUB.contacts_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5989: l_notes CS_ServiceRequest_PUB.notes_table;
5990: l_contacts CS_ServiceRequest_PUB.contacts_table;
5991: l_summary_prefix VARCHAR2(80);
5992: l_summary VARCHAR2(300);
5993: l_party_type VARCHAR2(80);
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5989: l_notes CS_ServiceRequest_PUB.notes_table;
5990: l_contacts CS_ServiceRequest_PUB.contacts_table;
5991: l_summary_prefix VARCHAR2(80);
5992: l_summary VARCHAR2(300);
5993: l_party_type VARCHAR2(80);
5994: l_contact_type VARCHAR2(80);
6853:
6854: l_logmessage:='customer _id is '|| g_customer_id ;
6855: iem_logger(l_logmessage);
6856: --dbms_output.put_line(l_logmessage);
6857: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
6858:
6859:
6860: OPEN caller_type;
6861: FETCH caller_type INTO l_party_type;
7111:
7112: l_logmessage:='start calling service request' ;
7113: iem_logger(l_logmessage);
7114: --dbms_output.put_line(l_logmessage);
7115: CS_ServiceRequest_PUB.Create_ServiceRequest (
7116: p_api_version => l_cs_version_number,
7117: p_init_msg_list => FND_API.G_FALSE,
7118: p_commit => FND_API.G_FALSE,
7119: x_return_status => l_return_status,