DBA Data[Home] [Help]

APPS.IEM_SERVICEREQUEST_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 86: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

82: l_msg_count NUMBER := 0;
83: l_msg_data VARCHAR2(2000);
84: l_index NUMBER := 1;
85:
86: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
87: l_notes CS_ServiceRequest_PUB.notes_table;
88: l_contacts CS_ServiceRequest_PUB.contacts_table;
89:
90: --Added by LiangXia on Dec18,2002 for CS changes in 115.9

Line 87: l_notes CS_ServiceRequest_PUB.notes_table;

83: l_msg_data VARCHAR2(2000);
84: l_index NUMBER := 1;
85:
86: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
87: l_notes CS_ServiceRequest_PUB.notes_table;
88: l_contacts CS_ServiceRequest_PUB.contacts_table;
89:
90: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
91: l_individual_owner NUMBER;

Line 88: l_contacts CS_ServiceRequest_PUB.contacts_table;

84: l_index NUMBER := 1;
85:
86: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
87: l_notes CS_ServiceRequest_PUB.notes_table;
88: l_contacts CS_ServiceRequest_PUB.contacts_table;
89:
90: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
91: l_individual_owner NUMBER;
92: l_group_owner NUMBER;

Line 118: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

114: THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
119:
120: -- IF p_service_request_rec is not null then
121: l_service_request_rec.request_date := p_service_request_rec.request_date;
122: l_service_request_rec.type_id := p_service_request_rec.type_id;

Line 287: CS_ServiceRequest_PUB.Create_ServiceRequest (

283: END IF;
284:
285:
286:
287: CS_ServiceRequest_PUB.Create_ServiceRequest (
288: p_api_version => l_cs_version_number,
289: p_init_msg_list => p_init_msg_list,
290: p_commit => p_commit,
291: x_return_status =>l_return_status,

Line 398: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

394: l_msg_count NUMBER := 0;
395: l_msg_data VARCHAR2(2000);
396: l_index NUMBER := 1;
397:
398: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
399: l_notes CS_ServiceRequest_PUB.notes_table;
400: l_contacts CS_ServiceRequest_PUB.contacts_table;
401:
402: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;

Line 399: l_notes CS_ServiceRequest_PUB.notes_table;

395: l_msg_data VARCHAR2(2000);
396: l_index NUMBER := 1;
397:
398: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
399: l_notes CS_ServiceRequest_PUB.notes_table;
400: l_contacts CS_ServiceRequest_PUB.contacts_table;
401:
402: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
403:

Line 400: l_contacts CS_ServiceRequest_PUB.contacts_table;

396: l_index NUMBER := 1;
397:
398: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
399: l_notes CS_ServiceRequest_PUB.notes_table;
400: l_contacts CS_ServiceRequest_PUB.contacts_table;
401:
402: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
403:
404: BEGIN

Line 424: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

420: THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
425:
426: -- IF p_service_request_rec is not null then
427: l_service_request_rec.request_date := p_service_request_rec.request_date;
428: l_service_request_rec.type_id := p_service_request_rec.type_id;

Line 592: CS_ServiceRequest_PUB.Update_ServiceRequest (

588: l_index:=l_index+1;
589: END LOOP;
590: END IF;
591:
592: CS_ServiceRequest_PUB.Update_ServiceRequest (
593: p_api_version => l_cs_version_number,
594: p_init_msg_list => p_init_msg_list,
595: p_commit => p_commit,
596: x_return_status => l_return_status,

Line 888: CS_SERVICEREQUEST_PUB.Update_Status

884: fnd_global.apps_initialize( user_id=>l_user_id,
885: resp_id=>l_resp_id,
886: resp_appl_id=>l_resp_appl_id);
887:
888: CS_SERVICEREQUEST_PUB.Update_Status
889: ( p_api_version => l_cs_version_number,
890: p_init_msg_list => p_init_msg_list,
891: p_commit => p_commit,
892: x_return_status => l_return_status,

Line 989: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

985: l_msg_count NUMBER := 0;
986: l_msg_data VARCHAR2(2000);
987: l_index NUMBER := 1;
988:
989: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
990: p_notes CS_ServiceRequest_PUB.notes_table;
991: p_contacts CS_ServiceRequest_PUB.contacts_table;
992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;

Line 990: p_notes CS_ServiceRequest_PUB.notes_table;

986: l_msg_data VARCHAR2(2000);
987: l_index NUMBER := 1;
988:
989: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
990: p_notes CS_ServiceRequest_PUB.notes_table;
991: p_contacts CS_ServiceRequest_PUB.contacts_table;
992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
994:

Line 991: p_contacts CS_ServiceRequest_PUB.contacts_table;

987: l_index NUMBER := 1;
988:
989: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
990: p_notes CS_ServiceRequest_PUB.notes_table;
991: p_contacts CS_ServiceRequest_PUB.contacts_table;
992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
994:
995: l_notes CS_ServiceRequest_PUB.notes_table;

Line 992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;

988:
989: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
990: p_notes CS_ServiceRequest_PUB.notes_table;
991: p_contacts CS_ServiceRequest_PUB.contacts_table;
992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
994:
995: l_notes CS_ServiceRequest_PUB.notes_table;
996: l_contacts CS_ServiceRequest_PUB.contacts_table;

Line 995: l_notes CS_ServiceRequest_PUB.notes_table;

991: p_contacts CS_ServiceRequest_PUB.contacts_table;
992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
994:
995: l_notes CS_ServiceRequest_PUB.notes_table;
996: l_contacts CS_ServiceRequest_PUB.contacts_table;
997:
998: l_summary_prefix VARCHAR2(80);
999: l_summary VARCHAR2(300);

Line 996: l_contacts CS_ServiceRequest_PUB.contacts_table;

992: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
993: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
994:
995: l_notes CS_ServiceRequest_PUB.notes_table;
996: l_contacts CS_ServiceRequest_PUB.contacts_table;
997:
998: l_summary_prefix VARCHAR2(80);
999: l_summary VARCHAR2(300);
1000: l_party_type VARCHAR2(80);

Line 1050: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

1046:
1047: l_summary := l_summary_prefix||' : '|| p_subject ;
1048:
1049:
1050: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
1051:
1052:
1053: l_service_request_rec.type_id := p_sr_type_id;
1054: l_service_request_rec.summary := l_summary;

Line 1143: CS_ServiceRequest_PUB.Create_ServiceRequest (

1139:
1140: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1141:
1142:
1143: CS_ServiceRequest_PUB.Create_ServiceRequest (
1144: p_api_version => l_cs_version_number,
1145: p_init_msg_list => FND_API.G_FALSE,
1146: p_commit => FND_API.G_FALSE,
1147: x_return_status => l_return_status,