DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on CS_SERVICEREQUEST_PUB

Line 988: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;

984: l_return_status_full VARCHAR2(1);
985: l_access_flag VARCHAR2(1);
986: l_sqlcode Number;
987: l_sqlerrm Varchar2(2000);
988: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
989: l_notes_table cs_servicerequest_pub.notes_table;
990: l_notes_rec cs_servicerequest_pub.notes_rec;
991: l_contacts_table cs_servicerequest_pub.contacts_table;
992: l_msg_index_out number;

Line 989: l_notes_table cs_servicerequest_pub.notes_table;

985: l_access_flag VARCHAR2(1);
986: l_sqlcode Number;
987: l_sqlerrm Varchar2(2000);
988: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
989: l_notes_table cs_servicerequest_pub.notes_table;
990: l_notes_rec cs_servicerequest_pub.notes_rec;
991: l_contacts_table cs_servicerequest_pub.contacts_table;
992: l_msg_index_out number;
993: l_task_id NUMBER;

Line 990: l_notes_rec cs_servicerequest_pub.notes_rec;

986: l_sqlcode Number;
987: l_sqlerrm Varchar2(2000);
988: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
989: l_notes_table cs_servicerequest_pub.notes_table;
990: l_notes_rec cs_servicerequest_pub.notes_rec;
991: l_contacts_table cs_servicerequest_pub.contacts_table;
992: l_msg_index_out number;
993: l_task_id NUMBER;
994: l_index NUMBER := 0;

Line 991: l_contacts_table cs_servicerequest_pub.contacts_table;

987: l_sqlerrm Varchar2(2000);
988: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
989: l_notes_table cs_servicerequest_pub.notes_table;
990: l_notes_rec cs_servicerequest_pub.notes_rec;
991: l_contacts_table cs_servicerequest_pub.contacts_table;
992: l_msg_index_out number;
993: l_task_id NUMBER;
994: l_index NUMBER := 0;
995: l_primary_contact VARCHAR2(1);

Line 1130: cs_servicerequest_pub.initialize_rec(l_service_request_rec);

1126: and location_id = v_location_id;
1127:
1128: BEGIN
1129: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1130: cs_servicerequest_pub.initialize_rec(l_service_request_rec);
1131: --keep on Selecting
1132:
1133: IF (p_old_incident_id <> 0) THEN
1134: OPEN c_incident_record(p_old_incident_id);

Line 1363: cs_servicerequest_pub.Create_ServiceRequest

1359: l_contacts_table(1).CONTACT_TYPE := l_party_type;
1360: END IF;
1361:
1362: --CALLING API
1363: cs_servicerequest_pub.Create_ServiceRequest
1364: ( p_api_version => 3.0,
1365: p_init_msg_list => FND_API.G_FALSE,
1366: p_commit => FND_API.G_TRUE, -- COMMIT
1367: x_return_status => x_return_status,