eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_SRCONTACT_PKG dependencies on CS_SERVICEREQUEST_PVT

Line 39: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

35: -- update SR API.
36: --------------------------------------------------------------------------------
37: PROCEDURE check_duplicates
38: ( p_mode IN VARCHAR2
39: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
40: , p_updated_cp_qry IN VARCHAR2
41: , p_updated_cp_bind IN NUM_TBL
42: , p_incident_id IN NUMBER
43: , x_return_status OUT NOCOPY VARCHAR2

Line 45: l_not_updated_contacts CS_SERVICEREQUEST_PVT.contacts_table;

41: , p_updated_cp_bind IN NUM_TBL
42: , p_incident_id IN NUMBER
43: , x_return_status OUT NOCOPY VARCHAR2
44: ) IS
45: l_not_updated_contacts CS_SERVICEREQUEST_PVT.contacts_table;
46: --
47: l_sql VARCHAR2(4000);
48: l_cur_hdl INT;
49: l_rows_processed BINARY_INTEGER;

Line 267: , p_new_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

263: --------------------------------------------------------------------------------
264: Procedure create_cp_audit
265: ( p_sr_contact_point_id IN NUMBER
266: , p_incident_id IN NUMBER
267: , p_new_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
268: , p_old_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
269: , p_cp_modified_by IN NUMBER
270: , p_cp_modified_on IN DATE
271: , x_return_status OUT NOCOPY VARCHAR2

Line 268: , p_old_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

264: Procedure create_cp_audit
265: ( p_sr_contact_point_id IN NUMBER
266: , p_incident_id IN NUMBER
267: , p_new_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
268: , p_old_cp_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
269: , p_cp_modified_by IN NUMBER
270: , p_cp_modified_on IN DATE
271: , x_return_status OUT NOCOPY VARCHAR2
272: , x_msg_count OUT NOCOPY NUMBER

Line 389: , p_new_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

385: --------------------------------------------------------------------------------
386: PROCEDURE validate_contact
387: ( p_caller_type IN VARCHAR2
388: , p_customer_id IN NUMBER
389: , p_new_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
390: , p_old_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
391: , x_return_status OUT NOCOPY VARCHAR2
392: ) IS
393: l_api_name_full VARCHAR2(61);

Line 390: , p_old_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec

386: PROCEDURE validate_contact
387: ( p_caller_type IN VARCHAR2
388: , p_customer_id IN NUMBER
389: , p_new_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
390: , p_old_contact_rec IN CS_SERVICEREQUEST_PVT.contacts_rec
391: , x_return_status OUT NOCOPY VARCHAR2
392: ) IS
393: l_api_name_full VARCHAR2(61);
394: l_employee_name VARCHAR2(80);

Line 757: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

753: -- -----------------------------------------------------------------------------
754: PROCEDURE process_g_miss
755: ( p_mode IN VARCHAR2
756: , p_incident_id IN NUMBER
757: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
758: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
759: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
760: , x_updated_cp_qry OUT NOCOPY VARCHAR2
761: , x_updated_cp_bind OUT NOCOPY NUM_TBL

Line 758: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

754: PROCEDURE process_g_miss
755: ( p_mode IN VARCHAR2
756: , p_incident_id IN NUMBER
757: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
758: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
759: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
760: , x_updated_cp_qry OUT NOCOPY VARCHAR2
761: , x_updated_cp_bind OUT NOCOPY NUM_TBL
762: , x_return_status OUT NOCOPY VARCHAR2

Line 759: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

755: ( p_mode IN VARCHAR2
756: , p_incident_id IN NUMBER
757: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
758: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
759: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
760: , x_updated_cp_qry OUT NOCOPY VARCHAR2
761: , x_updated_cp_bind OUT NOCOPY NUM_TBL
762: , x_return_status OUT NOCOPY VARCHAR2
763: ) IS

Line 896: ( p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

892: -------- -------- --------------------------------------------------------------
893: -- 04/15/05 smisra Created
894: --------------------------------------------------------------------------------
895: FUNCTION new_primary
896: ( p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
897: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
898: , x_return_status OUT NOCOPY VARCHAR2
899: ) RETURN NUMBER IS
900: BEGIN

Line 897: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

893: -- 04/15/05 smisra Created
894: --------------------------------------------------------------------------------
895: FUNCTION new_primary
896: ( p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
897: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
898: , x_return_status OUT NOCOPY VARCHAR2
899: ) RETURN NUMBER IS
900: BEGIN
901: FOR loop_index in p_new_contact_tbl.FIRST..p_new_contact_tbl.LAST

Line 940: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

936: , p_invocation_mode IN VARCHAR2
937: , p_sr_update_date IN DATE
938: , p_sr_updated_by IN VARCHAR2
939: , p_sr_update_login IN VARCHAR2
940: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
941: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
942: , x_return_status OUT NOCOPY VARCHAR2
943: ) IS
944: --

Line 941: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

937: , p_sr_update_date IN DATE
938: , p_sr_updated_by IN VARCHAR2
939: , p_sr_update_login IN VARCHAR2
940: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
941: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
942: , x_return_status OUT NOCOPY VARCHAR2
943: ) IS
944: --
945: l_audit_id NUMBER;

Line 1099: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;

1095: ( p_incident_id IN NUMBER
1096: , p_sr_contact_point_id IN NUMBER
1097: , x_return_status OUT NOCOPY VARCHAR2
1098: ) IS
1099: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1100: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1101: l_msg_count NUMBER;
1102: l_msg_data VARCHAR2(4000);
1103: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

Line 1100: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;

1096: , p_sr_contact_point_id IN NUMBER
1097: , x_return_status OUT NOCOPY VARCHAR2
1098: ) IS
1099: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1100: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1101: l_msg_count NUMBER;
1102: l_msg_data VARCHAR2(4000);
1103: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
1104: BEGIN

Line 1169: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

1165: , p_incident_id IN NUMBER
1166: , p_caller_type IN VARCHAR2
1167: , p_customer_id IN NUMBER
1168: , p_validation_mode IN NUMBER
1169: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1170: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1171: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1172: , x_primary_party_id OUT NOCOPY NUMBER
1173: , x_primary_contact_point_id OUT NOCOPY NUMBER

Line 1170: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

1166: , p_caller_type IN VARCHAR2
1167: , p_customer_id IN NUMBER
1168: , p_validation_mode IN NUMBER
1169: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1170: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1171: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1172: , x_primary_party_id OUT NOCOPY NUMBER
1173: , x_primary_contact_point_id OUT NOCOPY NUMBER
1174: , x_return_status OUT NOCOPY VARCHAR2

Line 1171: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

1167: , p_customer_id IN NUMBER
1168: , p_validation_mode IN NUMBER
1169: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1170: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1171: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1172: , x_primary_party_id OUT NOCOPY NUMBER
1173: , x_primary_contact_point_id OUT NOCOPY NUMBER
1174: , x_return_status OUT NOCOPY VARCHAR2
1175: ) IS

Line 1178: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;

1174: , x_return_status OUT NOCOPY VARCHAR2
1175: ) IS
1176: --
1177: l_primary_found number;
1178: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1179: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1180: l_api_name_full VARCHAR2(61);
1181: l_existing_primary NUMBER;
1182: l_contact_party_role_found NUMBER := 0;

Line 1179: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;

1175: ) IS
1176: --
1177: l_primary_found number;
1178: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1179: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1180: l_api_name_full VARCHAR2(61);
1181: l_existing_primary NUMBER;
1182: l_contact_party_role_found NUMBER := 0;
1183: l_updated_cp_qry VARCHAR2(4000);

Line 1461: x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.CONTACTS_REC,

1457: --------------------------------------------------------------------------------
1458:
1459: PROCEDURE Populate_CP_Audit_Rec
1460: (p_sr_contact_point_id IN NUMBER,
1461: x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.CONTACTS_REC,
1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2) IS
1465: