APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_SR_CONTACTS_EXT_AUDIT

Line 4880: FROM cs_sr_contacts_ext_audit

4876: and party_role_code = p_party_role_code
4877: and context = p_context
4878: and attr_group_id = p_attr_group_id
4879: AND extension_id NOT IN (SELECT extension_id
4880: FROM cs_sr_contacts_ext_audit
4881: where incident_id = p_incident_id
4882: and party_id = p_party_id
4883: and contact_type = p_contact_type
4884: and party_role_code = p_party_role_code

Line 5830: SELECT CS_SR_CONTACTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;

5826: IF P_NEW_ext_attrs.count = 0 OR P_OLD_ext_attrs.count = 0 THEN
5827: RETURN;
5828: ELSE
5829: FOR l_table_index in P_NEW_ext_attrs.FIRST..P_NEW_ext_attrs.LAST LOOP
5830: SELECT CS_SR_CONTACTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;
5831: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5832:
5833: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).extension_ID'||P_new_ext_attrs(l_table_index).extension_ID);
5834:

Line 5835: INSERT INTO CS_SR_CONTACTS_EXT_AUDIT

5831: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5832:
5833: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).extension_ID'||P_new_ext_attrs(l_table_index).extension_ID);
5834:
5835: INSERT INTO CS_SR_CONTACTS_EXT_AUDIT
5836: ( AUDIT_EXTENSION_ID
5837: , EXTENSION_ID
5838: , INCIDENT_ID
5839: , CONTEXT