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.CSC_SERVICE_REQUEST_PVT dependencies on CSC_CORE_UTILS_PVT

Line 32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

28: p_api_version_number IN NUMBER,
29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_string OUT NOCOPY VARCHAR2,
32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

Line 33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

29: x_return_status OUT NOCOPY VARCHAR2,
30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_string OUT NOCOPY VARCHAR2,
32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

30: x_msg_count OUT NOCOPY NUMBER,
31: x_msg_string OUT NOCOPY VARCHAR2,
32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

Line 35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

31: x_msg_string OUT NOCOPY VARCHAR2,
32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

Line 36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

32: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

33: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

34: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

Line 39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

35: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

Line 40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

36: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

37: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

38: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

Line 43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,

39: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
47: x_service_request_number out NOCOPY VARCHAR2

Line 44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

40: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
47: x_service_request_number out NOCOPY VARCHAR2
48: ) return varchar2

Line 45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

41: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
47: x_service_request_number out NOCOPY VARCHAR2
48: ) return varchar2
49: is

Line 46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,

42: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
43: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
44: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
45: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
46: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
47: x_service_request_number out NOCOPY VARCHAR2
48: ) return varchar2
49: is
50: -- Declare variables and record,table types

Line 189: p_init_msg_list => csc_core_utils_pvt.g_true,

185: -- Create the SR
186:
187: CS_SERVICEREQUEST_PVT.Create_serviceRequest(
188: p_api_version => 3,
189: p_init_msg_list => csc_core_utils_pvt.g_true,
190: p_commit => csc_core_utils_pvt.g_true,
191: p_validation_level => csc_core_utils_pvt.g_valid_level_none,
192: x_return_Status => l_return_Status,
193: x_msg_count => l_msg_count,

Line 190: p_commit => csc_core_utils_pvt.g_true,

186:
187: CS_SERVICEREQUEST_PVT.Create_serviceRequest(
188: p_api_version => 3,
189: p_init_msg_list => csc_core_utils_pvt.g_true,
190: p_commit => csc_core_utils_pvt.g_true,
191: p_validation_level => csc_core_utils_pvt.g_valid_level_none,
192: x_return_Status => l_return_Status,
193: x_msg_count => l_msg_count,
194: x_msg_data => l_msg_data,

Line 191: p_validation_level => csc_core_utils_pvt.g_valid_level_none,

187: CS_SERVICEREQUEST_PVT.Create_serviceRequest(
188: p_api_version => 3,
189: p_init_msg_list => csc_core_utils_pvt.g_true,
190: p_commit => csc_core_utils_pvt.g_true,
191: p_validation_level => csc_core_utils_pvt.g_valid_level_none,
192: x_return_Status => l_return_Status,
193: x_msg_count => l_msg_count,
194: x_msg_data => l_msg_data,
195: p_resp_appl_id => null,

Line 216: if (l_return_status = csc_core_utils_pvt.g_ret_sts_success) then

212: );
213:
214: x_return_Status := l_return_Status;
215:
216: if (l_return_status = csc_core_utils_pvt.g_ret_sts_success) then
217: x_service_request_number := l_incident_number;
218: l_return := 'SRSuccess';
219: return l_return;
220: else