APPS.CS_SR_PARTY_MERGE_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 57: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

53: l_ship_to_party_id NUM_TBL;
54: l_last_update_program_code VARCHAR2_30_TBL;
55: l_rowid_tbl ROWID_TBL;
56:
57: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
58: l_merge_reason_code VARCHAR2(30);
59: l_api_name VARCHAR2(30) := 'CS_INC_ALL_MERGE_PARTY';
60: l_count NUMBER(10) := 0;
61:

Line 203: CS_ServiceRequest_PVT.Create_Audit_Record

199: l_audit_vals_rec.entity_activity_code := 'U' ;
200:
201: END IF;
202:
203: CS_ServiceRequest_PVT.Create_Audit_Record
204: ( p_api_version => 2.0,
205: x_return_status => l_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data,

Line 319: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

315: l_ship_to_site_use_id NUM_TBL;
316: l_last_update_program_code VARCHAR2_30_TBL;
317: l_last_fetch BOOLEAN := FALSE ;
318: l_audit_id NUMBER;
319: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
320: l_return_status VARCHAR2(3);
321: x_msg_count NUMBER(15);
322: x_msg_data VARCHAR2(2000);
323: RESOURCE_BUSY EXCEPTION;

Line 453: CS_ServiceRequest_PVT.Create_Audit_Record

449: l_audit_vals_rec.entity_activity_code := 'U' ;
450:
451: END IF;
452:
453: CS_ServiceRequest_PVT.Create_Audit_Record
454: ( p_api_version => 2.0,
455: x_return_status => l_return_status,
456: x_msg_count => x_msg_count,
457: x_msg_data => x_msg_data,

Line 589: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

585: l_install_site_id NUM_TBL ;
586: l_incident_location_id NUM_TBL ;
587: l_incident_location_type VARCHAR2_30_TBl ;
588: l_last_update_program_code VARCHAR2_30_TBL ;
589: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
590: l_return_status VARCHAR2(3);
591: x_msg_count NUMBER;
592: x_msg_data VARCHAR2(2000);
593: l_audit_id NUMBER;

Line 808: CS_ServiceRequest_PVT.Create_Audit_Record (

804: l_audit_vals_rec.entity_activity_code := 'U';
805:
806: END IF;
807:
808: CS_ServiceRequest_PVT.Create_Audit_Record (
809: p_api_version => 2.0,
810: x_return_status => x_return_status,
811: x_msg_count => x_msg_count,
812: x_msg_data => x_msg_data,

Line 1200: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;

1196: l_audit_id NUMBER;
1197: l_return_status VARCHAR2(3);
1198: x_msg_count NUMBER(15);
1199: x_msg_data VARCHAR2(2000);
1200: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1201: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1202:
1203: RESOURCE_BUSY EXCEPTION;
1204: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);

Line 1201: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;

1197: l_return_status VARCHAR2(3);
1198: x_msg_count NUMBER(15);
1199: x_msg_data VARCHAR2(2000);
1200: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1201: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1202:
1203: RESOURCE_BUSY EXCEPTION;
1204: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1205:

Line 1602: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;

1598: v_merged_to_id NUMBER;
1599: l_primary_flag VARCHAR2(1);
1600: l_incident_id NUM_TBL;
1601: l_sr_contact_point_id NUM_TBL;
1602: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1603: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1604:
1605: RESOURCE_BUSY EXCEPTION;
1606: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);

Line 1603: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;

1599: l_primary_flag VARCHAR2(1);
1600: l_incident_id NUM_TBL;
1601: l_sr_contact_point_id NUM_TBL;
1602: l_sr_contact_old_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1603: l_sr_contact_new_rec CS_SERVICEREQUEST_PVT.CONTACTS_REC;
1604:
1605: RESOURCE_BUSY EXCEPTION;
1606: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);
1607:

Line 1998: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;

1994: l_customer_phone_id NUM_TBL;
1995: l_customer_email_id NUM_TBL;
1996: l_last_update_program_code VARCHAR2_30_TBL;
1997: l_last_fetch BOOLEAN := FALSE ;
1998: l_audit_vals_rec CS_ServiceRequest_PVT.SR_AUDIT_REC_TYPE;
1999: l_audit_id NUMBER;
2000: l_return_status VARCHAR2(3);
2001: x_msg_count NUMBER(15);
2002: x_msg_data VARCHAR2(2000);

Line 2133: CS_ServiceRequest_PVT.Create_Audit_Record (

2129: l_audit_vals_rec.entity_activity_code := 'U';
2130:
2131: END IF;
2132:
2133: CS_ServiceRequest_PVT.Create_Audit_Record (
2134: p_api_version => 2.0,
2135: x_return_status => x_return_status,
2136: x_msg_count => x_msg_count,
2137: x_msg_data => x_msg_data,