DBA Data[Home] [Help]

APPS.CSFW_TASKS_PUB dependencies on CS_SERVICEREQUEST_PUB

Line 1004: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;

1000: l_return_status_full VARCHAR2(1);
1001: l_access_flag VARCHAR2(1);
1002: l_sqlcode Number;
1003: l_sqlerrm Varchar2(2000);
1004: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1005: l_notes_table cs_servicerequest_pub.notes_table;
1006: l_notes_rec cs_servicerequest_pub.notes_rec;
1007: l_contacts_table cs_servicerequest_pub.contacts_table;
1008: l_msg_index_out number;

Line 1005: l_notes_table cs_servicerequest_pub.notes_table;

1001: l_access_flag VARCHAR2(1);
1002: l_sqlcode Number;
1003: l_sqlerrm Varchar2(2000);
1004: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1005: l_notes_table cs_servicerequest_pub.notes_table;
1006: l_notes_rec cs_servicerequest_pub.notes_rec;
1007: l_contacts_table cs_servicerequest_pub.contacts_table;
1008: l_msg_index_out number;
1009: l_task_id NUMBER;

Line 1006: l_notes_rec cs_servicerequest_pub.notes_rec;

1002: l_sqlcode Number;
1003: l_sqlerrm Varchar2(2000);
1004: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1005: l_notes_table cs_servicerequest_pub.notes_table;
1006: l_notes_rec cs_servicerequest_pub.notes_rec;
1007: l_contacts_table cs_servicerequest_pub.contacts_table;
1008: l_msg_index_out number;
1009: l_task_id NUMBER;
1010: l_index NUMBER := 0;

Line 1007: l_contacts_table cs_servicerequest_pub.contacts_table;

1003: l_sqlerrm Varchar2(2000);
1004: l_service_request_rec cs_servicerequest_pub.service_request_rec_type;
1005: l_notes_table cs_servicerequest_pub.notes_table;
1006: l_notes_rec cs_servicerequest_pub.notes_rec;
1007: l_contacts_table cs_servicerequest_pub.contacts_table;
1008: l_msg_index_out number;
1009: l_task_id NUMBER;
1010: l_index NUMBER := 0;
1011: l_primary_contact VARCHAR2(1);

Line 1148: cs_servicerequest_pub.initialize_rec(l_service_request_rec);

1144:
1145: BEGIN
1146: FND_PROFILE.GET ( 'CS_INV_VALIDATION_ORG' , l_organization_id);
1147: FND_PROFILE.GET ( 'CS_SR_ORG_ID' , l_org_id);
1148: cs_servicerequest_pub.initialize_rec(l_service_request_rec);
1149: --keep on Selecting
1150:
1151: IF (p_old_incident_id <> 0) THEN
1152: OPEN c_incident_record(p_old_incident_id);

Line 1381: cs_servicerequest_pub.Create_ServiceRequest

1377: l_contacts_table(1).CONTACT_TYPE := l_party_type;
1378: END IF;
1379:
1380: --CALLING API
1381: cs_servicerequest_pub.Create_ServiceRequest
1382: ( p_api_version => 3.0,
1383: p_init_msg_list => FND_API.G_FALSE,
1384: p_commit => FND_API.G_TRUE, -- COMMIT
1385: x_return_status => x_return_status,