24: -- contact_type --> party_type
25:
26: /****
27: TYPE SR_Rec_Type IS RECORD(
28: CUSTOMER_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
25:
26: /****
27: TYPE SR_Rec_Type IS RECORD(
28: CUSTOMER_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
26: /****
27: TYPE SR_Rec_Type IS RECORD(
28: CUSTOMER_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
27: TYPE SR_Rec_Type IS RECORD(
28: CUSTOMER_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
28: CUSTOMER_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
29: CUSTOMER_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
30: TYPE_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
31: SUMMARY VARCHAR2(80) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
32: SEVERITY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
40: CONTACT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR
33: URGENCY_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
40: CONTACT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR
41: );
34: NOTE_TYPE VARCHAR2(240) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
40: CONTACT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR
41: );
42: G_MISS_SR_REC SR_Rec_Type;
35: NOTE VARCHAR2(2000):= CSC_CORE_UTILS_PVT.G_MISS_CHAR,
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
40: CONTACT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR
41: );
42: G_MISS_SR_REC SR_Rec_Type;
43:
36: CONTACT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
37: CONTACT_POINT_ID NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
38: PRIMARY_FLAG VARCHAR2(1) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
39: CONTACT_POINT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
40: CONTACT_TYPE VARCHAR2(30) := CSC_CORE_UTILS_PVT.G_MISS_CHAR
41: );
42: G_MISS_SR_REC SR_Rec_Type;
43:
44: ***/
58:
59: -- Standard IN Parameters:
60:
61: -- p_api_version IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional. Default = CSC_CORE_UTILS_PVT.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
64:
65: -- Explanation of other in parameters ??
66: -- Standard OUT NOCOPY Parameters:
59: -- Standard IN Parameters:
60:
61: -- p_api_version IN NUMBER Required
62: -- p_init_msg_list IN VARCHAR2 Optional. Default = CSC_CORE_UTILS_PVT.G_FALSE
63: -- p_commit IN VARCHAR2 Optional Default = CSC_CORE_UTILS_PVT.G_FALSE
64:
65: -- Explanation of other in parameters ??
66: -- Standard OUT NOCOPY Parameters:
67:
75: p_api_version_number IN NUMBER,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_string OUT NOCOPY VARCHAR2,
79: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
76: x_return_status OUT NOCOPY VARCHAR2,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_string OUT NOCOPY VARCHAR2,
79: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
77: x_msg_count OUT NOCOPY NUMBER,
78: x_msg_string OUT NOCOPY VARCHAR2,
79: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
78: x_msg_string OUT NOCOPY VARCHAR2,
79: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
79: CUSTOMER_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
80: CUST_ACCOUNT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
81: CUSTOMER_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
82: SERIAL_NUMBER IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
83: TYPE_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
84: SUMMARY IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
85: SEVERITY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
93: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
86: URGENCY_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
93: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
94: x_service_request_number out NOCOPY VARCHAR2
87: NOTE_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
93: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
94: x_service_request_number out NOCOPY VARCHAR2
95: ) return varchar2;
88: NOTE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
93: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
94: x_service_request_number out NOCOPY VARCHAR2
95: ) return varchar2;
96:
89: CONTACT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
90: CONTACT_POINT_ID IN NUMBER := CSC_CORE_UTILS_PVT.G_MISS_NUM,
91: PRIMARY_FLAG IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
92: CONTACT_POINT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
93: CONTACT_TYPE IN VARCHAR2 := CSC_CORE_UTILS_PVT.G_MISS_CHAR,
94: x_service_request_number out NOCOPY VARCHAR2
95: ) return varchar2;
96:
97: END CSC_Service_Request_Pvt;