APPS.BOM_UDA_OVERRIDES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 41

  SELECT DATA_LEVEL_ID
    FROM EGO_DATA_LEVEL_B
   WHERE DATA_LEVEL_NAME = p_data_level_name;

Line: 46

  SELECT *
    FROM BOM_COMP_ATTR_CTX_ASSOCS_B
   WHERE COMPONENT_SEQUENCE_ID = p_comp_seq;

Line: 51

  SELECT *
    FROM BOM_COMPONENTS_EXT_B
   WHERE BILL_SEQUENCE_ID = p_bill_seq_id
     AND COMPONENT_SEQUENCE_ID = p_comp_seq_id
     AND ATTR_GROUP_ID = p_attr_grp_id
     AND DATA_LEVEL_ID = l_data_level_id_comp
     AND CONTEXT_ID IS NULL;

Line: 60

  SELECT *
    FROM BOM_COMPONENTS_EXT_B
   WHERE EXTENSION_ID = p_extension_id;

Line: 65

  SELECT *
    FROM BOM_COMPONENTS_EXT_B
   WHERE EXTENSION_ID = p_extension_id
     AND DATA_LEVEL_ID = l_data_level_id_comp_ovr
     AND CONTEXT_ID IS NOT NULL;

Line: 72

  SELECT *
    FROM BOM_COMPONENTS_EXT_TL
   WHERE EXTENSION_ID = p_extension_id
     AND DATA_LEVEL_ID = l_data_level_id_comp_ovr
     AND CONTEXT_ID IS NOT NULL;

Line: 117

      l_dynamic_sql := ' SELECT NEW.EXTENSION_ID ' ||
                       '   FROM BOM_COMPONENTS_EXT_B NEW, BOM_COMPONENTS_EXT_B OLD ' ||
                       '  WHERE OLD.EXTENSION_ID = :1 ' ||
                       '    AND NEW.BILL_SEQUENCE_ID = OLD.BILL_SEQUENCE_ID ' ||
                       '    AND NEW.ATTR_GROUP_ID = OLD.ATTR_GROUP_ID ' ||
                       '    AND NEW.COMPONENT_SEQUENCE_ID = :2 ' ||
                       '    AND NEW.DATA_LEVEL_ID = :3 ' ||
                       '    AND NEW.CONTEXT_ID IS NULL ' ;

Line: 163

      SELECT BOM_COMP_ATTR_CTX_ASSOCS_B_S.NEXTVAL
      INTO l_new_ctx_id
      FROM dual;

Line: 174

        SELECT EGO_EXTFWK_S.NEXTVAL
        INTO l_new_ext_id
        FROM dual;

Line: 185

        l_new_ovr_b_ext_rec.LAST_UPDATE_DATE      := sysdate;

Line: 186

	    l_new_ovr_b_ext_rec.LAST_UPDATED_BY       := l_user_id;

Line: 187

        l_new_ovr_b_ext_rec.LAST_UPDATE_LOGIN     := l_login_id;

Line: 192

	      INSERT
	      INTO BOM_COMPONENTS_EXT_B
	      VALUES l_new_ovr_b_ext_tbl(i);

Line: 204

          l_new_ovr_tl_ext_rec.LAST_UPDATE_DATE      := sysdate;

Line: 205

	      l_new_ovr_tl_ext_rec.LAST_UPDATED_BY       := l_user_id;

Line: 206

          l_new_ovr_tl_ext_rec.LAST_UPDATE_LOGIN     := l_login_id;

Line: 211

	        INSERT
	        INTO BOM_COMPONENTS_EXT_TL
	        VALUES l_new_ovr_tl_ext_tbl(i);

Line: 228

      new_ctx_rec.LAST_UPDATE_DATE      := sysdate;

Line: 229

      new_ctx_rec.LAST_UPDATED_BY       := l_user_id;

Line: 230

      new_ctx_rec.LAST_UPDATE_LOGIN     := l_login_id;

Line: 235

      INSERT
        INTO BOM_COMP_ATTR_CTX_ASSOCS_B
      VALUES l_new_ctx_tbl(i);

Line: 249

PROCEDURE Delete_Comp_UDA_Overrides (p_del_comp_seq NUMBER,
                                     x_return_status OUT NOCOPY VARCHAR2) IS
l_data_level_id_comp_ovr   NUMBER;

Line: 255

  SELECT DATA_LEVEL_ID
    FROM EGO_DATA_LEVEL_B
   WHERE DATA_LEVEL_NAME = p_data_level_name;

Line: 267

  DELETE
    FROM BOM_COMPONENTS_EXT_B
   WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq
     AND DATA_LEVEL_ID = l_data_level_id_comp_ovr;

Line: 272

  DELETE
    FROM BOM_COMPONENTS_EXT_TL
   WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq
     AND DATA_LEVEL_ID = l_data_level_id_comp_ovr;

Line: 277

  DELETE
    FROM BOM_COMP_ATTR_CTX_ASSOCS_B
   WHERE COMPONENT_SEQUENCE_ID = p_del_comp_seq;

Line: 284

END Delete_Comp_UDA_Overrides;