1 Package CS_SRCONTACT_PKG AS
2 /* $Header: cssrcps.pls 120.1 2005/12/22 15:49:17 spusegao noship $*/
3 --
4 PROCEDURE create_update
5 ( p_incident_id IN NUMBER
6 , p_invocation_mode IN VARCHAR2
7 , p_sr_update_date IN DATE
8 , p_sr_updated_by IN VARCHAR2
9 , p_sr_update_login IN VARCHAR2
10 , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
11 , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
12 , x_return_status OUT NOCOPY VARCHAR2
13 ) ;
14 PROCEDURE process
15 ( p_mode IN VARCHAR2
16 , p_incident_id IN NUMBER
17 , p_caller_type IN VARCHAR2
18 , p_customer_id IN NUMBER
19 , p_validation_mode IN NUMBER
20 , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
21 , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
22 , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
23 , x_primary_party_id OUT NOCOPY NUMBER
24 , x_primary_contact_point_id OUT NOCOPY NUMBER
25 , x_return_status OUT NOCOPY VARCHAR2
26 ) ;
27 --------------------------------------------------------------------------------
28 -- Procedure Name :
29 -- Parameters :
30 -- IN :
31 -- OUT :
32 --
33 -- Description :
34 --
35 -- Modification History:
36 -- Date Name Desc
37 -------- -------- --------------------------------------------------------------
38 -- 04/15/05 smisra Created
39 --------------------------------------------------------------------------------
40
41 --------------------------------------------------------------------------------
42 -- Procedure Name : validate_contact
43 -- Parameters :
44 -- IN : p_caller_type This is service request customer type.
45 -- It can be ORGANIZATION or PERSON
46 -- p_new_contact_rec This record contains contact record passed
47 -- to service request API
48 -- p_old_contact_rec This record containt value of contact
49 -- record being update. in case of insert
50 -- this record in NULL
51 -- OUT : x_return_status Indicates success or Error condition
52 -- encountered by procedure.
53 --
54 -- Description : This procedure takes old and new value of contact being
55 -- processed and validates it. Old value record is needed to
56 -- determine if a particular attribute is changed or not.
57 -- validation is performed on only changed attributes.
58 -- in case of insert, all attributes that are not null are
59 -- assumed to be changed attributes.
60 --
61 -- Modification History:
62 -- Date Name Desc
63 -------- -------- --------------------------------------------------------------
64 -- 04/15/05 smisra Created
65 --------------------------------------------------------------------------------
66 PROCEDURE validate_contact
67 ( p_caller_type IN VARCHAR2
68 , p_customer_id IN NUMBER
69 , p_new_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
70 , p_old_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
71 , x_return_status OUT NOCOPY VARCHAR2
72 );
73 --------------------------------------------------------------------------------
74 -- Procedure Name : process_g_miss
75 -- Parameters :
76 -- IN : x_new_contact_rec This record contains contact record passed
77 -- to service request API
78 -- p_old_contact_rec This record containt value of contact
79 -- record being update. in case of insert
80 -- this record in NULL
81 -- OUT : x_return_status Indicates success or Error condition
82 -- encountered by procedure.
83 --
84 -- Description : This procedure check new contact record and if any value if
85 -- missing then it is set to it's value in old contact record.
86 --
87 -- Modification History:
88 -- Date Name Desc
89 -------- -------- --------------------------------------------------------------
90 -- 04/15/05 smisra Created
91 --------------------------------------------------------------------------------
92 /*
93 PROCEDURE process_g_miss
94 ( p_mode IN VARCHAR2
95 , p_incident_id IN NUMBER
96 , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
97 , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
98 , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
99 , x_return_status OUT NOCOPY VARCHAR2
100 );
101 */
102
103 --------------------------------------------------------------------------------
104 -- Procedure Name : populate_cp_audit_rec
105 -- Parameters :
106 -- IN : p_sr_contact_point_id - Contact point identifier.
107 -- OUT : x_cp_contact_rec This is a populated audit record.
108 -- : x_return_status Indicates success or Error condition
109 -- encountered by procedure.
110 -- x_msg_count
111 -- x_msg_data
112 --
113 -- Modification History:
114 -- Date Name Desc
115 -------- -------- --------------------------------------------------------------
116 -- 11/23/2005 spusegao created
117 --------------------------------------------------------------------------------
118
119 PROCEDURE Populate_CP_Audit_Rec
120 (p_sr_contact_point_id IN NUMBER,
121 x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_rec,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2);
125
126
127 --------------------------------------------------------------------------------
128 -- Procedure Name :
129 -- Parameters :
130 -- IN :
131 -- OUT :
132 --
133 -- Description :
134 --
135 -- Modification History:
136 -- Date Name Desc
137 -------- -------- --------------------------------------------------------------
138 -- 04/27/05 smisra Created
139 -- 11/23/05 spusegao added to the package spec so that this procedure is available for party merge routine.
140 --------------------------------------------------------------------------------
141 Procedure create_cp_audit
142 ( p_sr_contact_point_id IN NUMBER
143 , p_incident_id IN NUMBER
144 , p_new_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
145 , p_old_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
146 , p_cp_modified_by IN NUMBER
147 , p_cp_modified_on IN DATE
148 , x_return_status OUT NOCOPY VARCHAR2
149 , x_msg_count OUT NOCOPY NUMBER
150 , x_msg_data OUT NOCOPY VARCHAR2);
151
152 END;