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
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
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
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: ) ;
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: --------------------------------------------------------------------------------
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
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: );
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: */
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:
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:
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
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