eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_SERVICE_REQUESTS_PKG dependencies on CS_SERVICEREQUEST_PUB

Line 136: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

132: SELECT custa.cust_account_id FROM hz_cust_accounts custa
133: WHERE custa.status = 'A'
134: AND custa.party_id = b_customer_id;
135:
136: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
137: l_user_id NUMBER;
138: l_msg_count NUMBER;
139: l_msg_data VARCHAR2(240);
140: l_notes_tab CS_ServiceRequest_PUB.notes_table;

Line 140: l_notes_tab CS_ServiceRequest_PUB.notes_table;

136: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
137: l_user_id NUMBER;
138: l_msg_count NUMBER;
139: l_msg_data VARCHAR2(240);
140: l_notes_tab CS_ServiceRequest_PUB.notes_table;
141: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
142: l_request_id NUMBER;
143: l_request_number VARCHAR2(64);
144: l_interaction_id NUMBER;

Line 141: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

137: l_user_id NUMBER;
138: l_msg_count NUMBER;
139: l_msg_data VARCHAR2(240);
140: l_notes_tab CS_ServiceRequest_PUB.notes_table;
141: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
142: l_request_id NUMBER;
143: l_request_number VARCHAR2(64);
144: l_interaction_id NUMBER;
145: l_workflow_process_id NUMBER;

Line 146: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;

142: l_request_id NUMBER;
143: l_request_number VARCHAR2(64);
144: l_interaction_id NUMBER;
145: l_workflow_process_id NUMBER;
146: l_contact_rec CS_ServiceRequest_PUB.contacts_rec;
147: l_contact_index BINARY_INTEGER;
148: l_contact_id CS_HZ_SR_CONTACT_POINTS.PARTY_ID%TYPE;
149: l_profile_value VARCHAR2(240);
150: l_decript_value VARCHAR2(250);

Line 175: CS_ServiceRequest_PUB.INITIALIZE_REC

171: -- Lookup the user_id
172: l_user_id := JTM_HOOK_UTIL_PKG.Get_User_Id( p_record.CLID$$CS );
173:
174: -- Initialization
175: CS_ServiceRequest_PUB.INITIALIZE_REC
176: ( p_sr_record => l_sr_rec
177: );
178:
179: l_sr_rec.CALLER_TYPE := p_record.CALLER_TYPE;

Line 308: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);

304: /*
305: l_profile_value := fnd_profile.value('JTM_CREDIT_CARD_ENABLED');
306: IF l_profile_value = 'Y' THEN
307: IF p_record.CREDIT_CARD_NUMBER IS NOT NULL THEN
308: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
309: l_sr_rec.cc_number := l_decript_value;
310: l_sr_rec.cc_type_code := p_record.CREDIT_CARD_TYPE_CODE;
311: l_sr_rec.cc_expiration_date := p_record.CREDIT_CARD_EXPIRATION_DATE;
312: l_sr_rec.cc_first_name := p_record.CREDIT_CARD_HOLDER_FNAME;

Line 360: CS_ServiceRequest_PUB.Create_ServiceRequest

356: -- CS 11.5.9 Uptake
357: l_sr_rec.creation_program_code := 'CSL_LAPTOP';
358:
359: -- Api Modified, version 3.0, new parameters for Assignment Mgr
360: CS_ServiceRequest_PUB.Create_ServiceRequest
361: ( p_api_version => 3.0
362: , p_init_msg_list => FND_API.G_TRUE
363: , p_commit => FND_API.G_TRUE
364: , x_return_status => x_return_status

Line 470: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;

466:
467: r_credit_card c_credit_card%ROWTYPE;
468:
469:
470: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(240);
473: l_notes_tab CS_ServiceRequest_PUB.notes_table;
474: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

Line 473: l_notes_tab CS_ServiceRequest_PUB.notes_table;

469:
470: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(240);
473: l_notes_tab CS_ServiceRequest_PUB.notes_table;
474: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
475: l_interaction_id NUMBER;
476: l_ovn NUMBER;
477: l_user_id NUMBER;

Line 474: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;

470: l_sr_rec CS_ServiceRequest_PUB.service_request_rec_type;
471: l_msg_count NUMBER;
472: l_msg_data VARCHAR2(240);
473: l_notes_tab CS_ServiceRequest_PUB.notes_table;
474: l_contacts_tab CS_ServiceRequest_PUB.contacts_table;
475: l_interaction_id NUMBER;
476: l_ovn NUMBER;
477: l_user_id NUMBER;
478: l_workflow_id NUMBER;

Line 538: CS_ServiceRequest_PUB.INITIALIZE_REC

534: close c_last_update_date;
535: end if;
536:
537: -- Initialization
538: CS_ServiceRequest_PUB.INITIALIZE_REC
539: ( p_sr_record => l_sr_rec
540: );
541:
542: -- Lookup the user_id

Line 640: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);

636: NVL(r_credit_card.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_MNAME,FND_API.G_MISS_CHAR) OR
637: NVL(r_credit_card.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) <> NVL(p_record.CREDIT_CARD_HOLDER_LNAME,FND_API.G_MISS_CHAR) OR
638: NVL(r_credit_card.CREDIT_CARD_ID,FND_API.G_MISS_NUM) <> NVL(p_record.CREDIT_CARD_ID,FND_API.G_MISS_NUM))
639: THEN
640: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
641: l_sr_rec.cc_number := l_decript_value;
642: l_sr_rec.cc_type_code := p_record.CREDIT_CARD_TYPE_CODE;
643: l_sr_rec.cc_expiration_date := p_record.CREDIT_CARD_EXPIRATION_DATE;
644: l_sr_rec.cc_first_name := p_record.CREDIT_CARD_HOLDER_FNAME;

Line 659: CS_ServiceRequest_PUB.Update_ServiceRequest

655:
656:
657: -- Finally the update itself.
658: -- Api Modified for CS 11.5.9 Uptake Version changed to 3.0
659: CS_ServiceRequest_PUB.Update_ServiceRequest
660: ( p_api_version => 3.0
661: , p_init_msg_list => FND_API.G_TRUE
662: , p_commit => FND_API.G_TRUE
663: , x_return_status => x_return_status