[Home] [Help]
PACKAGE: APPS.CSC_SERVICE_REQUEST_PVT
Source
1 PACKAGE CSC_Service_request_pvt AUTHID CURRENT_USER AS
2 /* $Header: cscvcsrs.pls 115.3 2002/12/04 16:24:11 bhroy noship $ */
3
4 -- *******************************************************
5 -- Start of Comments
6 -- -------------------------------------------------------
7 -- Record name:SR_Rec_Type
8 -- -------------------------------------------------------
9 -- Parameters:
10 -- customer_id --> object_id in contact center
11 -- customer_type
12 -- serial_number
13 -- type_id
14 -- summary
15 -- severity_id
16 -- urgency_id
17 -- note_type
18 -- note
19 -- problem_code --> not required?
20 -- contact_id --> subject_id from contact center
21 -- contact_point_id
22 -- contact_primary_flag
23 -- contact_point_type
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,
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 );
42 G_MISS_SR_REC SR_Rec_Type;
43
44 ***/
45
46 -- ------------------------------------------------------------------
47 -- Create_Service_Request
48 -- -----------------------------------------------------------------
49 -- Start Of Comments
50
51 -- API name: Create_Service_Request
52 -- Version : Initial version 1.0
53 -- Type : Private
54 -- Function: Calls the sr API to create a service request.
55 -- Pre-reqs: None.
56
57 -- Parameters:
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:
67
68 -- x_return_status OUT NOCOPY VARCHAR2(1)
69 -- x_msg_count OUT NOCOPY NUMBER
70 -- x_msg_data OUT NOCOPY VARCHAR2(2000)
71 -- End Of Comments
72 -- -----------------------------------------------------------------
73
74 FUNCTION Create_Service_Request(
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,
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,
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;