APPS.CSD_OM_INTERFACE_PVT dependencies on CS_SERVICEREQUEST_PUB

Line 77: RETURN CS_SERVICEREQUEST_PUB.CONTACTS_TABLE ;

73:
74: END DEBUG;
75:
76: FUNCTION get_sr_contacts (p_contact_id NUMBER)
77: RETURN CS_SERVICEREQUEST_PUB.CONTACTS_TABLE ;
78:
79: /*-------------------------------------------------------------------------------------*/
80: /* Procedure name: Get_Party_site_id */
81: /* Description : Get the bill to/ship to party site use id */

Line 221: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;

217: p_inventory_org_id IN NUMBER,
218: p_subinventory_name IN VARCHAR2
219: ) IS
220:
221: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
222: l_notes_table CS_ServiceRequest_PUB.notes_table;
223: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
224: l_rep_line_tbl CSD_REPAIRS_PUB.REPLN_TBL_Type;
225: l_inc_type_id NUMBER;

Line 222: l_notes_table CS_ServiceRequest_PUB.notes_table;

218: p_subinventory_name IN VARCHAR2
219: ) IS
220:
221: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
222: l_notes_table CS_ServiceRequest_PUB.notes_table;
223: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
224: l_rep_line_tbl CSD_REPAIRS_PUB.REPLN_TBL_Type;
225: l_inc_type_id NUMBER;
226: l_inc_status_id NUMBER;

Line 223: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

219: ) IS
220:
221: l_service_request_rec CS_SERVICEREQUEST_PUB.service_request_rec_type;
222: l_notes_table CS_ServiceRequest_PUB.notes_table;
223: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
224: l_rep_line_tbl CSD_REPAIRS_PUB.REPLN_TBL_Type;
225: l_inc_type_id NUMBER;
226: l_inc_status_id NUMBER;
227: l_inc_severity_id NUMBER;

Line 598: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);

594: RAISE SKIP_RECORD;
595: END IF;
596:
597: -- Initialize the SR record values
598: CS_SERVICEREQUEST_PUB.initialize_rec(l_service_request_rec);
599:
600: l_service_request_rec.request_date := sysdate;
601: l_service_request_rec.type_id := l_inc_type_id;
602: l_service_request_rec.status_id := l_inc_status_id;

Line 685: Debug( 'Calling CS_SERVICEREQUEST_PUB.Create_ServiceRequest ',l_mod_name,1);

681: Debug( 'l_service_request_rec.ship_to_site_use_id = '||to_char(l_service_request_rec.ship_to_site_use_id),l_mod_name,1);
682: Debug( 'l_service_request_rec.account_id = '||to_char(l_service_request_rec.account_id),l_mod_name,1);
683: Debug( 'l_service_request_rec.cust_po_number = '||l_service_request_rec.cust_po_number,l_mod_name,1);
684:
685: Debug( 'Calling CS_SERVICEREQUEST_PUB.Create_ServiceRequest ',l_mod_name,1);
686:
687: -- Call to Service Request API
688: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
689: p_api_version => 2.0,

Line 688: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(

684:
685: Debug( 'Calling CS_SERVICEREQUEST_PUB.Create_ServiceRequest ',l_mod_name,1);
686:
687: -- Call to Service Request API
688: CS_SERVICEREQUEST_PUB.Create_ServiceRequest(
689: p_api_version => 2.0,
690: p_init_msg_list => FND_API.G_TRUE,
691: p_commit => FND_API.G_FALSE,
692: x_return_status => l_return_status,

Line 1096: RETURN CS_SERVICEREQUEST_PUB.CONTACTS_TABLE IS

1092: /* 02/16/04 vlakaman Included in the latest APIs */
1093: /*-------------------------------------------------------------------------------------*/
1094:
1095: FUNCTION GET_SR_CONTACTS(p_contact_id NUMBER)
1096: RETURN CS_SERVICEREQUEST_PUB.CONTACTS_TABLE IS
1097:
1098: -- cursor definitions
1099: CURSOR CUR_CONTACTS(p_contact_id NUMBER) IS
1100: SELECT acct_role.party_id party_id, C.contact_point_id,

Line 1111: l_contacts_table CS_ServiceRequest_PUB.contacts_table;

1107: and C.status(+)='A'
1108: and C.primary_flag(+)='Y'
1109: and acct_role.party_id=C.owner_table_id(+) ;
1110:
1111: l_contacts_table CS_ServiceRequest_PUB.contacts_table;
1112: i NUMBER;
1113:
1114: -- Variables used in FND Log
1115: l_error_level number := FND_LOG.LEVEL_ERROR;