APPS.CS_SRCONTACT_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 10: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 11: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 20: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 21: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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

Line 22: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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

Line 69: , p_new_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

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: --------------------------------------------------------------------------------

Line 70: , p_old_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

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

Line 96: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 97: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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

Line 98: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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:

Line 121: x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_rec,

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:

Line 144: , p_new_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

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

Line 145: , p_old_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

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