DBA Data[Home] [Help]

APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_SR_CONTACTS_EXT_AUDIT

Line 4882: FROM cs_sr_contacts_ext_audit

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

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

5853: last_update_login=l_last_update_login
5854: where incident_id=l_incident_id;
5855: end if;
5856:
5857: SELECT CS_SR_CONTACTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;
5858: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5859:
5860: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).extension_ID'||P_new_ext_attrs(l_table_index).extension_ID);
5861:

Line 5862: INSERT INTO CS_SR_CONTACTS_EXT_AUDIT

5858: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5859:
5860: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).extension_ID'||P_new_ext_attrs(l_table_index).extension_ID);
5861:
5862: INSERT INTO CS_SR_CONTACTS_EXT_AUDIT
5863: ( AUDIT_EXTENSION_ID
5864: , EXTENSION_ID
5865: , INCIDENT_ID
5866: , CONTEXT