APPS.CS_SR_EXTATTRIBUTES_PVT dependencies on CS_INCIDENTS_EXT_AUDIT

Line 4843: FROM cs_incidents_ext_audit

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

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

5205: FOR l_table_index in P_NEW_ext_attrs.FIRST..P_NEW_ext_attrs.LAST LOOP
5206:
5207: IF P_NEW_ext_attrs.exists(l_table_index) THEN
5208:
5209: SELECT CS_INCIDENTS_EXT_AUDIT_S.NEXTVAL INTO l_ext_audit_id FROM dual;
5210: --DBMS_OUTPUT.PUT_LINE('inside for loop:' || to_char(l_ext_audit_id));
5211:
5212: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr1 '||P_new_ext_attrs(l_table_index).C_ext_attr1);
5213: --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 5217: INSERT INTO CS_INCIDENTS_EXT_AUDIT

5213: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr2 '||P_new_ext_attrs(l_table_index).C_ext_attr2);
5214: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr3 '||P_new_ext_attrs(l_table_index).C_ext_attr3);
5215: --DBMS_OUTPUT.PUT_LINE('P_new_ext_attrs(l_table_index).C_ext_attr4 '||P_new_ext_attrs(l_table_index).C_ext_attr4);
5216:
5217: INSERT INTO CS_INCIDENTS_EXT_AUDIT
5218: ( AUDIT_EXTENSION_ID
5219: , EXTENSION_ID
5220: , INCIDENT_ID
5221: , CONTEXT