DBA Data[Home] [Help]

APPS.IEM_SERVICEREQUEST_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 80: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

76: l_msg_count NUMBER := 0;
77: l_msg_data VARCHAR2(2000);
78: l_index NUMBER := 1;
79:
80: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
81: l_notes CS_ServiceRequest_PUB.notes_table;
82: l_contacts CS_ServiceRequest_PUB.contacts_table;
83:
84: --Added by LiangXia on Dec18,2002 for CS changes in 115.9

Line 81: l_notes CS_ServiceRequest_PUB.notes_table;

77: l_msg_data VARCHAR2(2000);
78: l_index NUMBER := 1;
79:
80: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
81: l_notes CS_ServiceRequest_PUB.notes_table;
82: l_contacts CS_ServiceRequest_PUB.contacts_table;
83:
84: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
85: l_individual_owner NUMBER;

Line 82: l_contacts CS_ServiceRequest_PUB.contacts_table;

78: l_index NUMBER := 1;
79:
80: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
81: l_notes CS_ServiceRequest_PUB.notes_table;
82: l_contacts CS_ServiceRequest_PUB.contacts_table;
83:
84: --Added by LiangXia on Dec18,2002 for CS changes in 115.9
85: l_individual_owner NUMBER;
86: l_group_owner NUMBER;

Line 112: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

108: THEN
109: FND_MSG_PUB.initialize;
110: END IF;
111:
112: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
113:
114: -- IF p_service_request_rec is not null then
115: l_service_request_rec.request_date := p_service_request_rec.request_date;
116: l_service_request_rec.type_id := p_service_request_rec.type_id;

Line 281: CS_ServiceRequest_PUB.Create_ServiceRequest (

277: END IF;
278:
279:
280:
281: CS_ServiceRequest_PUB.Create_ServiceRequest (
282: p_api_version => l_cs_version_number,
283: p_init_msg_list => p_init_msg_list,
284: p_commit => p_commit,
285: x_return_status =>l_return_status,

Line 392: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

388: l_msg_count NUMBER := 0;
389: l_msg_data VARCHAR2(2000);
390: l_index NUMBER := 1;
391:
392: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
393: l_notes CS_ServiceRequest_PUB.notes_table;
394: l_contacts CS_ServiceRequest_PUB.contacts_table;
395:
396: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;

Line 393: l_notes CS_ServiceRequest_PUB.notes_table;

389: l_msg_data VARCHAR2(2000);
390: l_index NUMBER := 1;
391:
392: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
393: l_notes CS_ServiceRequest_PUB.notes_table;
394: l_contacts CS_ServiceRequest_PUB.contacts_table;
395:
396: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
397:

Line 394: l_contacts CS_ServiceRequest_PUB.contacts_table;

390: l_index NUMBER := 1;
391:
392: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
393: l_notes CS_ServiceRequest_PUB.notes_table;
394: l_contacts CS_ServiceRequest_PUB.contacts_table;
395:
396: IEM_SERVICEREQUEST_NOT_UPDATED EXCEPTION;
397:
398: BEGIN

Line 418: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

414: THEN
415: FND_MSG_PUB.initialize;
416: END IF;
417:
418: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
419:
420: -- IF p_service_request_rec is not null then
421: l_service_request_rec.request_date := p_service_request_rec.request_date;
422: l_service_request_rec.type_id := p_service_request_rec.type_id;

Line 586: CS_ServiceRequest_PUB.Update_ServiceRequest (

582: l_index:=l_index+1;
583: END LOOP;
584: END IF;
585:
586: CS_ServiceRequest_PUB.Update_ServiceRequest (
587: p_api_version => l_cs_version_number,
588: p_init_msg_list => p_init_msg_list,
589: p_commit => p_commit,
590: x_return_status => l_return_status,

Line 882: CS_SERVICEREQUEST_PUB.Update_Status

878: fnd_global.apps_initialize( user_id=>l_user_id,
879: resp_id=>l_resp_id,
880: resp_appl_id=>l_resp_appl_id);
881:
882: CS_SERVICEREQUEST_PUB.Update_Status
883: ( p_api_version => l_cs_version_number,
884: p_init_msg_list => p_init_msg_list,
885: p_commit => p_commit,
886: x_return_status => l_return_status,

Line 983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;

979: l_msg_count NUMBER := 0;
980: l_msg_data VARCHAR2(2000);
981: l_index NUMBER := 1;
982:
983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
984: p_notes CS_ServiceRequest_PUB.notes_table;
985: p_contacts CS_ServiceRequest_PUB.contacts_table;
986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;

Line 984: p_notes CS_ServiceRequest_PUB.notes_table;

980: l_msg_data VARCHAR2(2000);
981: l_index NUMBER := 1;
982:
983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
984: p_notes CS_ServiceRequest_PUB.notes_table;
985: p_contacts CS_ServiceRequest_PUB.contacts_table;
986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
988:

Line 985: p_contacts CS_ServiceRequest_PUB.contacts_table;

981: l_index NUMBER := 1;
982:
983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
984: p_notes CS_ServiceRequest_PUB.notes_table;
985: p_contacts CS_ServiceRequest_PUB.contacts_table;
986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
988:
989: l_notes CS_ServiceRequest_PUB.notes_table;

Line 986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;

982:
983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
984: p_notes CS_ServiceRequest_PUB.notes_table;
985: p_contacts CS_ServiceRequest_PUB.contacts_table;
986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
988:
989: l_notes CS_ServiceRequest_PUB.notes_table;
990: l_contacts CS_ServiceRequest_PUB.contacts_table;

Line 989: l_notes CS_ServiceRequest_PUB.notes_table;

985: p_contacts CS_ServiceRequest_PUB.contacts_table;
986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
988:
989: l_notes CS_ServiceRequest_PUB.notes_table;
990: l_contacts CS_ServiceRequest_PUB.contacts_table;
991:
992: l_summary_prefix VARCHAR2(80);
993: l_summary VARCHAR2(300);

Line 990: l_contacts CS_ServiceRequest_PUB.contacts_table;

986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
988:
989: l_notes CS_ServiceRequest_PUB.notes_table;
990: l_contacts CS_ServiceRequest_PUB.contacts_table;
991:
992: l_summary_prefix VARCHAR2(80);
993: l_summary VARCHAR2(300);
994: l_party_type VARCHAR2(80);

Line 1036: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);

1032:
1033: l_summary := l_summary_prefix||' : '|| p_subject ;
1034:
1035:
1036: CS_ServiceRequest_PUB.initialize_rec(l_service_request_rec);
1037:
1038:
1039: l_service_request_rec.type_id := p_sr_type_id;
1040: l_service_request_rec.summary := l_summary;

Line 1092: CS_ServiceRequest_PUB.Create_ServiceRequest (

1088:
1089: l_coverage_template_id:=fnd_profile.value_specific('CS_SR_DEFAULT_COVERAGE');
1090:
1091:
1092: CS_ServiceRequest_PUB.Create_ServiceRequest (
1093: p_api_version => l_cs_version_number,
1094: p_init_msg_list => FND_API.G_FALSE,
1095: p_commit => FND_API.G_FALSE,
1096: x_return_status => l_return_status,