DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 3857: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

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;

Line 5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

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;

Line 5984: p_notes CS_ServiceRequest_PUB.notes_table;

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:

Line 5985: p_contacts CS_ServiceRequest_PUB.contacts_table;

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;

Line 5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;

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;

Line 5989: l_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;
5991: l_summary_prefix VARCHAR2(80);
5992: l_summary VARCHAR2(300);
5993: l_party_type VARCHAR2(80);

Line 5990: l_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);
5994: l_contact_type VARCHAR2(80);

Line 6857: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

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;

Line 7115: CS_ServiceRequest_PUB.Create_ServiceRequest (

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,