APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_INCIDENTS_EXT_AUDIT

Line 4845: FROM cs_incidents_ext_audit

4841: WHERE incident_id = p_incident_id
4842: AND context = p_context
4843: AND attr_group_id = p_attr_group_id
4844: AND extension_id NOT IN (SELECT extension_id
4845: FROM cs_incidents_ext_audit
4846: WHERE incident_id = p_incident_id
4847: AND context = p_context
4848: AND attr_group_id = p_attr_group_id);
4849:

Line 5223: SELECT CS_INCIDENTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;

5219: last_update_login=l_last_update_login
5220: where incident_id=l_incident_id;
5221: end if;
5222:
5223: SELECT CS_INCIDENTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;
5224: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5225:
5226: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr1 '||P_new_ext_attrs(l_table_index).C_ext_attr1);
5227: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr2 '||P_new_ext_attrs(l_table_index).C_ext_attr2);

Line 5231: INSERT INTO CS_INCIDENTS_EXT_AUDIT

5227: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr2 '||P_new_ext_attrs(l_table_index).C_ext_attr2);
5228: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr3 '||P_new_ext_attrs(l_table_index).C_ext_attr3);
5229: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr4 '||P_new_ext_attrs(l_table_index).C_ext_attr4);
5230:
5231: INSERT INTO CS_INCIDENTS_EXT_AUDIT
5232: ( AUDIT_EXTENSION_ID
5233: , EXTENSION_ID
5234: , INCIDENT_ID
5235: , CONTEXT