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 755: , p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 756: , x_new_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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

Line 757: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

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

Line 894: ( p_new_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 895: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 938: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 939: , p_old_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

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

Line 1088: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;

1084: ( p_incident_id IN NUMBER
1085: , p_sr_contact_point_id IN NUMBER
1086: , x_return_status OUT NOCOPY VARCHAR2
1087: ) IS
1088: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1089: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1090: l_msg_count NUMBER;
1091: l_msg_data VARCHAR2(4000);
1092: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;

Line 1089: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;

1085: , p_sr_contact_point_id IN NUMBER
1086: , x_return_status OUT NOCOPY VARCHAR2
1087: ) IS
1088: l_new_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1089: l_old_cp_rec CS_SERVICEREQUEST_PVT.contacts_rec;
1090: l_msg_count NUMBER;
1091: l_msg_data VARCHAR2(4000);
1092: l_audit_enabled fnd_profile_option_values.profile_option_value % TYPE;
1093: BEGIN

Line 1158: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table

1154: , p_incident_id IN NUMBER
1155: , p_caller_type IN VARCHAR2
1156: , p_customer_id IN NUMBER
1157: , p_validation_mode IN NUMBER
1158: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1159: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1160: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1161: , x_primary_party_id OUT NOCOPY NUMBER
1162: , x_primary_contact_point_id OUT NOCOPY NUMBER

Line 1159: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

1155: , p_caller_type IN VARCHAR2
1156: , p_customer_id IN NUMBER
1157: , p_validation_mode IN NUMBER
1158: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1159: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1160: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1161: , x_primary_party_id OUT NOCOPY NUMBER
1162: , x_primary_contact_point_id OUT NOCOPY NUMBER
1163: , x_return_status OUT NOCOPY VARCHAR2

Line 1160: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table

1156: , p_customer_id IN NUMBER
1157: , p_validation_mode IN NUMBER
1158: , p_contact_tbl IN CS_SERVICEREQUEST_PVT.contacts_table
1159: , x_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1160: , x_old_contact_tbl OUT NOCOPY CS_SERVICEREQUEST_PVT.contacts_table
1161: , x_primary_party_id OUT NOCOPY NUMBER
1162: , x_primary_contact_point_id OUT NOCOPY NUMBER
1163: , x_return_status OUT NOCOPY VARCHAR2
1164: ) IS

Line 1167: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;

1163: , x_return_status OUT NOCOPY VARCHAR2
1164: ) IS
1165: --
1166: l_primary_found number;
1167: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1168: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1169: l_api_name_full VARCHAR2(61);
1170: l_existing_primary NUMBER;
1171: l_contact_party_role_found NUMBER := 0;

Line 1168: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;

1164: ) IS
1165: --
1166: l_primary_found number;
1167: l_new_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1168: l_old_contact_tbl CS_SERVICEREQUEST_PVT.contacts_table;
1169: l_api_name_full VARCHAR2(61);
1170: l_existing_primary NUMBER;
1171: l_contact_party_role_found NUMBER := 0;
1172: l_updated_cp_qry VARCHAR2(4000);

Line 1366: x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.CONTACTS_REC,

1362: --------------------------------------------------------------------------------
1363:
1364: PROCEDURE Populate_CP_Audit_Rec
1365: (p_sr_contact_point_id IN NUMBER,
1366: x_sr_contact_rec OUT NOCOPY CS_SERVICEREQUEST_PVT.CONTACTS_REC,
1367: x_return_status OUT NOCOPY VARCHAR2,
1368: x_msg_count OUT NOCOPY NUMBER,
1369: x_msg_data OUT NOCOPY VARCHAR2) IS
1370: